[Spce-user] CSV Upload problem

Sergey Kharlamov mentax at bk.ru
Mon Dec 2 11:57:23 EST 2013


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

will work?

>Quotes.
>
>Daniel
>
>
>Sergey Kharlamov < mentax at bk.ru > wrote:
>
> 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


-- 
Sergey Kharlamov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20131202/fcfb13a8/attachment.html>


More information about the Spce-user mailing list