Dear all,
You can directly push data into axapta tables via Atlas XL(excel interface tool) It validates the mandatory fields and also creates record its automatically. Normally i never use import option, when i have Atlas XL. Regards, Vivek K Vivekanandan Start by doing what is necessary, then do what is possible, and suddenly you are doing the impossible. www.robinhood.in To: Axapta-Knowledge-Village@yahoogroups.com From: maryann.h...@gmail.com Date: Fri, 20 Mar 2009 05:49:14 -0600 Subject: Re: [Axapta-Knowledge-Village] Importing Question You can never import directly into an AX database because you cannot succeed in setting the record ids. You can try to use the AX Admin import - but there is one new complexity with AX 2009 - the global address book must be loaded with customer data as well and I personally have not been very successful doing Admin imports when this is the case. Open the CustTable form, right click and choose Setup, go to middle tab, click edit on the form name, open the DataSources node. There you see all the tables that must be loaded for customer records to display in AX. What state are your 50K rows in? Is it in another database accessible by ODBC? Is it in a delimited text file? My most effective way of importing data when there are other datasources needed is to use an X++ job that creates an instance of axCustTable class. You read the data via ODBC or with one of the IO classes for text files. You use parm methods of the axCustTable class to set fields that you have read. Then you call the axCustTable.save() method. That process will populate all of the tables for you auto-"magically". You may want to get help from a developer for this process. On Thu, Mar 19, 2009 at 9:00 AM, Girac <girac...@yahoo.com> wrote: > Hi Everyone, I'm fairly new to Ax2009. My question is on importing data into > the CustTable. > I have about 50K rows of customer info to import into Ax. Can I import > directly into the database or should I do this through AX Admin/Data > export-import form? > Thanks > > _________________________________________________________________ Twice the fun—Share photos while you chat with Windows Live Messenger. http://www.microsoft.com/india/windows/windowslive/messenger.aspx