Skip to Content
Main Content

3 Minute Read | January 13, 2022

How Titan CMS Helps Streamline Data Management

Use the Data Import/Export Feature to Save Time and Increase Efficiency

Titan CMS facilitates the import and export of data throughout your website. From data nodes to file piles, Titan CMS can quickly download and help organize data.

How the Titan CMS Import/Export Feature Works

Titan CMS' import/export feature eliminates the need to download files individually or edit them manually.

Navigate to the data node/file pile/content site from which you want to pull data. Once in the node, note the download icon on the far right. Clicking on that icon prompts Titan to download an XLS file.

Image showing the export function in Titan CMS admin

Now you’re ready to organize and/or revise data. You can fully edit and customize this file in Excel, and you can make unlimited changes in every field, from names to metadata.

After editing is complete, easily upload the file back into Titan CMS. New in Titan CMS 7: the data upload feature is compatible with .xlsx, .csv, .txt, .xml and .ics file types. Note: If you make a lot of changes to your data, we recommend testing it before permanently uploading to allow you to see how many records succeeded or failed.

Image of the Upload Content window in Titan CMS admin

If the test is successful, we recommend using the Add and Update All selection, with Skip Workflow selected. This simply updates all records, instead of making a new copy and adding it to the files in the system.

Titan CMS Import/Export Feature Use Cases

Titan CMS customers implement the import/export feature to make bulk changes and save hours of work. Some very light HTML is the only skill needed. Here are just some of the ways our customers use import/export: 

Customer Data

For product-based sites, data import and export can be especially handy. It saves time in making bulk price changes and adjusting product quantities, without needing to click through to each product node.

Calendars

Editing and updating calendars can sometimes be tedious. With Titan CMS, you can upload a .ics file directly to a data node or download the current calendar event data node and make bulk changes. You can modify any of the data, including times and event names, and more.

Documentation Sites

Help sites often require big changes all at once – editing teaser text is just one example. Rather than manually edit teaser text on every page/data node, the import/export feature allows you to download the data and make bulk edits in an Excel file. Note: If you add imagery from a file pile, take care to ensure consistent and correct URL pathways.

Metadata

Do you have several teaser texts to update? Did you forget to add metatag descriptions? No problem. The Titan CMS import/export feature allows you to pull metadata for an entire data node or site, quickly update, remove, or add new metadata, then save the file and import it back to Titan CMS. Just like that, you’ve saved hours of manual updates to all the metadata across your site. Metadata continues to play a critical role for effective on-site search results, and with Titan CMS you can easily see all pertinent information and make changes in one spot instead of having to access individual pages and files.

Whether you have a small website or one with hundreds of pages, Titan CMS’ import/export feature saves time and improves accuracy.

For more detailed information about how to complete the import/export process, visit our Documentation section.

 

393726/Blog/How-Titan-CMS-Helps-Streamline-Data-ManagementUse the Data Import/Export Feature to Save Time and Increase Efficiency3
<p>Titan CMS facilitates the import and export of data throughout your website. From data nodes to file piles, Titan CMS can quickly download and help organize data.</p> <h2>How the Titan CMS Import/Export Feature Works</h2> <p>Titan CMS&#39; import/export feature eliminates the need to download files individually or edit them manually.</p> <p>Navigate to the data node/file pile/content site from which you want to pull data. Once in the node, note the download icon on the far right. Clicking on that icon prompts Titan to download an XLS file.</p> <p><img alt="Image showing the export function in Titan CMS admin" loading="lazy" src="/Titan-CMS-20211/Industry-Insights/Blog-Images/Import-Export-1.jpg?Large" /></p> <p>Now you&rsquo;re ready to organize and/or revise data. You can fully edit and customize this file in Excel, and you can make unlimited changes in every field, from names to metadata.</p> <p>After editing is complete, easily upload the file back into Titan CMS. New in Titan CMS 7: the data upload feature is compatible with .xlsx, .csv, .txt, .xml and .ics file types. Note: If you make a lot of changes to your data, we recommend testing it before permanently uploading to allow you to see how many records succeeded or failed.</p> <p><img alt="Image of the Upload Content window in Titan CMS admin" loading="lazy" src="/Titan-CMS-20211/Industry-Insights/Blog-Images/Import-Export-2.jpg?Large" /></p> <p>If the test is successful, we recommend using the Add and Update All selection, with Skip Workflow selected. This simply updates all records, instead of making a new copy and adding it to the files in the system.</p> <h2>Titan CMS Import/Export Feature Use Cases</h2> <p>Titan CMS customers implement the import/export feature to make bulk changes and save hours of work. Some very light HTML is the only skill needed. Here are just some of the ways our customers use import/export:&nbsp;</p> <h3>Customer Data</h3> <p>For product-based sites, data import and export can be especially handy. It saves time in making bulk price changes and adjusting product quantities, without needing to click through to each product node.</p> <h3>Calendars</h3> <p>Editing and updating calendars can sometimes be tedious. With Titan CMS, you can upload a .ics file directly to a data node or download the current calendar event data node and make bulk changes. You can modify any of the data, including times and event names, and more.</p> <h3>Documentation Sites</h3> <p>Help sites often require big changes all at once &ndash; editing teaser text is just one example. Rather than manually edit teaser text on every page/data node, the import/export feature allows you to download the data and make bulk edits in an Excel file. Note: If you add imagery from a file pile, take care to ensure consistent and correct URL pathways.</p> <h3>Metadata</h3> <p>Do you have several teaser texts to update? Did you forget to add metatag descriptions? No problem. The Titan CMS import/export feature allows you to pull metadata for an entire data node or site, quickly update, remove, or add new metadata, then save the file and import it back to Titan CMS. Just like that, you&rsquo;ve saved hours of manual updates to all the metadata across your site. Metadata continues to play a critical role for effective on-site search results, and with Titan CMS you can easily see all pertinent information and make changes in one spot instead of having to access individual pages and files.</p> <p>Whether you have a small website or one with hundreds of pages, Titan CMS&rsquo; import/export feature saves time and improves accuracy.</p> <p><em>For more detailed information about how to complete the import/export process, visit our <a href="https://titancms.com/Documentation/ImportExport-Data.htm" linktype="3" target="_self">Documentation</a> section.</em></p> <p>&nbsp;</p>
Titan CMS Team/Titan-CMS-20211/People/Titan-CMS-Team-Logo.jpg/Titan-CMS-20211/Industry-Insights/Titan-CMS-ImportExport-Feature---Open-Graph.jpg?LargeHow Titan CMS Helps Streamline Data Management2022-01-13T10:28:41.230Titan CMS' data import/export feature eliminates the need to download files individually or edit them manually. Here's how it works.Add-In Type - NWS Data ModulesCategory - NWS Data ModulesCommittee - NWS Data ModulesDivision - NWS Data ModulesEvent Audience - NWS Data ModulesEvent Service - NWS Data ModulesEvent Type - NWS Data ModulesLocality - NWS Data ModulesModule - NWS Data ModulesNWS Data ModulesTopic - NWS Data ModulesFeatures and FunctionalityTips and TricksPackage Type - NWS Data ModulesPersonID - NWS Data ModulesTitan CMS TeamProductVersion - NWS Data ModulesRecorded Webinar TopicsRegion - NWS Data ModulesSite Display - NWS Data ModulesTitan CMSSkillLevel - NWS Data ModulesTopic - NWS Data ModulesVideoAudience - NWS Data ModulesVideoClassification - NWS Data ModulesVideoStatus - NWS Data Modules02022-01-13T12:25:20.14300