Importing data from excel/CSV files to Axapta

vchitnis
vchitnis Member Posts: 2
edited 2006-05-18 in Dynamics AX
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

Comments

  • Harish
    Harish Member Posts: 172
    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,
    Harish Mohanbabu
    Long way to go before I sleep..

Categories