[Spce-user] CSV Upload problem
Daniel Grotti
dgrotti at sipwise.com
Tue Dec 3 07:37:38 EST 2013
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
More information about the Spce-user
mailing list