Perhaps not elegant, but should work
(1) Print the Excel file to a .TXT file
(2) Import/Load .TXT file to a TEMP table
(3) Count the number of rows to a variable
(4) If count value is <2, don't GATEWAY
Bruce
Bruce A. Chitiea
SafeSectors, Inc.
112 Harvard Ave #272
Claremont CA 91711-4716
[email protected]
(909) 238-9012 c
------ Original Message ------
From: "'Jim Belisle' via RBASE-L" <[email protected]>
To: "[email protected]" <[email protected]>
Sent: 5/10/2020 12:59:33 PM
Subject: [RBASE-L] - File import
I am trying to work with our web administrator in bringing order
information into RBASE using FTP.
The FTP syncornizer creates an Excel file from the web then send that
Excel file to our server. I then create code that brings that file
information into RBASE using GATEWAY.
Here is the glitch. On the web side, the automated sync downloading the
Excel file fires even if there is no info to send to us. That means I
end up with a file that has a header row but no actual information to
import.
My GATEWAY just hangs up if there is no actual info to import.
So my question. Is there some code or GATEWAY setting that can check an
Excel file for info so it will not import?
My web man says he cannot set up the FTP to NOT send files (if no info
available) if it is automated to sync with my server at set times.
The only other option is for the web to export to our server all the
web traffic every time. That eventually will get to be a BIG file if
our web traffic increases as we wish.
Can anyone think of anything I can do on the RBASE end?
James Belisle
Making Information Systems People Friendly Since 1990
cid:[email protected]
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394AF530E44BBE904A88D2DA0A00%40CY4PR0201MB3394.namprd02.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394AF530E44BBE904A88D2DA0A00%40CY4PR0201MB3394.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em4952efa5-4ce6-4631-85fa-e10acd33c24c%40pathfinder.
