Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / export employee inform...
Microsoft Dynamics GP (Archived)

export employee information from Dynamics GP

(0) ShareShare
ReportReport
Posted on by dynamics-erik

It's been a loooong while since I have dealt in Dynamics.   I have a new installation of Dynamics 2018 (w/ eConnect).  I was shown the employee information within the application, but now I am trying to pull that data out (preferably from c# or powershell) on a regular basis.   Is talking to eConnect the way to go?  Seems like most examples are for writing information to Dynamics.  I am strictly reading data.   Should I be looking to the database directly instead?

Thanks in advance for any pointers.


Erik

*This post is locked for comments

  • dynamics-erik Profile Picture
    dynamics-erik on at
    RE: export employee information from Dynamics GP

    Thanks for sharing some breadcrumbs.   Victoria's table reference has a section on Payroll tables that is exactly what I need.   Thank you!

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: export employee information from Dynamics GP

    The SDK has payroll but not HR. You can click on Tools->Resource Descriptions->Tables and then the series and product to get an idea. If you are still stuck let me know the information you need and I can tell you the tables. You can also use the handy table reference provided by Victoria Yudin located here victoriayudin.com/gp-tables.

  • dynamics-erik Profile Picture
    dynamics-erik on at
    RE: export employee information from Dynamics GP

    That's definitely along the lines of what I am thinking.   Do you know if schema documentation is available?  I peeked at the tables and there are many of them (and cryptic too!).  I don't know where to look for HR/Employee data.

    Thanks,

    Erik

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: export employee information from Dynamics GP

    You could create an SSIS project in SQL and then schedule that process to run at whatever intervals necessary.

  • dynamics-erik Profile Picture
    dynamics-erik on at
    RE: export employee information from Dynamics GP

    This needs to be an automatic, recurring process.  The SmartList is how it was shown to me interactively within the application.  Is there a way to pull SmartList data from an API?   Or maybe there's a way to schedule a smartlist to automatically be run regularly and deliver an export to a specific file folder or email address? I do have access to the database, but worry about breaking changes happening there (although since we are talking reading data out only, that might not be a show-stopper.

    I'm doing integrations with a few different systems and this one is the only one that doesn't seem to have an obvious option.   I'm looking for advice from people who have done something similar.

    Thanks

  • mm123 Profile Picture
    mm123 2,535 on at
    RE: export employee information from Dynamics GP

    Erik, We have done a similar employee & other info Data export out of GP  for our customers based on their specific requirement,  using custom GP programming.  This export will happen automatically or manual button click & on-scheduled time.  If you are interested please let me know.

    samr(at)expsoltech(dot)com

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: export employee information from Dynamics GP

    Does this extraction need to be automatic or will it always occur manually? I assume using SmartList is not sufficient? eConnect is used to write to the GP database. You could set up a SQL view and then point Excel to that view to extract the fields you need. VS is also another way to go. There are several options.

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans