DATA DOWNLOADING UPLOADING AND NORMALIZATION
Given form data which can come from any of three sources:
Where the data contains names, numbers, addresses, and answers to various questions,
The data must be:
2.uploaded to a single Google Sheet at will 3.downloaded from that same Sheet and uploaded to SugarCRM at will
A process, running on a remote server, should log into each of the sources, on a nightly basis, and download only new data. There are a total of approximately 100 sources, but each will run for only part of the year. We need to be able to turn any given source on or off on a daily basis.