Naming export file

[Ricardo]

Hi guys.

i am epxorting as an xml file for each record from my fmpro db.

Problem being it will try to replace the previoulsy generated xml file with the latest generated xml file as the names are the same!!

is there a way i can name each individual xml file automatically...dont really want to do this manually as i have 1000+ records to export each record generating 1 xml file!!!

thanks.

[Fenton]

An xml export is the same as any other export in this aspect. You need to use the script step Set Variable to specify the full path to each file (or a relative path if going to a subfolder of the FileMaker file's location on your local machine). Since you want a different file per record, this would be in a Loop, and you'd need a file name field in each record. You would reset the variable within the Loop.

The name of the script variable goes directly into the export path, typed, with local syntax, i.e., $variable name.

Assuming you have an "XML_Files" folder on your desktop, and a FileMaker field "File_name",

Set Variable [ $filepath; "filewin:" & Get (DesktopPath) & "XML_Files/" & File_name ]

Export Records [ no dialog; $filepath; etc. ]

If you need more help, do a search here about Exports and Variables. The FileMaker Help has info about this method, but you'll have to do a find on "variable" to find it. Also, every Export (and Import) shows clear examples of what the file path should look like.

[Lee Smith]

After reading your other post, and this one. Are you doing a DDR, or trying to export the data, so that it can then be imported into your new file?