<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi Ivan,<br>
<br>
your script works very well! Thank you!<br>
<br>
I get some warnings, are these problems?<br>
Use of uninitialized value $acid in concatenation (.) or string at
/usr/share/perl5/Sipwise/Provisioning/Billing/DB.pm line 5453,
<$data> line 1.<br>
Use of uninitialized value $subscriber_id in concatenation (.) or
string at /usr/share/perl5/Sipwise/Provisioning/Voip/DB.pm line
354, <$data> line 1.<br>
Use of uninitialized value $acid in concatenation (.) or string at
/usr/share/perl5/Sipwise/Provisioning/Billing/DB.pm line 5453,
<$data> line 2.<br>
Use of uninitialized value $subscriber_id in concatenation (.) or
string at /usr/share/perl5/Sipwise/Provisioning/Voip/DB.pm line
354, <$data> line 2.<br>
<br>
I attach the csv I used and I commented two options out from your
script:<br>
Line 132 and 133:<br>
# fraud_limit_cash => $quota,<br>
# no_nat_sipping => $no_nat_sipping,<br>
<br>
I didn't find fraud_limit_cash in the preferences and I need NAT.<br>
<br>
Florian<br>
<br>
Am 15.09.2013 17:30, schrieb Ivan Milivojevic:<br>
</div>
<blockquote
cite="mid:CAOGEezb34kes1LJxztPPGkRHPnX-epcp+hFq3tAC=3fz1Pec2Q@mail.gmail.com"
type="cite">
<div dir="ltr">Hi Flo,
<div><br>
</div>
<div>The scipt is using sipwise soap api, to be more precise
'ngcp-create_voip_account' script + parameters from csv:</div>
<div><br>
</div>
<div>
<div>my $account_new =
$o->handle_request('create_voip_account',</div>
<div> {</div>
<div> authentication => {</div>
</div>
<div>...</div>
<div><br>
</div>
<div>You need to execute the scipt directly from the spce
server, just adjust username and pass for authentication.</div>
<div><br>
</div>
<div>Regards,</div>
<div>Ivan</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Sun, Sep 15, 2013 at 4:33 PM,
Florian <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:florian@acw.at" target="_blank">florian@acw.at</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hello
Ivan,<br>
<br>
great! Thank you!<br>
<br>
I have some questions and it would be great, if you can
answer them?<br>
<br>
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.<br>
Do I have to execute the script directly on the spce server?<br>
<br>
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.<br>
<br>
I will try the script on the testserver on Monday! I am very
curious on that script!<br>
<br>
Florian<br>
<br>
Am 13.09.2013 15:58, schrieb Ivan Milivojevic:
<div class="HOEnZb">
<div class="h5"><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi all,,<br>
<br>
Here is mine<br>
<br>
:)<br>
<br>
#csv template, adjust your needs and comment
unnecessary fields<br>
external_id,user,domain,pass,web-user,web-pass,primary_number,,,billing-profile,quota,no_nat_sipping<br>
<br>
Dont forget to adjust<br>
<br>
authentication => {<br>
type => 'admin',<br>
username =>
'<change_this>',<br>
password =>
'<change_this>',<br>
<br>
<br>
#calling<br>
create_subscribers_from_csv <CSV><br>
<br>
Regards,<br>
Ivan<br>
<br>
</blockquote>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>