change phone mac addresses in bulk

[davistw]

Running 7.1

I have a block of 80 phones that I need to change out. They are exactly like the old phones so all that I need to do is change the mac address in the device information field. What I was hoping is there was an easier way to do this. I will have to do this multiple times. I was looking at the phone migration tool but that looks like it changes other fields except just the mac address. Is there a way to do this?

[Jaime Valencia · Accepted solution]

Use BAT to export all details, delete phones, change csv file to update MACs, reimport using all details option.

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

[davistw]

Ok bear with me I am new to BAT...

Go to Import/Export and Export selecting "Select All" and submit it as a job.

Delete all phones

Take the output and masage it and import it.

Right?

Do I have to select all of fields on the Expor or just the "Device Data" fields?

[Marcel Ammann · Accepted solution]

Hello,

yes you are right. Here are some screenshots:

Bulk:

Export:

After export, you delete the phones. Update the CSV with excel and import the CSV (all details).

Please rate helpful posts.

Kind regards,

Marcel Ammann

[davistw]

Ahhhh... The light goes on...

Thank you so much.