Importing DHCP Reservations via EC200

Importing DHCP Reservations via EC200

Importing DHCP Reservations via EC200
Importing DHCP Reservations via EC200
2 weeks ago
Model: ER605 (TL-R605)  
Hardware Version: V2
Firmware Version:

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

  1      
  1      
#1
Options
7 Reply
Re:Importing DHCP Reservations via EC200
a week ago

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.

Best Regards! If you are new to the forum, please read: Howto - A Guide to Use Forum Effectively. Read Before You Post. Look for a model? Search your model NOW Official and Beta firmware. NEW features! Subscribe for the latest update!Download Beta Here☚ ☛ ★ Configuration Guide ★ ☚ ☛ ★ Knowledge Base ★ ☚ ☛ ★ Troubleshooting ★ ☚ ● Be kind and nice. ● Stay on the topic. ● Post details. ● Search first. ● Please don't take it for granted. ● No email confidentiality should be violated. ● S/N, MAC, and your true public IP should be mosaiced.
  1  
  1  
#2
Options
Re:Importing DHCP Reservations via EC200
a week ago

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

  1  
  1  
#3
Options
Re:Importing DHCP Reservations via EC200
a week ago

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,,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

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.

Best Regards! If you are new to the forum, please read: Howto - A Guide to Use Forum Effectively. Read Before You Post. Look for a model? Search your model NOW Official and Beta firmware. NEW features! Subscribe for the latest update!Download Beta Here☚ ☛ ★ Configuration Guide ★ ☚ ☛ ★ Knowledge Base ★ ☚ ☛ ★ Troubleshooting ★ ☚ ● Be kind and nice. ● Stay on the topic. ● Post details. ● Search first. ● Please don't take it for granted. ● No email confidentiality should be violated. ● S/N, MAC, and your true public IP should be mosaiced.
  1  
  1  
#4
Options
Re:Importing DHCP Reservations via EC200
Monday

HI   @Clive_A 

 

Still can't get this to work. This is a screenshot of my file and the associated error message.

 

 

Not sure what you mean by "...the IP should exist on the router as the VLAN int has been created and the IP is not used."

 

You'd think this would be a lot easier. Unfortunately I have quite a few reservaltions I'd like reserved if I can ever get this to work.

 

Thanks,

Allen

  0  
  0  
#5
Options
Re:Importing DHCP Reservations via EC200
Tuesday

Hi @AAADiver

AAADiver wrote

HI   @Clive_A 

 

Still can't get this to work. This is a screenshot of my file and the associated error message.

 

 

 

 

Not sure what you mean by "...the IP should exist on the router as the VLAN int has been created and the IP is not used."

 

You'd think this would be a lot easier. Unfortunately I have quite a few reservaltions I'd like reserved if I can ever get this to work.

 

Thanks,

Allen

You exported the file from the Controller and edited the file in Excel. Then imported it and it reported this error message, is that correct?

If you export the existing DHCP reservation, and manually delete one of the entries in the Controller. Then edit the file and only keep the deleted entry in the .csv and try importing it. Will it behave the same with the same error?

I have tried multiple ways but I don't reproduce this.

 

Firmware version of ER605 and Controller version.

Best Regards! If you are new to the forum, please read: Howto - A Guide to Use Forum Effectively. Read Before You Post. Look for a model? Search your model NOW Official and Beta firmware. NEW features! Subscribe for the latest update!Download Beta Here☚ ☛ ★ Configuration Guide ★ ☚ ☛ ★ Knowledge Base ★ ☚ ☛ ★ Troubleshooting ★ ☚ ● Be kind and nice. ● Stay on the topic. ● Post details. ● Search first. ● Please don't take it for granted. ● No email confidentiality should be violated. ● S/N, MAC, and your true public IP should be mosaiced.
  1  
  1  
#6
Options
Re:Importing DHCP Reservations via EC200
Tuesday - last edited Tuesday

  @AAADiver 

 

HELLO, I JUST GOT THIS TO WORK!

 

After getting lucky and managing to export a reservation I found out that it is looking for 7 columns of data as follows:


Network Name    MAC                              IP                     Status    Export to IP-MAC Binding    Description(Optional)    Client Name(Optional)
 

Default                B0-5A-DA-AA-AA-AA    192.168.0.10    FALSE    TRUE                                   A PC Workstation          Host1
 

I hope this helps.

 

Good Luck.

  1  
  1  
#7
Options
Re:Importing DHCP Reservations via EC200
Wednesday

Note: I discovered the correct number of fields by exporting a record, which is only possible when working on the local controller IP and not in the cloud access method.

this is on Router:

ER7212PC v1.0
Firmware Version:
1.2.0 Build 20240716 Rel.80083

  0  
  0  
#8
Options