From:
Hemant Kumthekar [mailto:[EMAIL PROTECTED]
Sent: Saturday, 12 February 2005
5:08 a.m.
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re:
[Axapta-Knowledge-Village] Re: Very large item master
Hi,
To upload Item Master, BOM , Routings with large amount of data, MS-SQ
y 11, 2005 9:01
AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE:
[Axapta-Knowledge-Village] Re: Very large item master
You can write a class
to import this via ODBC from a staging database. This will ensure all of
the RI is correct. I have written classes for all of our da
the message and deleting it from your computer.
From: Hemant Kumthekar
[mailto:[EMAIL PROTECTED]
Sent: Friday, February 11, 2005
11:08 AM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject: Re:
[Axapta-Knowledge-Village] Re: Very large item master
Hi,
To upload
Hi,
To upload Item Master, BOM , Routings with large amount of data, MS-SQL DTS is better option, other way is to create a CSV files. We had the same problem in one of our implementation where we had around 700K records in BoM it took us 5 hours to upload using CSV and the upload was done on
Hey sorry for my third mail on this. something else came into my mind..Actually I didn't have access to SQL database as my administrator did n't give me the access ( kidding ! ). Did you try to load directly in SQL using DTS?. how does sound. I guess its a worth to give a try...
Hi,
As a work-around you could import into InventTable and then do a consistency
check, which will add the missing records in InventTableModule.
However, I will regard this as a last resort, since you may need info in
InventItemLocation.
To my knowledge, the records in InventDim will be created
Just adding to my last email, at the end of the load, you need to run consistency check to make sure your data is valid.Subrahmanyam Mamidi <[EMAIL PROTECTED]> wrote:
Hi,
Presently I am migrating master data into Axapta.
1. Axapta is relatively slow for Excel as it uses COM
Hi,
Presently I am migrating master data into Axapta.
1. Axapta is relatively slow for Excel as it uses COM for communication. It took approximately 2 hours to upload ~ 9000 records in just only one Table ( invnetTable).
So I wrote jobs that read from the flat file and Individually insert
8 matches
Mail list logo
