[Spce-user] fees CSV file import

[Andrew Pogrebennyk]

Gerry,
additionally please double check your csv file, e.g. I see value '-' in
onpeak_init_rate and use_free_time and I don't think that it works.

BR,
Andrew

On 03/31/2014 03:32 PM, gerry kernan wrote:
> Hi
> 
> I’m trying to import a fees csv file but I’m getting the error below in
> the oss.log, would anyone be able to point out what I’m doing wrong.
> 
> sipwise /usr/share/ngcp-panel/ngcp_panel_*fastcgi.pl: failed to upload
> csv: DBIx::Class::ResultSet::create(): DBI Exception: DBD::mysql::st
> execute failed: Data truncated for column 'direction' at row 1 [for
> Statement "INSERT INTO `billing`.`billing_fees` ( `billing_profile_id`,
> `billing_zone_id`, `destination`, `direction`,
> `offpeak_follow_interval`, `offpeak_follow_rate`,
> `offpeak_init_interval`, `offpeak_init_rate`, `onpeak_follow_interval`,
> `onpeak_follow_rate`, `onpeak_init_interval`, `onpeak_init_rate`,
> `use_free_time`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with
> ParamValues: 0='1', 1='8', 2='353112', 3='outbound', 4='1', 5='-',
> 6='1', 7='325', 8='1', 9='', 10='1', 11='325', 12='-'] at
> /usr/share/perl5/NGCP/Panel/Controller/Billing.pm line 394*