topic Re: APIC-EM Bulk Upload in Controllers

APIC-EM Bulk Upload

Claudia de Luna — Fri, 01 Mar 2019 12:35:42 GMT

Hi,

I'm working on provisioning about 35 switches. I downloaded the bulk upload project template and filled it in pretty consistently or so I thought but 7 switches don't go into the project for some reason and wind up in Unplanned devices. I can then claim them and add them to the project. Are there any logs that I can review to try to figure out why those 7 are rejected?

Thanks!

Re: APIC-EM Bulk Upload

aradford — Wed, 25 Jan 2017 04:20:49 GMT

Hi Claudia,

How are you doing the upload? UI or API?

Adam

Re: APIC-EM Bulk Upload

Claudia de Luna — Wed, 25 Jan 2017 04:23:24 GMT

Via the GUI.

Happy to send you the CSV file but "out of band" if possible.

claudia.deluna@dimensiondata.com

Re: APIC-EM Bulk Upload

aradford — Wed, 25 Jan 2017 04:28:00 GMT

ok. will email you.

BTW, for the forum, make sure that any config/image files in the rules are already uploaded to the controller.

Re: APIC-EM Bulk Upload

Claudia de Luna — Wed, 25 Jan 2017 04:32:08 GMT

Maybe that is the problem...in this project it was initially just for code upgrade on the 34 devices. No config file. But that does not explain why those 7 failed. If that was an issue they would have all failed. Sorry...thinking "out loud" so to speak.

Re: APIC-EM Bulk Upload

aradford — Wed, 25 Jan 2017 04:35:50 GMT

One way you could try, is to use the swagger API to do the upload.

Click on "API" top right,

Select "Network Plug And Play" on LHS

Select "POST pnp-project/seed-file"

Select "Choose File" next too "seedFile" parameter and use your CSV.

Press "Try it out" and you will see any errors below.

Re: APIC-EM Bulk Upload

aradford — Wed, 25 Jan 2017 04:40:25 GMT

BTW, we broke the UI for bulk import in 1.3.2, but it will be fixed in 1.3.3 (in a day or two)

We should show the errors in the UI too, but I cannot test that right now.

Re: APIC-EM Bulk Upload

aradford — Wed, 25 Jan 2017 04:49:05 GMT

Strange. i took a look at your file. Looks like we do not accept "." in the device name? That does not explain the ones that worked.

"Line 2, Device Name* aaaaaa.bbbbbbb is invalid. Accepted Format: Alpha Numeric with hyphen and underscore

Re: APIC-EM Bulk Upload

Claudia de Luna — Wed, 25 Jan 2017 04:50:05 GMT

woops...must have sent you the wrong file. In the one I'm uploading I've replaced the "." with "_".

Re: APIC-EM Bulk Upload

aradford — Wed, 25 Jan 2017 04:50:50 GMT

The next problem was the serial number. A lot of the ones in the file are 12 characters? Is that correct?

Invalid Serial Number, Serial number is 11 characters alphanumeric

Re: APIC-EM Bulk Upload

Claudia de Luna — Wed, 25 Jan 2017 04:51:11 GMT

Should have mentioned this before..running 1.3.1.9

Re: APIC-EM Bulk Upload

Claudia de Luna — Wed, 25 Jan 2017 04:56:55 GMT

I love this interface!

So I tried the upload via the API and all 34 devices failed. Not really sure what the output is telling me.

Code 202 =

202	Request was accepted. Use Task ID to track the progress

Re: APIC-EM Bulk Upload

aradford — Wed, 25 Jan 2017 05:00:38 GMT

OK... here is the real answer.

The API stuff will show you data issues in your file.

If you get through this, then you will see the seed file uploads and there will be a report you can download.

In your case, it shows the devices already exist... the names are duplicated. Every device name needs to be unique

Re: APIC-EM Bulk Upload

aradford — Wed, 25 Jan 2017 05:01:41 GMT

here is a sanitised version of the report.

Re: APIC-EM Bulk Upload

aradford — Wed, 25 Jan 2017 05:03:17 GMT

The 202 tells you there were no data errors in the file. You can then look at the GUI (or another API) to get a report of the upload.

I can show you the API to find out the next step programatically, but probably simpler in the UI.

Re: APIC-EM Bulk Upload

Claudia de Luna — Wed, 25 Jan 2017 05:07:30 GMT

So I didn't realize that the device name had to be unique..I assumed that they key was the Serial Number. And that explains the failure as the names are indeed duplicates because these are stacks and I used the host name as the device name vs the label which notes the member number.

Thank you so much.

Re: APIC-EM Bulk Upload

aradford — Wed, 25 Jan 2017 05:11:44 GMT

Happy to help.

Just need to configure a single rule any of the serial numbers in the stack, with the stacking option enabled, and the controller will do the rest.

When the stack contacts the controller, it will send all serial numbers in the stack and the controller will match on any of them.

Might be good to select the appropriate number of stack members too.

Adam