Re: [libreoffice-users] Re: Batch conversion from csv

On 07/24/2012 12:16 PM, Andreas Säger wrote:
> Am 24.07.2012 13:34, Michael Crider wrote:
> > I have csv files generated from an SQL command-line utility that I am
> > trying to convert to dBase using the batch converter. If I open the csv
> > in LibreOffice, a default option is "Quoted fields as text", and if it
> > is saved as another filetype, those fields remain text, but when using
> > the batch converter it will bring all numbers in as numbers, even if
> > they are quoted. The command I am using is:
> > libreoffice --headless --invisible --convert-to dbf *.csv
> > I have the same results if I convert to other spreadsheet types. Is
> > there a way to tell the batch converter to convert "quoted fields as 
> > text"?
>
> CSV is a database exchange format. dBase is a database in a directory. 
> Why do you try to load csv into spreadsheets?
> Why csv at all? Probably you can connect Base to the database and use 
> it directly. Base is a versatile tool to serve database data to office 
> documents and it can be used to move data from one database type to 
> another.
This is part of my attempt to automate the process (run by cron) to 
export data from an IBM server (DB2 database) to netbooks that are 
carried away from the office. There are 2 tables which are each dumped 
to dBase files and copied to the netbooks, where an odb file exists that 
points to the directory with the dBase files. Initially the data was 
being downloaded from DB2 by a Windows program that could save directly 
as dBase, but this could not be automated, and I wanted to move the 
process to an Ubuntu server. The only option I have found for retrieving 
the data from DB2 is using IBM's unixODBC driver and the isql command, 
which only exports as csv.
The reason I attempted other spreadsheet types is because dBase files 
can be opened directly in Calc, as well as accessed through Base.
I am open any suggestions for improving this process.


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted