Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 159

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

  • Shirley McCutcheon Profile Picture
    Shirley McCutcheon 159 on at
    RE: How can the eConnect_Out_Setup table be recreated with default data

    Thank you

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,772 on at
    RE: How can the eConnect_Out_Setup table be recreated with default data

    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,772 on at
    RE: How can the eConnect_Out_Setup table be recreated with default data

    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 159 on at
    RE: How can the eConnect_Out_Setup table be recreated with default data

    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,772 on at
    RE: How can the eConnect_Out_Setup table be recreated with default data

    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,772 on at
    RE: How can the eConnect_Out_Setup table be recreated with default data

    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 159 on at
    RE: How can the eConnect_Out_Setup table be recreated with default data

    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,772 on at
    RE: How can the eConnect_Out_Setup table be recreated with default data

    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 159 on at
    RE: How can the eConnect_Out_Setup table be recreated with default data

    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,772 on at
    RE: How can the eConnect_Out_Setup table be recreated with default data

    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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,234 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans