Newbies JRW1 Posted June 11, 2020 Newbies Share Posted June 11, 2020 Hi, I am trying to perform an import from one table to another within a FM cloud file but cannot see how this works. I need to run the import on the server as running it from teh desktop client is far too slow compared to when I had the database hosted locally. I have worked out how to get simplke scripts running on the server by setting a parameter (eg the layout), but I only get error messages when trying to run an import script taht worked finme on a local version of the db. Is it actually possible to run an import script in the cloud, and is there any dociumentation to help with running scripts in teh cloud as I have foudn very little help online with how to set parameters etc. I hope someone can help me! Link to comment Share on other sites More sharing options...
Wim Decorte Posted June 11, 2020 Share Posted June 11, 2020 Server-side scripts cannot import from one table to another directly. You have to make it a two-step process by exporting from the source table, to a non-FM format (CSV will do) and then import from that CSV into the destination table. Link to comment Share on other sites More sharing options...
Newbies JRW1 Posted June 11, 2020 Author Newbies Share Posted June 11, 2020 Many thanks for the quick response. I did an export /import like this when I ran the scripts locally as I was grouping data. How can I specify a location in the cloud for the csv to export to: I can't see what path I would use - the script needs to run entirely in the cloud (rather than via local export/import) as they involve processing very large tables of data? Link to comment Share on other sites More sharing options...
Wim Decorte Posted June 11, 2020 Share Posted June 11, 2020 server-side (FM Cloud or FMS, doesn't matter) FMS has access to only two folders: 1) the documents folder that is inside its own folder structure, you can use Get(DocumentsPath) - anything you put in there will remain there 2) a temporary folder created for the script that runs, you can use Get(TemporaryPaty) for that - anything you put in there gets deleted by FMS automatically. Beware that it is for the running script only, don't expect it to be there for any other script. Link to comment Share on other sites More sharing options...
Newbies JRW1 Posted June 16, 2020 Author Newbies Share Posted June 16, 2020 many thanks for your help, much appreciated! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1409 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now