Is it possible to import a web hosted .csv file into a db hosted on a FMP 13 server?
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