Jump to content

Clone file not taking system date format when using migration tool?

Recommended Posts


I hope someone could just lead me in the right direction.

We are based in Spain, and whenever I download any sample file most of the time it was created using US date format mm/dd/yyyy. Reading about using the Filemaker Migration Tool and the Helpers, I have manage to create a clone file. If I open the file before using the Migration Tool Helper, then the file takes System date format which is dd/mm/yyyy.

BUT if I dont open the file (as it required for the migration tool to work) and I use the helper to do the migration (in this case DBservices one) then the Output File is back with the old US date format, which is mm/dd/yyyy.

It is important to remark that this only is visible when exporting data (dates) to excel, while using the file all dates shows in European date format dd/mm/yyyy.

Any ideas how to use he Filemaker Migration Tool Helper so the cloned file with all migrated tables would get the system date format dd/mm/yyyy?

Thanks a lot in advance for any comments!

Best regards!



Link to post
Share on other sites

One can only guess that if the FileMaker Data Migration Tool Guide says:


Important: Do not open the clone with FileMaker Pro Advanced.

and explains:


Opening a clone modifies it so that it won't work with the data migration tool.

it is precisely because they don't want the clone to acquire any settings yet. One could further surmise that they need the clone to inherit the settings from the source file, otherwise the data migration can fail.

Note that importing data between files having different settings does work. So presumably the data migration tool is using a different method to transfer the data -  a method that does not convert the data from source format to target format..


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.