Importing data from excel/CSV files to Axapta

vchitnis

Hello everybody,

I am facing problem when importing data from csv file to axpta table using "custom" type definition group. I want to create records for smmQuotationLines and smmQuotationTable.

I put some code under conversion tab of table setup for smmQuotationLines to initialise from other tables.Using some methods like initFromSmmQuotationTable, initFromInventTable from this location.But they are not affecting any thing.

I have tried with "Excel Import" type definition group as well.

Can anyone suggest me what can I do for this.

OR

What could be the way I can import data from XLS/CSV format files for smmQuotationLines table.
Preferrably using Axapta's Import functionality.

Any kind of suggestion will be of great help.

Thanks,
Vaibhav

Harish

Hi Vaibhav,

It should be somewhat straight forward for a developer to import the data by code. For inspiration, please see here -

http://www.harishm.com/Navision/Code.html

Alternatively you might want to check Atlas XL - an Excel add-in which will allow you to import as well as export data from Axapta.

http://www.atlasxl.com.au/

Good luck,