Hey Jim, Happy New Year, and thanks. Great minds.
My original code, which I simplified for presentation to the list,
looked like this:
SET VAR +
v04_folder_lists = 'D:\WORKBENCH\RBMS\FNAME_2\2-FILE_LIST\', +
v04_fileList_stage1 = 'stage1_list_prepared.txt'
SET VAR +
v04_fileSpec_importSource = (.v04_folder_lists +
.v04_fileList_stage1)
GATEWAY IMPORT CUS &v04_fileSpec_importSource +
APPEND stage2_atomized_tt +
OPTION FIRST_ROW 3 +
|SEPARATOR ( +
...+
Also tried the import source as a dot variable. Since the GUI import
succeeded, now attempting to integrate the .RGW file into the code.
Always appreciated, Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | [email protected]
------ Original Message ------
From "'Jim Belisle' via RBASE-L" <[email protected]>
To "[email protected]" <[email protected]>
Date 1/12/2023 9:10:08 AM
Subject RE: Re[2]: [RBASE-L] - GATEWAY IMPORT Fail
The file path set to a var is normally better because you do not have
to worry about spaces, etc.
At least that has helped me with my RGW spec code.
James Belisle
Making Information Systems People Friendly Since 1990
From:[email protected] <[email protected]> On Behalf Of
Bruce Chitiea
Sent: Thursday, January 12, 2023 11:01 AM
To:[email protected]
Subject: Re[2]: [RBASE-L] - GATEWAY IMPORT Fail
CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on
any links or opening attachments.
R:azzak:
Thank you, the GUI import succeeds. An .RGW file was generated during
the successful import. I am unclear on the syntax for integrating the
.RGW approach into code. This fails to populate the target table:
GATEWAY IMPORT CUS D:\stage1_list_prepared.txt +
APPEND stage2_atomized_tt +
OPTION SPECIFICATION_FILE_NAME stage1_list_prepared.rgw
What have I missed?
Atmospheric River Rafting Regards, Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | [email protected]
------ Original Message ------
From "A. Razzak Memon" <[email protected]>
To [email protected]
Date 1/11/2023 8:55:32 PM
Subject Re: [RBASE-L] - GATEWAY IMPORT Fail
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
<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=05%7C01%7Cjim%40kaypark.com%7C97bf3237c87e481202ac08daf4be961e%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091396669983884%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=gA89acX4EtXwHn3%2Fex%2BwSJEkFJb3UwPButwtP%2BSIWOU%3D&reserved=0>
---
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://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2Fem83b2b1f7-53a0-471e-a941-b9396eee10e5%2540fe37ca4e.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cjim%40kaypark.com%7C97bf3237c87e481202ac08daf4be961e%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091396670140127%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=dBk6jZJJmhLuJxyI2ZkjYFbpOEKBx%2Br9Gsh86RcLX6c%3D&reserved=0>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=05%7C01%7Cjim%40kaypark.com%7C97bf3237c87e481202ac08daf4be961e%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091396670140127%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=acOMMOK7tl5Q5StLSld8uNKvuCAc0objI3pwKkmNewQ%3D&reserved=0>
---
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
<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2Fe13815b8-43c1-be23-f4ea-a4d8bfec3d5b%2540rbase.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cjim%40kaypark.com%7C97bf3237c87e481202ac08daf4be961e%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091396670140127%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=1aroUN24hNNYQp4nxnVknGEqOA5OXEB4GavZgSYaRCk%3D&reserved=0>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=05%7C01%7Cjim%40kaypark.com%7C97bf3237c87e481202ac08daf4be961e%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091396670140127%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=acOMMOK7tl5Q5StLSld8uNKvuCAc0objI3pwKkmNewQ%3D&reserved=0>
---
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/emc411f5d5-4fde-4ce4-a2f0-70c63f51c76e%40dfe82e29.com
<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2Femc411f5d5-4fde-4ce4-a2f0-70c63f51c76e%2540dfe82e29.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cjim%40kaypark.com%7C97bf3237c87e481202ac08daf4be961e%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091396670140127%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ERRJV%2BEGiI5iaW%2BkW0iuMeuTLakx%2Fq0wOKrvcLYeDdo%3D&reserved=0>.
--
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/IA1PR02MB889880A0DCDEB111DE222551A0FD9%40IA1PR02MB8898.namprd02.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/IA1PR02MB889880A0DCDEB111DE222551A0FD9%40IA1PR02MB8898.namprd02.prod.outlook.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/emc30c9ac2-923d-4653-b8a6-06d739f677b6%40dfe82e29.com.
