Immediately after the export, what found set do you have?
What exact steps do you use to export the data? Do you use a script or do it by hand from the File menu?
Many thanks. The found set in the database remains the same - But, the exported file has all the records in the database. The exported file is an XML file - Not sure if that makes any difference.
The export is run from a script.
I need to see that script.
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post A Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here.
- If You have FileMaker advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format. (Use the HTML option on the database tab panel and paste the text into the forum's HTML editor.)
Many thanks for any help.
Script is as below:
Product: Exports: Website XML Export
Allow User Abort [ Off ]
Set Error Capture [ On ]
Export Records [ Character Set: “Windows (ANSI)”; Field Order: PM_Product::ID_External_System PM_Product::Collection
PM_Product::Subtitle ] [ No dialog ]
Not sure if is helpful. But have placed a short Quicktime screen grab of the export showing the amount of records in the found set and the number of records in the resultant file on my Drop Box (link: https://dl.dropbox.com/u/363830/Export.zip).
When I export in any other file format than XML the record count is correct. Driving me bonkers.
That is ODD, I would expect XML to export the found set like any other format.
One picky, but critical detail needs to be checked:
You are exporting from a table occurrence named: "PM_Product". Open Layout setup for the layout you have up when you export the records. Do you see exactly the same text in "Show Records From"?
If they are not the same, this could explain why you are having the entire table exported instead of just the found set.
If I look on the server at the 'data' file it shows the full number of records in that table. So, going to guess it is an issue with the 'separation' model and XML as if I use for example CSV then the correct of records are exported. So, in short, need to move platforms.
I hoped that I was doing something 'obvious' wrong as am very much a novice but looks like very much a failing of Filemaker in enabling separation of data and interface. Will look at other options.
Happy to copy the original files if helps as looks like they aren't a lot of use to us now.
Thanks, for your help.