February 10Feb 10 This one has me baffled--the import script works fine in FM Pro, but not in Go. I did everything I could think of to prep the files (mapped the imports in FM Pro) for use in Go, but no dice; all the files were are in FM GO's "sandbox." The account name is admin, (no password), so you can open the file. Any insight would be GREATLY appreciated.Thanks,Rich Import.csv Import.xlsx Data.fmp12
February 11Feb 11 I know practically nothing about FM Go but these things caught my attention:You cannot import a .xlxs file. You can import only from FileMaker Pro, comma-separated values, tab-separated values, DBF, and merge file formats.https://help.claris.com/en/pro-help/content/import-records.htmlYour $_Error variable captures the error from the immediately preceding Set Variable step (which is not likely to ever generate one). If you want to capture the error from the Import Records step, you must do so immediately after this step is performed, with no intervening steps other than If, Else, Else If, End If, Loop, Exit Loop If, End Loop, Exit Script and Halt Script.https://help.claris.com/en/pro-help/content/get-lasterror.htmlGetting the correct error code should at least get you one step further. Edited February 11Feb 11 by comment
Create an account or sign in to comment