automated export

[joen0s]

Hi all,

i'm a newbie at FMP and the company i do my internship uses a very old FMP. FMP v5.0. now i have to export a few fields after a search has been done.

this need to be automated. so when the press the button export ( i've created on the form) that they dont need to select the fields they want to export. so it need to automatically select the field and export it to a fixed name csv file.

could someone help me with the scripting cause i dont know where to start.

thanks in advance.

[mr_vodka]

Its been a while since I used fm5 but IIRC, you should do a manual export with the fields that you want first. Then when you go to setup your script with the Export Records, it should restore it for you. If you want to replace the export order, then uncheck the restore to replace it.

[joen0s]

ok so i cant do it with a specific script. so i have to do the export first on all the computers using the FMP and then create the export button.

that kinda sucks

but thanks anyway :

[Lee Smith]

Hi joen0s, and welcome to the Forum.

Prior to Version 7, FileMaker defaulted to your last performed Page Setup, Import Order, Export Order, Find Request, and Sort Order when you set up these script steps. This meant that you had to perform these steps manually the way you wanted them, before choosing them in your script. I think the idea was, that you would test the steps, and perfect them before committing them to the Script.

With the release of version 7 in March 2004, FileMaker added the ability to set these steps up, and/or modify them within ScriptMaker.

Sorry you feel this sucks, but you are using a 9 year old program!

Lee

[Fenton]

ok so i cant do it with a specific script. so i have to do the export first on all the computers using the FMP and then create the export button.

No, you only have to do it once, on the FileMaker file which is being hosted, following the procedure that Lee outlined.

[Robere]

I have the same issue. I want to export all to a .tab file.

I have the script written, and it runs OK, but I have to manually click OK through a couple screens to save the file.

I'd like to schedule this to run automatically over night with no manual intervention (I'll be setting up more than one table to export). Can I do this?

[Lee Smith]

FileMaker does not have the ability to do this natively.

[mr_vodka]

Since you are not on FMS10, you will need to use a Client Pro version to run the script. Create a file that has an opening script which performs the export of the referenced production file records, then closes.

Use a scheduler to open the file at the time that you need it to run.

Edited April 23, 2009 by Guest

[Lee Smith]

Server 10 works with v6?

[mr_vodka]

Of course not. The point I was trying to make to Robere was that only FMS10 can schedule an import / export automatically. Since he is using FMP6, he would have to use a FileMaker Pro Client version as a "bot" to schedule it. :o