Bruce,
Are you able to complete the process using the manual GATEWAY IMPORT GUI
interface?
If successful, you may create the "Import Specification (.rgw)" file to
automate the entire process.
Hope that provides you with some blue's clues!
Very Best R:egards,
Razzak
On 1/11/2023 10:01 PM, Bruce Chitiea 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]/
--
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/e13815b8-43c1-be23-f4ea-a4d8bfec3d5b%40rbase.com.
