<br><br><div class="gmail_quote">2011/8/5 Daniel Tiefnig <span dir="ltr"><<a href="mailto:dtiefnig@sipwise.com">dtiefnig@sipwise.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On 08/05/2011 06:18 PM, Sébastien Cramatte wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I've got lot of malformed issue but I can't solved it because<br>
OSS.log doesn't tell me on which line ...<br>
</blockquote>
<br></div>
You should get an error in the webinterface pointing to the line in the<br>
file.<br></blockquote><div>NO ! Only Internal Error Message ...<br><br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
When you export from excel the default separator (at least here in<br>
Spain is) ";" not "," so I need to replace then using text<br>
editor.<br>
</blockquote></blockquote>
<br></div>
I'm sure you can change the separator in the Excel Export, can't you?</blockquote><div> </div><div>I've got a Mac with Office 2011 and we can't do it directly from excel (as far as I know). Same thing with dot instead of semi colon. I need to change global<br>
system preferences to be able to use "." as decimal separator.<br><br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Afterthat if "zone" field we have description that include ","<br>
... So this "," create a conflict "," separator.<br>
</blockquote></blockquote>
<br></div>
Yes, that's what I said already, you need to replace these with<br>
something else. I'm thinking about switching to quo"ted fields in the<br>
next release, as this can be annoying sometimes.<div class="im"><br></div></blockquote><div> </div><div>Quoted fields would be nice. Or including better ... as in phpmyadmin you can choose separator and if fields are quoted or not. <br>
<br>As I told before I've prepare rate from excel. But some cells content is concatenated from others cells and it would cool to be able to ignore some columns.<br>Concretly I've got file with more thant 12 columns ! I think that a good way is to have first line with columns names. <br>
<br> <br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Moreover we have got lot destinations which contains "accents"<br>
and this generate error too.<br>
</blockquote></blockquote>
<br></div>
This shouldn't happen, if the source file is encoded in UTF-8 correctly.<div><div></div></div></blockquote><div><br>Yes ! I've just discovered this ... by default excel export as Windows Latin 1 ... LF/CF <br><br>
The easiest way I found is to export as UTF-8 text with tab separator and replace tab by "," (don't ask me whay Microsoft haven't got one option to choose separator and encoding on Mac ...)<br><br><br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div> </div></div></blockquote><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div><div class="h5">
<br>
br,<br>
daniel<br>
<br>
______________________________<u></u>_________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="http://lists.sipwise.com/listinfo/spce-user" target="_blank">http://lists.sipwise.com/<u></u>listinfo/spce-user</a><br>
</div></div></blockquote></div><br>