[cisco-voip] Exporting users?

[Mike O]

I got the phones to import, but the users are giving the me following error.

 

Moor Could not insert new row - duplicate value in a UNIQUE INDEX column.

Bone Could not insert new row - duplicate value in a UNIQUE INDEX column.

Cost Could not insert new row - duplicate value in a UNIQUE INDEX column.


 


From: me at go0se.com
To: mikeeo at msn.com
CC: cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] Exporting users?
Date: Fri, 10 Jul 2009 13:49:58 -0500







You typically can’t just take the export file and import it directly into the new box. You need to copy the data into the correct tab of the bat.xlt file that can be downloaded under UPLOAD/DOWNLOAD FILES, then use the macro in that file to export it to a .txt file that you then import. 
 
-Go0se
http://atc.go0se.com
 
 


From: Mike O [mailto:mikeeo at msn.com] 
Sent: Friday, July 10, 2009 1:45 PM
To: me at go0se.com
Cc: cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] Exporting users?
 
I ran a validation.
 
 
Validate Phones - Specific Details

Begin Time : 07/10/2009 14:43:26


Failure Details : 

Device Name/MAC Address Error Code Error Description
-----------------------------------------------------------------------------------------
2001 CSV contains more number of lines than are supported by the phone template.




Result Summary :

VALIDATE for 0 PHONE passed.
VALIDATE for 20 PHONE failed.


End Time : 07/10/2009 14:43:26

 



From: me at go0se.com
To: mikeeo at msn.com
CC: cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] Exporting users?
Date: Fri, 10 Jul 2009 13:42:32 -0500

What does the import log file say?
 
-Go0se
http://atc.go0se.com
 
 


From: Mike O [mailto:mikeeo at msn.com] 
Sent: Friday, July 10, 2009 1:27 PM
To: me at go0se.com; rratliff at cisco.com
Cc: cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] Exporting users?
 
The export worked fine and the import successfully ran, but I don't see any phones or users. Do I need to restart some services?
 
Thanks,
 
Mike
 
> From: me at go0se.com
> To: rratliff at cisco.com; mikeeo at msn.com
> CC: cisco-voip at puck.nether.net
> Subject: RE: [cisco-voip] Exporting users?
> Date: Fri, 10 Jul 2009 13:09:47 -0500
> 
> I concur - it doesn't delete anything and won't affect any call processing,
> etc. Also, you will probably have to reformat the data out of the export
> file and into the BAT spreadsheet, but it works well and beats the krabby
> patties out of doing the export and/or import manually.
> 
> -Go0se
> http://atc.go0se.com
> 
> 
> -----Original Message-----
> From: Ryan Ratliff [mailto:rratliff at cisco.com] 
> Sent: Friday, July 10, 2009 12:47 PM
> To: Mike O
> Cc: me at go0se.com; cisco-voip at puck.nether.net
> Subject: Re: [cisco-voip] Exporting users?
> 
> BAT exports do not delete anything.
> 
> -Ryan
> 
> On Jul 10, 2009, at 1:44 PM, Mike O wrote:
> 
> Go0se thanks for the reply, looks like it will work. But do you know 
> if it just copies the data out and keeps the phones registered or 
> does it actually delete the data?
> 
> I have to do it on a live system and didn't want to delete the phones 
> in the middle of the day.
> 
> From: me at go0se.com
> To: mikeeo at msn.com; cisco-voip at puck.nether.net
> Subject: RE: [cisco-voip] Exporting users?
> Date: Fri, 10 Jul 2009 08:00:06 -0500
> 
> .ExternalClass p.EC_MsoNormal, .ExternalClass 
> li.EC_MsoNormal, .ExternalClass div.EC_MsoNormal {margin-bottom:. 
> 0001pt;font-size:12.0pt;font-family:'Times New 
> Roman','serif';} .ExternalClass a:link, .ExternalClass 
> span.EC_MsoHyperlink {color:blue;text- 
> decoration:underline;} .ExternalClass a:visited, .ExternalClass 
> span.EC_MsoHyperlinkFollowed {color:purple;text- 
> decoration:underline;} .ExternalClass span.EC_EmailStyle17 {font- 
> family:'Calibri','sans- 
> serif';color:#1F497D;} .ExternalClass .EC_MsoChpDefault {font-size: 
> 10.0pt;} @page Section1 {size:8.5in 11.0in;} .ExternalClass 
> div.EC_Section1 {page:Section1;}
> BAT.
> 
> 
> See here:
> 
> 
> http://is.gd/1twQP
> 
> 
> -Go0se
> 
> http://atc.go0se.com
> 
> 
> 
> From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip- 
> bounces at puck.nether.net] On Behalf Of Mike O
> Sent: Thursday, July 09, 2009 9:26 PM
> To: cisco-voip at puck.nether.net
> Subject: [cisco-voip] Exporting users?
> 
> 
> I have to move about 50 users from Call Manager 5.1.3 to Business 
> Edition 7.0. Is there away I can export those 50? or do I need to do 
> a stare and compare?
> 
> 
> Thanks,
> 
> Mike
> 
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> 
> 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090710/fd6c3080/attachment.html>