[racktables-users] Re: CSV import plugin
- From: Alain Iltchev <alain.iltchev@xxxxxxxxx>
- To: racktables-users@xxxxxxxxxxxxx
- Date: Wed, 24 Sep 2014 21:10:12 +0200
Hello,
Good work for this module ! Just a small suggestion for end user ergonomy
and for people that don't have access to the original php. It would be
interesting to show the documentation or at least the Syntax for each
importable item in the HTML page itself. For example , what I added in one
of your previous versions of the csv_import.php :
...
echo '</table></form><br>';
echo '<p align="left">Usage:<br>
* Importing Objects:<br>
<b>Syntax: OBJECT; Objecttype ; Common name ; Visible label ; Asset tag;
portname,portname,etc ; porttype,porttype,etc </b><br>
Value 1, OBJECT<br>
Value 2, Objectype: Can be one of the predefined types (SERVER,
PATCHPANEL,SWITCH), or a numeric value indicating the object type from
Racktables<br>
...
Alain Iltchev
2014-09-24 20:32 GMT+02:00 Erik Ruiter <erik.ruiter@xxxxxxxxxxx>:
> Hi Lucas,
>
> Nice that it works, I am happy that more people find it useful.
> Thanks for the updates for the interface types, I updated the correct
> labels in the documentation.
>
> I also found out (looking at the commitAddPort() function) that it is
> already possible to use other inner interface types.
>
> If you want to have a different inner interface type, eg . GBIC (type
> 3), you can add this with a hyphen preceding the outer interface type.
> For example: OBJECT;7;myRouterCN1;myRouterLB1;;1/1/[1-2];3-1204 <—
> If you don’t specify the inner interface type, it defaults to hardwire.
>
> I updated the documentation to reflect this feature.
>
> Best regards,
>
> Erik.
>
>
> From: Lucas Aimaretto <laimaretto@xxxxxxxxx>
> Reply-To: "racktables-users@xxxxxxxxxxxxx" <racktables-users@xxxxxxxxxxxxx
> >
> Date: Wednesday, September 24, 2014 at 15:25
> To: "racktables-users@xxxxxxxxxxxxx" <racktables-users@xxxxxxxxxxxxx>
> Subject: [racktables-users] Re: CSV import plugin
>
> Hi Erik!
>
> So, I've tried your updated plugin and is working great! Now I can insert
> routers, link them together and assign IP addresses in one shot!
>
> This is an example script that I've tried and is working very nice!
>
> OBJECT;7;myRouterCN1;myRouterLB1;;1/1/[1-2];1204
> OBJECT;7;myRouterCN2;myRouterLB2;;1/1/[1-2];1204
> CABLELINK;myRouterCN1;1/1/1;myRouterCN2;1/1/2;
> IP;20.1.3.0/30;Link_network;TRUE;
> IP;20.1.3.4/30;Shared_network;TRUE;
> OBJECTIP;myRouterCN1;toCN2;20.1.3.1;point2point
> OBJECTIP;myRouterCN1;toCN2;20.1.3.5;shared
> OBJECTIP;myRouterCN2;toCN1;20.1.3.2;point2point
> OBJECTIP;myRouterCN2;toCN1;20.1.3.5;shared
>
> Just one thing to note: the type of the IP interfaces need to match any
> type within the output of the following query:
>
> select distinct type from IPv4Allocation;
>
> This output is then:
>
> virtual
> regular
> point2point
> shared
>
> ... because I've tried to create an IP interface of type 'point-to-point'
> and it didn't work (it was created as 'connected' if I would do so ...),
> but when I created it as 'point2point' (as in the script) it just worked
> perfect.
>
> I have to modify the hardwired inner interface and added the type 1204
> (1000BaseLX). There is no problem with this approach. The only thing that
> I'd require if possible is the possibility of using some other type of
> inner interface (other than hardwired) because some of our routers do
> support SFP ports. Do you think it is feasible to do it?
>
> In any case thank you very much for this plugin, it is just perfect so
> far!
>
> Regards!
>
> Lucas
>
>
> On Wed, Sep 24, 2014 at 7:28 AM, Erik Ruiter <erik.ruiter@xxxxxxxxxxx>
> wrote:
>
>> Hi Lucas,
>>
>> This is not difficult.
>> I just added the following:
>>
>> Importing Object IP interfaces
>>
>> Syntax: OBJECTIP; Objectname; OS Interface name; IP address; Type
>> Value 1, OBJECTIP
>> Value 2, Objectname: Specifies the name of the object
>> Value 3, OS Interface name: Specifies the name of the interface to be
>> added
>> Value 4, IP address: Specifies the ip address of the interface to b e
>> added (IPv4 or Ipv6) no subnet mask required
>> Value 5, Type: Chooses the type of interface to be added. Can be:
>> connected, loopback, shared, router, point-to-point. The default type is:
>> router
>>
>> Examples:
>>
>> OBJECTIP;myRouter;eth0;10.1.3.1;connected
>> Creates an IP interface name eth0, with address 10.1.3.1 and type
>> 'connected', which is added to the myRouter object.
>>
>>
>> Please try it and let me know if it works.
>>
>> Best regards,
>>
>> Erik.
>>
>>
>>
>> From: Lucas Aimaretto <laimaretto@xxxxxxxxx>
>> Reply-To: "racktables-users@xxxxxxxxxxxxx" <
>> racktables-users@xxxxxxxxxxxxx>
>> Date: Tuesday, September 23, 2014 at 22:39
>> To: "racktables-users@xxxxxxxxxxxxx" <racktables-users@xxxxxxxxxxxxx>
>> Subject: [racktables-users] Re: CSV import plugin
>>
>> Hi Erik,
>>
>> Very nice plugin! I'll give it a try right away. I do have tons of IP
>> subnets and VLANs to be imported into racktables.
>>
>> As far as I've seen, your script does support:
>> - importing objects;
>> - importing racks;
>> - assigning rackspaces;
>> - linking ports;
>> - importing vlans;
>> - importing IP spaces;
>>
>> Now, how difficult is it to implement the creation of interfaces with
>> their IP address into a router?
>>
>> Example:
>>
>> IPinterface;10.1.3.1;to_router_B;routerA;connected
>> Creates the IP interface called "to_router_B" of type "connected" within
>> "routerA" with IP address 10.1.3.1
>>
>> Thanks!
>>
>> Regards,
>>
>> Lucas
>>
>>
>> On Mon, Jul 14, 2014 at 6:17 AM, Erik Ruiter <erik.ruiter@xxxxxxxxxxx>
>> wrote:
>>
>>> Hi Olivier,
>>>
>>> Thanks for the feedback.
>>> Other formats would indeed be nice, but that would be a lot of work.
>>> For our internal usage there is not much need at the moment.
>>>
>>> Best regards,
>>>
>>> Erik.
>>>
>>>
>>> From: Olivier Contant <Olivier.Contant@xxxxxxxxxxxxxxxxx>
>>> Reply-To: "racktables-users@xxxxxxxxxxxxx" <
>>> racktables-users@xxxxxxxxxxxxx>
>>> Date: Friday, July 11, 2014 at 17:58
>>> To: "racktables-users@xxxxxxxxxxxxx" <racktables-users@xxxxxxxxxxxxx>
>>> Subject: [racktables-users] Re: CSV import plugin
>>>
>>> Thank you very much for this plugin.
>>>
>>> Maybe I could push you even more and ask you to support other format
>>> like json, xml, :)
>>>
>>> *Olivier Contant*
>>>
>>> System Administrator, Triton Digital
>>>
>>>
>>>
>>> 1440 Ste-Catherine W., Suite 1200 | Montreal, Qc, H3G 1R8
>>>
>>> +1.514.448.4037
>>>
>>> olivier.contant@xxxxxxxxxxxxxxxxx
>>> ------------------------------
>>> *From:* racktables-users-bounce@xxxxxxxxxxxxx [
>>> racktables-users-bounce@xxxxxxxxxxxxx] on behalf of Erik Ruiter [
>>> erik.ruiter@xxxxxxxxxxx]
>>> *Sent:* July 11, 2014 10:34 AM
>>> *To:* racktables-users@xxxxxxxxxxxxx
>>> *Subject:* [racktables-users] CSV import plugin
>>>
>>> Hi All,
>>>
>>> To make it easier to import objects and other things in Racktables, I
>>> built an CSV import plugin which enables loading batches of data.
>>> It adds an CSV import page on the configuration menu screen.
>>> From here you can choose to either import a CSV file, or paste some
>>> manual CSV lines in a textbox.
>>>
>>> The script currently supports importing of Objects, Racks, VLANs and
>>> IP space.
>>> It also supports linking ports, and assigning rackspace to objects.
>>>
>>> The syntax of the CSV formatting is explained in the source code of
>>> the plugin.
>>>
>>> I hope this might be useful to you. Feedback is very welcome of course.
>>>
>>> You can find the plugin at:
>>>
>>>
>>> https://github.com/sara-nl/racktables-contribs/blob/master/csv_import.php
>>>
>>>
>>> Best Regards,
>>>
>>> Erik Ruiter.
>>>
>>>
>>
>>
>> --
>> "Antes teníamos hambre y mirábamos el reloj para saber qué hora era.
>> Ahora miramos el reloj para saber si tenemos hambre." -- Ernesto Sábato
>>
>>
>
>
> --
> "Antes teníamos hambre y mirábamos el reloj para saber qué hora era. Ahora
> miramos el reloj para saber si tenemos hambre." -- Ernesto Sábato
>
>
Other related posts:
