Importing and Exporting | Agility CMS Docs

Importing and Exporting

The Import and Export tool is great for getting bulk data into and out of the Content (area) and Pages (area). It allows for content to be exported and re-imported easily and reliably. 

Exporting Content

There are two types of formats that you can export: Regular and Translation.

Regular Format

This format will display all your exported website data content where each content type is represented on different Excel Worksheets, similar to database tables.

Translation Format

This format will allow you to easily make translation changes to your copy.

To export content, click on the Export Button:

Select your Format:

If exporting for Translation, the TranslatedValue column is where you can enter your copy in a different language, eg. FR. You can then import the formatted excel document into Agility with the newly, translated values.

Importing Content

To begin Importing Content, first export the Content List you would like to work on.

Using your Export, update/enter any new content you would like to add.

Note

The Agility_ContentID and Agility_ContainerName columns are required for import.

Agility_ContentID - This is the ContentID of an existing item. If you are importing new items, the value can be blank.

Agility_ContainerName - This is the reference name of the list to import into.

Once you have saved your Import and its changes, click on the Import Button:

Select your Import From Language and the Import To Language.

Import From

This is the original language from which you are importing from.

Import To

This is the language where you are you Importing into.

Choose your file, then click Import:

Importing Content that contains Child Content

Agility offers you the ability to import and export content via Excel, however, it is also important to note that you are also able to import and export child content. Let’s look at how this can be done. 

As an example, here is a list of Properties (Content List), that can contain Linked Content to another Content List named Spaces

Under Shared Content, I created 3 new Properties in our Property list: 

However, I did not add any Spaces to any of the Properties yet, I'll export these Properties to an Excel file, add Spaces to our Properties, then import back the Excel file. 

 Click on Export, export for Regular Format, then download the file. When we open the Excel file, we’ll see the information about our Properties: 

Some important values to note here would be the ones in our “Spaces” column. This is the Reference Name for our Linked Content and we will use these to attach the Spaces to Properties (i.e. Spaces for the Agility Large Property will use Properties_Spaces and Spaces for the Agility Small Property will use Properties_Spaces39). 

We can add a new sheet to this Excel file named “Spaces” and fill out some important information we’ll need to be able to import these spaces and link them to its respective Property: 

Agility_ContentID & Agility_VersionID: These do not require values as Agility will populate these upon import. 

Agility_LanguageCode: Required Field. 

Agility_State: May be set to Staging or Published depending on your use case. 

Agility_ContainerName: This will be relating to the important values or “Reference Names” we mentioned earlier:

  • To add Spaces to the Agility Large Property, we’ll use Properties_Spaces
  • To add Spaces to the Agility Medium Property, we’ll use Properties_Spaces38
  • To add Spaces to the Agility Medium Property, we’ll use Properties_Spaces38

 Title: This is just a Text Field set up to describe the Space and will be different depending on your use case. 

We can save our Properties & Spaces sheets, export it, and head back into the Agility dashboard to import our new data. Head to Properties under Shared Content and import our updated Excel file. 

Once complete we can select a Property from our list and see the new Spaces we’ve created and imported: