Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 8:43 pm
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: No tariffplan defined !
PostPosted: Tue Dec 11, 2007 8:35 am 
Offline

Joined: Sun Feb 25, 2007 3:10 am
Posts: 190
Location: Philadelphia, PA
I am having problems importing rates. I get the error No tariffplan defined ! Even though it deifined. Here is a sample of cvs file.

93 Afghanistan 0.20964 0.13847 0.262054475 VoiceTrading
9370 Afghanistan Mobile 0.21638 0.14292 0.2704761 VoiceTrading
9375 Afghanistan Mobile 0.21638 0.14292 0.2704761 VoiceTrading
9377 Afghanistan Mobile 0.21638 0.14292 0.2704761 VoiceTrading
9378 Afghanistan Mobile 0.21638 0.14292 0.2704761 VoiceTrading
9379 Afghanistan Mobile 0.21638 0.14292 0.2704761 VoiceTrading
355 Albania 0.04877 0.03221 0.060957425 VoiceTrading
35567 Albania Mobile 0.21803 0.14401 0.272538925 VoiceTrading
35568 Albania Mobile 0.21803 0.14401 0.272538925 VoiceTrading
35569 Albania Mobile 0.21803 0.14401 0.272538925 VoiceTrading
213 Algeria 0.13051 0.0862 0.1631335 VoiceTrading
2131 Algeria Mobile 0.14121 0.09327 0.176513475 VoiceTrading
2135 Algeria Mobile 0.14121 0.09327 0.176513475 VoiceTrading
2136 Algeria Mobile 0.14121 0.09327 0.176513475 VoiceTrading
2137 Algeria Mobile 0.14121 0.09327 0.176513475 VoiceTrading
2139 Algeria Mobile 0.14121 0.09327 0.176513475 VoiceTrading
1684 American Samoa 0.05111 0.03376 0.0638908 VoiceTrading
684 American Samoa 0.05111 0.03376 0.0638908 VoiceTrading
1684733 American Samoa Mobile 0.05163 0.0341 0.06453425 VoiceTrading
376 Andorra 0.02374 0.01568 0.0296744 VoiceTrading
3763 Andorra Mobile 0.23055 0.15228 0.2881899 VoiceTrading


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 11, 2007 10:40 am 
Offline

Joined: Sun Jun 25, 2006 9:13 am
Posts: 183
Location: Germany
Hello

make sure u have choose the ratecard to import and trunk. also u should not have VoiceTrading in your csv


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 11, 2007 11:52 am 
Offline

Joined: Sun Feb 25, 2007 3:10 am
Posts: 190
Location: Philadelphia, PA
I went ahead a little bit. It will not accept the cvs file so I used a txt file but th output is not right and will redo it. It has all the fields on the dialprefix line. Thanks.

The first line of your import is previewed below, please check to ensure that every is correct.
FIELD VALUE
IDTARIFFPLAN (KEY) CompanyName_int (1)
OUTBOUND TRUNK VoiceTrading (7)
DIALPREFIX 93 afghanistan 0.20964 0.13847 0.262054475
DESTINATION COUNTRY
RATE INITIAL
TIMECHARGEA


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 11, 2007 12:07 pm 
Offline

Joined: Sun Jun 25, 2006 9:13 am
Posts: 183
Location: Germany
Fields have to separated by ; or :
loks your have use tab/space


Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 15, 2007 10:01 am 
Offline

Joined: Sun Feb 25, 2007 3:10 am
Posts: 190
Location: Philadelphia, PA
I finally figured it out thanks all.

For window users if you don’t see the file extension .CSV (Windows has this option disabled by default) then follow this step to enable the file extension – Select the menu “Tools”/”Folder Options” then select the “View” tab, uncheck the item “Hide extensions for known file types” as the picture below:

Then right click and rename with a .txt and do a find/replace , to ;. That worked fine.

My only problem is I uploaded the rate table 5 times thinking it replaced the old but instead it added to it.

I am using LCR so I should be fine. Thanks again.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 15, 2007 11:40 am 
Offline

Joined: Fri Apr 28, 2006 5:11 am
Posts: 426
broadbandvoice wrote:
My only problem is I uploaded the rate table 5 times thinking it replaced the old but instead it added to it.

Actualy this is BUG. i got it before too.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 15, 2007 10:53 pm 
Offline

Joined: Sun Jun 25, 2006 9:13 am
Posts: 183
Location: Germany
It's better to use openoffice


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 
Voice Broadcast System


All times are UTC


Who is online

Users browsing this forum: No registered users and 10 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group