I agree that CSV file is faster than Excel, but if you have close to 65000 records I would never recommend using it. Still going to take, much, much longer than X++ code.
Most of the time, during implementations, you can re-use a lot of the same X++ import scripts that you have done in the past. Still I never recommend going that route if you have over 40,000 records. The time it will take to develop an X++ import code, and import it vs. using the standard import is much less, much less. Plus you have the X++ code developed now, and have total control, and you can build from that, and re-use. X++ is so much better, and the far better choice. Now for one time imports, that deal with new installations, that are less than 40,000 records per spreadsheet, CSV file, sure use the standard. If you go beyond that, your wasting time... thanks, J. Brandon George Senior Technical Architect Sunrise Technologies, Inc. http://www.sunriseconsult.com Cell: 706-412-7726 Office: 336-722-6741 <http://www.sunriseconsult.com/> <http://www.sunriseconsult.com/> ________________________________ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Garg, Vikas Sent: Friday, January 12, 2007 8:58 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Re: about Best FAS software integration with Dynamics Ax Hi, Just to add few words on data import process using Excel. One can speed up the data import process using CSV format files instead of using XLS. And I believe using the standard way to import is better then writing extra code for the same if number of records is less then 65000 (because of excel limit for number of records). Regards Vikas Garg ________________________________ From: Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [mailto:Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> ] On Behalf Of Brandon George Sent: Friday, January 12, 2007 6:02 PM To: Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> Subject: RE: [Axapta-Knowledge-Village] Re: about Best FAS software integration with Dynamics Ax Importance: High You are right in your steps (basically) for creating Excel Import Templates. I mean you could go into more detail about import data def., etc. And custom validation X++ code on the data def. But basically that's exactly what you have to do for importing via the standard import. This is great for Functional Consultants, during implementation, on small data sets. However compare this: 65,000 record limit for Excel Spreadsheet. If you fill that up, it will take 4-7 hours for Ax to bring in that data via those imports. Now take 65,000 records, and import via X++ code, it will take 3-7 mins., at max! You compare those numbers. Also think about how many iterations you have to go through until the data is right? Now times those iterations by the time it takes to bring in the data, you tell me what is the best way? Again for small data sets, and not automating the process, the excel spreadsheets are great. Also, Amit said he wanted this done on a monthly process, that means automation... so X++, integration point, is for sure the way to go for the Monthly process. Granted you can use BizTalk, MSMQ, AIF, Web Services, DotNet, X++, and any and all of those mixed together to create an importing framework, that can then be extended to each integration point (ie: FAS 1000 Fixed Assets) for automating the process, and making it fast, effective, and have total control over the entire thing. You need a technical person to do what Amit is wanting to do.... thanks, J. Brandon George Senior Technical Architect Sunrise Technologies, Inc. http://www.sunriseconsult.com <http://www.sunriseconsult.com> < http://www.sunriseconsult.com <http://www.sunriseconsult.com> > Cell: 706-412-7726 Office: 336-722-6741 <http://www.sunriseconsult.com/ <http://www.sunriseconsult.com/> < http://www.sunriseconsult.com/ <http://www.sunriseconsult.com/> > > <http://www.sunriseconsult.com/ <http://www.sunriseconsult.com/> < http://www.sunriseconsult.com/ <http://www.sunriseconsult.com/> > > ________________________________ From: Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [mailto:Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> <mailto:Axapta-Knowledge-Village%40yahoogroups.com> ] On Behalf Of subhashmn Sent: Friday, January 12, 2007 1:29 AM To: Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> <mailto:Axapta-Knowledge-Village%40yahoogroups.com> Subject: [Axapta-Knowledge-Village] Re: about Best FAS software integration with Dynamics Ax Hi Amit, I hope you can import the said data into Axapta using Excel Import comfortably. To my knowledge, for any module's data: 1) Identify the necessary tables in Axapta and create Excel Templates. 2) Fill the external data (for example FAS1000 Fixed Assets Data) into the above created templates. 3) Include extra userdefined validations, if any required. 4) Import the data from the excel templates using Axapta Excel Import. I have mentioned in a very brief manner, please add up more details if any one can and also correct me if any thing is to be corrected in my steps. We did the similar imports to various modules comfortably. NOTE: Pls check whether all the posting are giving correct results once after importing. Subhash --- In Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> <mailto:Axapta-Knowledge-Village%40yahoogroups.com> <mailto:Axapta-Knowledge-Village%40yahoogroups.com> , "Amit Nirantare" <[EMAIL PROTECTED]> wrote: > > Please guyz...i am strugling on this....the partner source is not any help pertaining this. do any one have manual to setup this integration things. > > Appreciate if any one can respond to it. > > Regards > > Amit > > ________________________________ > > From: Amit Nirantare > Sent: Tue 1/9/2007 3:10 PM > To: Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> <mailto:Axapta-Knowledge-Village%40yahoogroups.com> <mailto:Axapta-Knowledge-Village%40yahoogroups.com> > Subject: about Best FAS software integration with Dynamics Ax > > > > Hi, > > My client has FAS 1000 fixed asset software. Dynamics Ax has functionality to import the fixed asset transactions from this FAS1000 software. Can any one guide me what are the setups, and parameterization in order to achieve this. > > Thanks in advance > > Amit > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]