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]
--
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.
