07-26-06 12:11 AM
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@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,9725557
148,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@gmail.com
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
--
Nick Marus
nmarus@gmail.com
 Attachment:
This has been downloaded 0 time(s).
[ Post a follow-up to this message ]
| 
