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

Notifications

Announcements

Season of Giving Solutions is Here!
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)
  • Shirley McCutcheon Profile Picture
    Shirley McCutcheon 163 on at

    Thank you

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

    Do you know how to use the SQL Server Import and Export Wizard?

    If you do, first create a table called eConnect_Out_Setup_TEMP in your company database using the script below. Then using the wizard import the data you have in your csv file into eConnect_Out_Setup_TEMP.

    Then scroll down and run the second script to copy the data from eConnect_Out_Setup_TEMP into eConnect_Out_Setup. I do have these records in an Excel spreadsheet. If you want that send me an email and I will send it over.

    CREATE TABLE [dbo].[eConnect_Out_Setup_TEMP](
        [QUEUEPATH] [varchar](100) NOT NULL,
        [QUEUE_ENABLED] [int] NOT NULL,
        [DOCTYPE] [varchar](50) NOT NULL,
        [INSERT_ENABLED] [int] NOT NULL,
        [UPDATE_ENABLED] [int] NOT NULL,
        [DELETE_ENABLED] [int] NOT NULL,
        [TABLENAME] [varchar](30) NOT NULL,
        [ALIAS] [varchar](30) NOT NULL,
        [MAIN] [int] NOT NULL,
        [PARENTLEVEL] [int] NOT NULL,
        [ORDERBY] [int] NOT NULL,
        [USERDEF1] [varchar](30) NOT NULL,
        [USERDEF2] [varchar](30) NOT NULL,
        [USERDEF3] [varchar](30) NOT NULL,
        [USERDEF4] [varchar](30) NOT NULL,
        [USERDEF5] [varchar](30) NOT NULL,
        [REQUIRED1] [varchar](30) NOT NULL,
        [INDEX1] [varchar](30) NOT NULL,
        [INDEX2] [varchar](30) NOT NULL,
        [INDEX3] [varchar](30) NOT NULL,
        [INDEX4] [varchar](30) NOT NULL,
        [INDEX5] [varchar](30) NOT NULL,
        [INDEX6] [varchar](30) NOT NULL,
        [INDEX7] [varchar](30) NOT NULL,
        [INDEX8] [varchar](30) NOT NULL,
        [INDEX9] [varchar](30) NOT NULL,
        [INDEX10] [varchar](30) NOT NULL,
        [INDEX11] [varchar](30) NOT NULL,
        [INDEX12] [varchar](30) NOT NULL,
        [INDEX13] [varchar](30) NOT NULL,
        [INDEX14] [varchar](30) NOT NULL,
        [INDEX15] [varchar](30) NOT NULL,
        [INDEXCNT] [int] NOT NULL,
        [TRIGGER1] [varchar](30) NOT NULL,
        [TRIGGER2] [varchar](30) NOT NULL,
        [TRIGGER3] [varchar](30) NOT NULL,
        [TRIGGER4] [varchar](30) NOT NULL,
        [TRIGGER5] [varchar](30) NOT NULL,
        [TRIGGER6] [varchar](30) NOT NULL,
        [TRIGGER7] [varchar](30) NOT NULL,
        [TRIGGER8] [varchar](30) NOT NULL,
        [TRIGGER9] [varchar](30) NOT NULL,
        [TRIGGER10] [varchar](30) NOT NULL,
        [TRIGGER11] [varchar](30) NOT NULL,
        [TRIGGER12] [varchar](30) NOT NULL,
        [TRIGGER13] [varchar](30) NOT NULL,
        [TRIGGER14] [varchar](30) NOT NULL,
        [TRIGGER15] [varchar](30) NOT NULL,
        [TRIGGERCNT] [int] NOT NULL,
        [JOINTABLE] [varchar](30) NOT NULL,
        [JOIN1] [varchar](30) NOT NULL,
        [JOIN2] [varchar](30) NOT NULL,
        [JOIN3] [varchar](30) NOT NULL,
        [JOIN4] [varchar](30) NOT NULL,
        [JOIN5] [varchar](30) NOT NULL,
        [JOIN6] [varchar](30) NOT NULL,
        [JOIN7] [varchar](30) NOT NULL,
        [JOIN8] [varchar](30) NOT NULL,
        [JOIN9] [varchar](30) NOT NULL,
        [JOIN10] [varchar](30) NOT NULL,
        [JOINTO1] [varchar](30) NOT NULL,
        [JOINTO2] [varchar](30) NOT NULL,
        [JOINTO3] [varchar](30) NOT NULL,
        [JOINTO4] [varchar](30) NOT NULL,
        [JOINTO5] [varchar](30) NOT NULL,
        [JOINTO6] [varchar](30) NOT NULL,
        [JOINTO7] [varchar](30) NOT NULL,
        [JOINTO8] [varchar](30) NOT NULL,
        [JOINTO9] [varchar](30) NOT NULL,
        [JOINTO10] [varchar](30) NOT NULL,
        [DATACNT] [int] NOT NULL,
        [DATA1] [varchar](30) NOT NULL,
        [DATA2] [varchar](30) NOT NULL,
        [DATA3] [varchar](30) NOT NULL,
        [DATA4] [varchar](30) NOT NULL,
        [DATA5] [varchar](30) NOT NULL,
        [DATA6] [varchar](30) NOT NULL,
        [DATA7] [varchar](30) NOT NULL,
        [DATA8] [varchar](30) NOT NULL,
        [DATA9] [varchar](30) NOT NULL,
        [DATA10] [varchar](30) NOT NULL,
        [DATA11] [varchar](30) NOT NULL,
        [DATA12] [varchar](30) NOT NULL,
        [DATA13] [varchar](30) NOT NULL,
        [DATA14] [varchar](30) NOT NULL,
        [DATA15] [varchar](30) NOT NULL,
        [DATA16] [varchar](30) NOT NULL,
        [DATA17] [varchar](30) NOT NULL,
        [DATA18] [varchar](30) NOT NULL,
        [DATA19] [varchar](30) NOT NULL,
        [DATA20] [varchar](30) NOT NULL,
        [DATA21] [varchar](30) NOT NULL,
        [DATA22] [varchar](30) NOT NULL,
        [DATA23] [varchar](30) NOT NULL,
        [DATA24] [varchar](30) NOT NULL,
        [DATA25] [varchar](30) NOT NULL,
        [DATA26] [varchar](30) NOT NULL,
        [DATA27] [varchar](30) NOT NULL,
        [DATA28] [varchar](30) NOT NULL,
        [DATA29] [varchar](30) NOT NULL,
        [DATA30] [varchar](30) NOT NULL,
        [DATA31] [varchar](30) NOT NULL,
        [DATA32] [varchar](30) NOT NULL,
        [DATA33] [varchar](30) NOT NULL,
        [DATA34] [varchar](30) NOT NULL,
        [DATA35] [varchar](30) NOT NULL,
        [DATA36] [varchar](30) NOT NULL,
        [DATA37] [varchar](30) NOT NULL,
        [DATA38] [varchar](30) NOT NULL,
        [DATA39] [varchar](30) NOT NULL,
        [DATA40] [varchar](30) NOT NULL,
        [DATA41] [varchar](30) NOT NULL,
        [DATA42] [varchar](30) NOT NULL,
        [DATA43] [varchar](30) NOT NULL,
        [DATA44] [varchar](30) NOT NULL,
        [DATA45] [varchar](30) NOT NULL,
        [DATA46] [varchar](30) NOT NULL,
        [DATA47] [varchar](30) NOT NULL,
        [DATA48] [varchar](30) NOT NULL,
        [DATA49] [varchar](30) NOT NULL,
        [DATA50] [varchar](30) NOT NULL,
        [DATA51] [varchar](30) NOT NULL,
        [DATA52] [varchar](30) NOT NULL,
        [DATA53] [varchar](30) NOT NULL,
        [DATA54] [varchar](30) NOT NULL,
        [DATA55] [varchar](30) NOT NULL,
        [DATA56] [varchar](30) NOT NULL,
        [DATA57] [varchar](30) NOT NULL,
        [DATA58] [varchar](30) NOT NULL,
        [DATA59] [varchar](30) NOT NULL,
        [DATA60] [varchar](30) NOT NULL,
        [DATA61] [varchar](30) NOT NULL,
        [DATA62] [varchar](30) NOT NULL,
        [DATA63] [varchar](30) NOT NULL,
        [DATA64] [varchar](30) NOT NULL,
        [DATA65] [varchar](30) NOT NULL,
        [DATA66] [varchar](30) NOT NULL,
        [DATA67] [varchar](30) NOT NULL,
        [DATA68] [varchar](30) NOT NULL,
        [DATA69] [varchar](30) NOT NULL,
        [DATA70] [varchar](30) NOT NULL,
        [DATA71] [varchar](30) NOT NULL,
        [DATA72] [varchar](30) NOT NULL,
        [DATA73] [varchar](30) NOT NULL,
        [DATA74] [varchar](30) NOT NULL,
        [DATA75] [varchar](30) NOT NULL,
        [DATA76] [varchar](30) NOT NULL,
        [DATA77] [varchar](30) NOT NULL,
        [DATA78] [varchar](30) NOT NULL,
        [DATA79] [varchar](30) NOT NULL,
        [DATA80] [varchar](30) NOT NULL,
        [DATA81] [varchar](30) NOT NULL,
        [DATA82] [varchar](30) NOT NULL,
        [DATA83] [varchar](30) NOT NULL,
        [DATA84] [varchar](30) NOT NULL,
        [DATA85] [varchar](30) NOT NULL,
        [DATA86] [varchar](30) NOT NULL,
        [DATA87] [varchar](30) NOT NULL,
        [DATA88] [varchar](30) NOT NULL,
        [DATA89] [varchar](30) NOT NULL,
        [DATA90] [varchar](30) NOT NULL,
        [DATA91] [varchar](30) NOT NULL,
        [DATA92] [varchar](30) NOT NULL,
        [DATA93] [varchar](30) NOT NULL,
        [DATA94] [varchar](30) NOT NULL,
        [DATA95] [varchar](30) NOT NULL,
        [DATA96] [varchar](30) NOT NULL,
        [DATA97] [varchar](30) NOT NULL,
        [DATA98] [varchar](30) NOT NULL,
        [DATA99] [varchar](30) NOT NULL,
        [DATA100] [varchar](30) NOT NULL,
        [DATA101] [varchar](30) NOT NULL,
        [DATA102] [varchar](30) NOT NULL,
        [DATA103] [varchar](30) NOT NULL,
        [DATA104] [varchar](30) NOT NULL,
        [DATA105] [varchar](30) NOT NULL,
        [DATA106] [varchar](30) NOT NULL,
        [DATA107] [varchar](30) NOT NULL,
        [DATA108] [varchar](30) NOT NULL,
        [DATA109] [varchar](30) NOT NULL,
        [DATA110] [varchar](30) NOT NULL,
        [DATA111] [varchar](30) NOT NULL,
        [DATA112] [varchar](30) NOT NULL,
        [DATA113] [varchar](30) NOT NULL,
        [DATA114] [varchar](30) NOT NULL,
        [DATA115] [varchar](30) NOT NULL,
        [DATA116] [varchar](30) NOT NULL,
        [DATA117] [varchar](30) NOT NULL,
        [DATA118] [varchar](30) NOT NULL,
        [DATA119] [varchar](30) NOT NULL,
        [DATA120] [varchar](30) NOT NULL,
        [DATA121] [varchar](30) NOT NULL,
        [DATA122] [varchar](30) NOT NULL,
        [DATA123] [varchar](30) NOT NULL,
        [DATA124] [varchar](30) NOT NULL,
        [DATA125] [varchar](30) NOT NULL,
        [DATA126] [varchar](30) NOT NULL,
        [DATA127] [varchar](30) NOT NULL,
        [DATA128] [varchar](30) NOT NULL,
        [DATA129] [varchar](30) NOT NULL,
        [DATA130] [varchar](30) NOT NULL,
        [DATA131] [varchar](30) NOT NULL,
        [DATA132] [varchar](30) NOT NULL,
        [DATA133] [varchar](30) NOT NULL,
        [DATA134] [varchar](30) NOT NULL,
        [DATA135] [varchar](30) NOT NULL,
        [DATA136] [varchar](30) NOT NULL,
        [DATA137] [varchar](30) NOT NULL,
        [DATA138] [varchar](30) NOT NULL,
        [DATA139] [varchar](30) NOT NULL,
        [DATA140] [varchar](30) NOT NULL,
        [DATA141] [varchar](30) NOT NULL,
        [DATA142] [varchar](30) NOT NULL,
        [DATA143] [varchar](30) NOT NULL,
        [DATA144] [varchar](30) NOT NULL,
        [DATA145] [varchar](30) NOT NULL,
        [DATA146] [varchar](30) NOT NULL,
        [DATA147] [varchar](30) NOT NULL,
        [DATA148] [varchar](30) NOT NULL,
        [DATA149] [varchar](30) NOT NULL,
        [DATA150] [varchar](30) NOT NULL,
        [DATA151] [varchar](30) NOT NULL,
        [DATA152] [varchar](30) NOT NULL,
        [DATA153] [varchar](30) NOT NULL,
        [DATA154] [varchar](30) NOT NULL,
        [DATA155] [varchar](30) NOT NULL,
        [DATA156] [varchar](30) NOT NULL,
        [DATA157] [varchar](30) NOT NULL,
        [DATA158] [varchar](30) NOT NULL,
        [DATA159] [varchar](30) NOT NULL,
        [DATA160] [varchar](30) NOT NULL,
        [DATA161] [varchar](30) NOT NULL,
        [DATA162] [varchar](30) NOT NULL,
        [DATA163] [varchar](30) NOT NULL,
        [DATA164] [varchar](30) NOT NULL,
        [DATA165] [varchar](30) NOT NULL,
        [DATA166] [varchar](30) NOT NULL,
        [DATA167] [varchar](30) NOT NULL,
        [DATA168] [varchar](30) NOT NULL,
        [DATA169] [varchar](30) NOT NULL,
        [DATA170] [varchar](30) NOT NULL,
        [DATA171] [varchar](30) NOT NULL,
        [DATA172] [varchar](30) NOT NULL,
        [DATA173] [varchar](30) NOT NULL,
        [DATA174] [varchar](30) NOT NULL,
        [DATA175] [varchar](30) NOT NULL,
        [DATA176] [varchar](30) NOT NULL,
        [DATA177] [varchar](30) NOT NULL,
        [DATA178] [varchar](30) NOT NULL,
        [DATA179] [varchar](30) NOT NULL,
        [DATA180] [varchar](30) NOT NULL
    ) ON [PRIMARY]
    GO

    -------------------------------------------------------------------------------------------------------------------------------------------------

    After populating the eConnect_Out_Setup_TEMP table run this query to populate eConnect_Out_Setup

    -------------------------------------------------------------------------------------------------------------------------------------------------

    INSERT INTO [dbo].[eConnect_Out_Setup]
               ([QUEUEPATH],[QUEUE_ENABLED],[DOCTYPE],[INSERT_ENABLED],[UPDATE_ENABLED],[DELETE_ENABLED],[TABLENAME],[ALIAS],[MAIN],[PARENTLEVEL],[ORDERBY]
               ,[USERDEF1],[USERDEF2],[USERDEF3],[USERDEF4],[USERDEF5],[REQUIRED1],[INDEX1],[INDEX2],[INDEX3],[INDEX4],[INDEX5],[INDEX6],[INDEX7],[INDEX8]
               ,[INDEX9],[INDEX10],[INDEX11],[INDEX12],[INDEX13],[INDEX14],[INDEX15],[INDEXCNT],[TRIGGER1],[TRIGGER2],[TRIGGER3],[TRIGGER4],[TRIGGER5],[TRIGGER6]
               ,[TRIGGER7],[TRIGGER8],[TRIGGER9],[TRIGGER10],[TRIGGER11],[TRIGGER12],[TRIGGER13],[TRIGGER14],[TRIGGER15],[TRIGGERCNT],[JOINTABLE],[JOIN1],[JOIN2]
               ,[JOIN3],[JOIN4],[JOIN5],[JOIN6],[JOIN7],[JOIN8],[JOIN9],[JOIN10],[JOINTO1],[JOINTO2],[JOINTO3],[JOINTO4],[JOINTO5],[JOINTO6],[JOINTO7],[JOINTO8]
               ,[JOINTO9],[JOINTO10],[DATACNT],[DATA1],[DATA2],[DATA3],[DATA4],[DATA5],[DATA6],[DATA7],[DATA8],[DATA9],[DATA10],[DATA11],[DATA12],[DATA13],[DATA14]
               ,[DATA15],[DATA16],[DATA17],[DATA18],[DATA19],[DATA20],[DATA21],[DATA22],[DATA23],[DATA24],[DATA25],[DATA26],[DATA27],[DATA28],[DATA29],[DATA30]
               ,[DATA31],[DATA32],[DATA33],[DATA34],[DATA35],[DATA36],[DATA37],[DATA38],[DATA39],[DATA40],[DATA41],[DATA42],[DATA43],[DATA44],[DATA45],[DATA46]
               ,[DATA47],[DATA48],[DATA49],[DATA50],[DATA51],[DATA52],[DATA53],[DATA54],[DATA55],[DATA56],[DATA57],[DATA58],[DATA59],[DATA60],[DATA61],[DATA62]
               ,[DATA63],[DATA64],[DATA65],[DATA66],[DATA67],[DATA68],[DATA69],[DATA70],[DATA71],[DATA72],[DATA73],[DATA74],[DATA75],[DATA76],[DATA77],[DATA78]
               ,[DATA79],[DATA80],[DATA81],[DATA82],[DATA83],[DATA84],[DATA85],[DATA86],[DATA87],[DATA88],[DATA89],[DATA90],[DATA91],[DATA92],[DATA93],[DATA94]
               ,[DATA95],[DATA96],[DATA97],[DATA98],[DATA99],[DATA100],[DATA101],[DATA102],[DATA103],[DATA104],[DATA105],[DATA106],[DATA107],[DATA108],[DATA109]
               ,[DATA110],[DATA111],[DATA112],[DATA113],[DATA114],[DATA115],[DATA116],[DATA117],[DATA118],[DATA119],[DATA120],[DATA121],[DATA122],[DATA123],[DATA124]
               ,[DATA125],[DATA126],[DATA127],[DATA128],[DATA129],[DATA130],[DATA131],[DATA132],[DATA133],[DATA134],[DATA135],[DATA136],[DATA137],[DATA138],[DATA139]
               ,[DATA140],[DATA141],[DATA142],[DATA143],[DATA144],[DATA145],[DATA146],[DATA147],[DATA148],[DATA149],[DATA150],[DATA151],[DATA152],[DATA153],[DATA154]
               ,[DATA155],[DATA156],[DATA157],[DATA158],[DATA159],[DATA160],[DATA161],[DATA162],[DATA163],[DATA164],[DATA165],[DATA166],[DATA167],[DATA168],[DATA169]
               ,[DATA170],[DATA171],[DATA172],[DATA173],[DATA174],[DATA175],[DATA176],[DATA177],[DATA178],[DATA179],[DATA180])
    SELECT [QUEUEPATH],[QUEUE_ENABLED],[DOCTYPE],[INSERT_ENABLED],[UPDATE_ENABLED],[DELETE_ENABLED],[TABLENAME],[ALIAS],[MAIN],[PARENTLEVEL],[ORDERBY]
               ,[USERDEF1],[USERDEF2],[USERDEF3],[USERDEF4],[USERDEF5],[REQUIRED1],[INDEX1],[INDEX2],[INDEX3],[INDEX4],[INDEX5],[INDEX6],[INDEX7],[INDEX8]
               ,[INDEX9],[INDEX10],[INDEX11],[INDEX12],[INDEX13],[INDEX14],[INDEX15],[INDEXCNT],[TRIGGER1],[TRIGGER2],[TRIGGER3],[TRIGGER4],[TRIGGER5],[TRIGGER6]
               ,[TRIGGER7],[TRIGGER8],[TRIGGER9],[TRIGGER10],[TRIGGER11],[TRIGGER12],[TRIGGER13],[TRIGGER14],[TRIGGER15],[TRIGGERCNT],[JOINTABLE],[JOIN1],[JOIN2]
               ,[JOIN3],[JOIN4],[JOIN5],[JOIN6],[JOIN7],[JOIN8],[JOIN9],[JOIN10],[JOINTO1],[JOINTO2],[JOINTO3],[JOINTO4],[JOINTO5],[JOINTO6],[JOINTO7],[JOINTO8]
               ,[JOINTO9],[JOINTO10],[DATACNT],[DATA1],[DATA2],[DATA3],[DATA4],[DATA5],[DATA6],[DATA7],[DATA8],[DATA9],[DATA10],[DATA11],[DATA12],[DATA13],[DATA14]
               ,[DATA15],[DATA16],[DATA17],[DATA18],[DATA19],[DATA20],[DATA21],[DATA22],[DATA23],[DATA24],[DATA25],[DATA26],[DATA27],[DATA28],[DATA29],[DATA30]
               ,[DATA31],[DATA32],[DATA33],[DATA34],[DATA35],[DATA36],[DATA37],[DATA38],[DATA39],[DATA40],[DATA41],[DATA42],[DATA43],[DATA44],[DATA45],[DATA46]
               ,[DATA47],[DATA48],[DATA49],[DATA50],[DATA51],[DATA52],[DATA53],[DATA54],[DATA55],[DATA56],[DATA57],[DATA58],[DATA59],[DATA60],[DATA61],[DATA62]
               ,[DATA63],[DATA64],[DATA65],[DATA66],[DATA67],[DATA68],[DATA69],[DATA70],[DATA71],[DATA72],[DATA73],[DATA74],[DATA75],[DATA76],[DATA77],[DATA78]
               ,[DATA79],[DATA80],[DATA81],[DATA82],[DATA83],[DATA84],[DATA85],[DATA86],[DATA87],[DATA88],[DATA89],[DATA90],[DATA91],[DATA92],[DATA93],[DATA94]
               ,[DATA95],[DATA96],[DATA97],[DATA98],[DATA99],[DATA100],[DATA101],[DATA102],[DATA103],[DATA104],[DATA105],[DATA106],[DATA107],[DATA108],[DATA109]
               ,[DATA110],[DATA111],[DATA112],[DATA113],[DATA114],[DATA115],[DATA116],[DATA117],[DATA118],[DATA119],[DATA120],[DATA121],[DATA122],[DATA123],[DATA124]
               ,[DATA125],[DATA126],[DATA127],[DATA128],[DATA129],[DATA130],[DATA131],[DATA132],[DATA133],[DATA134],[DATA135],[DATA136],[DATA137],[DATA138],[DATA139]
               ,[DATA140],[DATA141],[DATA142],[DATA143],[DATA144],[DATA145],[DATA146],[DATA147],[DATA148],[DATA149],[DATA150],[DATA151],[DATA152],[DATA153],[DATA154]
               ,[DATA155],[DATA156],[DATA157],[DATA158],[DATA159],[DATA160],[DATA161],[DATA162],[DATA163],[DATA164],[DATA165],[DATA166],[DATA167],[DATA168],[DATA169]
               ,[DATA170],[DATA171],[DATA172],[DATA173],[DATA174],[DATA175],[DATA176],[DATA177],[DATA178],[DATA179],[DATA180]
    FROM eConnect_Out_Setup_TEMP

    GO

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 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.

  • 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,852 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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 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.

  • 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,852 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

    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,852 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?

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

News and Announcements

Season of Giving Solutions is Here!

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 December 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