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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Automate File Import t...
Microsoft Dynamics GP (Archived)

Automate File Import to GP

(1) ShareShare
ReportReport
Posted on by Community Member

Hi,

 I was wondering if there was a solution to automate a data transfer into Item Maintenance details (Dynamics GP), that would not have to be manually run daily.

The software we need data imported from is AssurX

 -What file type would it have to be?

-What programs or methods would be used?

-Could a sql job create a trigger to input the information?

Thanks everyone for your help! much appreciated

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Harold Worby Profile Picture
    Harold Worby 1,331 on at

    You can use Integration Managers's econnect Invetory Item destination and run IM as a scheduled task. The econnect destinations in IM do not need to have anyone logged in to GP to run and can run in the background.

  • Verified answer
    Lyn Barr Profile Picture
    Lyn Barr 1 on at

    There are all sorts of ways to automate data imports. You can use scheduled jobs in SQL, you can write a dexterity integration, or more commonly, you can use a tool such as SmartConnect or Scribe.

    There are also many different options for how your source data is formatted and stored.

    I recommend you talk with your partner about the options that are best for you. The short answer is that it can probably be done just about any way you want it to be done, using just about any source file you can come up with!

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    You could purchase the Customization Suite for GP which includes Integration Manager. You then use Windows Task Manager to run the integration automatically. The import file could be a csv, txt, xls, xml or any ODBC compatible database.  You could also write your own integration using a host of tools.

  • Community Member Profile Picture
    Community Member on at

    Thank you everyone for the help!!!!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans