Home › Forums › Import Export PowerTool › Import file layout/questions

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Ted JohnstonTed Johnston
      Post count: 8

      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?

      Travis PlettTravis Plett
        Post count: 325
        Upvote
        Up
        -1
        Down
        Not Helpful
        ::

        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)
      • You must be logged in to reply to this topic.