[Spce-user] CSV Upload problem
Daniel Grotti
dgrotti at sipwise.com
Tue Dec 3 08:48:39 EST 2013
Hi,
I've got the 504 timeout page so I can replicate the issue, but at the
end the fees were uploaded and the webpage appears again.
Anyway since the timeout page is wrong, I opened an internal ticket
about that.
We will fix it in the next packages release.
Daniel
On 12/03/2013 01:37 PM, Daniel Grotti wrote:
> Please,
> send us the CSV to test.
> If it is not possible, please paste here the output from
> /var/log/ngcp/oss.log during the upload.
>
> Also, What's the size of the file in MB ?
> Nginx limit is 128M.
>
> Please, try to upload less then 5000 lines in one time, for example 1000
> rows.
>
>
> Daniel
>
>
>
>
> On 12/02/2013 09:05 PM, Sergey Kharlamov wrote:
>> 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
>> <sentmsg?compose&To=Spce%2duser at lists.sipwise.com>
>> http://lists.sipwise.com/listinfo/spce-user
>>
>>
>>
>> --
>> Sergey Kharlamov
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
>
More information about the Spce-user
mailing list