[Spce-user] Error in Upload Fees as CSV in 3.8.3

[Marco Teixeira]

Guys, time to give back...
The problem was UTF8 BOM (https://en.wikipedia.org/wiki/Byte_order_mark)
That puts an HEX code at the beggining of the file, that messes things up.
If saved in UTF-8 without BOM everything is fine!

Daniel,
another one for the roadmap? - Check and remove BOM from UTF8 encoded
CSV...

Thank you
Marco

On Wed, Sep 23, 2015 at 12:20 PM, Marco Teixeira <admin at marcoteixeira.com>
wrote:

> Hello Daniel,
>
> I already had found your sample file somewhere in this list. I based my
> file on it... The only thing i changed is the pattern. I'm using "^351".
> Fromk ehat i can see of the error, it doesn't even parse the first line.
> I also tried the file in UNIX and DOS format (because of LineBreaks)
> Always same result...
>
>
> MSG="Failed to upload Billing Fees (DBIx::Class::Schema::txn_do(): Some
> lines could not be parsed. Did not reach eof. Last successful: 0. at
> /usr/share/perl5/NGCP/Panel/Controller/Billing.pm line 467. at
> /usr/share/perl5/Catalyst/Model/DBIC/Schema.pm line 501#012)" LOG=""
>
>
> ---
> Cumprimentos / Best regards
> Marco
>
> On Wed, Sep 23, 2015 at 10:15 AM, Daniel Grotti <dgrotti at sipwise.com>
> wrote:
>
>> Hi Marco,
>> the one in attach should be the right format.
>> Please check it out.
>>
>>
>> --
>> Daniel Grotti
>> VoIP Engineer
>>
>>
>> Sipwise GmbH
>> Europaring F15 | 2345 Brunn am Gebirge, Austria | www.sipwise.com
>>
>> On 09/23/2015 10:12 AM, Marco Teixeira wrote:
>> > Hello list,
>> >
>> > Anyone managed to import Fees as CSV in LTS 3.8.3 ?
>> > Always getting this in panel.log:
>> >
>> > ngcp-panel: ERROR: IP=X.X.X.X CALLED=Controller::Billing::fees_upload
>> > TX=14068C5A8908C020 USER=admin DATA={ 'save' => 'Upload', 'submitid' =>
>> > '', 'upload_fees' => 'CSV.txt'} MSG="Failed to upload Billing Fees
>> > (DBIx::Class::Schema::txn_do(): Some lines could not be parsed. Did not
>> > reach eof. Last successful: 0. at
>> > /usr/share/perl5/NGCP/Panel/Controller/Billing.pm line 467. at
>> > /usr/share/perl5/Catalyst/Model/DBIC/Schema.pm line 501#012)" LOG=""
>> >
>> > Did not touch fees field order in config.yml:
>> >   fees_csv:
>> >     element_order:
>> >       - source
>> >       - destination
>> >       - direction
>> >       - zone
>> >       - zone_detail
>> >       - onpeak_init_rate
>> >       - onpeak_init_interval
>> >       - onpeak_follow_rate
>> >       - onpeak_follow_interval
>> >       - offpeak_init_rate
>> >       - offpeak_init_interval
>> >       - offpeak_follow_rate
>> >       - offpeak_follow_interval
>> >       - use_free_time
>> >
>> > My CSV.txt is like this (edited in notepad++ in UTF8 in UNIX format):
>> > ".","\.local$",out,"local","local services",0,1,0,1,0,1,0,1,0
>> > ".","^3512",out,"PT","Portugal Fixed",0.1,1,0.1,1,0.1,1,0.1,1,0
>> >
>> > By looking at the code, it line that errors out points to a cycle for
>> > working billing zones... (i already have them created)
>> >
>> > Any clues ?
>> >
>> > ---
>> > Best regards
>> > Marco
>> > ---
>> >
>> >
>> >
>> > _______________________________________________
>> > Spce-user mailing list
>> > Spce-user at lists.sipwise.com
>> > https://lists.sipwise.com/listinfo/spce-user
>> >
>>
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://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/20150923/1d53c6e3/attachment-0001.html>