Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Tue Apr 16, 2024 7:08 am
Predictive Dialer


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Importing Rates
PostPosted: Wed Sep 30, 2009 1:31 pm 
Offline

Joined: Wed Sep 30, 2009 8:58 am
Posts: 49
Hey Everyone,

I'm trying to Import rates into our A2B 1.4.2, and I get an strange error:

I tried both .txt and .csv, the import function, reads the file good, shows the first line of the records good, but when press the last-step Import button, i get an strange error saying 0 record was imported, and it shows all my records as the lines which were not imported, below is exactly what i get:

"Success, 0 new rates have been imported.


Line that has not been inserted!"
and then below that error is shows all my rates.

And here is the format I'm using, with the correct additional fields selected for importing:

93;Afghanistan;XX;XX;60;1;60;1
9370;Afghanistan Mobile;XX;XX;60;1;60;1
9375;Afghanistan Mobile;XX;XX;60;1;60;1
9377;Afghanistan Mobile;XX;XX;60;1;60;1
9378;Afghanistan Mobile;XX;XX;60;1;60;1
9379;Afghanistan Mobile;XX;XX;60;1;60;1

Attached, is also the screen shot.


Attachments:
File comment: Step 2 (nothing imported)
Picture 2.png
Picture 2.png [ 19.08 KiB | Viewed 2419 times ]
File comment: Step 1 (showing sample compiled first line record)
Picture-1.jpg
Picture-1.jpg [ 19.78 KiB | Viewed 2420 times ]
Top
 Profile  
 
 Post subject: Re: Importing Rates
PostPosted: Wed Sep 30, 2009 2:25 pm 
Offline

Joined: Wed Sep 30, 2009 8:58 am
Posts: 49
OK, here is what solved the issue:

Adding phpmyAdmin for MySQL, fixed the broken privileges, specially when I went to privildges in phpmyAdmin, and the was no user, and was saying run script mysql_fix_privileges_,.... to have the users shown, as soon as that was done, the importing started working.


Before that I wasn't even able to add rates individually, so now it's all good.

Ali.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
Predictive Dialer


All times are UTC


Who is online

Users browsing this forum: No registered users and 4 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