Create Imagen XML in Excel 👩‍🎓

Learn how to convert your Excel spreadsheet into structured data XML that can be used to import records into Imagen

The first step towards exporting XML from Excel is to establish your Imagen XML schema. This will follow the same structure in most cases, but the field nodes will vary depending on your record schema. As an example:

 <Records>
    <ImagenRecord>
        <Fields>
            [Your Imagen record fields go here]
        </Fields>
    </ImagenRecord>
 <Records>

If you wish to Import media along with data, the structure will look like this:

<?xml version="1.0" encoding="UTF-8"?>
<Records>
   <ImagenRecord>
      <Fields>
           [Your Imagen record fields go here]   
      </Fields>
      <MediaObject Version="3" ID="-1" MediaType="[Your media type goes here]" IsClip="">                                                                          
         <MediaElement MediaType="[Your media type goes here]" Index="0" Umid=""> 
            <OriginalFile>[HTTP(s) path to file goes here]</OriginalFile>
         </MediaElement>
      </MediaObject>
   </ImagenRecord>
</Records>

If your spreadsheet is to be used to update records, the record number will be specified as an attribute like so:

<?xml version="1.0" encoding="UTF-8"?>
<Records>
   <ImagenRecord ID="[Your record number goes here]">
      <Fields>
           [Your Imagen record fields go here]   
   </Fields>
 </ImagenRecord>
</Records>

Any of the XML elements shown in the examples can be mapped to columns in your Excel spreadsheet. 

Now we have our import XML, we can use the XML import widget to create new records. The Imagen API can also be used to pass this XML and create new records.