Happy New Year to you as well.
From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Bruce
Chitiea
Sent: Thursday, January 12, 2023 11:30 AM
To: rbase-l@googlegroups.com
Subject: Re[4]: [RBASE-L] - GATEWAY IMPORT Fail
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 | rby...@safesectors.com<mailto:rby...@safesectors.com>
------ Original Message ------
>From "'Jim Belisle' via RBASE-L"
><rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
To "rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>"
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
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
[cid:image001.jpg@01D92679.DDDE6C20]
From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> On Behalf Of Bruce
Chitiea
Sent: Thursday, January 12, 2023 11:01 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
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 | rby...@safesectors.com<mailto:rby...@safesectors.com>
------ Original Message ------
>From "A. Razzak Memon" <raz...@rbase.com<mailto:raz...@rbase.com>>
To rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
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 | rby...@safesectors.com<mailto:rby...@safesectors.com>
--
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%7C8eaf9cd29f3943cd701b08daf4c2a1a6%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091415042103087%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=3pE0NwcL8CRNPypb5icZJ09O43JYd%2FcgUc31%2B6rCvfs%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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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%7C8eaf9cd29f3943cd701b08daf4c2a1a6%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091415042103087%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=o4LoJO%2FAxjMdeVE%2FB%2BZ3K8KauPOGfAJoeOr82yu87Sw%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%7C8eaf9cd29f3943cd701b08daf4c2a1a6%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091415042103087%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=3pE0NwcL8CRNPypb5icZJ09O43JYd%2FcgUc31%2B6rCvfs%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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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%7C8eaf9cd29f3943cd701b08daf4c2a1a6%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091415042103087%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=J57iDeENUJgJP%2FYceloon24qTnNuxwZutNPGDy%2Fzkwk%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%7C8eaf9cd29f3943cd701b08daf4c2a1a6%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091415042103087%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=3pE0NwcL8CRNPypb5icZJ09O43JYd%2FcgUc31%2B6rCvfs%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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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%7C8eaf9cd29f3943cd701b08daf4c2a1a6%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091415042103087%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=%2B%2BqGC%2FUhfCRmGzrCNnyehYXVU%2FBY1JZuh%2BALMQQlvPM%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%7C8eaf9cd29f3943cd701b08daf4c2a1a6%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091415042103087%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=3pE0NwcL8CRNPypb5icZJ09O43JYd%2FcgUc31%2B6rCvfs%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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/IA1PR02MB889880A0DCDEB111DE222551A0FD9%40IA1PR02MB8898.namprd02.prod.outlook.com<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2FIA1PR02MB889880A0DCDEB111DE222551A0FD9%2540IA1PR02MB8898.namprd02.prod.outlook.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cjim%40kaypark.com%7C8eaf9cd29f3943cd701b08daf4c2a1a6%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091415042259328%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=dSjT6O7Jo7TNRRSPPlXpj%2FJ31502WWGcYymMqL5zZKs%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%7C8eaf9cd29f3943cd701b08daf4c2a1a6%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091415042259328%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=QWBqxhcY%2Fsfp5AVjQue3b4mqfR64ZWA8%2FnXaEqRpdTg%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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emc30c9ac2-923d-4653-b8a6-06d739f677b6%40dfe82e29.com<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2Femc30c9ac2-923d-4653-b8a6-06d739f677b6%2540dfe82e29.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cjim%40kaypark.com%7C8eaf9cd29f3943cd701b08daf4c2a1a6%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638091415042259328%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=KMjT5SYVoV1%2BDTbIgPxjN3kigmbl%2B6sHRL78nLDyY94%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/IA1PR02MB88987CD8024E9C0875D467D8A0FD9%40IA1PR02MB8898.namprd02.prod.outlook.com.
