Importing DHCP Reservations via EC200
Anybody have any luck importing DHCP reservations via a EC200 controller.
Template says format is
Network Name,MAC,IP,Status,Export to IP-MAC Binding,Description(Optional)
I tried the following and get the error, , “Invalid user file format due to number of delimiters. Please check the file and import again.”
Default,00:06:78:xx:xx:xx,192.168.254.169, Enable,,Heos
Any ideas?
Thanks!
Allen
- Copy Link
- Subscribe
- Bookmark
- Report Inappropriate Content
Hi @AAADiver
Thanks for posting in our business forum.
I uploaded one from the exported file or the template, both can be uploaded correctly on a Software Controller V5.14.
What file format did you use?
Have you examined if you have put the correct parameters?
Note that the network name and the IP you've input.
- Copy Link
- Report Inappropriate Content
Hi @Clive_A -
Thanks for your reply. Responses to your questions are below.
Q: What file format did you use?
A: Standard csv format exported from excel.
Q: Have you examined if you have put the correct parameters?
A: I included an example of what I uploaded in my original question,
Default,00:06:78:xx:xx:xx,192.168.254.169, Enable,,Heos
Honestly not sure what "Export to IP-MAC Binding" is so left that field blank. Maybe that's my issue? It's saying invalid number of delimiters so clearly missing something or my format is wrong. Can you share a single record from one of your successful uploads?
Q: Note that the network name and the IP you've input.
A: Not sure what you mean here. I kept my Network Name as "Default" and that's what I specified in the upload and the IP address is valid and in my IP range.
Thansk again,
Allen
- Copy Link
- Report Inappropriate Content
Hi @AAADiver
Thanks for posting in our business forum.
AAADiver wrote
Hi @Clive_A -
Thanks for your reply. Responses to your questions are below.
Q: What file format did you use?
A: Standard csv format exported from excel.
Q: Have you examined if you have put the correct parameters?
A: I included an example of what I uploaded in my original question,
Default,00:06:78:xx:xx:xx,192.168.254.169, Enable,,HeosHonestly not sure what "Export to IP-MAC Binding" is so left that field blank. Maybe that's my issue? It's saying invalid number of delimiters so clearly missing something or my format is wrong. Can you share a single record from one of your successful uploads?
Q: Note that the network name and the IP you've input.
A: Not sure what you mean here. I kept my Network Name as "Default" and that's what I specified in the upload and the IP address is valid and in my IP range.
Thansk again,
Allen
So that is to say the csv is the template from Omada. And you replaced the parameters. Do I understand you correctly?
Can you paste a screenshot directly from your csv file? You can mosaic your MAC address.
The Network Name and the IP should exist on the router as the VLAN int has been created and the IP is not used.
- Copy Link
- Report Inappropriate Content
Information
Helpful: 0
Views: 85
Replies: 3
Voters 0
No one has voted for it yet.