IP Address Import

[danopogac]

Import IP Addresses from xsl file after uload file and click on Preview throw error for each hostname Unable to locate the subnet in the specified VRF. VRF module is disabled because we don't use VRFs at all. Subnet for import is defined correctly without VRF or VRF showing value None.

phpIPAM version
1.5 and 1.4 latest. Tested both versions

• OS RHEL 8
• PHP version 7.4 64bit
• Webserver Apache
• Database MariaDB 10.5

Steps To Reproduce
Click Administration -> Import / Export
Select Dataset IPadresses from drop down menu
Click import
Click Browse / Drag and drop
Select file to import
Click Preview

[Graham9999]

Is there a work around for this issue? I'm experiencing the same issue and have a lot of importing to do.

[avkolbasenko]

Confirm, i have some problem. ver.~1.5 devel from GIT

This is happened because this networks created in MySQL with default vrfid NULL(i don't know why). Other networks created with vrfid 0.
After changing this field to 0 in phpmyadmin, all ip imported successfully:
New entry, will be added.

[avkolbasenko]

Partially Solved.. It is necessary to understand, why these networks are created with vrfid NULL

[jondah]

I had same issue and has come to the conclusion that subnets created in GUI got null as vrfID and subnets created from Excel import got 0 as id.

[ivoruetsche]

Confirm, i have some problem. ver.~1.5 devel from GIT

This is happened because this networks created in MySQL with default vrfid NULL(i don't know why). Other networks created with vrfid 0. After changing this field to 0 in phpmyadmin, all ip imported successfully: New entry, will be added.

UPDATE subnets SET vrfId = 0 WHERE vrfId is NULL;

[qvdm]

The above workaround only works for me when importing a single IP address. Subsequent entries still fail with the "Unable to locate the subnet in the specified VRF" error message.

[Graham9999]

This will fix this issue, make sure you click the box

Check the box Search for matching subnet in all VRFs.