[Spce-user] Problem (Bug?) in Billing Fee uploads

[Gavin Sweet]

I re-read the handbook regarding this point, but the behaviour is not
consistent.
According to the handbook, the web interface removes the regex, but this
isn't the case - only for some formats of regex.
I'd like really to be able to see the full code (including regex) that's
being matched, because that's the only way you can be sure you have a fee
that's correct.
At the moment it's pretty tricky to manage because you're not quite sure
what you're looking at.
Thanks for any light anyone can shed...




> -----Original Message-----
> From: spce-user-bounces at lists.sipwise.com [mailto:spce-user-
> bounces at lists.sipwise.com] On Behalf Of Gavin Sweet
> Sent: 14 March 2013 14:39
> To: spce-user at lists.sipwise.com
> Subject: Re: [Spce-user] Problem (Bug?) in Billing Fee uploads
> 
> My table of tests got a bit mangled.
> Basically, this problem is when trying to upload fees from file.
> For example, for *exactly* 44118555, the destination should be:
> ^44118555$ But the ^ and $ get stripped for some reason during the
> upload from file.
> Same with ^44118555.*$
> But NOT with ^4411855[5]$ or  ^44118555.$
> 
> Cheers
> Gavin
> 
> > -----Original Message-----
> > From: spce-user-bounces at lists.sipwise.com [mailto:spce-user-
> > bounces at lists.sipwise.com] On Behalf Of Gavin Sweet
> > Sent: 14 March 2013 12:51
> > To: spce-user at lists.sipwise.com
> > Subject: [Spce-user] Problem (Bug?) in Billing Fee uploads
> >
> > Hi -
> > I have had some problems with destination regex support when
> uploading
> > Billing Fees using the batch Upload file function in the Admin GUI.
> > I have tested these problems with very small file uploads to ensure
> > its not a problem with file size/transfer etc.
> > I actually started off trying to ensure an exact match for the number
> > 44118555, which should be simply ^44118555$ - however this doesn't
> > upload.
> > I then investigated further and found some unexpected results as
> below.
> > If anyone can help, or let me know that this is a bug, that would be
> > great.
> > Manual definition of these fees is not an option for workaround as we
> > have over 30000 records. An odd (inelegant) form of regex may force
> it
> > to work, but that's not what I'd prefer.
> >
> > Other than case 7 and 8 which I tried for completeness, I think all
> > the below should work, but they don't.
> > ---------------------------------------------------------------------
> -
> > -
> > -----
> > ---------------------
> > Case       Uploaded fee (csv record)
> > =>
> > Destination (in profile)
> > ---------------------------------------------------------------------
> -
> > -
> > -----
> > ---------------------
> > 1 (ok)     ^*.$,ABC,ABC,0,1,0.5,1,0,1,0.5,1,0
> > =>
> > ^*.$
> > 2 (ok)     ^44118555.$,ABC,ABC,0,1,0.5,1,0,1,0.5,1,0
> > =>
> > ^44118555.$
> > 3 (ok)     ^44118[1-9][0-9][0-9]$,ABC,ABC,0,1,0.5,1,0,1,0.5,1,0
> > =>
> > ^44118[1-9][0-9][0-9]$
> > 4 (ok)     ^4411855[5]$,ABC,ABC,0,1,0.5,1,0,1,0.5,1,0
> > =>
> > ^4411855[5]$
> > 5 (fail)   ^44118555.*$,ABC,ABC,0,1,0.5,1,0,1,0.5,1,0
> > =>
> > 44118555
> > 6 (fail)   ^44118555$,ABC,ABC,0,1,0.5,1,0,1,0.5,1,0
> > =>
> > 44118555
> > 7 (fail)   '^44118555$',ABC,ABC,0,1,0.5,1,0,1,0.5,1,0
> > =>
> > '^44118555$'
> > 8 (fail)   "^44118555$",ABC,ABC,0,1,0.5,1,0,1,0.5,1,0
> > =>
> > "^44118555$"
> > ---------------------------------------------------------------------
> -
> > -
> > -----
> > ---------------------
> >
> > Thanks,
> > Gavin
> >
> >
> > _______________________________________________
> > Spce-user mailing list
> > Spce-user at lists.sipwise.com
> > http://lists.sipwise.com/listinfo/spce-user
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2013.0.2904 / Virus Database: 2641/6166 - Release Date:
> > 03/12/13
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.2904 / Virus Database: 2641/6166 - Release Date:
> 03/12/13