We have FMPS 13 running on Windows 2008r2.
I need to download a csv file from a remote web server and import its contents into fields into a hosted database using the server's 'perform script on server' feature. This will all be scheduled and automated with zero user interaction.
Where does the csv file need to reside on the server in order for the script to be able to import it? I have a powershell script that can download the file but don't know where to store the file.
What options do I have for importing this file and parsing its contents into fields?