Hey Bruce, Happy New Year mate. Sorry I've been absent on line for abit rolling out the version 2 of the new aquaculture system.
Anyway to your issue, I have to import external data from numerous devices, CSV base but in different column orders. The primary data needs to be stored in a set table format in the system so to get over this I use the import gateway create temporary table command followed by a series of alter table commands the match the required format. I know which line the headers are in and that's what I use to alter the column headings to. So I was thinking you might let gateway do the initial import and manipulate the column names once the data is in R:Base. Happy to send you some code if it helps On Thu, 12 Jan 2023, 1:01 pm Bruce Chitiea, <[email protected]> wrote: > RBG5XE current > > I'll fill in the drywall forehead dents tomorrow, maybe. > > Been all over every aspect of this. Exhaustively. Target table refuses to > populate. > > Can anyone see a reason why this import fails? > > *GATEWAY TARGET TABLE* > CREATE TEMP TABLE stage2_atomized_tt + > ( stage1_filenameID TEXT (7) , + > rbms TEXT (4) , + > soNum TEXT (5) , + > custCode_txt TEXT (8) , + > docCode TEXT (1) , + > docDateRaw TEXT (10) , + > docNum TEXT (16) , + > docField08 TEXT (12) , + > docField09 TEXT (20) , + > docField10 TEXT (4) , + > docField11 TEXT (4) , + > docField12 TEXT (40) , + > docField13 TEXT (4) , + > stage2_column_count INT , + > walkListID INTEGER ) > > *IMPORT DATA SOURCE (sample set)* > D:\stage1_list_prepared.txt > > stage1_fileName > ------------------------------------------------------------- > 100001(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf > 100002(rbms(23233(cpsb....(1(2020-01-29(543199(stock(0(c(.pdf > 100003(rbms(23238(gar.....(1(2020-01-06(7274(na(0(c(.pdf > 100004(rbms(23239(gar.....(1(2020-01-16(7283(na(0(c(.pdf > 100005(rbms(23240(gar.....(1(2020-01-28(7288(na(0(c(.pdf > > *GATEWAY IMPORT CODE* > GATEWAY IMPORT CUS D:\stage1_list_prepared.txt + > APPEND stage2_atomized_tt + > OPTION FIRST_ROW 3 + > |SEPARATOR ( + > |ADD_MAPPING stage1_fileNameID = field1 + > |ADD_MAPPING rbms = field2 + > |ADD_MAPPING soNum = field3 + > |ADD_MAPPING custCode_txt = field4 + > |ADD_MAPPING docCode = field5 + > |ADD_MAPPING docDateRaw = field6 + > |ADD_MAPPING docNum = field7 + > |ADD_MAPPING docField08 = field8 + > |ADD_MAPPING docField09 = field9 + > |ADD_MAPPING docField10 = field10 + > |ADD_MAPPING docField11 = field11 + > |ADD_MAPPING docField12 = field12 + > |ADD_MAPPING docField13 = Field13 + > |ADD_MAPPING stage2_column_count = field14 + > |ADD_MAPPING walkListID = field15 > > I've tried SEPARATOR option value with and without single quotes: [ ( | > '(' ]. No difference. > > Any thoughts appreciated. > > Warmest Regards, Bruce > > Bruce A. Chitiea | SafeSectors, Inc. > 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA > +011 (909) 238-9012 m | *[email protected] <[email protected]>* > > > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/em83b2b1f7-53a0-471e-a941-b9396eee10e5%40fe37ca4e.com > <https://groups.google.com/d/msgid/rbase-l/em83b2b1f7-53a0-471e-a941-b9396eee10e5%40fe37ca4e.com?utm_medium=email&utm_source=footer> > . > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDAQq3S%2Bx4Hnpv_3K-V-qv4%2BO%2B9ajw6mPkukeWNTOPpL0iQ%40mail.gmail.com.
