[Spce-user] Import Billing rate issue ...

[Sébastien Cramatte]

Hi,

When you export from excel the default separator (at least here in Spain is)
";" not "," so  I need  to replace  then using text editor.
Afterthat  if  "zone" field we have description that include  ","  ... So
this "," create a conflict   "," separator.
Moreover we have got lot destinations which contains  "accents"  and this
generate error too.


-- OSS.log ---
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.
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 "
https://sipwise:1443/billing/search_fees?bilprof=default&use_session=1&offset=0"
"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:5.0.1) Gecko/20100101
Firefox/5.0.1"

---

2011/8/5 Daniel Tiefnig <dtiefnig at sipwise.com>

> On 08/05/2011 02:29 PM, Sébastien Cramatte wrote:
>
>> Hello,
>>
>
> Hi,
>
>
>  I've created  CSV file matching default SPCE fields as explained in
>> manual.
>>
>> 93;Asia central, sur y
>> occidental;Afghanistan;0.1566;**1;0.1566;1;0.1566;1;0.1566;1;0
>>
>
> The fields need to be separated with commas, not semicolons. Also you
> may not use any commas within the fields. We'll update the doc for the
> next release to make it more clear.
>
> br,
> daniel
>
> ______________________________**_________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/**listinfo/spce-user<http://lists.sipwise.com/listinfo/spce-user>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20110805/e2d86164/attachment-0001.html>