You’re offline. This is a read only version of the page.
155
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
Thank you
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
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.
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!
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.
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.
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.
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.
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?
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,900
Super User 2024 Season 2
#2
Martin Dráb
229,275
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (