[Spce-user] CSV Upload problem

Sergey Kharlamov mentax at bk.ru
Mon Dec 2 11:46:20 EST 2013


 So, I'm not really quite sure, what the difference?
What is +$? is the quotes must be there and it will fix a problem?

How should look this example:

.,^01120,out, Egypt,,0.0029953,60,0.0029953,60,0.0029953,60,0.0029953,60,0


where 0.0029953 = cost per second 

that csv creating some entries, you can see it on a screenshot 

So, i'm not really sure what what's wrong in my entry 



>Hi,
>the format is wrong.
>Please have a look at these example wit the right format:
>
>
>".","^1",out,"EU","ZONE EU",5.37,60,5.37,60,5.37,60,5.37,60,0,0
>
>"^01.+$","^02145.+$",out,"Regional","NÖ-Prellenkirchen",0.06250,1,0.06250,1,0.01733,1,0.01733,1,0
>
>
>Daniel
>
>
>
>
>On 12/02/2013 05:23 PM, Sergey Kharlamov wrote:
>> Here is part of CSV file:
>> 
>> .,^0112119,out, South Sudan (Mobile
>> A),,0.010257555,60,0.010257555,60,0.010257555,60,0.010257555,60,0
>> .,^01121191,out, South Sudan (Mobile B)
>> Mobitel,,0.010257555,60,0.010257555,60,0.010257555,60,0.010257555,60,0
>> .,^01121192,out, South Sudan (Mobile C)
>> MTN,,0.010257555,60,0.010257555,60,0.010257555,60,0.010257555,60,0
>> .,^01121195,out, South Sudan (Mobile D)
>> Vivacel,,0.010257555,60,0.010257555,60,0.010257555,60,0.010257555,60,0
>> .,^01121197,out, South Sudan (Mobile E)
>> Gemtel,,0.010257555,60,0.010257555,60,0.010257555,60,0.010257555,60,0
>> .,^01121199,out, South Sudan (Mobile C)
>> MTN,,0.010257555,60,0.010257555,60,0.010257555,60,0.010257555,60,0
>> .,^011212,out,
>> Morocco,,0.000679735,60,0.000679735,60,0.000679735,60,0.000679735,60,0
>> .,^011212520,out, Morocco (Mobile A)
>> Meditel,,0.003696,60,0.003696,60,0.003696,60,0.003696,60,0
>> .,^011212521,out, Morocco (Mobile A)
>> Meditel,,0.003696,60,0.003696,60,0.003696,60,0.003696,60,0
>> .,^011212522,out,
>> Morocco,,0.00059675,60,0.00059675,60,0.00059675,60,0.00059675,60,0
>> .,^011212525,out, Morocco (Mobile A)
>> Meditel,,0.003696,60,0.003696,60,0.003696,60,0.003696,60,0
>> 
>> 
>> 
>> 
>>     Hi,
>>     How your entries look like ?
>>     Do you have a couple of example ?
>> 
>>     Daniel
>> 
>> 
>>     On 12/02/2013 04:41 PM, Sergey Kharlamov wrote:
>>     > I'm trying to upload fees for new billing, csv was contained about
>>     5 000
>>     > entries. web server return me
>>     >
>>     > 504 Gateway Time-out nginx.
>>     > Now I can't open administrator web interface, I see 504 error.
>>     >
>>     > [error] 4171#0: *66720 upstream timed out (110: Connection timed out)
>>     > while reading response header from upstream, client: 201.229.220.67,
>>     > server: , request: "GET / HTTP/1.1", upstream:
>>     > "fastcgi://unix:/var/run/fastcgi/ngcp-panel.sock:", host:
>>     > "webhost_name:1443"
>>     >
>>     > [error] 3092#0: *17482 upstream timed out (110: Connection timed out)
>>     > while reading response header from upstream, client: 74.73.92.236,
>>     > server: , request: "POST /billing/2/fees/upload HTTP/1.1", upstream:
>>     > "fastcgi://unix:/var/run/fastcgi/ngcp-panel.sock:", host:
>>     > "webhost_name:1443", referrer:
>>     >
>>     "https://webhost_name:1443/billing/2/fees/upload?back=https%3A%2F%2Fwebhost_name%3A1443%2Fbilling%2F2%2Ffees"
>>     >
>>     > Can someone help with that?
>>     >
>>     >
>>     > _______________________________________________
>>     > Spce-user mailing list
>>     >  Spce-user at lists.sipwise.com
>>     <sentmsg?compose&To=Spce%2duser at lists.sipwise.com>
>>     >  http://lists.sipwise.com/listinfo/spce-user
>>     >
>> 
>>     _______________________________________________
>>     Spce-user mailing list
>>  Spce-user at lists.sipwise.com
>>     <sentmsg?compose&To=Spce%2duser at lists.sipwise.com>
>>  http://lists.sipwise.com/listinfo/spce-user
>> 
>> 
>> 
>> -- 
>> Sergey Kharlamov


-- 
Sergey Kharlamov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20131202/77d75bda/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2013-12-02 at 11.42.40 AM.png
Type: image/png
Size: 49841 bytes
Desc: not available
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20131202/77d75bda/attachment.png>


More information about the Spce-user mailing list