Options

Importing item translations

lanemarklanemark Member Posts: 82
edited 2014-08-11 in Navision Attain
We are currently creating an Excel spreadsheet with alternative Item descriptions.
We want to use these as a "less technical " description of items on Sales documents. I intend to create a language code called "Spares" and use this language code on all customer cards. This will then use the new descriptions on sales documents, the problem is we have many items that need description changes, we have done this in Excel.
Can someone advise how we can import these new descriptions into Navision V5.

Comments

  • Options
    KowaKowa Member Posts: 918
    Save the excel sheet as a "CSV (MS-DOS)" file (check that the delimiter (comma or semicolon depending on settings) is not accidently included in any of the fields).
    Open the CSV file to check the structure and then create a new dataport to process the file and write the data to table 30 Item Translation.
    If the direct import seems to delicate, you can add a further step, import the data into a separate buffer table first (copied from table 30) , and if everything looks okay, copy the data from there to table 30.
    Kai Kowalewski
Sign In or Register to comment.