Scripting IMPORT and EXPORT

[TKnTexas]

I am having a little problem with importing and exporting. The real-time setting will have data files on J: (in the root of J). Files are named in a format incorporating the date to the name.

The output will go to C:Lilly (long story and a dumb one). Output will be to a file that is rewritten daily, because they are interfacing to a program that is hardcoded for the input name.

My FMPro runtime will be a datafilter. I am reading spooled accounting reports, cleaning the data to produce csv files.

When opening the runtime the user will be presented with a menu of which filter to run. I then want the IMPORT command to open to the J: and pause for the user to select the file. After the clean up is done, I want the EXPORT command to overwrite the existing file from yesterday.

For test purposes I have created a J: drive by using the SUBST command to assign J: to a folder. That works. But it is not opening to the drive when I hit the IMPORT script step.

And the EXPORT will not overwrite the existing file.

I am using FMPro 10adv (10.3) on XP Professional. I would appreciate any thoughts.

[bcooney]

Hello Thomas,

There is no way natively to have Import remember a directory, but ask for a file. You can try to import a file from that directory that you know is NOT there, then FM will throw a "Can't find that file" and allow the user to select but they'll be in the correct directory. I believe this "trick" will work.

As for export...I don't understand why it won't overwrite. What does happen?