This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Custom Properties Import Can't Match on InterfaceID?

byrona over 10 years ago

I want to use a spreadsheet to import a bunch of interface custom property data; however, it doesn't seem like I can match on InterfaceID? I had originally exported the list I am using from Orion with the InterfaceID as it's the only truly unique field that I have to work with. Since this is the only truly unique field I am curious why I can't match on this?

0 byrona over 10 years ago

Really would like a SW response on this if possible as this is something that I need to do.
Cancel
Vote Up 0 Vote Down

Cancel
0 Michal.Pecenka over 10 years ago in reply to byrona

Hi, what is your NPM version?
Cancel
Vote Up 0 Vote Down

Cancel
0 byrona over 10 years ago in reply to Michal.Pecenka

I am running version 10.4.2
Cancel
Vote Up 0 Vote Down

Cancel
0 Halef over 10 years ago in reply to byrona

Checking this on my 10.4.2, this is definitely a supported scenario. 10.4.1 didn't offer InterfaceId for export though - can you double check the CSV contains it? Also, the first page ('Select File") of Import is a bit tricky, you need to switch from "Nodes" to "Interfaces" in a dropdown.
If all that looks right, please open a support ticket.
Cancel
Vote Up 0 Vote Down

Cancel
0 byrona over 10 years ago in reply to Halef

I didn't do my export using that tool, InterfaceID is also not available as an export option. My export was done using a report I created in the report writer.
Cancel
Vote Up 0 Vote Down

Cancel
0 Halef over 10 years ago in reply to byrona

That's a path we didn't account for, but in general, any CSV should work. This is first few lines of the one that works for me:
FullName,InterfaceID,CarrierName
lab-whatsup - Software Loopback Interface 1 · Loopback Pseudo-Interface 1,1,
lab-whatsup - WAN Miniport (SSTP) · Local Area Connection*,2,
lab-whatsup - WAN Miniport (IKEv2) · Local Area Connection* 2,3,
I believe this is case sensitive. Report writer might also use different encoding (not sure here, but I think the web import expects UTF-8. Best way to check is to do a test export from web and examine that file (I don't have tools for that handy right now).
Do you just see different columns than InterfaceID in the wizard, or nothing at all?
Cancel
Vote Up 0 Vote Down

Cancel
0 byrona over 10 years ago in reply to Halef

In the import wizard I just don't see an option for InterfaceID.
Cancel
Vote Up 0 Vote Down

Cancel
0 byrona over 10 years ago in reply to Halef

Is exporting the data to an Excel Spreadsheet with Report Writer and then importing via the Custom Properties manager in the WebUI not an acceptable use case? According to the Custom Properties manager in the WebUI it accepts .xls files. I only used the Report Writer for my export as it allows me to be more specific about what I want to export.
Cancel
Vote Up 0 Vote Down

Cancel
0 Halef over 10 years ago in reply to byrona

It's definitely an acceptable use case. What I meant was, it's not the primary flow I'd expect.
If the CSV looks fine (per what I wrote earlier), please open a support ticket and we'll look into this.
Cancel
Vote Up 0 Vote Down

Cancel