Hi there, I just started to work with Axapta and I’m having a bad time trying to import a csv file exported from SQL Server. The file only contains data for the InventTable table. I went in Administration/Import Export/Definition Group, created a new group with custom as the type, then in table set up I specified the Axapta table to load and the file to import and finally I listed the Field name in the field setup with the field number corresponding to the order that they appears in the flat file. When I click import on the Definition group button it hang out, takes forever and finally display an info log saying that the Item number already exist after inserting only one row. The item number are unique in the flat file and I don’t event see the only row that is suppose to be import in the table. I’m probably missing some step and I don’t find that much documentation on the topic. I’d really appreciate if I could have any clue or reference on what I should do to achieve this simple task. Thanks in advance.
hi JeromeQc, i think if you want to import invent table you most import some table to … this is the list of table you need to import : - Item Group - InventItemLocation - InventItemModule - and of course InventTable hope it’s help regards, Danang Ismu
Never mind, I was just missing some settings under the data definition general tab…