[Spce-user] fees CSV file import

Mon Mar 31 09:37:37 EDT 2014

Hi!

Sample that works:

.,^27.+$,out,South Africa,South Africa - Fixed,0.10363333,1,0.10363333,1,0.10363333,1,0.10363333,1,0

Direction is  out, not outbound.

And missing source (i.E.: .) at beginning.

regards

mit freundlichen Grüßen
best regards
Martin Stix
CEO
pluteus communication solutions
ms at pluteus.at<mailto:ms at pluteus.at>
www.pluteus.at
Dampfsägestraße 17
3300 Amstetten
Austria
tel.: +43 7472 28165 20
fax.: +43 7472 28165 22

Von: gerry kernan [mailto:gerry.kernan at infinityit.ie]
Gesendet: Montag, 31. März 2014 15:32
An: spce-user at lists.sipwise.com
Betreff: [Spce-user] fees CSV file import

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
[logo]<http://www.infinityit.ie/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140331/4624dbe4/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 16016 bytes
Desc: image001.jpg
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140331/4624dbe4/attachment-0001.jpg>