-Original Message-
From: Wayne Irvine [mailto:[EMAIL PROTECTED]
Hey, I asked for tab delimited and look what I got.
*g* Yeah, I've got a few of those, too.
That is a very good point and one I hadn't thought of. It is
the same fields in each record that are quoted. I'll try
Robert is talking about the server version...
5.0.1.065
The current production version for osx, windows and linux.
Wilcox, Jamileh (HSC) wrote:
-Original Message-
From: Wayne Irvine [mailto:[EMAIL PROTECTED]
Hey, I asked for tab delimited and look what I got.
*g* Yeah, I've
Doh! I'm going to wake up, soon, I swear. Thanks.
-Original Message-
From: John McGowan [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 9:12 AM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Import CSV
Robert is talking about the server version...
5.0.1.065
In MySQL, which I know you aren't using, this is addressed by
terminating fields with a comma and enclosing them with quotes. I do
the exact same thing with fields including commas and quotes and it
works every time.
FileMaker does present a different predicament. My experience with its
I would do almost anything to
avoid it including converting to MySQL : )
Please forgive me if I seem a little frustrated, but this really isn't
helping.
The site uses FileMaker.
The data files are CSV.
The issue is bringing CSVs (some of whose fields contain commas) into arrays
in Tango.
Do not mean to frustrate, just thought you might be interested in a
possible workaround which you would have seen if you had read a
little further. Depending on the source of the file, you might be able
to specify a different and less common delimiter (such as a pipe) to
avoid the problem
which you would have seen if you had read a
little further.
Oh I read the whole thing. I only quoted the salient part.
As I stated the files are CSVs. I have no control over that.
Wayne Irvine
Byte Services Pty Ltd
http://www.byteserve.com.au/
Good luck.
On Apr 15, 2004, at 1:54 AM, Wayne Irvine wrote:
which you would have seen if you had read a
little further.
Oh I read the whole thing. I only quoted the salient part.
As I stated the files are CSVs. I have no control over that.
Wayne Irvine
Byte Services Pty Ltd
Good luck.
Not so far. :(
Byte Services Pty Ltd
http://www.byteserve.com.au/
[EMAIL PROTECTED]
Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088
TO UNSUBSCRIBE: Go
that it does
- Original Message -
From: Chris Smith - Comcast Acct [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 10:29 PM
Subject: RE: Witango-Talk: Import CSV
I would load csv into temp table.
that way you can loop and use the data from the temp table for inserts
A properly formatted csv file has double quotes around all fields,
Damn, these files don't have quotes around the numeric value fields.
Wayne
Byte Services Pty Ltd
http://www.byteserve.com.au/
[EMAIL PROTECTED]
Ph 02 9960 6099 Mob 0409
Maybe you can request that they are formatted correctly from
your source?
Stefan
At 10:30 AM 4/15/2004, you wrote:
A properly formatted csv file has double quotes around all fields,
Damn, these files don't have quotes around the numeric value fields.
Wayne
Byte Services Pty
You could also do the following (tedious) replacements before
the final tokenize step:
replace ,1 with ,1
replace ,2 with ,2
and so on...
replace 1, with 1,
replace 2, with 2,
and so on...
Yuck, but it would work.
Stefan
At 10:53 AM 4/15/2004, you wrote:
Maybe you can request that they are
Actually, this might not work in the following scenario
where you have an address field like this:
123 Laurel Lane Apt. 3, Chicago, IL
Bummer.
At 10:59 AM 4/15/2004, you wrote:
You could also do the following (tedious) replacements before
the final tokenize step:
replace ,1 with ,1
replace ,2
Not all CVS files have quotes delimiting the fields ... AFAIK always
delimiting your fields with quotes is optional...
(from the first link i could find on G that specified the CVS format)
Not sure how much of an authority this is, but It matches my experience
of what's out there.
* *Each
not that familiar with Witango or Javascript regex, so I can't help
you much there.)
Hope this might help.
jamileh
-Original Message-
From: Wayne Irvine [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 12:44 AM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Import CSV
I'd say the first thing to try is ask him if he can produce csv files
with all fields quoted. That may or may not be possible, depending on
the program he's using and his level of expertise, but you could ask.
Hey, I asked for tab delimited and look what I got. There's already about 2
weeks
Be sure to use Witango 065 as the REGEX code was just recently updated.
-Original Message-
From: Wayne Irvine [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 7:39 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Import CSV
I'd say the first thing to try is ask him if he
]
Subject: Witango-Talk: Import CSV
A client of mine insists on providing database updates in CSV format. And of
course some of the fields contain commas within the text. All the text
fields are double quoted.
I've written a bunch of assigns that replace , and , with [col] and then
remove all remaining
Run an external action to a shell script. Here is the sql (MySQL)
syntax I use. This gets run all the time for doing exactly what you are
describing. It works like a charm. Even if you're not using MySQL, you
should be able to accomplish the same thing with another database.
LOAD DATA
REPLACE will not wipe out any existing data, as I stated below, only duplicate data. If you want to wipe out all data you will need to run something like DELETE FROM tablename prior to running load data infile. This WILL wipe out the data in your table in a flash, and I do recommend running a
Does the database that you are importing to able to import CSV format? Have
you tried just uploading file as is then automate the database import?
I'm not directly importing to the database. The database contains all sorts
of product information. The data file is product code, current stock
: Thursday, April 15, 2004 1:18 AM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Import CSV
Does the database that you are importing to able to import CSV format?
Have
you tried just uploading file as is then automate the database import?
I'm not directly importing to the database
]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 10:29 PM
Subject: RE: Witango-Talk: Import CSV
I would load csv into temp table.
that way you can loop and use the data from the temp table for inserts
into
the product table more efficiently
you could then empty the temp table after the action
I would load csv into temp table.
Do you mean a temporary table in the database or an array in Tango.
If the former, then it means having another table (or database file in
FileMaker) and using a script to import the file (stops the db server whilst
executing), then doing a number of searches,
heres a simple way to get csv data into a witango array:
@assign user$csvdata value=@array cols=2 value='@arg csvdata'
rdelim='@crlf' cdelim=','
dunno if that helps any, just tossing it out hoping that it does
That doesn't address the issue of fields containing commas which is the sole
.
csmith
-Original Message-
From: Wayne Irvine [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 1:41 AM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Import CSV
I would load csv into temp table.
Do you mean a temporary table in the database or an array in Tango.
If the former
A client of mine insists on providing database updates in CSV format. And of
course some of the fields contain commas within the text. All the text
fields are double quoted.
I've written a bunch of assigns that replace , and , with [col] and then
remove all remaining and it works just fine. Of
28 matches
Mail list logo