AnsweredAssumed Answered

Is it possible to import a web hosted .csv file into a db hosted on a FMP 13 server?

Question asked by alternapop on May 12, 2015
Latest reply on May 13, 2015 by alternapop

Title

Is it possible to import a web hosted .csv file into a db hosted on a FMP 13 server?

Post

Is it possible to import a .csv file from a url into a FMP13 db?

I know it can be done by importing from a local disk but we'd like to have a server script that imports a remote csv file every hour.  Can this be done?  If so, how?

The url string would contain two variables that are created based on the date like this, currently done on a unix server:

# set date variables
oneMonthAgo=`date -v -1m "+%m%d%Y"`
plus3months=`date -v +3m "+%m%d%Y"`

# set url variable
url="http://www.example.com/schedule/Access?pStartDate=${oneMonthAgo}&pEndDate=${plus3months}

 

 

Thanks!

Outcomes