[Spce-user] fees CSV file import

Mon Mar 31 09:32:17 EDT 2014

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

The csv elements of config.yml is 

fees_csv:
    element_order:
      - destination
      - direction
      - zone
      - 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

And start of csv file is as below.

 353112
 outbound
 112 Emergency Services
 325
 1
  1
 325
 1

 1

 3531193
 outbound
 1193 Eirpac Access

 0.0267
 1

 0.0167
 1

 3531195
 outbound
 1195 Eirpac Access

 0.0267
 1

 0.0167
 1

 3531511
 outbound
 1511 Eirpac Access

 0.0467
 1

 0.035
 1

 3531512
 outbound
 1512 Premium Rate Service
 21
 1

 1
 21
 1

 1

 3531513
 outbound
 1513 Premium Rate Service
 52
 1

 1
 52
 1

 1

 3531514
 outbound
 1514 Premium Rate Service
 65
 1

 1
 65
 1

 1

 3531515
 outbound
 1515 Premium Rate Service
 87
 1

 1
 87
 1

 1

 3531516
 outbound
 1516 Premium Rate Service
 132
 1

 1
 132
 1

 1

 3531517
 outbound
 1517 Premium Rate Service
 176
 1

 1
 176
 1

 1

 3531518
 outbound
 1518 Premium Rate Service
 265
 1

 1
 265
 1

 1

 3531520
 outbound
 1520 Premium Rate Service

 0.2333
 1

 0.2333
 1

 3531530
 outbound
 1530 Premium Rate Service

 0.5
 1

 0.5
 1

 3531540
 outbound
 1540 Premium Rate Service

 1.1667
 1

 1.1667
 1

 3531550
 outbound
 1550 Premium Rate Service

 1.4333
 1

 1.4333
 1

 3531560
 outbound
 1560 Premium Rate Service

 1.8833
 1

 1.8833
 1

 3531570
 outbound
 1570 Premium Rate Service

 2.6
 1

 2.6
 1

 3531580
 outbound
 1580 Premium Rate Service

 3.55
 1

 3.55
 1

 3531590
 outbound
 1590 Premium Rate Service

 4.3333
 1

 4.3333
 1

 3531598
 outbound
 1598 Premium Rate Service

 3
 1

 3
 1

 3531599
 outbound
 1599 Premium Rate Service

 4.5
 1

 4.5
 1

 3531891
 outbound
 1891 Internet Access

 0.0433
 1

 0.0433
 1

 3531892
 outbound
 1892 Internet Access

 0.1
 1

 0.05
 1

 353999
 outbound
 999 Emergency Services
 325
 1

 1
 325
 1

 1

 3531850
 outbound
 CallSave 1850
 4
 1

 1
 6
 1

 1

 35311860
 outbound
 Conduit Dir Enquiries Int'l
 250
 1
 4.1667
 1
 250
 1
 4.1667
 1

 35311850
 outbound
 Conduit Dir Enquiries Ireland
 200
 1
 3.3333
 1
 200
 1
 3.3333
 1

 35311888
 outbound
 Conduit Dir Enquiries

 1
 1

 1
 1

 35311818
 outbound
 EirCom Dir Enquiries  Int'l
 130.98
 1
 0.9105
 1
 130.98
 1
 0.9105
 1

 3531191
 outbound
 EirCom Dir Enquiries  Int'l
 161.79
 1
 0.9078
 1
 161.79
 1
 0.9078
 1

 35311811
 outbound
 EirCom Dir Enquiries  Ireland
 130
 1
 1.374
 1
 130
 1
 1.374
 1

 35311890
 outbound
 Numbers Direct DQ (11890)
 100
 1
 4.1667
 1
 100
 1
 4.1667
 1

 353700
 outbound
 Eircom Personal Numbering

 0.1667
 1

 0.1167
 1

 3531902
 outbound
 Eircom Repairs

 0.0167
 1

 0.0083
 1

 3531901
 outbound
 Eircom Serviceplus

 0.0167
 1

 0.0083
 1

 3531191
 outbound
 Eircom Speaking Clock

 0.4333
 1

 0.4
 1

 353818
 outbound
 Eircom Universal Access

 0.1167
 1

 0.0667
 1

 3531800
 outbound
 FreePhone 1800

 1

 1

 3530800
 outbound
 International Freephone 00800

 1

 1

  outbound
 Local

 0.0017
 1

 0.0017
 1

 3531890
 outbound
 LoCall 1890

 0.1
 1

 0.0333
 1

 3531905
 outbound
 Meteor Customer Services

 0.0167
 1

 0.0083
 1

 35383
 outbound
 Mobile 083

 0.1
 1

 0.1
 1

 35385
 outbound
 Mobile 085

 0.1167
 1

 0.0667
 1

 35386
 outbound
 Mobile 086

 0.1
 1

 0.1
 1

 35387
 outbound
 Mobile 087

 0.1
 1

 0.1
 1

 35389
 outbound
 Mobile 089

 0.1
 1

 0.1
 1

 353
 outbound
 National

 0.0017
 1

 0.0017
 1

 35382
 outbound
 National Pager

 0.3333
 1

 0.25
 1

 35348
 outbound
 NationalNorthern Ireland

 0.015
 1

 0.01
 1

 3531909
 outbound
 O2 Customer Care

 0.0167
 1

 0.0083
 1

 3538
 outbound
 Other Mobile

 0.1
 1

 0.1
 1

  outbound
 Short Codes 190; 191

 0.0167
 1

 0.0083
 1

 3.53E+10
 outbound
 Special IP Dial

 0.1167
 1

 0.05
 1

 3.53E+10
 outbound
 Special IP Dial

 0.1167
 1

 0.05
 1

 3.54E+11
 outbound
 Special IP Dial

 0.1167
 1

 0.05
 1

 35376
 outbound
 VoIP Dialup

 0.1167
 1

 0.0667
 1

 93
 outbound
 Afghanistan

 0.7778
 1

 0.7778
 1

 9370
 outbound
 AfghanistanMobile

 0.7778
 1

 0.7778
 1

 9377
 outbound
 AfghanistanMobileAreeba

 0.7778
 1

 0.7778
 1

 9378
 outbound
 AfghanistanMobileEtisalat

 0.7778
 1

 0.7778
 1

 9379
 outbound
 AfghanistanMobileRoshan

 0.7778
 1

 0.7778
 1

 355
 outbound
 Albania

 0.25
 1

 0.25
 1

 35567
 outbound
 AlbaniaMobile

 0.6944
 1

 0.6944
 1

 35568
 outbound
 AlbaniaMobileAMC

 0.6944
 1

 0.6944
 1

 35569
 outbound
 AlbaniaMobileVodafone

 0.6944
 1

 0.6944
 1

 3554
 outbound
 AlbaniaTirana

 0.25
 1

 0.25
 1

 213
 outbound
 Algeria

 0.2222
 1

 0.2222
 1

 21365
 outbound
 AlgeriaMobile

 0.8333
 1

 0.8333
 1

 21377
 outbound
 AlgeriaMobileOrascom

 1.1111
 1

 1.1111
 1

Best Regards,

Gerry Kernan
InfinityIT

Suite 17 The Mall | Beacon Court | Sandyford | Dublin 18
p: +35312930090 | f: +35312930137 | m: +353861709790
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20140331/a4450502/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 16016 bytes
Desc: not available
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20140331/a4450502/attachment.jpg>