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

On 12/22/2012 09:08 AM, Rich Shepard wrote:
> On Fri, 21 Dec 2012, Jay Lozier wrote:
>
> > In a csv file the field delimiter is usually a comma and to denote 
> > what is
> > a string that may contain a comma quotation marks are used. If the 
> > cell in
> > the original format was empty or NULL in a database nothing is exported.
> > For example the export from a database might look like this:
> >
> > 1,"text string, test",,,"the last two were NULLs in the database",34
> > 2."another string",3,3,,57
>
> Jay,
>
>   I know this and that's why I don't understand why postgres balks at
> inserting the rows with NULL values in text columns.
Check the column restrictions, often the column must be defined to 
accept NULL. This is true with MS SQL Server and MySQL/MariaDB. If the 
column definition does not explicitly allow NULL values you must enter 
an appropriate placeholder value (empty string, 0, etc)
> > For the exported value to an empty string ("") the original value 
> > must be an empty string "" not an empty cell. When importing into a 
> > database is it often better to have the equivalent to a NULL value 
> > because the each column in the database will have an assigned data 
> > type and the empty string will cause an import error if there is data 
> > type mismatch. The empty string will cause problems with numeric data.
>
>   That's what I'm doing: replacing empty cells with NA strings. I aborted
> the first attempt yesterday afternoon because it was late and the size of
> the data file (~20 Mb) was taking too long to complete. I'll do this 
> today.
>
> Thanks,
>
> Rich


--
Jay Lozier
jslozier@gmail.com


--
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