Hello:
Yes, there is a better way. The Excel imports are wonderful for small
imports, but for the larger ones, you really need to write X++ code. I have
done this on several installs for gigs of historical data, anything from
financial transactions to customers to open sales orders. I have a client with
several hundred thousand combinations for one sector of their company.
The data should be manipulated as much as possible (cleansed) and pre-processed
in SQL prior to import.
Thanks
Michael G. Simms MCDBA, CBIP
mgsr...@yahoo.com
________________________________
From: "visti2...@gmail.com" <visti2...@gmail.com>
To: Axapta-Knowledge-Village@yahoogroups.com
Cc: maryann.h...@gmail.com
Sent: Monday, December 22, 2008 11:17:22 PM
Subject: Re: [Axapta-Knowledge-Village] INVENTDIM, INVENTCOMBINATIONS IMPORT
Hi friends,
I am also currently implementing AX 4.0 SP2 in one of the industries
where I am only using configurations.
Can anyone help me as to how I need to import Item-Config combination
coz I am only using Item-Configs
I have about 5.5 lacs items with each item having 2 / 3 configs
Please help for the same
Thanks in advance
On 12/22/08, MaryAnn Hand <maryann.hand@ gmail.com> wrote:
> Developers can import with AX jobs and load data faster than Excel.
>
> On Mon, Dec 22, 2008 at 8:36 AM, ax_con <ax_...@yahoo. com> wrote:
>> Dear all,
>>
>> I am working in paint industry, I am using configuration and size
>> inventory dimensions, I have about 3000 colors, 10 Sizes, and 500 items.
>> I need to upload millions of records in Inventcombination and inventdim
>> table....I wanted to know if there is any quicker way to upload the
>> data than through excel templates, or through excel templates is there
>> any better procedure followed by any of you in the past.
>>
>> Regards
>> Sayeed
>>
>>
>
--
With Regards,
Mr. Vishtaspa Sethna
Associate E.R.P. Consultant
Godrej Infotech Ltd.
Cell: +919718010823
