Import and Export from Pages and Content

The Import and Export tool has been for getting bulk data into and out of Pages and Content.  It allows multiple pages, modules, content, and linked content to be exported and re-imported easily and reliably.

This will allow for mass-import and export to and from Agility that includes Linked Content, which previous imports did not allow for.

This is a major benefit for folks who wish to do translations from an export of an existing locale, or for those wishing to do a manual find/replace of text in many places throughout the system. 

There are two formats available to be Exported and Imported in: 

  1. A "horizontal" version of the content where each field is represented in a column, and each content type is represented on different Excel Worksheets, similar to database tables.
  2. A "vertical" version of the content, suitable for translation scenarios, where the content is represented in 5 columns:
    • Type
    • ID
    • FieldName
    • FieldValue
    • TranslatedFieldValue

Imported data can now be copied from a previous locale so that only certain values need to be updated, and other values will be pulled from the previous version of the item.

Please note:
There are 2 new columns that need to be on every Excel file to Agility to handle linked content, pages, modules, etc, all in the same file.

The column names are: 

  •  Agility_ContentID  -  the ContentID an existing item. If you want to import new items, it can be blank 
  •  Agility_ContainerName  -  the reference name of the list to import into

 

An Export In Progress

expotwait.PNG

The All-New Import

import222.PNG

 

 

4 out of 5 found this helpful

Comments

3 comments
  • Is it possible to get step by step instructions on the import process using a template for translation? I've attempted the import process using the vertical style template and have had no luck.

    thanks!

     

    0
    Comment actions Permalink
  • How to import new item?

    1
    Comment actions Permalink
  • Hello @Chu Nguyen,

    The easiest way to import a new item is to:

    1. Export the content list you wish to add a new item to as an Excel file
    2. Open the Excel file, and add a new row filling out the content for the new item you wish to add.
    3. Save and re-import the excel file into the content list, selecting the Import From Language, Import To Language, and the Excel File itself.

    It is important to note that there are 2 new mandatory columns that need to be on every Excel file in order to import in Agility:

    - Agility_ContentID - this is the ContentID of an existing item. If you are importing new items, the value can be blank or set to -1.

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

    Check out this article for more information: https://help.agilitycms.com/hc/en-us/articles/360019537551-Getting-Started-Import-Content

    0
    Comment actions Permalink

Please sign in to leave a comment.