how to delete all the rates??

medulin · **Joined:** Fri Jan 23, 2009 10:43 am **Posts:** 28

Hi all,
I did an error creating rates (inserting prefix interval). So now, I have more than 1500 rates created.
I need to delete all this rates.
I tryed to use phpmyadmin but I don't know hot to search cc_ratecard database (in cc_ratecard the rates and prefix are stored).
How can I delete all the database? Deleting one by one takes too many time!

I attached the screenshot of phpmyadmin first page.

@stavros: I sent you a pm, I don't know you received it

stavros · **Posted:** Tue Mar 03, 2009 3:20 pm

Quote:

@stavros: I sent you a pm, I don't know you received it

Yes, please refrain in future; I've never used phpmyadmin and this isn't the place to ask for help with using it.

medulin wrote:

I need to delete all this rates.

You can do this from within the A2B interface. Use 'Batch Update'.

medulin · **Joined:** Fri Jan 23, 2009 10:43 am **Posts:** 28

stavros wrote:

medulin wrote:

I need to delete all this rates.

You can do this from within the A2B interface. Use 'Batch Update'.

Sorry but I dont understand how to use it...
I have the list with the rates; then I select "BATCH UPDATE"; I select ratecard (option 2); I select BATCH UPDATE RATECARD;message appears: Could not perform the batch update!

can you explain me how to delete all rates using "batch update"?

Thanks

stavros · **Posted:** Tue Mar 03, 2009 6:56 pm

Sorry, I was mis-remembering the interface. You need to use 'Search rates' not 'Batch update'. After your first search an option to 'delete all' will appear.

medulin · **Joined:** Fri Jan 23, 2009 10:43 am **Posts:** 28

stavros wrote:

Sorry, I was mis-remembering the interface. You need to use 'Search rates' not 'Batch update'. After your first search an option to 'delete all' will appear.

perfect! thank you Stavros!!

shimond · **Joined:** Tue Nov 29, 2011 11:38 pm **Posts:** 2

I created 10000 rates by mistake.
I need to delete them but my version of a2billing will not prompt to delete after making a "Search rates"
can anyone help?
i am using Asterisk2Billing - Version 1.3.4 (SeamRóg) - Release : 1 Oct 2008
Thanks
Shimon

jroper · **Joined:** Fri Jun 23, 2006 3:56 pm **Posts:** 4065

Hi

Sometimes, its easier to delete the rate table, which will delete all associated rates as well.

Joe

shimond · **Joined:** Tue Nov 29, 2011 11:38 pm **Posts:** 2

Thanks,
but I found the answer myself.
The "delete all" button is hidden inside the "Search rates" box
thanks everyone
Shimon

provided by Star2Billing S.L.

how to delete all the rates??

Who is online