|
Home > Archive > Voice over IP Cisco > July 2006 > Cisco BAT and comma's inside values.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cisco BAT and comma's inside values.
|
|
| Nick Marus 2006-07-25, 1:11 pm |
| | |
| Ryan Ratliff 2006-07-25, 7:11 pm |
| 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 2006-07-25, 7:11 pm |
| 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
| |
| Ed Leatherman 2006-07-26, 1:11 am |
| |
|
|
|
|