Bulk Adding Items via SQL

(0) Share

Report

Posted on by dmacintosh

1,145

Hello everyone,

I have a unique situation, or at least I believe it to be. We are looking to add roughly 500K+ items to our GP 9. We have macro the procedure but due to some small scale testing, we believe that the macro would take hundreds if not thousands of hours to complete and that is not accounting for the breaks as we would have to divide the macro up for performance reasons.

My next thought was to instead add these items via SQL. I started by running the macro in our test environment and running SQL Profiler to catch the save actions. Unfortunately, this hasn't worked to well as it seem only selects are taking place.

I am wondering if anyone has had experience with a bulk upload via SQL or perhaps some other method. Thank you in advance

*This post is locked for comments

All responses (2)

Answers (2)

Verified answer

L Vail 65,271 on at

Like (0)

Report

RE: Bulk Adding Items via SQL

Hi,

Of course, if you have Integration Manager or eConnect, you would definitely use those tools. If you've got 500K items to import, I would buy it if I didn't have it.

If you are dead set on doing a table import, you need to look at the GP SDK (software development kit). In the SDK, you'll find a section named 'Table Integration', select 'Design Documents and Transaction Flows' under that section and then 'Item Master Import Guidelines' in the Inventory section.

A Word document will open that explains in detail how to import an Item. Back in the 'old days', the days before Integration Manager and eConnect (yes, I've been around that long) we had to use the Table Import utility to do all of our master file and transaction imports. While no business logic was applied, it was (and still is) super fast.

You can use this article as a guide for which tables to insert into using SQL, or you can use the import utility. To launch the import utility use the following navigation:

Microsoft Dynamics GP > Tools > Integrate > Table Import

It works like a champ, but backup and test, test, test. Be sure to run Check Links after any import accomplished using Table Import or SQL.

Good Luck!

Kind regards,

Leslie

PS I still use table import regularly.

LV
Verified answer

soma 24,406 on at

Like (0)

Report

RE: Bulk Adding Items via SQL

Do you have Integration Manger? If yes, you can import bulk number of items into GP. Or If you have the eConnect tools, you can create customization to import the same.

For SQL importing, referring the tables names from Victoria Yudin-MVP site(victoriayudin.com/.../inventory-tables)

Note: I wouldn't recommend SQL insert. Anyway if you using SQL insert, pleas try this on test environment. Then before go to the live, make sure you have latest backup for company database.

Hope this helps!!!