[Spce-user] Admin Block List

[Andrew Pogrebennyk]

You are welcome, I noticed a typo in my response:
the database location is the voip_usr_preferences in provisioning DB
the attribute dictionary is in the voip_preferences table in same DB.

Hope this helps.
Andrew

On 03/06/2015 11:46 AM, Paul Hughes Callhosts.com wrote:
> Many thanks Andrew.
> 
> Great response  Thanks for the right direction ...
> 
> Paul
> 
> -----Original Message-----
> From: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] On Behalf Of
> Andrew Pogrebennyk
> Sent: 06 March 2015 09:43
> To: paul at dinasbuild.co.uk; spce-user at lists.sipwise.com
> Subject: Re: [Spce-user] Admin Block List
> 
> Paul,
> the database location is the voip.usr_preferences like with all other user
> preferences:
> 
> mysql> select * from voip_usr_preferences where attribute_id in (select
> id from voip_preferences where attribute in
> ('block_in_list','block_out_list'));
> +------+---------------+--------------+-------+---------------------+
> | id   | subscriber_id | attribute_id | value | modify_timestamp    |
> +------+---------------+--------------+-------+---------------------+
> | 1223 |            29 |            3 | 123   | 2015-03-06 10:39:35 |
> | 1225 |            29 |            3 | 456   | 2015-03-06 10:39:38 |
> | 1227 |            29 |            3 | 789   | 2015-03-06 10:39:41 |
> +------+---------------+--------------+-------+---------------------+
> 3 rows in set (0.00 sec)
> 
> But if you ask me about the right direction, the right way would be to
> import the lists using the REST* or SOAP API.. This would be quite easy.
> 
> [*] https://www.sipwise.com/doc/mr3.7.1/spce/ar01s10.html#_rest_api
> 
> Regards,
> Andrew
> 
> On 03/04/2015 04:18 PM, Paul Hughes wrote:
>> Hi everyone,
>>
>> I wonder if anyone can point me in to the right direction.
>>
>> What i am looking for is a way to do a direct upload to the databae 
>> for the admin blocked numbers list as in the interface there is only 
>> option to add a nuber one by one.
>>
>> does anyone know the database location for the admin block list so 
>> that i can do a direct import of the numbers or a way to remote in to 
>> the database using a gui like phpmyadmin.
>>
>> has anyone installed phpmyadmin on the server at all ? as gui can be 
>> handy for such instances?
>>
>> perhaps in the admin lock list section there would be an improvement 
>> in next version to upload csv like in the billing section ??
>>
>> Regards Paul
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>