Been there, done that, don't want to do it again.
I worked on an app that allowed a site admin to upload a .csv file
with updated store data (from his POS system). I found a UDF at
cflib.org that turned a .csv file into a query object, and I looped
through that. However, on a fast machine (my wo
This UDF read a strig line by line and turn it into an array leveraging
Java's API (no CFML lists). Not sure if it may fits your neds:
http://www.cflib.org/udf.cfm?ID=1222
Massimo Foti
Tools for ColdFusion and Dreamweaver developers:
http://www.massimocorner.com
What database? If it is SQL Server, you may be able to set the import
up as a DTS package, and then fire off the DTS package when the new
file is uploaded.
-jim
On 1/11/06, Robert Everland III <[EMAIL PROTECTED]> wrote:
> We have a file upload process here where a user needs to upload a file, the
efficient text processing.
> -Original Message-
> From: Figy, Kam [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 11, 2006 9:02 AM
> To: CF-Talk
> Subject: RE: Parsing through text file
>
> List functions are really slow. I'll bet you could realize a
>
List functions are really slow. I'll bet you could realize a pretty good
speed increase using ListToArray() first and parsing the array, since
you're iterating over it so many times.
Hth
Kam
-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 1
>>The issue is the processor goes crazy on a 1.4 mb file. There are no
line breaks. Just a 1.4 mb string of text that is delimenated.
1.4 mb is not that long for processors we have nowadays.
Is your server so small?
The problem might be reading the file as a list and using listGetAt(),
which i
The issue is the processor goes crazy on a 1.4 mb file. There are no line
breaks. Just a 1.4 mb string of text that is delimenated. I'm trying to parse
through it in Homesite and it's killing the processor on there also. I guess
there isn't much I can do.
Bob
~
> We have a file upload process here where a user needs to
> upload a file, the file then needs to be parsed through to
> get data out of it and inserted into a database. The file is
> 1.4mb long. I'm having issues just reading and looping
> through the file. Is there a better way to do somethi
8 matches
Mail list logo