On 2013-07-24 05:29, [email protected] wrote: > Setelah upgrade ke v.13.5.1 - error pada saat import file contacts.csv > "*There was an error importing your contacs*"
Bisa diperlihatkan import contact yang berhasil di MDaemon versi sebelumnya? Kalau melihat dari error textnya, itu problem di format file contacts.csv, selama pakai format yang salah mestinya akan mengalami problem yang sama menggunakan MDaemon versi berapapun. CSV itu sebenarnya lebih tepat diterjemahkan sebagai "character-separated values" bukan "comma-separated values" karena separator character bisa bervariasi : comma atau tab space http://en.wikipedia.org/wiki/Comma-separated_values http://tools.ietf.org/html/rfc4180 CSV format yang digunakan MDaemon/Worldclient contact sbb: "Title","First Name","Middle Name", Character double quote between bracket ("") untuk menghindari problem pemakaian MS Excel yang selalu menghapus "leading zero" (spasi kosong) didepan huruf. http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm ---[start quote]--> Excel vs. Leading Zero & Space While this article is about CSV, this section is not. As mentioned, CSV stands on its own as a data transport format. The data it caries is just that, data. CSV does not care at all what the data is that is carried in its fields. It could be ASCII text, UNICODE text, binary image data, or even executables. It just doesn't matter to CSV what's in there. Excel is an application that produces and uses CSV. A particular aspect of how Excel uses CSV has become a considerable source of confusion and uncertanty. Excel will always remove leading zeros from fields before displaying them. It will also always remove leading spaces. It insists on helping you, even if removing these leading zeros will, for example, cause your numerically keyed records to sort out of order. <--[end of quote]--- Akan lebih "aman" pakai openoffice atau libreoffice untuk export/import CSV file https://en.wikipedia.org/wiki/LibreOffice -- syafril ------- Syafril Hermansyah MDaemon-L Moderators, running MDaemon 13.5.2 Beta B SecurityPlus 4.1.5 Harap tidak cc: atau kirim ke private mail untuk masalah MDaemon. -- --[MDaemon-L]------------------------------------------------ Milis ini untuk Diskusi antar pengguna MDaemon Mail Server. Netiket: http://www.netmeister.org/news/learn2quote Arsip: http://mdaemon-l.dutaint.com Dokumentasi : http://mdaemon.dutaint.co.id Henti Langgan: Kirim mail ke MDaemon-L-unsubscribe [at] dutaint.com Berlangganan: kirim mail ke MDaemon-L-subscribe [at] dutaint.com Versi terakhir MD 13.5.1, SP 4.1.5, BES 2.0.2, OC 2.3.2, SG 2.1.2, PP 2.0.1
