Are you sure the cells are "empty"? I've seen a carriage return move data down to not be seen until you click in the cell to show all of it.
If it's "new records", is there something else that may have changed?
What happens with an export as .CSV (text), does it also 'forget' those fields, too?
yes, the cells are definitely empty, there is no "hidden" content.
Exporting .csv, .tab or .fmp12 is giving the same results, old records OK, new records not OK. I've duplicated a couple of old and new records and exported them. Again the same results OK resp. not OK.
In the last two days, I've edited some 100 records. All of them are being exported correctly.
The only changes which I've made to the database are deleting a field which is not needed anymore, and adding a new field. But this I did after creating the "new" records.
I can't see any differences between old and new records, data entry is consistent.
2 of 2 people found this helpful
Ah! Deleting a field can mangle any export (or save as). Check your script and possibly 'reset' (recreate) the Export/Save As part of the script step.
I exported the records several times manually, and checked carefully if all fields are listed in the export dialogue.
The deleted, as well as the newly created field are for filter purposes only, they have never been a part of exported data.
Which steps I did:
– Started a manual export.
– Cleared the three fields from the export dialogue.
– Performed the export.
– Started a manual export again.
– Added the three fields again in the export dialogue.
– Performed the export. Everything was OK then.
– Deleted the export script.
– Defined a new export script. Working fine now.
With other words, Beverly's hint was right, the export has been corrupted. Thanks!