Custom import order

[MWile]

I have a script that includes a step to import an Excel sheet using "Custom Order." When I run the script using Script Debugger, the option has changed to "Last Order" and the items are now in the incorrect order. Any ideas on why this is happening? Also, I'd like to check the "Don't import first record (contains field names)" checkbox but it's grayed out. That's no biggie as I can just remove the first line. I would like to retain the custom order, though.

[Josh Ormond]

The Import script step has a few quirky behaviors. Does it import correctly if you just run the script without the debugger? Are you showing the Import dialog during the script?

 

As for the "Don't import first record..." option, try adding 1 record to the table first. I believe there has to be 1 existing record in the table for that to work.

[MWile]

Thanks for the info. I'll give it a try in the morning.

[MWile]

I checked and there are already 7 records in the solution. I just changed the script so that it allows the user to match up fields.

[Josh Ormond]

Does the original script run correctly if you don't have the debugger on?

[MWile]

If I don't have the debugger on, it runs because it uses "last order." Not sure if I ran a script with different parameters and then ran this script. Would it pick up "last order" from the other script?

[Josh Ormond]

Make a copy of the file and test it on the copy. Run the script. Verify its correct. Do a manual import of some other file with different data with different settings. Run the script again...verify if the data is correct.

 

But if you are not showing the sort order dialog, you wouldn't know if it ran with "Last Order" or ran as it was saved.