Hi There
I managed to create a script in excel to create my routes via the web interface.
I do this because there is no cli interface for my router (mega 105WR) and I became gatvol of trying all else, so I used my excel skills.
So with the click of a button it does the following:
I have two problems.
Its starts out pretty okay, but when it gets to around 400 routes (of the current 1300+) its slo-o-o-ows do-o-o-o-wn. This is not due to the router slowing down, but because the actual weppage lists every route added. So the router needs to create 400 extra lines in the page every time the program chooses local or clicks Apply to add a route.
I'll figure that out.
My second problem has to do with defining routes. I'm not a network oke and don't understand those things much, so please assist. I need to know what I should specify in the fields when defining a route. Please answer this in relation to the routes as they are defined in localroutes4.txt
Thanks
I will publish the spreadsheet as soon as I've cleaned it up sufficiently
I managed to create a script in excel to create my routes via the web interface.
I do this because there is no cli interface for my router (mega 105WR) and I became gatvol of trying all else, so I used my excel skills.So with the click of a button it does the following:
- Open Explorer
- Logs into the router's web interface
- Downloads the latest localroutes4.txt file
- Strips out everything, and keeps the routes only
- It then goes to the page to add static routes
- Chooses "local", fills in the route (as per the stripped out localroutes file)
- Loops through the entire stipped out file and does the previous step
- Closes localroutes
- Saves the routes [to do]
I have two problems.
Its starts out pretty okay, but when it gets to around 400 routes (of the current 1300+) its slo-o-o-ows do-o-o-o-wn. This is not due to the router slowing down, but because the actual weppage lists every route added. So the router needs to create 400 extra lines in the page every time the program chooses local or clicks Apply to add a route.
I'll figure that out.My second problem has to do with defining routes. I'm not a network oke and don't understand those things much, so please assist. I need to know what I should specify in the fields when defining a route. Please answer this in relation to the routes as they are defined in localroutes4.txt
Thanks
I will publish the spreadsheet as soon as I've cleaned it up sufficiently