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