Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Bulk Adding Items via SQL

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

  • 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

  • Verified answer
    soma Profile Picture
    soma 24,406 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!!!

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans