[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