magnusbilling7 icon indicating copy to clipboard operation
magnusbilling7 copied to clipboard

Mass upload Prefixes/ProviderRates from CSV - ready CSV-2-SQL prefix/tariff converter (php)

Open Aminuxer opened this issue 2 years ago • 0 comments

Many ISP present prefixes/rates in CSV format like prefix;description;price

But current version of import/export rates subsystem rely to internal IDs of prefixes in magnus-DB and not comfortable for mass-management prefixes from many providers.

I make simple PHP-script which allow convert CSV-files from ISP to ready-to-upload SQL-dumps. It's first beta-version; Please test;

https://github.com/Aminuxer/Voipswitch-Additions/tree/master/MagnusBilling7

Main idea - select provider, csv-delimiter, upload ISP CSV to my php script and got ready to upload SQL-dumps.

Upload make in two pass - at first must be upload prefixes; At second step upload rates for prefixes for selected provider.

I release this script public; I hope this script will be useful for someone. If this feature will be added to main code - it will be nice.

Aminuxer avatar Dec 29 '22 11:12 Aminuxer