I tell you the best way to upload data. Create Classes in X++ that use ODBC. I always upload customer data into Axapta during implementations using X++ and ODBC.
To give you and example, we had a functional consultant take Zipcode data and try and upload that into Axapta through the Excel import. It took 5 hours for Axapta to upload that data through Excel. I took the data when I came on the project, and had to re-load the Zipcode data. I delete it, and used my ODBC Classes that I have wrote in X++ and it took less than 10 mins. 5 hours vs. less then 10mins? If you want an example on how to do this you can search the site: http://dynamics-ax.blogspot.com Thanks, Brandon -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hemant Kumthekar Sent: Thursday, March 23, 2006 9:23 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Upload Thru Axapta Excel Templates Hi, Use CSV file to upload. It is faster than excel upload. Create the same excel spreadsheet, but you may have to map later to create definition for upload. We had uploaded 4 years balances for 3 companies, thats lot of records but the load was much much faster. Another soultion is ATLAS/XL that works well too but I haven't tested with heavy load, you may give a try. Hemant Nihar Saraiya <[EMAIL PROTECTED]> wrote: Hi Group I tried to upload Ledger Transactions thru Axapta Excel Template, using LedgerJournalTrans table. I uploaded 378 lines with minimal data at each line level. It took almost 15 minutes. What i would like to know, is there any way to optimize the Data Upload thru Axapta? Is there a way to reduce the Formatting Issue? Does any one use any 3rd Party tool to upload the data into Axapta? The above are generic questions, but would really appreciate some advise on them. Regards Nihar Saraiya, Synergy Software Systems, Confidentiality Notice This email is confidential and may also be privileged. If you are not the intended recipient please notify the sender immediately. You must not copy or use it for any purpose or disclose its contents to any other person. The sender accepts no responsibility for viruses received with or changes made to this email after it was sent. Any opinion expressed in this email may be personal to the sender. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. --------------------------------- YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Blab-away for as little as 1ยข/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
