[Spce-user] fees CSV file import

[gerry kernan]

Hi Andrew

Thanks, will do, it is getting past the direction field now, I'll fix the other fields.

Gerry


-----Original Message-----
From: Andrew Pogrebennyk [mailto:apogrebennyk at sipwise.com] 
Sent: 31 March 2014 14:46
To: gerry kernan
Cc: Spce-user
Subject: Re: [Spce-user] fees CSV file import

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*