[RBASE-L] - GATEWAY

[jan johansen]

All,

While using GATEWAY IMPORT to a new table from a CSV file, is there an 
option to use first row as table Column Names?

Jan

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Gateway

['Jim Belisle' via RBASE-L]

I am trying to Export information with Gateway to an Excel file from temp files 
created in RBASE.
When I create a temp table for the order header information, these columns are 
primarily TEXT, INTEGER and a few NUMERIC, things go well and all information 
exports properly.
All the columns are in the Excel file and all the rows of information exports.

When I create a temp table for ship to address using similar columns, TEXT, 
INTEGER and a few NUMERIC, the data exported through Gateway is not correct.
Only about 15 of the 59 columns are exporting. And some of the columns not 
exporting are between columns that DO export.
I have never encountered this problem in the 30 years I have exported data to 
Excel.

Below is the information on the limits of Excel and I do not come even close to 
the limits.
[cid:image002.png@01D8DCB9.45BCEF20]

If I go into the table itself and export from there, not using the Gateway 
utility, all columns show up in the export.
However I am not allowed to determine what to do with zeros or null values so 
zeros do not show in the Excel file.
This will make me have to manually put zeros into the file.

Here is the kicker. If I use CODE to do the EXPORT, everything works as 
expected.
GATEWAY EXPORT xls 
(filename) SELECT ALL 
FROM (tablename) OPTION COL_NAMES ON |ACTION OPENVIEW |BLANK_IF_NULL ON 
|BLANK_IF_ZERO OFF

Is there a setting someplace I am missing?

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01D8DCB8.64B1D9A0]

-- 
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/IA1PR02MB88987172172B0A94D189B387A0209%40IA1PR02MB8898.namprd02.prod.outlook.com.

[RBASE-L] - Gateway XLS

[Stefan Maldet]

Hello together,
Is there a way to use the Gateway Export xls command and define names, as I can 
do it in the namesmanager of the Excel file to get the result, as you can see 
in the following image?

That would be really great ...
Thanks for your help,
Best regards,
Stefan

[cid:image001.png@01D3E2E8.95DF8460]

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - GATEWAY

[Bruce A. Chitiea]

Jan:

Not according to RSYNTAX. Would the intent be to store TableColumnName 
aliases within the dataset?


Example:

Table columnname: IMHO

First Column Row Value: 'In My Humble Opinion'

Bruce



-- Original Message --
Sent: 10/27/2018 12:31:58 PM
Subject: [RBASE-L] - GATEWAY
From: "jan johansen" 
To: rbase-l@googlegroups.com
Cc:

All,

While using GATEWAY IMPORT to a new table from a CSV file, is there an 
option to use first row as table Column Names?


Jan


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

For more options, visit https://groups.google.com/d/optout.

--
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.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - GATEWAY

[Steve Johnson]

Jan,

 

I use Gateway Import quite a bit, although I am not a power user.  To answer 
your question directly ( you sparked some curiosity regarding your question, 
hence some testing using RbaseXE),  the answer appears to be no, at least I 
could not find a way.  You probably already know that you can when importing an 
XLS file.  So perhaps import the CSV into Excel and then save as an XLS and 
then import.   I have to import a text fixed width file monthly and its far 
easier and to insure accurate data, to import into Excel then import into 
Rbase.  

 

Steve

 

 

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
jan johansen
Sent: Saturday, October 27, 2018 3:32 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - GATEWAY

 

All,

 

While using GATEWAY IMPORT to a new table from a CSV file, is there an option 
to use first row as table Column Names?

 

Jan

 

-- 
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.
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Gateway XLS

[A. Razzak Memon]

Stepfan,

Use may use the "AS" option to define names when creating XLS.

Here's how ...


-- GATEWAY_EXPORT_XLS.RMD
-- Start here
   CONNECT RRBYW19
   SET ERROR MESSAGE 2077 OFF
   DELETE InvoiceHeader.xls
   SET ERROR MESSAGE 2077 ON
   GATEWAY EXPORT XLS InvoiceHeader.xls +
   SELECT TransID AS `Invoice No`, +
   TransDate AS `Invoice Date`, +
   NetAmount AS `Sub Total`, +
   Freight, Tax, +
   InvoiceTotal AS `Invoice Total` +
   FROM InvoiceHeader ORDER BY TransID +
   OPTION COL_NAMES ON +
   |HEADER_TEXT Customer Invoices +
   |FOOTER_TEXT Quarterly Report +
   |SHEET_NAME Invoices +
   |ACTION OPENVIEW
   RETURN
-- End here

See attached sample for your viewing pleasure.

Hope that helps!

Very Best R:egards,

Razzak


At 08:15 AM 5/3/2018, you wrote:


Hello together,
Is there a way to use the Gateway Export xls 
command and define names, as I can do it in the 
namesmanager of the Excel file to get the 
result, as you can see in the following image?


That would be really great …
Thanks for your help,
Best regards,
Stefan




--
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.
For more options, visit https://groups.google.com/d/optout.


InvoiceHeader.xls
Description: Binary data

AW: [RBASE-L] - Gateway XLS

[Stefan Maldet]

Thanks for your fast response but this is not what I mean.
Please have a look on this page 
http://www.excel-easy.com/examples/names-in-formulas.html 
The word name makes for a confusion in this case.
I need to define and name a constant in my Excel file.

Best regards,
Stefan  

-Ursprüngliche Nachricht-
Von: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Im Auftrag von 
A. Razzak Memon
Gesendet: Donnerstag, 3. Mai 2018 15:06
An: rbase-l@googlegroups.com
Betreff: Re: [RBASE-L] - Gateway XLS

Stepfan,

Use may use the "AS" option to define names when creating XLS.

Here's how ...


-- GATEWAY_EXPORT_XLS.RMD
-- Start here
CONNECT RRBYW19
SET ERROR MESSAGE 2077 OFF
DELETE InvoiceHeader.xls
SET ERROR MESSAGE 2077 ON
GATEWAY EXPORT XLS InvoiceHeader.xls +
SELECT TransID AS `Invoice No`, +
TransDate AS `Invoice Date`, +
NetAmount AS `Sub Total`, +
Freight, Tax, +
InvoiceTotal AS `Invoice Total` +
FROM InvoiceHeader ORDER BY TransID +
OPTION COL_NAMES ON +
|HEADER_TEXT Customer Invoices +
|FOOTER_TEXT Quarterly Report +
|SHEET_NAME Invoices +
|ACTION OPENVIEW
RETURN
-- End here

See attached sample for your viewing pleasure.

Hope that helps!

Very Best R:egards,

Razzak


At 08:15 AM 5/3/2018, you wrote:

>Hello together,
>Is there a way to use the Gateway Export xls command and define names, 
>as I can do it in the namesmanager of the Excel file to get the result, 
>as you can see in the following image?
>
>That would be really great …
>Thanks for your help,
>Best regards,
>Stefan



--
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.
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - GATEWAY IMPORT Fail

[Bruce Chitiea]

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) , +
soNumTEXT (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
   -
   11(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf
   12(rbms(23233(cpsb(1(2020-01-29(543199(stock(0(c(.pdf
   13(rbms(23238(gar.(1(2020-01-06(7274(na(0(c(.pdf
   14(rbms(23239(gar.(1(2020-01-16(7283(na(0(c(.pdf
   15(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


--
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/em83b2b1f7-53a0-471e-a941-b9396eee10e5%40fe37ca4e.com.

[RBASE-L] - GATEWAY IMPORT/EXPORT XML

[Stephen Markson]

Hello,

Does anyone have any experience with GATEWAY IMPORT/EXPORT XML? Is it just for 
sharing data in R:Base databases or can it be used with an xsd file for other 
purposes?

I ask because we are now sharing data with a third party that does everything 
in XML. When we will send data to them, we need to extract data from our DB and 
format it using their XML schema. Is there a way in R:Base to do this 
automatically or do I need to build the XML file in a looping program?

Reports they send to us will also be in XML using their particular schema. Is 
there a way in R:Base to automatically get this into a table or do I need to 
write a program to parse the file?

Thanks for any help with this.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - gateway export to xlsx

[Dan Goldberg]

I am using a command line export to xls like the sample.


GATEWAY EXPORT XLS Customers_123.xls +

SELECT +

Company AS `Company Name`, +

CustID AS `Customer ID`, +

CustAddress AS `Company Address`, +

(CustCity+','&CustState&CustZip) AS `City, State, and Zip Code` +

FROM Customer ORDER by Company +

OPTION COL_NAMES ON +

|TAB_NAME Customer List



Is there a way to export to xlsx? The reason being is xlsx is a smaller file 
size.



TIA



Dan Goldberg

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: AW: [RBASE-L] - Gateway XLS

[A. Razzak Memon]

Let me read the article regarding "Names in 
Formula", and see what you are trying to accomplish.


My time and schedule permitting, I'll provide you 
with the answer you are looking for.


Remember, nothing is impossible!

Razzak

At 09:12 AM 5/3/2018, Stefan Maldet wrote:


Thanks for your fast response but this is not what I mean.
Please have a look on this page 
http://www.excel-easy.com/examples/names-in-formulas.html

The word name makes for a confusion in this case.
I need to define and name a constant in my Excel file.

Best regards,
Stefan

-Ursprüngliche Nachricht-
Von: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] Im Auftrag von A. Razzak Memon

Gesendet: Donnerstag, 3. Mai 2018 15:06
An: rbase-l@googlegroups.com
Betreff: Re: [RBASE-L] - Gateway XLS

Stepfan,

Use may use the "AS" option to define names when creating XLS.

Here's how ...


-- GATEWAY_EXPORT_XLS.RMD
-- Start here
CONNECT RRBYW19
SET ERROR MESSAGE 2077 OFF
DELETE InvoiceHeader.xls
SET ERROR MESSAGE 2077 ON
GATEWAY EXPORT XLS InvoiceHeader.xls +
SELECT TransID AS `Invoice No`, +
TransDate AS `Invoice Date`, +
NetAmount AS `Sub Total`, +
Freight, Tax, +
InvoiceTotal AS `Invoice Total` +
FROM InvoiceHeader ORDER BY TransID +
OPTION COL_NAMES ON +
|HEADER_TEXT Customer Invoices +
|FOOTER_TEXT Quarterly Report +
|SHEET_NAME Invoices +
|ACTION OPENVIEW
RETURN
-- End here

See attached sample for your viewing pleasure.

Hope that helps!

Very Best R:egards,

Razzak


At 08:15 AM 5/3/2018, you wrote:

>Hello together,
>Is there a way to use the Gateway Export xls command and define names,
>as I can do it in the namesmanager of the Excel file to get the result,
>as you can see in the following image?
>
>That would be really great …
>Thanks for your help,
>Best regards,
>Stefan






--
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.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - GATEWAY IMPORT Fail

[A. Razzak Memon]

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
 -
 11(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf
 12(rbms(23233(cpsb(1(2020-01-29(543199(stock(0(c(.pdf
 13(rbms(23238(gar.(1(2020-01-06(7274(na(0(c(.pdf
 14(rbms(23239(gar.(1(2020-01-16(7283(na(0(c(.pdf
 15(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/



--
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/em83b2b1f7-53a0-471e-a941-b9396eee10e5%40fe37ca4e.com 
.


--
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/e13815b8-43c1-be23-f4ea-a4d8bfec3d5b%40rbase.com.

Re: [RBASE-L] - GATEWAY IMPORT Fail

[Tony Luck]

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,  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) , +
> soNumTEXT (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
>-
>11(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf
>12(rbms(23233(cpsb(1(2020-01-29(543199(stock(0(c(.pdf
>13(rbms(23238(gar.(1(2020-01-06(7274(na(0(c(.pdf
>14(rbms(23239(gar.(1(2020-01-16(7283(na(0(c(.pdf
>15(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 *
>
>
>
>
> --
> 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/em83b2b1f7-53a0-471e-a941-b9396eee10e5%40fe37ca4e.com
> 
> .
>

-- 
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/CABnhDAQq3S%2Bx4Hnpv_3K-V-qv4%2BO%2B9ajw6mPkukeWNTOPpL0iQ%40mail.gmail.com.

RE: [RBASE-L] - GATEWAY IMPORT/EXPORT XML

[Javier Valencia]

The new Gateway Utility is absolutely fantastic. I created a front end utility 
that allow the user to select from one of the allowable tables and then export 
the structure or data or both in any of a bunch of formats using any criteria 
you want and then stores that format and criteria as the default for that table 
in case you do this routinely. Double clicking in the Format Field open a 
window with multiple options. You can easily modify it to do import from other 
formats in addition or instead of export. 
 

 
When you hit the Start button it brings out the actual Gateway screen fully 
populated to complete the process or change options.
 

 
Yes, it took some time to develop and debug the application but once it was 
done… it was worth it.
 
Javier,
 
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
 
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Stephen Markson
Sent: Friday, March 17, 2017 1:17 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - GATEWAY IMPORT/EXPORT XML
 
Hello,
 
Does anyone have any experience with GATEWAY IMPORT/EXPORT XML? Is it just for 
sharing data in R:Base databases or can it be used with an xsd file for other 
purposes?
 
I ask because we are now sharing data with a third party that does everything 
in XML. When we will send data to them, we need to extract data from our DB and 
format it using their XML schema. Is there a way in R:Base to do this 
automatically or do I need to build the XML file in a looping program?
 
Reports they send to us will also be in XML using their particular schema. Is 
there a way in R:Base to automatically get this into a table or do I need to 
write a program to parse the file?
 
Thanks for any help with this.
-- 
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.
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - GATEWAY IMPORT/EXPORT XML

[Claudine Robbins]

Very impressive Javier!

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Javier Valencia
Sent: Monday, March 20, 2017 6:20 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - GATEWAY IMPORT/EXPORT XML

The new Gateway Utility is absolutely fantastic. I created a front end utility 
that allow the user to select from one of the allowable tables and then export 
the structure or data or both in any of a bunch of formats using any criteria 
you want and then stores that format and criteria as the default for that table 
in case you do this routinely. Double clicking in the Format Field open a 
window with multiple options. You can easily modify it to do import from other 
formats in addition or instead of export.

[cid:image001.jpg@01D2A235.FCD3C8B0]

When you hit the Start button it brings out the actual Gateway screen fully 
populated to complete the process or change options.

[cid:image002.jpg@01D2A235.FCD3C8B0]

Yes, it took some time to develop and debug the application but once it was 
done… it was worth it.

Javier,

Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Stephen Markson
Sent: Friday, March 17, 2017 1:17 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - GATEWAY IMPORT/EXPORT XML

Hello,

Does anyone have any experience with GATEWAY IMPORT/EXPORT XML? Is it just for 
sharing data in R:Base databases or can it be used with an xsd file for other 
purposes?

I ask because we are now sharing data with a third party that does everything 
in XML. When we will send data to them, we need to extract data from our DB and 
format it using their XML schema. Is there a way in R:Base to do this 
automatically or do I need to build the XML file in a looping program?

Reports they send to us will also be in XML using their particular schema. Is 
there a way in R:Base to automatically get this into a table or do I need to 
write a program to parse the file?

Thanks for any help with this.
--
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>.
For more options, visit https://groups.google.com/d/optout.
--
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>.
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - GATEWAY IMPORT/EXPORT XML

[Stephen Markson]

Nice work and thanks!


Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Javier Valencia
Sent: March-20-17 7:20 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - GATEWAY IMPORT/EXPORT XML

The new Gateway Utility is absolutely fantastic. I created a front end utility 
that allow the user to select from one of the allowable tables and then export 
the structure or data or both in any of a bunch of formats using any criteria 
you want and then stores that format and criteria as the default for that table 
in case you do this routinely. Double clicking in the Format Field open a 
window with multiple options. You can easily modify it to do import from other 
formats in addition or instead of export.

[cid:image001.jpg@01D2A3B6.F8ADF0D0]

When you hit the Start button it brings out the actual Gateway screen fully 
populated to complete the process or change options.

[cid:image002.jpg@01D2A3B6.F8ADF0D0]

Yes, it took some time to develop and debug the application but once it was 
done… it was worth it.

Javier,

Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Stephen Markson
Sent: Friday, March 17, 2017 1:17 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - GATEWAY IMPORT/EXPORT XML

Hello,

Does anyone have any experience with GATEWAY IMPORT/EXPORT XML? Is it just for 
sharing data in R:Base databases or can it be used with an xsd file for other 
purposes?

I ask because we are now sharing data with a third party that does everything 
in XML. When we will send data to them, we need to extract data from our DB and 
format it using their XML schema. Is there a way in R:Base to do this 
automatically or do I need to build the XML file in a looping program?

Reports they send to us will also be in XML using their particular schema. Is 
there a way in R:Base to automatically get this into a table or do I need to 
write a program to parse the file?

Thanks for any help with this.
--
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>.
For more options, visit https://groups.google.com/d/optout.
--
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>.
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - GATEWAY IMPORT/EXPORT XML

[Dan Goldberg]

Looks very nice. Any chance of sharing it?

Dan Goldberg




On Mon, Mar 20, 2017 at 4:21 PM -0700, "Javier Valencia" 
mailto:javier.valen...@vtgonline.com>> wrote:

The new Gateway Utility is absolutely fantastic. I created a front end utility 
that allow the user to select from one of the allowable tables and then export 
the structure or data or both in any of a bunch of formats using any criteria 
you want and then stores that format and criteria as the default for that table 
in case you do this routinely. Double clicking in the Format Field open a 
window with multiple options. You can easily modify it to do import from other 
formats in addition or instead of export.

[cid:image002.jpg@01D2A1A6.A4E74A30]

When you hit the Start button it brings out the actual Gateway screen fully 
populated to complete the process or change options.

[cid:image006.jpg@01D2A1A6.A4E74A30]

Yes, it took some time to develop and debug the application but once it was 
done… it was worth it.

Javier,

Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Stephen Markson
Sent: Friday, March 17, 2017 1:17 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - GATEWAY IMPORT/EXPORT XML

Hello,

Does anyone have any experience with GATEWAY IMPORT/EXPORT XML? Is it just for 
sharing data in R:Base databases or can it be used with an xsd file for other 
purposes?

I ask because we are now sharing data with a third party that does everything 
in XML. When we will send data to them, we need to extract data from our DB and 
format it using their XML schema. Is there a way in R:Base to do this 
automatically or do I need to build the XML file in a looping program?

Reports they send to us will also be in XML using their particular schema. Is 
there a way in R:Base to automatically get this into a table or do I need to 
write a program to parse the file?

Thanks for any help with this.
--
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>.
For more options, visit https://groups.google.com/d/optout.

--
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>.
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - gateway export to xlsx

[Buddy Walker]

Dan

   Try changing

  GATEWAY EXPORT XLS Customers_123.xls 

to 

   GATEWAY EXPORT XLSW Customers_123.xlsx

 

 If you want a small file you could trying exporting to CSV then have Excel 
open the csv file.

 

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Dan 
Goldberg
Sent: Thursday, April 5, 2018 5:20 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - gateway export to xlsx

 

I am using a command line export to xls like the sample.

 

GATEWAY EXPORT XLS Customers_123.xls + 

SELECT + 

Company AS `Company Name`, + 

CustID AS `Customer ID`, + 

CustAddress AS `Company Address`, + 

(CustCity+','&CustState&CustZip) AS `City, State, and Zip Code` + 

FROM Customer ORDER by Company + 

OPTION COL_NAMES ON + 

|TAB_NAME Customer List 

 

Is there a way to export to xlsx? The reason being is xlsx is a smaller file 
size.

 

TIA

 

Dan Goldberg 

 

-- 
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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - gateway export to xlsx

[A. Razzak Memon]

Dan,

Here's how ...

Try the example below using the sample RRBYW19 database.

-- Example
-- Create XLSX file with Header, Footer, Style and Tab Name
-- Author: A. Razzak Memon
-- Date Created: April 5, 2018
-- Last Updated:
IF (CVAL('DATABASE')) <> 'RRBYW19' OR (CVAL('DATABASE')) IS NULL THEN
   CONNECT RRBYW19 IDENTIFIED BY NONE
ENDIF
  CLS
  SET ERROR MESSAGE 2077 OFF
  DELETE InvoiceDetails.xlsx
  SET ERROR MESSAGE 2077 ON
  SET VAR vGeneratedBy TEXT = ('Generated By:'&(CVAL('NETUSER')))
  GATEWAY EXPORT XLSW InvoiceDetails.xlsx +
  SELECT * FROM InvoiceDetail +
  OPTION COL_NAMES ON +
  |HEADER_TEXT 'Year to Date Invoice Details' +
  |HEADER_TEXT .#NOW +
  |FOOTER_TEXT ' ' +
  |FOOTER_TEXT 'Year to Date Invoice Details' +
  |FOOTER_TEXT .vGeneratedBy +
  |STYLE PRICELIST +
  |TAB_NAME Invoice Details +
  |SHOW_PROGRESS ON +
  |ACTION OPENVIEW
  RETURN

It's freakin' awesome, isn't it?

Very Best R:egards,

Razzak


At 05:19 PM 4/5/2018, Dan Goldberg wrote:


I am using a command line export to xls like the sample.

GATEWAY EXPORT XLS Customers_123.xls +
SELECT +
Company AS `Company Name`, +
CustID AS `Customer ID`, +
CustAddress AS `Company Address`, +
(CustCity+','&CustState&CustZip) AS `City, State, and Zip Code` +
FROM Customer ORDER by Company +
OPTION COL_NAMES ON +
|TAB_NAME Customer List
Is there a way to export to xlsx? The reason being is xlsx is a 
smaller file size.




--
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.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - GATEWAY Export using Specification file

[Ajay Sanghvi]

Hello all

I am trying to Export a table into Excel workbook using GATEWAY in a command
file. I have created a SPECIFICATION file that creates the proper heading
colors etc. What I am not able to do is set the width of certain columns and
have all my data be displayed with borders so the users do not have to
manipulate the excel file.

Thanks in advance.


AJAY SANGHVI
Vice President
700 Blair Road
Carteret, New Jersey  07008 U.S.A.

T (973) 748 8980
F (973) 680 9618
E asang...@berjeinc.com

-- 
*Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and 
Certified by WQS.

-- 
_** Markets are moving rapidly, please note all prices and volume offers 
are kindly to be considered subject final confirmation, including any 
pending tariff changes, unless otherwise stated. ** _

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re[2]: [RBASE-L] - GATEWAY IMPORT Fail

[Bruce Chitiea]

Thanks, Tony.

Per R:azzak's suggestion, I'm going to run the spec file approach to 
control for possible ghosts in my machine. But your offer of code is 
most appreciated; I may be back to you.


Warmest Sub-Equatorial Summer Regards, Bruce

Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | rby...@safesectors.com

-- Original Message --

From "Tony Luck" 

To rbase-l@googlegroups.com
Date 1/11/2023 10:14:41 PM
Subject Re: [RBASE-L] - GATEWAY IMPORT Fail


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,  
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) , +
soNumTEXT (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
   -
   11(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf
   12(rbms(23233(cpsb(1(2020-01-29(543199(stock(0(c(.pdf
   13(rbms(23238(gar.(1(2020-01-06(7274(na(0(c(.pdf
   14(rbms(23239(gar.(1(2020-01-16(7283(na(0(c(.pdf
   15(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




--
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/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 rbase-l+unsubscr...@googlegroups.com.
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 
<https://groups.google.com/d/msgid/rbase-l/CABnhDAQq3S%2Bx4Hnpv_3K-V-qv4%2BO%2B9ajw6mPkukeWNTOPpL0iQ%40mail.gmail.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

Re[2]: [RBASE-L] - GATEWAY IMPORT Fail

[Bruce Chitiea]

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

-- Original Message --

From "A. Razzak Memon" 

To 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) , +
soNumTEXT (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
   -
   11(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf
   12(rbms(23233(cpsb(1(2020-01-29(543199(stock(0(c(.pdf
   13(rbms(23238(gar.(1(2020-01-06(7274(na(0(c(.pdf
   14(rbms(23239(gar.(1(2020-01-16(7283(na(0(c(.pdf
   15(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



--
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/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 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://groups.google.com/d/msgid/rbase-l/e13815b8-43c1-be23-f4ea-a4d8bfec3d5b%40rbase.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 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.

Re[4]: [RBASE-L] - GATEWAY IMPORT Fail

[Bruce Chitiea]

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



-- Original Message --

From "'Jim Belisle' via RBASE-L" 

To "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




From:rbase-l@googlegroups.com  On Behalf Of 
Bruce Chitiea

Sent: Thursday, January 12, 2023 11:01 AM
To: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



-- Original Message --

From "A. Razzak Memon" 

To 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) , +

soNumTEXT (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

   -

   11(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf

   12(rbms(23233(cpsb(1(2020-01-29(543199(stock(0(c(.pdf

   13(rbms(23238(gar.(1(2020-01-06(7274(na(0(c(.pdf

   14(rbms(23239(gar.(1(2020-01-16(7283(na(0(c(.pdf

   15(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







--
For group guidelines, visit 
http

Re: [RBASE-L] - GATEWAY Export using Specification file

['Karen Tellef' via RBASE-L]

I'm not sure if there's a better way to do it now, but in the past I 
havecreated a blank template spreadsheet that had all the proper widths 
andformats applied to columns & rows, and had users copy/paste intothe template.

 You have to have a couple copies of the template stashed somewhere,or else the 
user would usually save their work over the template name.
Karen
 
 
-Original Message-
From: Ajay Sanghvi 
To: rbase-l 
Sent: Fri, Dec 14, 2018 12:20 pm
Subject: [RBASE-L] - GATEWAY Export using Specification file

Hello all

I am trying to Export a table into Excel workbook using GATEWAY in a command
file. I have created a SPECIFICATION file that creates the proper heading
colors etc. What I am not able to do is set the width of certain columns and
have all my data be displayed with borders so the users do not have to
manipulate the excel file.

Thanks in advance.


AJAY SANGHVI
Vice President
700 Blair Road
Carteret, New Jersey  07008 U.S.A.

T (973) 748 8980
F (973) 680 9618
E asang...@berjeinc.com

-- 
*Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and 
Certified by WQS.

-- 
_** Markets are moving rapidly, please note all prices and volume offers 
are kindly to be considered subject final confirmation, including any 
pending tariff changes, unless otherwise stated. ** _

-- 
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.
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - GATEWAY Export using Specification file

[Ajay Sanghvi]

I just figured out that when creating the specification file there is a
field for number of characters. This number set the width of the output
column in the Excel sheet.

This resolves one of my issues. But I am still missing a way to create
borders for the cells.



Thanks for taking the time to respond.

Ajay



*From:* 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com]
*Sent:* Friday, December 14, 2018 1:50 PM
*To:* rbase-l@googlegroups.com
*Subject:* Re: [RBASE-L] - GATEWAY Export using Specification file



I'm not sure if there's a better way to do it now, but in the past I have

created a blank template spreadsheet that had all the proper widths and

formats applied to columns & rows, and had users copy/paste into

the template.



You have to have a couple copies of the template stashed somewhere,

or else the user would usually save their work over the template name.



Karen







-Original Message-
From: Ajay Sanghvi 
To: rbase-l 
Sent: Fri, Dec 14, 2018 12:20 pm
Subject: [RBASE-L] - GATEWAY Export using Specification file

Hello all



I am trying to Export a table into Excel workbook using GATEWAY in a command

file. I have created a SPECIFICATION file that creates the proper heading

colors etc. What I am not able to do is set the width of certain columns and

have all my data be displayed with borders so the users do not have to

manipulate the excel file.



Thanks in advance.





AJAY SANGHVI

Vice President

700 Blair Road

Carteret, New Jersey  07008 U.S.A.



T (973) 748 8980

F (973) 680 9618

E asang...@berjeinc.com



-- 

*Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and

Certified by WQS.



-- 

_** Markets are moving rapidly, please note all prices and volume offers

are kindly to be considered subject final confirmation, including any

pending tariff changes, unless otherwise stated. ** _



-- 

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.

For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

-- 
*Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and 
Certified by WQS.

-- 
_** Markets are moving rapidly, please note all prices and volume offers 
are kindly to be considered subject final confirmation, including any 
pending tariff changes, unless otherwise stated. ** _

-- 
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.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - GATEWAY Export using Specification file

[Stephen Markson]

I have the used the following technique to achieve similar results:

Create a spreadsheet with an AUTO_OPEN macro that opens the spreadsheet created 
from the specification file and then sets the borders you want…


Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Ajay Sanghvi
Sent: December 14, 2018 3:10 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - GATEWAY Export using Specification file

I just figured out that when creating the specification file there is a field 
for number of characters. This number set the width of the output column in the 
Excel sheet.
This resolves one of my issues. But I am still missing a way to create borders 
for the cells.

Thanks for taking the time to respond.
Ajay
[cid:image001.jpg@01D49618.4293C8F0]

From: 'Karen Tellef' via RBASE-L 
[mailto:rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>]
Sent: Friday, December 14, 2018 1:50 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - GATEWAY Export using Specification file

I'm not sure if there's a better way to do it now, but in the past I have
created a blank template spreadsheet that had all the proper widths and
formats applied to columns & rows, and had users copy/paste into
the template.

You have to have a couple copies of the template stashed somewhere,
or else the user would usually save their work over the template name.

Karen



-Original Message-
From: Ajay Sanghvi mailto:asang...@berjeinc.com>>
To: rbase-l mailto:rbase-l@googlegroups.com>>
Sent: Fri, Dec 14, 2018 12:20 pm
Subject: [RBASE-L] - GATEWAY Export using Specification file
Hello all

I am trying to Export a table into Excel workbook using GATEWAY in a command
file. I have created a SPECIFICATION file that creates the proper heading
colors etc. What I am not able to do is set the width of certain columns and
have all my data be displayed with borders so the users do not have to
manipulate the excel file.

Thanks in advance.


AJAY SANGHVI
Vice President
700 Blair Road
Carteret, New Jersey  07008 U.S.A.

T (973) 748 8980
F (973) 680 9618
E asang...@berjeinc.com<mailto:asang...@berjeinc.com>

--
*Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and
Certified by WQS.

--
_** Markets are moving rapidly, please note all prices and volume offers
are kindly to be considered subject final confirmation, including any
pending tariff changes, unless otherwise stated. ** _

--
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.<mailto:unsubscr...@googlegroups.com.>
For more options, visit https://groups.google.com/d/optout.
--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

Berjé Inc. - an SQF Level 3 Quality Certified Supplier No. 7751 and Certified 
by WQS.
** Markets are moving rapidly, please note all prices and volume offers are 
kindly to be considered subject final confirmation, including any pending 
tariff changes, unless otherwise stated. **
--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - GATEWAY Export using Specification file

[Stephen Markson]

...then, LAUNCH the spreadsheet (with the AUTO_OPEN macro).


Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Stephen Markson
Sent: December 17, 2018 2:53 PM
To: 'rbase-l@googlegroups.com'
Subject: RE: [RBASE-L] - GATEWAY Export using Specification file

I have the used the following technique to achieve similar results:

Create a spreadsheet with an AUTO_OPEN macro that opens the spreadsheet created 
from the specification file and then sets the borders you want…


Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Ajay Sanghvi
Sent: December 14, 2018 3:10 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: RE: [RBASE-L] - GATEWAY Export using Specification file

I just figured out that when creating the specification file there is a field 
for number of characters. This number set the width of the output column in the 
Excel sheet.
This resolves one of my issues. But I am still missing a way to create borders 
for the cells.

Thanks for taking the time to respond.
Ajay
[cid:image001.jpg@01D49618.CF4BCD60]

From: 'Karen Tellef' via RBASE-L 
[mailto:rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>]
Sent: Friday, December 14, 2018 1:50 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - GATEWAY Export using Specification file

I'm not sure if there's a better way to do it now, but in the past I have
created a blank template spreadsheet that had all the proper widths and
formats applied to columns & rows, and had users copy/paste into
the template.

You have to have a couple copies of the template stashed somewhere,
or else the user would usually save their work over the template name.

Karen



-Original Message-
From: Ajay Sanghvi mailto:asang...@berjeinc.com>>
To: rbase-l mailto:rbase-l@googlegroups.com>>
Sent: Fri, Dec 14, 2018 12:20 pm
Subject: [RBASE-L] - GATEWAY Export using Specification file
Hello all

I am trying to Export a table into Excel workbook using GATEWAY in a command
file. I have created a SPECIFICATION file that creates the proper heading
colors etc. What I am not able to do is set the width of certain columns and
have all my data be displayed with borders so the users do not have to
manipulate the excel file.

Thanks in advance.


AJAY SANGHVI
Vice President
700 Blair Road
Carteret, New Jersey  07008 U.S.A.

T (973) 748 8980
F (973) 680 9618
E asang...@berjeinc.com<mailto:asang...@berjeinc.com>

--
*Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and
Certified by WQS.

--
_** Markets are moving rapidly, please note all prices and volume offers
are kindly to be considered subject final confirmation, including any
pending tariff changes, unless otherwise stated. ** _

--
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.<mailto:unsubscr...@googlegroups.com.>
For more options, visit https://groups.google.com/d/optout.
--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

Berjé Inc. - an SQF Level 3 Quality Certified Supplier No. 7751 and Certified 
by WQS.
** Markets are moving rapidly, please note all prices and volume offers are 
kindly to be considered subject final confirmation, including any pending 
tariff changes, unless otherwise stated. **
--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more

RE: [RBASE-L] - GATEWAY Export using Specification file

[Ajay Sanghvi]

Thanks for your input Stephen.



Ajay



*From:* rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] *On
Behalf Of *Stephen Markson
*Sent:* Monday, December 17, 2018 2:57 PM
*To:* 'rbase-l@googlegroups.com' 
*Subject:* RE: [RBASE-L] - GATEWAY Export using Specification file



...then, *LAUNCH *the spreadsheet (with the AUTO_OPEN macro).





Regards,



Stephen Markson

The Pharmacy Examining Board of Canada

416.979.2431 x251



*From:* rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com
] *On Behalf Of *Stephen Markson
*Sent:* December 17, 2018 2:53 PM
*To:* 'rbase-l@googlegroups.com'
*Subject:* RE: [RBASE-L] - GATEWAY Export using Specification file



I have the used the following technique to achieve similar results:



Create a spreadsheet with an *AUTO_OPEN *macro that opens the spreadsheet
created from the specification file and then sets the borders you want…





Regards,



Stephen Markson

The Pharmacy Examining Board of Canada

416.979.2431 x251



*From:* rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com
] *On Behalf Of *Ajay Sanghvi
*Sent:* December 14, 2018 3:10 PM
*To:* rbase-l@googlegroups.com
*Subject:* RE: [RBASE-L] - GATEWAY Export using Specification file



I just figured out that when creating the specification file there is a
field for number of characters. This number set the width of the output
column in the Excel sheet.

This resolves one of my issues. But I am still missing a way to create
borders for the cells.



Thanks for taking the time to respond.

Ajay



*From:* 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com]
*Sent:* Friday, December 14, 2018 1:50 PM
*To:* rbase-l@googlegroups.com
*Subject:* Re: [RBASE-L] - GATEWAY Export using Specification file



I'm not sure if there's a better way to do it now, but in the past I have

created a blank template spreadsheet that had all the proper widths and

formats applied to columns & rows, and had users copy/paste into

the template.



You have to have a couple copies of the template stashed somewhere,

or else the user would usually save their work over the template name.



Karen







-Original Message-
From: Ajay Sanghvi 
To: rbase-l 
Sent: Fri, Dec 14, 2018 12:20 pm
Subject: [RBASE-L] - GATEWAY Export using Specification file

Hello all



I am trying to Export a table into Excel workbook using GATEWAY in a command

file. I have created a SPECIFICATION file that creates the proper heading

colors etc. What I am not able to do is set the width of certain columns and

have all my data be displayed with borders so the users do not have to

manipulate the excel file.



Thanks in advance.





AJAY SANGHVI

Vice President

700 Blair Road

Carteret, New Jersey  07008 U.S.A.



T (973) 748 8980

F (973) 680 9618

E asang...@berjeinc.com



-- 

*Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and

Certified by WQS.



-- 

_** Markets are moving rapidly, please note all prices and volume offers

are kindly to be considered subject final confirmation, including any

pending tariff changes, unless otherwise stated. ** _



-- 

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.

For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.


*Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and
Certified by WQS.
*** Markets are moving rapidly, please note all prices and volume offers
are kindly to be considered subject final confirmation, including any
pending tariff changes, unless otherwise stated. ** *

-- 
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.
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit
http://www.rbase

RE: Re[2]: [RBASE-L] - GATEWAY IMPORT Fail

['Jim Belisle' via RBASE-L]

Bruce,

I set my file to be used in a variable then use this code.

GATEWAY IMPORT CSV &vezpath +
APPEND tdaytable OPTION SPECIFICATION_FILE_NAME daytemp.RGW

This should work for you.

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01D92676.44AFAB20]

From: rbase-l@googlegroups.com  On Behalf Of Bruce 
Chitiea
Sent: Thursday, January 12, 2023 11:01 AM
To: 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" 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) , +
soNumTEXT (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
   -
   11(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf
   12(rbms(23233(cpsb(1(2020-01-29(543199(stock(0(c(.pdf
   13(rbms(23238(gar.(1(2020-01-06(7274(na(0(c(.pdf
   14(rbms(23239(gar.(1(2020-01-16(7283(na(0(c(.pdf
   15(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%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 
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://na

RE: Re[2]: [RBASE-L] - GATEWAY IMPORT Fail

['Jim Belisle' via RBASE-L]

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@01D92676.6DA979C0]

From: rbase-l@googlegroups.com  On Behalf Of Bruce 
Chitiea
Sent: Thursday, January 12, 2023 11:01 AM
To: 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" 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) , +
soNumTEXT (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
   -
   11(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf
   12(rbms(23233(cpsb(1(2020-01-29(543199(stock(0(c(.pdf
   13(rbms(23238(gar.(1(2020-01-06(7274(na(0(c(.pdf
   14(rbms(23239(gar.(1(2020-01-16(7283(na(0(c(.pdf
   15(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%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 
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.ou

RE: Re[4]: [RBASE-L] - GATEWAY IMPORT Fail

['Jim Belisle' via RBASE-L]

Happy New Year to you as well.


From: 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" 
>mailto:rbase-l@googlegroups.com>>
To "rbase-l@googlegroups.com<mailto: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> 
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" 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) , +
soNumTEXT (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
   -
   11(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf
   12(rbms(23233(cpsb(1(2020-01-29(543199(stock(0(c(.pdf
   13(rbms(23238(gar.(1(2020-01-06(7274(na(0(c(.pdf
   14(rbms(23239(gar.(1(2020-01-16(7283(na(0(c(.pdf
   15(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

[RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

[Bruce A. Chitiea]

Win10Pro / RGBX5E

GATEWAY IMPORT CSV

Wondering if there's a practical limit to the record count or file size 
of a source CSV file, or if there's a "choke" setting to be tweaked.


I had successfully imported several CSV files, the largest of which 
contained 634,500 records (101mb. )


RBASE started and then dropped efforts (without error message) to import 
a file containing 800,000 records (128mb. )


Without additional modification to internal data or structure, once this 
file was cut into halves (400,000 records, @64mb each), RBASE happily 
imported the halves.


Thoughts?

Best wishes for the season, all!

Bruce Chitiea
SafeSectors, Inc.
909.238.9012 m

--
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.
For more options, visit https://groups.google.com/d/optout.

Re[5]: [RBASE-L] - GATEWAY IMPORT Fail | Success, Notes and Postscript

[Bruce Chitiea]

All: Thank you. For any other professional trainee (best viewed in 
Courier New font):


The successful integration of the .RGW import specification file looks 
like this:


GATEWAY IMPORT CUS .v04_fileSpec_importSource +
APPEND stage2_atomized_tt +
OPTION SPECIFICATION_FILE_NAME stage1_list_prepared.rgw

As noted below, the .v04_filespec_importSource variable concatenates the 
source file with the source path. "Ampersanding" this variable also 
works.


In the above code, the stage_1_list_prepared.RGW file is found in the 
same folder as the .RMD file. But what if the .RGW file needs to be 
stored elsewhere?


SET VAR +
v04_importSpecFilePath = 'D:\WORKBENCH\RBMS\FNAME_2\2-FILE_LIST\', +
v04_importSpecFile = 'stage1_list_prepared.rgw'

SET VAR +
v04_importSpecification = (.v04_importSpecFilePath + .v04_importSpecFile 
)


GATEWAY IMPORT CUS &v04_fileSpec_importSource +
APPEND stage2_atomized_tt +
OPTION SPECIFICATION_FILE_NAME &v04_importSpecification

Note that the variable v04_importSpecification MUST be ampersanded.

**
Postscript.

The process of defining the .RGW file in the GUI is sensitive to the 
number of non-null populated columns found in the source-file sample 
used to capture the column mappings. It is possible that the sample used 
may not be representative of every row in the real-world data set, e.g. 
may not contain the maximum number of non-null column values (this is 
especially possible if one is testing with a small source data set, to 
avoid hard-resetting one's way out of eternal loops with the real-world 
data set.)


In my case, the target output table contains fifteen (15) columns; my 
small source sample contains only eleven (11) non-null columns. The .RGW 
file - editable with RBEdit, captured the following [Mappings]:


[Mappings]
Count=15
Map0=stage1_filenameID = Field1
Map1=rbms = Field2
Map2=soNum = Field3
Map3=custTextCode = Field4
Map4=docCode = Field5
Map5=docDateRaw = Field6
Map6=docNum = Field7
Map7=docField08 = Field8
Map8=docField09 = Field9
Map9=docField10 = Field10
Map10=docField11 = Field11
Map11=docField12 =
Map12=docField13 =
Map13=stage2_column_count =
Map14=walkListID =

There's the prospect that an attempt to import the real-world data set 
might fail, should rows contain data in Fields 12 through 15. Simple 
solution: edit the .RGW file:


...
Map11=docField12 = Field12
Map12=docField13 = Field13
Map13=stage2_column_count = Field14
Map14=walkListID = Field15

The successful tests reported above were performed with both the 
original and modified .RGW files.


Happy to help, Bruce

Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | rby...@safesectors.com


-- Original Message --

From "Bruce Chitiea" 

To "rbase-l@googlegroups.com" 
Date 1/12/2023 9:29:40 AM
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



-- Original Message --
From "'Jim Belisle' via RBASE-L" 
To "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




From:rbase-l@googlegroups.com  On Behalf Of 
Bruce Chitiea

Sent: Thursday, January 12, 2023 11:01 AM
To: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 | Clarem

RE: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

[Tony IJntema]

Bruce,

 

I have an application which imports several files of more than a million rows 
(size > 100 MB) and encounter no problems.

My suggestion is to have a look into the file if there is a structure problem, 
like a missing quote or something else.

You can start reading 600.000 rows and look what happens and so on

 

Tony

 

 

Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Bruce A. 
Chitiea
Verzonden: maandag 10 december 2018 2:07
Aan: rbase-l@googlegroups.com
Onderwerp: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size 
Limit?

 

Win10Pro / RGBX5E

 

GATEWAY IMPORT CSV

 

Wondering if there's a practical limit to the record count or file size of a 
source CSV file, or if there's a "choke" setting to be tweaked.

 

I had successfully imported several CSV files, the largest of which contained 
634,500 records (101mb. )

 

RBASE started and then dropped efforts (without error message) to import a file 
containing 800,000 records (128mb. )

 

Without additional modification to internal data or structure, once this file 
was cut into halves (400,000 records, @64mb each), RBASE happily imported the 
halves.

 

Thoughts?

 

Best wishes for the season, all!

 

Bruce Chitiea

SafeSectors, Inc.

909.238.9012 m 

-- 
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.
For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

[Albert Berry]

Check into the settings of your virus/malware programs. They may be slowing 
down the import to the point that R:Base thinks it’s done before it is. 
Albert

> On Dec 9, 2018, at 6:06 PM, Bruce A. Chitiea  wrote:
> 
> Win10Pro / RGBX5E
> 
> GATEWAY IMPORT CSV
> 
> Wondering if there's a practical limit to the record count or file size of a 
> source CSV file, or if there's a "choke" setting to be tweaked.
> 
> I had successfully imported several CSV files, the largest of which contained 
> 634,500 records (101mb. )
> 
> RBASE started and then dropped efforts (without error message) to import a 
> file containing 800,000 records (128mb. )
> 
> Without additional modification to internal data or structure, once this file 
> was cut into halves (400,000 records, @64mb each), RBASE happily imported the 
> halves.
> 
> Thoughts?
> 
> Best wishes for the season, all!
> 
> Bruce Chitiea
> SafeSectors, Inc.
> 909.238.9012  m 
> 
> -- 
> 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 
> .
> For more options, visit https://groups.google.com/d/optout 
> .

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re[2]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

[Bruce A. Chitiea]

Tony and Albert:

Thanks for the insights. Cannot see a structural issue (yet), as both 
halves imported without burping; but an antivirus delay is an intriguing 
idea. If one assumes that antivirus was also interested in, and active 
on, all the shorter files which imported without incident, then file 
size seems implicated; suggesting the crossing of an internal delay 
threshold within R:BASE ("uh, I've waited long enough") due to AV dwell 
time. May be worth an experiment or two.


Thanks!
Bruce



-- Original Message --
Sent: 12/9/2018 10:42:57 PM
Subject: RE: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / 
File Size Limit?

From: "Tony IJntema" 
To: rbase-l@googlegroups.com


Bruce,



I have an application which imports several files of more than a million 
rows (size > 100 MB) and encounter no problems.


My suggestion is to have a look into the file if there is a structure 
problem, like a missing quote or something else.


You can start reading 600.000 rows and look what happens and so on



Tony





Van:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens 
Bruce A. Chitiea

Verzonden: maandag 10 december 2018 2:07
Aan:rbase-l@googlegroups.com
Onderwerp: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / 
File Size Limit?




Win10Pro / RGBX5E



GATEWAY IMPORT CSV



Wondering if there's a practical limit to the record count or file size 
of a source CSV file, or if there's a "choke" setting to be tweaked.




I had successfully imported several CSV files, the largest of which 
contained 634,500 records (101mb. )




RBASE started and then dropped efforts (without error message) to import 
a file containing 800,000 records (128mb. )




Without additional modification to internal data or structure, once this 
file was cut into halves (400,000 records, @64mb each), RBASE happily 
imported the halves.




Thoughts?



Best wishes for the season, all!



Bruce Chitiea

SafeSectors, Inc.

909.238.9012 m

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

For more options, visit https://groups.google.com/d/optout.


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

For more options, visit https://groups.google.com/d/optout.

--
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.
For more options, visit https://groups.google.com/d/optout.

Re[4]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

[Bruce A. Chitiea]

Rich:

Ah, the eternal "garbage in" issue, which The Divine Being wrestles with 
daily as us folks down here keep producing more of it. R:BASE, however, 
don't take no trash from nobody, which is one of the reason to love it. 
Trash bites back, if allowed in, long after it seeps through the door, 
generally when your machine's "critical detector" is just itching to 
fire.


Cheers, Bruce

-- Original Message --
Sent: 12/10/2018 11:46:07 AM
Subject: Re: Re[2]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record 
Count / File Size Limit?

From: "Rich Jasinski" 
To: rbase-l@googlegroups.com


I have had an issue with garbage characters blowing up a csv load or a 
alpha char trying to load into an int  field


Sent from my iPhone

On Dec 10, 2018, at 2:25 PM, Bruce A. Chitiea  
wrote:



Tony and Albert:

Thanks for the insights. Cannot see a structural issue (yet), as both 
halves imported without burping; but an antivirus delay is an 
intriguing idea. If one assumes that antivirus was also interested in, 
and active on, all the shorter files which imported without incident, 
then file size seems implicated; suggesting the crossing of an internal 
delay threshold within R:BASE ("uh, I've waited long enough") due to AV 
dwell time. May be worth an experiment or two.


Thanks!
Bruce



-- Original Message --
Sent: 12/9/2018 10:42:57 PM
Subject: RE: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / 
File Size Limit?

From: "Tony IJntema" 
To: rbase-l@googlegroups.com


Bruce,



I have an application which imports several files of more than a 
million rows (size > 100 MB) and encounter no problems.


My suggestion is to have a look into the file if there is a structure 
problem, like a missing quote or something else.


You can start reading 600.000 rows and look what happens and so on



Tony





Van:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens 
Bruce A. Chitiea

Verzonden: maandag 10 december 2018 2:07
Aan:rbase-l@googlegroups.com
Onderwerp: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / 
File Size Limit?




Win10Pro / RGBX5E



GATEWAY IMPORT CSV



Wondering if there's a practical limit to the record count or file size 
of a source CSV file, or if there's a "choke" setting to be tweaked.




I had successfully imported several CSV files, the largest of which 
contained 634,500 records (101mb. )




RBASE started and then dropped efforts (without error message) to 
import a file containing 800,000 records (128mb. )




Without additional modification to internal data or structure, once 
this file was cut into halves (400,000 records, @64mb each), RBASE 
happily imported the halves.




Thoughts?



Best wishes for the season, all!



Bruce Chitiea

SafeSectors, Inc.

909.238.9012 m

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

For more options, visit https://groups.google.com/d/optout.


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

For more options, visit https://groups.google.com/d/optout.

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

For more options, visit https://groups.google.com/d/optout.


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

For more options, visit https://groups.google.com/d/optout.

--
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.
For more options, visit https://groups.google.com/d/optout.

Re[6]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

[Bruce A. Chitiea]

Thanks, Steve.

I'll do a controlled, comparative import of both a downloaded native 
.CSV file, and that same file converted to .XLSX, and report back, most 
likely next week.


Thanks to all!

Bruce

-- Original Message --
Sent: 12/10/2018 5:53:15 PM
Subject: Re: Re[4]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record 
Count / File Size Limit?

From: "Steve Johnson" 
To: "'rbase-l_googlegroups.com'" 


Bruce,

Perhaps import the file into Excel and see what happens.

Steve

Sent from my BlackBerry KeyOne

From:rby...@safesectors.com
Sent: December 10, 2018 2:58 PM
To:rbase-l@googlegroups.com
Reply-to:rbase-l@googlegroups.com
Subject: Re[4]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count 
/ File Size Limit?


Rich:

Ah, the eternal "garbage in" issue, which The Divine Being wrestles with 
daily as us folks down here keep producing more of it. R:BASE, however, 
don't take no trash from nobody, which is one of the reason to love it. 
Trash bites back, if allowed in, long after it seeps through the door, 
generally when your machine's "critical detector" is just itching to 
fire.


Cheers, Bruce

-- Original Message ------
Sent: 12/10/2018 11:46:07 AM
Subject: Re: Re[2]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record 
Count / File Size Limit?

From: "Rich Jasinski" 
To: rbase-l@googlegroups.com


I have had an issue with garbage characters blowing up a csv load or a 
alpha char trying to load into an int  field


Sent from my iPhone

On Dec 10, 2018, at 2:25 PM, Bruce A. Chitiea  
wrote:



Tony and Albert:

Thanks for the insights. Cannot see a structural issue (yet), as both 
halves imported without burping; but an antivirus delay is an 
intriguing idea. If one assumes that antivirus was also interested in, 
and active on, all the shorter files which imported without incident, 
then file size seems implicated; suggesting the crossing of an internal 
delay threshold within R:BASE ("uh, I've waited long enough") due to AV 
dwell time. May be worth an experiment or two.


Thanks!
Bruce



-- Original Message --
Sent: 12/9/2018 10:42:57 PM
Subject: RE: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / 
File Size Limit?

From: "Tony IJntema" 
To: rbase-l@googlegroups.com


Bruce,



I have an application which imports several files of more than a 
million rows (size > 100 MB) and encounter no problems.


My suggestion is to have a look into the file if there is a structure 
problem, like a missing quote or something else.


You can start reading 600.000 rows and look what happens and so on



Tony





Van:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens 
Bruce A. Chitiea

Verzonden: maandag 10 december 2018 2:07
Aan:rbase-l@googlegroups.com
Onderwerp: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / 
File Size Limit?




Win10Pro / RGBX5E



GATEWAY IMPORT CSV



Wondering if there's a practical limit to the record count or file size 
of a source CSV file, or if there's a "choke" setting to be tweaked.




I had successfully imported several CSV files, the largest of which 
contained 634,500 records (101mb. )




RBASE started and then dropped efforts (without error message) to 
import a file containing 800,000 records (128mb. )




Without additional modification to internal data or structure, once 
this file was cut into halves (400,000 records, @64mb each), RBASE 
happily imported the halves.




Thoughts?



Best wishes for the season, all!



Bruce Chitiea

SafeSectors, Inc.

909.238.9012  m

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

For more options, visit https://groups.google.com/d/optout.


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

For more options, visit https://groups.google.com/d/optout.

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

For more options, visit https://groups.google.com/d/optout.


--
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 fro

Re: Re[2]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

[Rich Jasinski]

I have had an issue with garbage characters blowing up a csv load or a alpha 
char trying to load into an int  field

Sent from my iPhone

> On Dec 10, 2018, at 2:25 PM, Bruce A. Chitiea  wrote:
> 
> Tony and Albert:
> 
> Thanks for the insights. Cannot see a structural issue (yet), as both halves 
> imported without burping; but an antivirus delay is an intriguing idea. If 
> one assumes that antivirus was also interested in, and active on, all the 
> shorter files which imported without incident, then file size seems 
> implicated; suggesting the crossing of an internal delay threshold within 
> R:BASE ("uh, I've waited long enough") due to AV dwell time. May be worth an 
> experiment or two.
> 
> Thanks!
> Bruce
> 
> 
> 
> -- Original Message --
> Sent: 12/9/2018 10:42:57 PM
> Subject: RE: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File 
> Size Limit?
> From: "Tony IJntema" 
> To: rbase-l@googlegroups.com
> 
> 
> Bruce,
> 
>  
> 
> I have an application which imports several files of more than a million rows 
> (size > 100 MB) and encounter no problems.
> 
> My suggestion is to have a look into the file if there is a structure 
> problem, like a missing quote or something else.
> 
> You can start reading 600.000 rows and look what happens and so on
> 
>  
> 
> Tony
> 
>  
> 
>  
> 
> Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Bruce 
> A. Chitiea
> Verzonden: maandag 10 december 2018 2:07
> Aan: rbase-l@googlegroups.com
> Onderwerp: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File 
> Size Limit?
> 
>  
> 
> Win10Pro / RGBX5E
> 
>  
> 
> GATEWAY IMPORT CSV
> 
>  
> 
> Wondering if there's a practical limit to the record count or file size of a 
> source CSV file, or if there's a "choke" setting to be tweaked.
> 
>  
> 
> I had successfully imported several CSV files, the largest of which contained 
> 634,500 records (101mb. )
> 
>  
> 
> RBASE started and then dropped efforts (without error message) to import a 
> file containing 800,000 records (128mb. )
> 
>  
> 
> Without additional modification to internal data or structure, once this file 
> was cut into halves (400,000 records, @64mb each), RBASE happily imported the 
> halves.
> 
>  
> 
> Thoughts?
> 
>  
> 
> Best wishes for the season, all!
> 
>  
> 
> Bruce Chitiea
> 
> SafeSectors, Inc.
> 
> 909.238.9012 m 
> 
> -- 
> 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.
> For more options, visit https://groups.google.com/d/optout.
> 
> -- 
> 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.
> For more options, visit https://groups.google.com/d/optout.
> -- 
> 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.
> For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: Re[4]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

[Steve Johnson]

  Bruce,Perhaps import the file into Excel and see what happens. SteveSent from my BlackBerry KeyOne   From: rby...@safesectors.comSent: December 10, 2018 2:58 PMTo: rbase-l@googlegroups.comReply-to: rbase-l@googlegroups.comSubject: Re[4]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?  Rich:Ah, the eternal "garbage in" issue, which The Divine Being wrestles with daily as us folks down here keep producing more of it. R:BASE, however, don't take no trash from nobody, which is one of the reason to love it. Trash bites back, if allowed in, long after it seeps through the door, generally when your machine's "critical detector" is just itching to fire.Cheers, Bruce-- Original Message --Sent: 12/10/2018 11:46:07 AMSubject: Re: Re[2]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?From: "Rich Jasinski" <r...@ogdengroup.com>To: rbase-l@googlegroups.comI have had an issue with garbage characters blowing up a csv load or a alpha char trying to load into an int  fieldSent from my iPhoneOn Dec 10, 2018, at 2:25 PM, Bruce A. Chitiea <rby...@safesectors.com> wrote:Tony and Albert:Thanks for the insights. Cannot see a structural issue (yet), as both halves imported without burping; but an antivirus delay is an intriguing idea. If one assumes that antivirus was also interested in, and active on, all the shorter files which imported without incident, then file size seems implicated; suggesting the crossing of an internal delay threshold within R:BASE ("uh, I've waited long enough") due to AV dwell time. May be worth an experiment or two.Thanks!Bruce

-- Original Message --
Sent: 12/9/2018 10:42:57 PM
Subject: RE: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?
From: "Tony IJntema" <t.ijnt...@cio-bv.nl>
To: rbase-l@googlegroups.com

Bruce, I have an application which imports several files of more than a million rows (size > 100 MB) and encounter no problems.My suggestion is to have a look into the file if there is a structure problem, like a missing quote or something else.You can start reading 600.000 rows and look what happens and so on Tony  Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Bruce A. ChitieaVerzonden: maandag 10 december 2018 2:07Aan: rbase-l@googlegroups.comOnderwerp: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit? Win10Pro / RGBX5E GATEWAY IMPORT CSV Wondering if there's a practical limit to the record count or file size of a source CSV file, or if there's a "choke" setting to be tweaked. I had successfully imported several CSV files, the largest of which contained 634,500 records (101mb. ) RBASE started and then dropped efforts (without error message) to import a file containing 800,000 records (128mb. ) Without additional modification to internal data or structure, once this file was cut into halves (400,000 records, @64mb each), RBASE happily imported the halves. Thoughts? Best wishes for the season, all! Bruce ChitieaSafeSectors, Inc.909.238.9012 m -- 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.For more options, visit https://groups.google.com/d/optout.



-- 
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.
For more options, visit https://groups.google.com/d/optout.




-- 
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.
For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.