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

[Gavin Sweet]

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