More issue importing rate ...<br><br>I've got lot of malformed issue but I can't solved it because OSS.log doesn't tell me on which line ...<br><br>-- OSS.log ---<br>Aug 5 18:12:05 sipwise provisioning: Sipwise::Provisioning::mydie: _check_bilprofee_data (called from set_billing_profile_fees): malformed offpeak_init_rate '<br>
---<br><br><br><br><br><div class="gmail_quote">2011/8/5 Sébastien Cramatte <span dir="ltr"><<a href="mailto:scramatte@gmail.com">scramatte@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi,<br><br>When you export from excel the default separator (at least here in Spain is) ";" not "," so I need to replace then using text editor. <br>Afterthat if "zone" field we have description that include "," ... So this "," create a conflict "," separator. <br>
Moreover we have got lot destinations which contains "accents" and this generate error too.<br>
<br><br>-- OSS.log ---<br>Failed to execute:#012INSERT INTO billing_zones#012 (billing_profile_id,zone,detail)#012 VALUES(?,?,?)#012 #012parameter: 1, Sudeste de Asia y Ocean?a, Australia#012DBI error:Incorrect string value: '\xEDa' for column 'zone' at row 1 at /usr/share/perl5/Sipwise/DB.pm line 117.<br>
Aug 5 17:57:03 sipwise oss: 95.17.212.39 - - [05/Aug/2011:17:56:46 +0200] "POST /billing/set_fees HTTP/1.1" 302 1910 "<a href="https://sipwise:1443/billing/search_fees?bilprof=default&use_session=1&offset=0" target="_blank">https://sipwise:1443/billing/search_fees?bilprof=default&use_session=1&offset=0</a>" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:5.0.1) Gecko/20100101 Firefox/5.0.1"<br>
<br>---<div><div></div><div class="h5"><br><br><div class="gmail_quote">2011/8/5 Daniel Tiefnig <span dir="ltr"><<a href="mailto:dtiefnig@sipwise.com" target="_blank">dtiefnig@sipwise.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 08/05/2011 02:29 PM, Sébastien Cramatte wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello,<br>
</blockquote>
<br>
Hi,<div><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I've created CSV file matching default SPCE fields as explained in<br>
manual.<br>
<br>
93;Asia central, sur y<br>
occidental;Afghanistan;0.1566;<u></u>1;0.1566;1;0.1566;1;0.1566;1;0<br>
</blockquote>
<br></div>
The fields need to be separated with commas, not semicolons. Also you<br>
may not use any commas within the fields. We'll update the doc for the<br>
next release to make it more clear.<br>
<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>
</blockquote></div><br>
</div></div></blockquote></div><br>