AnsweredAssumed Answered

Import records script doesn't work the same as a manual import

Question asked by JeffBroderick on Aug 4, 2015
Latest reply on Aug 4, 2015 by JeffBroderick

Title

Import records script doesn't work the same as a manual import

Post

I have a file where multiple imports are done from a .xlsx file.  

 

It's a fairly simple file with two tables - one for Inventory import and the other for a Scanned Count.  If I manually import from the Inventory layout, choosing the inventory worksheet in Excel, the records come in normally.

If I move to the Scanned Count layout, which is associated with the Scanned Count table, and manually import the records from the Excel worksheet for the scan, the records come across normally and then a sub summary  report is used to count the individual items.

For some reason, when I script the import, it will only default to the Inventory table.

My script starts with Go To Layout  to the Scanned Count layout, which is associated with the Scanned Count table.  For some reason, I can see using the Script Debugger that the Inventory table is selected as the target and no other option to change it is present.

I'm wondering why it would work differently in a script than in "manual mode".

 

 

Outcomes