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