• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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 Oct 24, 2016, 7:33 PM

    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
    • W
      Wayne Workman
      last edited by Oct 24, 2016, 7:50 PM

      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 Oct 25, 2016, 12:08 PM

        @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 Oct 25, 2016, 12:12 PM

          @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!

          W 1 Reply Last reply Oct 25, 2016, 12:15 PM Reply Quote 0
          • W
            Wayne Workman @jquilli1
            last edited by Oct 25, 2016, 12:15 PM

            @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
            • T
              Tom Elliott
              last edited by Oct 25, 2016, 12:29 PM

              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 Oct 25, 2016, 12:45 PM Reply Quote 0
              • J
                jquilli1 @Tom Elliott
                last edited by Oct 25, 2016, 12:45 PM

                @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”.

                W 1 Reply Last reply Oct 25, 2016, 12:51 PM Reply Quote 0
                • W
                  Wayne Workman @jquilli1
                  last edited by Wayne Workman Oct 25, 2016, 6:52 AM Oct 25, 2016, 12:51 PM

                  @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
                  • T
                    Tom Elliott
                    last edited by Oct 25, 2016, 12:52 PM

                    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 Oct 25, 2016, 2:18 PM

                      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
                      1 / 1
                      • First post
                        3/10
                        Last post

                      309

                      Online

                      12.0k

                      Users

                      17.3k

                      Topics

                      155.2k

                      Posts
                      Copyright © 2012-2024 FOG Project