4 Replies Latest reply on May 13, 2015 9:44 AM by alternapop

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

    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!