1 / 15

Instruction for DESADV excel to XML tool version 17

Instruction for DESADV excel to XML tool version 17. Johan Lindström Created 2012-12-18 Revised 2013-02-12. Save the excelfile. Save the excelfile in an appropriate folder on your harddrive, this folder is where the new XML files will appear as well, so use a separate folder for this purpose.

ronna
Download Presentation

Instruction for DESADV excel to XML tool version 17

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Instruction for DESADV excel to XML tool version 17 Johan Lindström Created 2012-12-18 Revised 2013-02-12

  2. Save the excelfile Save the excelfile in an appropriate folder on your harddrive, this folder is where the new XML files will appear as well, so use a separate folder for this purpose.

  3. Data sheet In the data sheet the data is entered into the correct columns, the columns could be re-arranged if there should be a need, but the corresponding changes must then be made on the settings sheet.

  4. Settings sheet In the settings sheet the column letters are entered to match the way data has been entered in the data sheet, it is recommended that a format is decided and then that is always used so that the user does not have to change the settings for every file transformation. At the bottom the user must also enter from which row in the data field that the data should be considered. Remember to use capital letters in [Y/N]-boxes. ”0” means that function is disabled MDE uses dummy prices (set Y), Bangalore real prices (set N) Feature used in Bangalore, MDE has smaller shipments Bangalore (set Y), MDE can have use of this (set N)

  5. Export sheet In the export sheet the user enters the Bill of Entry (BOE) date, Parma ID for seller and buyer the warehouse location and the buyer address (Parma of the receiving LC) and the Purchase Order number if available.

  6. Example 1 - Data In this example the data contains 112 rows, the first 11 pallets contains 10 packages, and the 12th pallet only 2 lines. Since the setting is 10 rows per XML file the result should be that 12 XML files are created.

  7. Example 1 - Export Below we see the user interface message saying that the 12 files have been created and the location where the files can be found, press <Yes> to open the folder.

  8. Example 1 - Where the files end up A new folder has appeared named DESADV 2013-02-12 18.32.32 (YYYY-MM-DD HH.MM.SS)

  9. Example 1 - The new folder The 12 files are now in the folder and ready to be uploaded to the server.

  10. Example 1 – File 1

  11. Example 2 - Data In this example th data is the same but for line 11-13 we have changed the outer package (pallet number) to the same as for lines 1-10, thereafter everything is the same. The expected result is now 11 files, explanation for this comes in the next slides.

  12. Example 2 – File 1 When an outer package contains more than 10 rows the this overrides the functionality that breaks the files every 10 rows, thus we get the expected 13 rows in this case.

  13. Example 2 – File 2 Since nothing else has changes we still have 7 packages in pallet 30002, but when the program has created the file here it did not reach 10 rows when pallet 30002 was done so it fills up with 30003 until it has reached 10 rows and there are no more packages for 30003. In this case the file then contains 17 rows.

  14. Example 2 – File 3 After the first files it continues to create the files which now contains 10 rows per pallet. So the reason for why we got 11 files this time is that pallet 30002 and 30003 got placed in the same file.

  15. Validation list This sheet is usually hidden, here new supplier PARMA ID’s need to be set so that the list contains all valid PARMA’s. Make sure this is updated when a new supplier is implemented

More Related