Jump to content

will import order survive file rename?


GlennC
 Share

This topic is 6486 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

I need to rename a file currently used to import records (via import script). The import order involves alot of fields which would be a pain having to do it all again. Will the import order stay intact if I change the file name in the script. The file itself will be the same. I need to change from 'all.xls' to 'all.csv'. When viewing both these files in Excel they appear the same.

FileMaker Version: 6

Platform: Windows XP

Link to comment
Share on other sites

  • 2 weeks later...

What I meant by "When viewing both these files in Excel they appear the same" is:

each save to all.xls overwrites the previous version. For each save the data within the file is different but the structure is the same - ie same columns/fields when viewed with excel.

If I call the file all.csv and point the import script to this file, will the import order defined in the script be OK?

Link to comment
Share on other sites

Usually the import order is not affected by the change of a filename. What will affect it is renaming a field, adding or removing fields.

One method that can be used to get around these problems too is to use an XML data format and create a stylesheet that deals with the import of data. The stylesheet tells the data where to go, even if the field name has moved or changed name.

But in your case you should be fine.

Best bet, try it out.

Link to comment
Share on other sites

This topic is 6486 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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