Here is a short code that can be used at the R Prompt. It should only load rows
1 thru 10. Replace filename.txt with ???.txt...your file name. Replace count
value with the number of columns you will have.GATEWAY IMPORT TAB +
filename.txt CREATE +
rawdata +
OPTION COLUMN_COUNT value +
|FIRST_ROW 1 +
|LAST_ROW 10 +
|SHOW_PROGRESS ON
The key is to determine if you can load any rows at all and what the data would
look like in the table.
If the above works the eliminate the First and Last command lines otherwise
post what happens.
Gary
On Monday, October 24, 2016 10:58 AM, Albert Berry <[email protected]>
wrote:
In the 1980's I had to import a huge file from a "wonderful" system that
wouldn't talk to any other application, and had no export capabilities. It
could save a report (with page headings and all) meant for 17" printers. The
report was huge. It was the logs from the equipment working in a coal mine, and
we needed to extract the information of how much rock was moved and how much
coal from which location was stockpiled at each of other locations. Every trip
a mine truck made from each shovel or loader to a stockpile was in their
somewhere.
I created a table with a single text column slightly wider than the widest
data row, created a form with a single field. I imported the data using the
form, then deleted any records that did not have specific characters at the
beginning of the data row/line to get rid of the page titles and other non data
rows.
I did this in 2.11 over a rather slow network with 1980's computer
capacities. It took about 2½ hours to import the data and create the stockpile
totals, but it did the work.
Albert
On 2016-10-23 1:38 PM, Gary Randall wrote:
#yiv0298156389 #yiv0298156389 -- _filtered #yiv0298156389 {panose-1:2 4 5 3 5 4
6 3 2 4;} _filtered #yiv0298156389 {font-family:Calibri;panose-1:2 15 5 2 2 2 4
3 2 4;}#yiv0298156389 #yiv0298156389 p.yiv0298156389MsoNormal, #yiv0298156389
li.yiv0298156389MsoNormal, #yiv0298156389 div.yiv0298156389MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv0298156389 a:link,
#yiv0298156389 span.yiv0298156389MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv0298156389 a:visited,
#yiv0298156389 span.yiv0298156389MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv0298156389
span.yiv0298156389EmailStyle17 {color:windowtext;}#yiv0298156389
.yiv0298156389MsoChpDefault {} _filtered #yiv0298156389 {margin:1.0in 1.0in
1.0in 1.0in;}#yiv0298156389 div.yiv0298156389WordSection1 {}#yiv0298156389
Hello All, I am trying to import data from a tab-delimited format txt file. I
have tried using the File Gateway utility and the command [Gateway] at the R:
prompt. When using the utility, it will not read the file, when it comes to
the step to match source column with target column the source is empty. When
using the R: prompt I get this error: “An error was encountered during
execution. Make sure the source exists and is not locked.” I have checked
the file with excel and note it’s not locked or corrupt. Not sure what I am
doing wrong? Thanks Gary Randall --
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].
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 [email protected].
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
