Import and Export Functions in exe mode

[Stacey Tan]

I have created a FMP 7 solution using FMP developer. The solution includes an import and export function. It works fine in a FMPro 7. However, the import and export functions does not work once I compiled it into an exe file. Does anyone know why? Desperate now. Can anyone help?

[davidp]

In the "Import Records" script step, when you specify the data source file, you will need to specify your file name(s) with the ".usr" extension in addition to the ".fp7" extension. By including both file names, you will be able to use the same script in both your developer version in FileMaker and your bound solution (of course, you may have changed your extension to something other than ".usr", but the principle is the same).

[Stacey Tan]

It was a Excel file that I was trying to import in. But you gave me an idea. I keep thinking that it was a disk access permission error and I keep looking that way. Then I found out that it was the data source path that was wrong. For some reason, I could not get it working with relative data path in exe mode. So I changed it to absolute path and it works!!!