Update Termination and Origination rates

[Ibbi]

Hello,

What is the best way to upload new rates into the system. If it requires the table manipulation on database end please explain it in details for termination and origination rates as well.

I have old rates uploaded in termination rates and deleting those rates through web page is really hectic and time consuming.

ASTPP version 2.3

[Samir Doshi]

If you have an idea about database queries then build query to delete the records from database directly. That will be quicker in 2.3. 

In version 3.0, to avoid this problem we have implemented batch delete features which makes life easier. 

Best Regards
--
Samir Doshi
iNextrix Technologies Pvt. Ltd.
http://www.inextrix.com

Disclaimer:
The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful.

--
=====================================================================
Documentation : https://astppdoc.atlassian.net/
Please contact at sa...@inextrix.com for commercial support.
---
You received this message because you are subscribed to the Google Groups "ASTPP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to astpp+unsubscribe@googlegroups.com.
To post to this group, send email to as...@googlegroups.com.
Visit this group at https://groups.google.com/group/astpp.
To view this discussion on the web visit https://groups.google.com/d/msgid/astpp/88f27111-5484-4d2c-8bee-86f0b4b59daf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ibbi]

Thank you for your response. Can please explain me which table i should edit? 

On Monday, October 24, 2016 at 10:38:33 PM UTC+5, Samir Doshi wrote:

If you have an idea about database queries then build query to delete the records from database directly. That will be quicker in 2.3. 

In version 3.0, to avoid this problem we have implemented batch delete features which makes life easier. 

Best Regards
--
Samir Doshi
iNextrix Technologies Pvt. Ltd.
http://www.inextrix.com

Disclaimer:
The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful.

On Mon, Oct 24, 2016 at 7:26 PM, Ibbi <ibrah...@gmail.com> wrote:

Hello,

What is the best way to upload new rates into the system. If it requires the table manipulation on database end please explain it in details for termination and origination rates as well.

I have old rates uploaded in termination rates and deleting those rates through web page is really hectic and time consuming.

ASTPP version 2.3

--
=====================================================================
Documentation : https://astppdoc.atlassian.net/
Please contact at sa...@inextrix.com for commercial support.
---
You received this message because you are subscribed to the Google Groups "ASTPP" group.

To unsubscribe from this group and stop receiving emails from it, send an email to astpp+un...@googlegroups.com.

[Niklas]

you have to insert or update the trunk rates -> table: outbound_routes and after that you have to pick the lowest rate for each prefix and insert or update it on table: routes

If you like, i can give you my solution