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

Gavin Sweet gavin.sweet at skyracktelecom.com
Thu Mar 14 08:51:15 EDT 2013


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





More information about the Spce-user mailing list