• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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 Mar 27, 2017, 12:16 AM

    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 Mar 27, 2017, 4:31 AM Mar 27, 2017, 10:30 AM

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

      S 1 Reply Last reply Mar 27, 2017, 10:34 PM Reply Quote 1
      • T
        Tom Elliott
        last edited by Tom Elliott Mar 27, 2017, 6:55 AM Mar 27, 2017, 12:55 PM

        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

        W 1 Reply Last reply Mar 27, 2017, 1:15 PM Reply Quote 3
        • W
          Wayne Workman @Tom Elliott
          last edited by Mar 27, 2017, 1:15 PM

          @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 Mar 27, 2017, 10:34 PM

            @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 Sep 13, 2017, 8:40 PM

              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

              206

              Online

              12.0k

              Users

              17.3k

              Topics

              155.2k

              Posts
              Copyright © 2012-2024 FOG Project