Re: [libreoffice-users] Calc: Text Columns Not Quoted When Saving .csv

Hi :)
Errr, have you tried reading the Sql tables directly with LO?  Base is best when used as a 
front-end for an existing back-end and i think Postgres is one that Base works particularly well 
with at the moment.  I think the Base - Postgre 
connector was at least partly developd by people from the Postgre project fairly recently (within 
the last year i think)  

If the connector lets you use the Postgre database then it should be possible to edit the tables in 
Calc dynamically without having to go through any Csv file import/export processing.  

Regards from
Tom :)  





> ________________________________
> From: Rich Shepard <rshepard@appl-ecosys.com>
> To: users@global.libreoffice.org 
> Sent: Saturday, 22 December 2012, 1:21
> Subject: Re: [libreoffice-users] Calc: Text Columns Not Quoted When Saving .csv
>
> On Sat, 22 Dec 2012, Brian Barker wrote:
>
> > Could you convert your empty cells to blank, output as CSV, read this into
> > your other program, and then - only if necessary - edit the blanks back to
> > null?
>
> Brian,
>
>   One does not 'read' the file into a SQL database such as postgres. When a
> column attribute type is text SQL wants to see it quoted; when it's numeric
> (INTEGER, REAL) it cannot be quoted. For the record, DATE attributes, even
> in ISO format (YYYY-mm-dd) must be quoted for SQL to properly interpret it.
>
> > Can your other programs cope only with CSV files?  Not spreadsheet
> > document files?
>
>   Nope. SQL wants certain formats, and R might be able to read spreadsheets
> but I work with plain ASCII text files for almost everything.
>
> Rich
>
>
> -- 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
-- 
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