web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Bulk Adding Items via SQL
Microsoft Dynamics GP (Archived)

Bulk Adding Items via SQL

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Verified answer
    soma Profile Picture
    soma 24,410 on at
    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!!!

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans