On 04/24/2013 09:26 AM, Alex Thurgood wrote:
Le 24/04/2013 14:36, sun shine a écrit :
Looking at this :
http://customs.hmrc.gov.uk/channelsPortalWebApp/channelsPortalWebApp.portal?_nfpb=true&_pageLabel=pageImport_ShowContent&id=HMCE_PROD_010685&propertyType=document
gives a list on how to structure the file and hints on what to do if
your CSV submission fails, e.g. if leading zeroes get dropped or if
NULL/0 values get replaced with nothing (as is the case with
LibreOffice). The solution to those particular problems is to enter
the data as a text string (by putting a leading apostrophe, for example).
That same page also recommends not working on your CSV file directly,
and in particular not to re-open it in your spreadsheet program (Excel
cited in that particular case) !!
Alex
Reading the link, I second the procedure of working on the spreadsheet
format then saving as csv. I suspect they are uploading to a database
using a script that expects a Windows end-of-line only (or they think it
will only take a Windows end-of-line).
Try passing the spreadsheet back and forth they due a final save to csv
on the Windows machine.
I have see the character encoding go wacky and have to be reset to
properly import a csv into Calc on occasion. Excel may be expecting a
different character set than UTF-8.
--
Jay Lozier
jsloz...@gmail.com
--
For unsubscribe instructions e-mail to: users+h...@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