[Spce-user] Adding Accounts and Subscriber through script or csv?

[Florian]

Hi Ivan,

your script works very well! Thank you!

I get some warnings, are these problems?
Use of uninitialized value $acid in concatenation (.) or string at 
/usr/share/perl5/Sipwise/Provisioning/Billing/DB.pm line 5453, <$data> 
line 1.
Use of uninitialized value $subscriber_id in concatenation (.) or string 
at /usr/share/perl5/Sipwise/Provisioning/Voip/DB.pm line 354, <$data> 
line 1.
Use of uninitialized value $acid in concatenation (.) or string at 
/usr/share/perl5/Sipwise/Provisioning/Billing/DB.pm line 5453, <$data> 
line 2.
Use of uninitialized value $subscriber_id in concatenation (.) or string 
at /usr/share/perl5/Sipwise/Provisioning/Voip/DB.pm line 354, <$data> 
line 2.

I attach the csv I used and I commented two options out from your script:
Line 132 and 133:
#                            fraud_limit_cash => $quota,
#                            no_nat_sipping => $no_nat_sipping,

I didn't find fraud_limit_cash in the preferences and I need NAT.

Florian

Am 15.09.2013 17:30, schrieb Ivan Milivojevic:
> Hi Flo,
>
> The scipt is using sipwise soap api, to be more precise 
> 'ngcp-create_voip_account' script + parameters from csv:
>
> my $account_new = $o->handle_request('create_voip_account',
>                                {
>                                  authentication => {
> ...
>
> You need to execute the scipt directly from the spce server, just 
> adjust username and pass for authentication.
>
> Regards,
> Ivan
>
>
> On Sun, Sep 15, 2013 at 4:33 PM, Florian <florian at acw.at 
> <mailto:florian at acw.at>> wrote:
>
>     Hello Ivan,
>
>     great! Thank you!
>
>     I have some questions and it would be great, if you can answer them?
>
>     Is this script using the soap api or directly the perl scripts
>     from the spce installation? I didn't find any place to insert the
>     soap api IP, user and password.
>     Do I have to execute the script directly on the spce server?
>
>     Do you have for every number always the length for ac?
>     Unfortunately, in Austria they have different lengths, but I
>     think, I can change the script for that.
>
>     I will try the script on the testserver on Monday! I am very
>     curious on that script!
>
>     Florian
>
>     Am 13.09.2013 15:58, schrieb Ivan Milivojevic:
>
>         Hi all,,
>
>         Here is mine
>
>         :)
>
>         #csv template, adjust your needs and comment unnecessary fields
>         external_id,user,domain,pass,web-user,web-pass,primary_number,,,billing-profile,quota,no_nat_sipping
>
>         Dont forget to adjust
>
>         authentication => {
>                                type     => 'admin',
>                                username => '<change_this>',
>                                password => '<change_this>',
>
>
>         #calling
>         create_subscribers_from_csv <CSV>
>
>         Regards,
>         Ivan
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130916/a3a68f12/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: user_import_test.csv
Type: application/vnd.ms-excel
Size: 196 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130916/a3a68f12/attachment-0001.csv>