On 04/24/2013 09:26 AM, Alex Thurgood wrote:
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).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=documentgives 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
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 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