Skip to content

Import Export PowerTool

Import file layout/questions

Viewing 2 posts – 1 through 2 (of 2 total)
  • Author
    Posts
  • #8514
    Ted J.

    In a webinar today, you show importing multiple tables in a single file.

    Is there guidance available on how to format the file? (One blank line between tables?)

    If I’m importing three tables, and an error occurs while importing records in the second, are the records in the first table saved or is the whole run a transaction?

    If I need to import one table (item uom) before importing another (item with sales UOM and purchase UOM), can I import them in one file?

    How do I call this tool from AL? If  I want to import a series of 5 files, feeding them one at a time to the tool and setting parameters differently per file, can I do this?

    #9978
    Travis P.
    Insight Works

    The format for a multi-table import file can be found at the 11:00 mark in the

    The best way to see a full example would be to export a couple of tables at once using a filter range.

     

    If you are using validation and there is an error, nothing will be imported. If you are not validating, there will be no errors and all other valid lines before and after will continue to import.

     

    The import files work the same way as a config package. If you have table dependencies, they need to be imported in order – either in separate files or a single file.

     

    The PowerTool is not extensible. If you are processing in AL, you would just be updating the records directly and not using the PowerTool.

Viewing 2 posts – 1 through 2 (of 2 total)
  • Sign in below to reply.