Export Data to Flat File & FTP/Import Flat File from FTP
REQUIREMENT 1 - Export Contact/Asset data to flat file (Request.txt - fixed width) and put it in a folder in FTP site, on a daily basis.
REQUIREMENT 2 - Also, on a daily basis, Read data (basically, just Status & Results) from a similar flat file (Response.xt - fixed width) from another folder in the same FTP site and then update Contact/Asset's Status in Service Cloud.
To implement this, I am planning to do these steps.
1) Create a PHP file (request.php) which reads the required Contact/Asset data from Service Cloud and create a file. QUESTION - Since file system is Service Cloud is not exposed, where can I place this file? Can I put the file directly in FTP site?