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



  • 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



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


  • Moderator

    @Tom-Elliott #wiki worthy


  • Senior Developer

    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,,


  • Moderator

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


Log in to reply
 

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.