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

    Headers for CSV files for 'Hosts' and 'Images' import...

    Scheduled Pinned Locked Moved
    General
    5
    6
    4.1k
    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.
    • S
      SAmps
      last edited by

      Where can I find the headers for the CSV files that I export from the ‘Export Images’ and ‘Export Hosts’ menu items?

      I am in the situation that I have had to install anew without a backup but have a large collection of Partclone images made with FOG 1.2.0 that I would like to import, so I need to know what fields are necessary to include in a .CSV file for uploading.
      Same goes for the headers of the upload file for hosts.

      FOG is v1.3.5 SVN 6067

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

        Create a dummy image and host, export as csv and use those as templates.

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

          Hosts require two fields at minimum.

          MACAddressListSeparatedWithPipe,Hostname

          So the way it might look with a single mac would be:
          00:00:01:01:02:02,SomeHostname

          With multiple macs it may look like:
          00:00:01:01:02:02|00:00:01:01:02:03,SomeHostname

          For all other elements it’s based on the fields required to store the item which can be found in the respective class.

          In the case of images you would have:

          Name, Description, Path, created time, created by, building, size, imageTypeID, imagePartitionTypeID, osID, size, captured date, format, magnet, protected, compress, isEnabled, to replicate, server size,

          Required fields are:
          Name, Path, imagetypeID, osID

          So a valid image csv with only required information would be:
          somename,,basepathofimagefile-folder,,,,,1,,5

          Of course if you wanted to use it right away you might have:
          somename,,basepathofimagefile-folder,,,,,1,,5,,,,,,1,1,,

          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

          Wayne WorkmanW 1 Reply Last reply Reply Quote 3
          • Wayne WorkmanW
            Wayne Workman @Tom Elliott
            last edited by

            @Tom-Elliott #wiki worthy

            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 1
            • S
              SAmps @Quazz
              last edited by

              @Quazz I did!
              Problem is that the exported CSV files don’t have headers either and there’s plenty of room for disambiguation. The parameters in the CSV files are not in the order they appear in the GUI either.

              I DID get a fair way by changing various parameters in the GUI, re-export, and then compare where the changes show up in the CSV files. I reckon that Tom Elliott has just given me what I need to finish it.

              Thanks to both of you!

              1 Reply Last reply Reply Quote 0
              • M
                mtn038
                last edited by

                I’m having a problem where my Ubuntu desktop freezes and I restore it from a back up. When I do that it does not sync with my /images/ folder where all of my images are. I’ve created my own CSV file to upload into fog, however, I’m running into the problem of figuring out the size and server size, so what goes into column G and R. If someone can help me figure out those two pieces of information from the images I already have I would appreciate it. Thank you.

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

                166

                Online

                12.0k

                Users

                17.3k

                Topics

                155.2k

                Posts
                Copyright © 2012-2024 FOG Project