Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT Text(CSV)
Issue selecting from a csv file with quoted data
Jim Ducharme
2010-12-01 11:03:21
We downloaded the 12/1/10 version of the driver and we are still seeing and issue with selecting data from a csv file where the data in the file is quoted. We have tested this using the build in test tool in the jar.

To reproduce:
Assuming the csv called fullnames.csv file located in my /temp directory:

FUID,EmployeeName,FirstName,LastName
FLAST,"Last, First",First,Last
JDUNN,"Dunn, John",John,Dunn

Now use the driver's test tool with the JDBC URL:
jdbc:csv:////temp?_CSV_Header=true;tmpdir=/temp

Run the sql:
select * from fullnames

The result window you will see:

2 rows of data:
The 2 FUID values are correct
EmployeeName values will be "Last and "Dunn
FirstName values will be First" and John"
LastName values will be First and John

Obviously this is not correct. The original version of this driver we used did not work this way. It would properly handle the quoted values in the file.

If I change the JDBC URL to be:
jdbc:csv:////temp?_CSV_Header=true;_CSV_Quoter=";tmpdir=/temp

then it works fine but this requires that all of our customers and application configurations need to change simply because we upgraded the driver. This doesn't seem like something we should have to set a parameter for to handle properly.

These changes in the driver are causing a lot of issues with our customers so if you could please investigate ASAP we would appreciate it. We really do not want to have to have to re-configure every database connection URL we have using this driver for something that seems like we shouldn't need a config property for.

thanks.
Re:Issue selecting from a csv file with quoted data
HXTT Support
2010-12-01 16:16:36
Don't worry. I misunderstand your requestion. The latest package will be available after about two hours.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap