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

Notifications

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) / How can the eConnect_O...
Microsoft Dynamics GP (Archived)

How can the eConnect_Out_Setup table be recreated with default data

(0) ShareShare
ReportReport
Posted on by Shirley McCutcheon 163

I have a client who is on GP 2018.  They have developers who are beginning to try to create an eConnect application for them.  For some strange reason there is only 1 record in the eConnect_Out_Setup table.  Is there a way to recreate this table with all the correct default entries.  There should be 105 rows in this table.

I have used the SQL Import/Export utility to export that data from this table on my local install of GP 2018 to a flat file.  Will it work OK to just import from that flat tile on their install to repopulate the table properly?  Thanks!

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Do they have other companies or the TWO company loaded? You will find the records there and write a quick script to copy them over. You could install the TWO company too.

  • Shirley McCutcheon Profile Picture
    Shirley McCutcheon 163 on at

    They have a test company and the TWO company.  But, they all have just the 1 record in that table.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Can someone from Microsoft chime in on this? All of my econnect_out_setup tables have records in them plus 2 triggers. Before I write a script based on the records I have I would like to know how to populate this table from within GP. How do you activate the code within GP to populate this table?

  • Shirley McCutcheon Profile Picture
    Shirley McCutcheon 163 on at

    Thank you Richard.  It would be very good if someone from Microsoft would assist with this.  Until they do, the actual table structure is probably OK so the table might not necessarily need to be recreated, but just populated with the default data.  In that case, do you see any problem with using the SQL import/export utility to import the records from the flat file that I created by exporting from my local GP2018 install?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Do you see the two triggers for this table?

    eConnectOutSetupDelete

    eConnectOutSetupEnabled

    If so, you should be able to use Table Import to import the records. I am surprised that I cannot find anything about how that table get populated nor in the Connect Programmer's guide.

    I could create a script based on the records I have in my table, if that would help.

  • Shirley McCutcheon Profile Picture
    Shirley McCutcheon 163 on at

    I will have to check with my client to make sure that it does have the 2 triggers.  Does your table have the default records or have you modified them?  If they are the default records and it wouldn't be too much trouble, I would greatly appreciate it if you would do that. 

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    The records in that table vary based on what GP modules are installed. Can you send me a copy of their DYNAMICS.SET file. If it just the default modules that is what I have.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Are the developers claiming they need these records? If they really need them either use table import to insert those records or once I know which modules they use I will create a script to populate that table and send the script over.

  • Shirley McCutcheon Profile Picture
    Shirley McCutcheon 163 on at

    Yes, their developers would like this table populated.  They have created a custom record for the Customer (which is what they are most interested in right now), but would like to have that record as well as other records.  I have requested the dynamics.set file from their IT person but have not received it yet.  However, I can tell you that they have the core modules, HR, and a 3rd party app from Binary Stream which is serial lot copy paste.   They may use inventory and PO records in the future.   So, all the records for the core modules would be good. Thank you!

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    I will have something ready for you by morning. It will be a series of SQL INSERT statements. I will paste it into this forum in the event someone else needs it.

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
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans