Well I've been fretting away at this wretched thing for 7 hours now, and I just can't make a query out of my csv files. I've tried cfhttp but that doesn't like having the column names on the second row and doesn't like having spaces in the column names.
I downloaded CFX_CSVtoQuery and can't make that do anything but parse .TXT files. It flatly refuses to parse .CSV files. It won't scan any rows. I keep getting zero rows scanned as one of the output variables. I can't make a DSNless connection to the files - that says ERROR all the time and gives no hint as to the reason. When I load the files into my trusty UltraEdit, which WILL read them, it asks if I want to convert them to dos format. I don't know quite what that means, except I'm assuming it's because the file only has HEX0A (Linefeed) at the end of the rows instead of CR/LF. So I have tried using regex and the function REREplace to fix that, and it insists on putting a CR/LF at the top of the file, thereby making sure the column headings are on row 2 and therefore unable to be used by CFHTTP or CFX_CSVtoQUERY. Has anyone ACTUALLY done any of this? If you've forgotten, here's the deal.... I have an information provider automatically dumping 17 .csv files into my server and I have to read them and manipulate them as queries for my site users to see the data in various ways. It happens automatically and I can't have the files changed. They are deposited every day at 5am and I can't have any manual processing. I have to be able to ensure the files are not locked by the server at 5am (approx) when the provider drops them on my system. If they're locked by the CF Server at that time, the ftp will fail and we wont get the data updated. So, ... how can I get around this? I can't spend much more time trying one thing after another trying to make CF parse these CSV files. In a few hours I'm going to have to say ColdFusion can't do it and give the job to a ASP progammer who also works on the site. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -----Original Message----- From: Michael Kear [mailto:mkear@;afpwebworks.com] Sent: Tuesday, 29 October 2002 7:02 PM To: CF-Talk Subject: RE: DSN-less connection to a CSV file? Thanks but everything has to happen daily and fully automatically. How do I do that in CF? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -----Original Message----- From: [EMAIL PROTECTED] [mailto:cf-talk@;linenoize.com] Sent: Tuesday, 29 October 2002 7:13 PM To: CF-Talk Subject: Re: DSN-less connection to a CSV file? Quick and dirty fix is to open the file using CFFILE then replace all of the LFs with CRLFs... then save the file. I've done this in the past without any problem. You will also want to make sure that there are no LFs anywhere that there shouldn't be... -Novak ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
