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

[Sébastien Cramatte]

More issue importing rate ...

I've got lot of malformed issue but I can't solved it because OSS.log
doesn't tell me on which line ...

-- OSS.log ---
Aug  5 18:12:05 sipwise provisioning: Sipwise::Provisioning::mydie:
_check_bilprofee_data (called from set_billing_profile_fees): malformed
offpeak_init_rate '
---




2011/8/5 Sébastien Cramatte <scramatte at gmail.com>

> 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/a42c32b2/attachment-0001.html>