[Spce-user] CSV Upload problem

Sergey Kharlamov mentax at bk.ru
Mon Dec 2 15:05:42 EST 2013


 I have the same error when I change it to:
".","^01120",out,"International"," Egypt",0.003394673,60,0.003394673,60,0.003394673,60,0.003394673,60,0
".","^0112010",out,"International"," Egypt (Mobile A)",0.00324632,60,0.00324632,60,0.00324632,60,0.00324632,60,0
".","^0112011",out,"International"," Egypt (Mobile B) Etisalat",0.00329868,60,0.00329868,60,0.00329868,60,0.00329868,60,0
".","^0112012",out,"International"," Egypt (Mobile A)",0.00324632,60,0.00324632,60,0.00324632,60,0.00324632,60,0
".","^0112014",out,"International"," Egypt",0.00329868,60,0.00329868,60,0.00329868,60,0.00329868,60,0
".","^01120150",out,"International"," Egypt",0.00324632,60,0.00324632,60,0.00324632,60,0.00324632,60,0
".","^01120151",out,"International"," Egypt",0.00324632,60,0.00324632,60,0.00324632,60,0.00324632,60,0
".","^01120152",out,"International"," Egypt",0.00329868,60,0.00329868,60,0.00329868,60,0.00329868,60,0
".","^01120153",out,"International"," Egypt",0.00324632,60,0.00324632,60,0.00324632,60,0.00324632,60,0

What can be a problem?



>
>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
>_______________________________________________
>Spce-user mailing list
>Spce-user at lists.sipwise.com
>http://lists.sipwise.com/listinfo/spce-user
>


-- 
Sergey Kharlamov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20131203/a4779b34/attachment-0001.html>


More information about the Spce-user mailing list