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 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 subhashmn Sent: Friday, January 12, 2007 1:29 AM To: Axapta-Knowledge-Village@yahoogroups.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> , "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> > 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]