topic Re: Simple CSV address Import not working in Expedition Discussions

Simple CSV address Import not working

Chacko42 — Fri, 31 Jan 2020 10:45:49 GMT

Hi Community,

I'm exploding... did a few Juniper migrations lately and we have an issue, that the address import is not working as expected.

The object names are fine, but all the addresses got value "1.1.1.1" - lot's of manual work or scripting.

So I did CSV Import to got duplicate entries with the right ip-values and merged them (CSV as merge-primary).

That worked.

Now, even a simple CSV import of csv-file "foo;1.2.3.4;255.255.255.255" doesn't work.

I got no values in preview output and when doing the import anyway, I got a address object with empty name and type FQDN.

So, how do I explicitly say, this is an ip-address netmask?

Chaning it to CIDR, doesn't work neither, so CSV input "foo;1.2.3.4;32"

When I use an csv-file from weeks ago with several hundred entries, it works, but this stupid "foo" import for demonstration isn't working.

Any ideas?

Best Regards

Chacko

dgildelaig — Mon, 03 Feb 2020 08:32:23 GMT

It could be the separation character.

Could you check changing the semicolon ";" for a comma ","?

Chacko42 — Mon, 03 Feb 2020 08:55:50 GMT

@dgildelaig: Found the issue:

I tried a lot, using notepad++ and looking at control characters etc.

Solution is: open you perfectly well formatted and correct-syntaxed scripted CSV with excel.

Save it as csv and you are fine.

It seems, that the Migration tool is looking at the metadata of files