[cisco-voip] Cisco BAT and comma's inside values.

[Nick Marus]

Ok, I'll look at the bug ids a little closer... but i can never get it to
insert either. Forget validation, i have a list as long as my arm with
errors in the validator.

Ok, so I setup a little test.

used this as my bat file:

0014A9103A49,2,5147,"Marus, Nick",Nick Marus 5147,,,,,,,

this is the error.


            Add Lines to PHONES     7/25/2006 12:09:40 PM

File Name:  5147commatest

Result Summary:
		Add Lines for 0 PHONES Passed
		Add Lines for 1 PHONES Failed


Failure Details :

Device Name              Error Number     Error Description
-------------------------------------------------------------------------------
0014A9103A49             -2147219934          CDBLException Dump: [The
specified directory pattern is not valid]: 'N' not allowed.(2)




On 7/25/06, Ryan Ratliff <rratliff at cisco.com> wrote:
>
> Depending on the field being used there are numerous bugs out there
> to get BAT to accept commas.
> A search for BAT and comma should turn up quite a few.
>
> CSCsc27282 seems to match your issue, "BAT Phone validation fails
> with comma in Display or Alerting Name".
>
> Of course the bug notes that the insert will work but the validation
> fails.
>
> -Ryan
>
> On Jul 25, 2006, at 11:00 AM, Nick Marus wrote:
>
> Anyone ever successfully use bat to import fields with commas in the
> fields? for example I want the "display name" field on a line to be
> lastn, firstn.
>
> Since BAT is a csv, the bat help says this is possible...
>
>
> 5.If the value of the field includes a comma or double quotes, then
> that field must be enclosed in double quotes. Enclosing the field in
> double quotes is not required for characters other than comma and
> double quotes in the field value.
>                 For example if the line text label includes a comma
> in its value, the sample record would be:
>                   1231123245AB,2,9728437154,9728437154,"Mike,line1",
> 9725557172,9725557196,9725557126,9725557148,9725557166,9725557171,Market
> ing
>
>
> Formating it like this, always errors out bat though. This field
> accepts a comma if you enter it through ccmadmin, but regardless of
> how i format the csv, a comma in the field is never taken. I have
> tried this on 2 installs of CM 4.1.3, a CM 4.1.2, and a cm 4.1. All
> the same
>
> Any others have similar issues? or better, a fix?
>
>
> --
> Nick Marus
> nmarus at gmail.com
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>


-- 
Nick Marus
nmarus at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060725/6f9e9688/attachment.html