Menu

#111 CSV/XLS import of subnets

Next_Release
open
None
1
2021-02-11
2013-04-03
Anonymous
No

Would like to request the ability to import subnets as well as hosts (I know host import is already a feature).

Related

Feature Requests: #111

Discussion

  • Braulio Cifuentes

    Hi,

    I'm thinking to move from IPPlan to phpIPAM, but I have dozens of subnets and it would be a lot of work for me to create all of them again.

    I think the ability to import subnets, besides IP addresses descriptions, would be a very important feature that would to add more users to this fantastic program.

    Thx.

     
  • Sebas

    Sebas - 2013-11-26

    I agree, using ipplan atm too. But import is a requirement.

    Awesome tool btw !

     
  • Miha Petkovsek

    Miha Petkovsek - 2013-11-27

    Hi, thanks. Yes, this can be tricky, I usually write custom parser to migrate from one system to another. Maybe import from ipplan directly would be an option? Have to look into that...

    brm

     
  • Anonymous

    Anonymous - 2013-12-11

    Any news on import from .xls subnet to phppipam ?

    What about at feature/section for device management , so username/password could be assigned to devices (would like to do asset management also..)

     
  • Anonymous

    Anonymous - 2013-12-18

    Hi, we're also considering moving to phpIPAM however we have thousands of subnets deployed (our network has over 900 sites with multiple subnets per site) so manually creating subnets is not really practical for us. We'd love a subnet import function OR to maybe know the phpIPAM DB schema so our DBA's can develop a script to munge our existing (exported) records into phpIPAM format, so they can be directly dropped into the phpIPAM DB. cheers Tony

     
  • Anonymous

    Anonymous - 2013-12-27

    the ability to import excel and populate or match or create custom fields would be really a great feature for the application nice work

     
  • Anonymous

    Anonymous - 2014-02-11

    Simply importing from CSV would be amazing

     
  • Eric Magutu

    Eric Magutu - 2014-02-22

    Hi,
    Is there a work around for this? I have a bunch of information including subnets in CSV format an would like to import it into phpIPAM. Please advise on how this can be accomplished.

     
  • Anonymous

    Anonymous - 2014-02-27

    Me too would need this feature. Any info on how to accomplish this will be greatly appreciated.

     
  • Anonymous

    Anonymous - 2014-03-12

    Hi guys, i want to move from gestio to phpipam, but i can't imput again more than 500 subnet.
    Do you have a script to import subnets from an excel or csv file?
    Kind Regards
    Alberto

     
  • zdor

    zdor - 2015-03-05

    just started using phpipam and we need to import 500 ipv4 subnets. so this feature would be very welcome. or is there script that allows to that?
    Thanks

     
  • Anonymous

    Anonymous - 2015-03-06

    How is it going with this feature? I think if you only support import from xls/csv should be good enough. I guess almost anybody can export his networks into some form.

     
  • zdor

    zdor - 2015-03-06

    we finally managed to import our subnets by inserting directly into mysql. luckily the subnets are defined within a single table. just make sure to correctly link subnet id to correct parent subnet id.

     
    • Anonymous

      Anonymous - 2015-03-27

      Hello
      I am trying to do it in the same way. However i didn't manage to import subnets as i don't understand how the information of the field "subnet" is converted to be transformed from 10.x.x. to 1254568...
      Can you help ?

       
  • Anonymous

    Anonymous - 2015-03-06

    could import subnet and Vlans form a csv?

     
  • Benoit Lambert

    Benoit Lambert - 2015-07-24

    You can't import directly into MySQL because the "sunbet" and "ip_addr" fields aren't in IP address/mask format. They are stored as a 9 digit log number. You would need to change formats but I have no idea how to do that.

     
  • Anonymous

    Anonymous - 2015-09-16
    Post awaiting moderation.
  • Anonymous

    Anonymous - 2015-09-16
    Post awaiting moderation.
  • Anonymous

    Anonymous - 2016-03-16
    Post awaiting moderation.
  • Peter Tzekov

    Peter Tzekov - 2021-02-10

    Hi everyone,
    Thanks for that very useful app!
    I'm using phpipam 1.4.2 and have to migrate thousands of subnets. :)
    Is there any way with the available tool for automatic subnets import via XLS/CSV file template, together with the fields "vlan", "vrf", "description" ..., to be possible importing the respective "Customer" field?
    Thank You in advance !

     

Anonymous
Anonymous

Add attachments
Cancel





Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.