• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Import host.csv not working or impatient

    Scheduled Pinned Locked Moved Unsolved
    FOG Problems
    4
    10
    2.2k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • J
      jquilli1
      last edited by

      Server
      • FOG Version: 1.3.0-RC-15
      • OS: Ubuntu 14.04
      Client
      • Service Version: 0.11.5
      • OS: Windows 10 Pro x64
      Description

      Importing host.csv doesn’t seem to be importing the whole list - or maybe I’m just impatient.
      I’ve downloaded our DHCP client list and only have the MAC, hostname, added image ID, and OSID. When
      I import the list only 5 or 6 clients are actually imported. The rest do not show up. There’s about 177 clients
      total.

      1 Reply Last reply Reply Quote 0
      • Wayne WorkmanW
        Wayne Workman
        last edited by

        Hosts don’t have an OSID. Try losing that field. You may also try loosing the image ID field too, it’s not necessary to have.

        The minimum you must have is two columns, MAC and hostname. First column is a MAC address, the second column is hostname. These are separated by a comma, and are not in quotes.

        The other stuff you can set as you need via the web interface.

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
        Daily Clean Installation Results:
        https://fogtesting.fogproject.us/
        FOG Reporting:
        https://fog-external-reporting-results.fogproject.us/

        1 Reply Last reply Reply Quote 0
        • J
          jquilli1
          last edited by

          @Wayne-Workman
          Still having issues with this.
          My excel spreadsheet looks like this:

          Column 1
          01:23:45:67:89:10

          Column 2
          Hostname

          I’m saving it as a .csv (comma delimited)
          It shows all hosts have imported successfully but will only import the same 6 hosts as before and no one else.

          1 Reply Last reply Reply Quote 0
          • J
            jquilli1
            last edited by

            @Wayne-Workman
            Nevermind it was user error obviously.
            The hostnames were way too long and weren’t being imported.

            Any chance an error can be thrown in stating that hostnames are too long instead of showing import successfully?
            Thanks for the help btw!

            Wayne WorkmanW 1 Reply Last reply Reply Quote 0
            • Wayne WorkmanW
              Wayne Workman @jquilli1
              last edited by

              @jquilli1 said in Import host.csv not working or impatient:

              Any chance an error can be thrown in stating that hostnames are too long instead of showing import successfully?

              I’d like to tell you no because FOG is in release candidate mode, which means bug fixes only. Also should fog throw an error if you’re importing… say 5,000 hosts and one of them is messed up? I want my import of 4,999 computers to go through so I can work. Plus again, release candidate mode.

              It’s up to @Tom-Elliott

              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
              Daily Clean Installation Results:
              https://fogtesting.fogproject.us/
              FOG Reporting:
              https://fog-external-reporting-results.fogproject.us/

              1 Reply Last reply Reply Quote 0
              • Tom ElliottT
                Tom Elliott
                last edited by

                The idea of the import is to pull in what can be imported. Those that are invalid are simply skipped. The message should show x number of success vs. x number of failed though, is this not happening?

                Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                J 1 Reply Last reply Reply Quote 0
                • J
                  jquilli1 @Tom Elliott
                  last edited by

                  @Tom-Elliott
                  It would show 177 imported. It would throw an error for a few but I know what’s wrong with those ones in the .csv already. So in a way it’s spitting out errors like “not valid mac address”.

                  Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                  • Wayne WorkmanW
                    Wayne Workman @jquilli1
                    last edited by Wayne Workman

                    @jquilli1 If you don’t mind, you could post the file here via google drive or mega or something like that. You could also email it to one of us. I’m going to be busy for a while, message Tom.

                    Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                    Daily Clean Installation Results:
                    https://fogtesting.fogproject.us/
                    FOG Reporting:
                    https://fog-external-reporting-results.fogproject.us/

                    1 Reply Last reply Reply Quote 0
                    • Tom ElliottT
                      Tom Elliott
                      last edited by

                      I’m an even worse candidate. I can’t do anything until I get home.

                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                      1 Reply Last reply Reply Quote 0
                      • Q
                        Quazz Moderator
                        last edited by

                        I’d just like to chime in and discourage using Excel to save csv files.

                        It tends to fuck up formatting, save large numbers in scientific notation and so forth.

                        1 Reply Last reply Reply Quote 1
                        • 1 / 1
                        • First post
                          Last post

                        276

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project