- Bulk Editor
- Feed Importer
- Offline Importer
- External Link Checker
There are various pages or folders available within the
Table 15. Functions available within the Tools tab
|Page or Folder||DescriptionBlu|
|Blueprints||Blueprints are used to create as many Live Copies as necessary.|
Holds the list of designs defined, including the graphics and css files to be used.
|Form Submissions||Holds the list of form submissions received.|
|Bulk Editor||Lets you search for items and edit them in bulk. You can also export and import content (in bulk) into the repository.|
|Offline Importer||The offline importer enables you to import content from MS Word documents generated offline.|
|Feed Importer||Lets you import content from external web sources, which is regularly polls for new and updated content. For example, use the feed importer to import events from other web-based calendars into your CQ WCM calendars.|
Lets you specify the URL of a Communiqué 3 or 4 instance from within a new CQ5 instance. The content and basic functionality will then be upgraded and imported into your new CQ5 installation. The upgrade of customized functionality cannot be guaranteed and must be analyzed individually.
For further information see Chapter 4, Upgrading to CQ5.
|External Link Checker||Scans all content pages within your CQ instance and checks any external links. A list of valid and invalid links displays.|
|Newsletter||Lets you notify users of newsletter updates or content changes.|
|Packages||Shows the packages that have been loaded for CQ WCM. Similar to the information shown in CRX's Package Manager.|
|Account Manager||Shows account management information, such as the emails sent to reset passwords, and so on.|
|Tags||Lets you manage tags.|
The Bulk Editor lets you search for and edit content from multiple
pages simultaneously. In addition, you can export content into the
repository using the bulk editor functionality. (Using the Product
Listing component, you can also import content into the repository, but
this is disabled for the Bulk Editor available in the
This section describes how to work with the bulk editor in the
Tools menu. Typically, administrators use the
bulk editor to search and edit multiple items by populating the table
using a GQL query and then by selecting the content items to work on.
Users generally use the bulk editor as part of a customized bulk editor
application accessible through the product listing component. See product listing. The Bulk
Editor allows for very efficient editing when the visual page context is
The Bulk Editor lets you do the following:
Search for items using GQL (Google Query Language)
Make changes to content items directly in the bulk editor to any of those items and save those changes.
Export the results into a tab-separated (.tsv) spreadsheet file.
(Product Listing Component only) Import content from a .tsv spreadsheet file.
For example, if you need all the names and email addresses of users who filled out a particular survey, the Bulk Editor can provide that information and you can export it into a spreadsheet.
An example of such a use case is included in the Geometrixx web site:
Navigate to the Support page and then to the Customer Service Satisfaction survey.
Start Formparagraph, click the
Action Configurationtab and then click
In this case, the bulk editor does not allow users to edit the content but only lets them export the information to a spreadsheet. The Bulk Editor is fully customizable.
This section describes how to use the bulk editor and includes procedures for searching for and editing multiple content using the bulk editor, and exporting and importing content from a tab-separated spreadsheet.
To use the bulk editor to edit multiple items simultaneously:
Toolstab, click the
Importersfolder to expand it.
Bulk Editorto open it.
Table 16. Bulk Editor Properties
Field Property Root Path Indicates the root path the bulk editor searches. For example,
/content/geometrixx/en. The bulk editor searches over all child nodes.
Query Parameters Using GQL parameters, enter the search string you want the bulk editor to look for in the repository; for example,
type:Pagelooks for all pages in the root path,
text:professionallooks for all pages that have the word "professional" in them, and
"jcr:title":Englishlooks for all pages that have "English" as the title. You can only search for strings.
Content Mode check box Select this check box to read properties within the
jcr:contentsub node of the search results if exists. Use for pages only. Property names are prefixed with
Properties/Columns Select the check boxes for the properties that you want the bulk editor to return. The properties you select are the column heads in the results pane. By default, the node path is displayed in the results. Custom Properties/Columns Enter any other properties that are not listed in the
Properties/Columnsfield. These custom properties appear in the results pane. You can add multiple properties by using a comma to separate properties. Note: If you add a custom property that does not yet exist, CQ WCM displays an empty cell. When you modify the empty cell and save it, the property is added to the node. The newly created property must respect node type constraints and property namespaces.
Enter information in the fields, as appropriate. See the previous table for more information.
Search. The Bulk Editor returns all the pages that meet your search criteria and displays them with the requested columns.
Make any changes you would like to directly into any of the columns by double-clicking in the cell.
Saveto save your changes.
You may need to export content and make changes to it in an Excel spreadsheet. For example, you may want to export a mailing list and change the area code of all the listed phone numbers directly in Excel, add additional lines, and so on.
To export content:
Search for content as described in the section called “How to Search For and Edit Multiple Content Using the Bulk Editor”
Exportto export the changes into a tab-separated Excel spreadsheet. CQ WCM asks you where you want to download the file.
Select the location and confirm that you want to download the file.
After you download the file, you can open it from your spreasheet program, for example, Microsoft Excel. The spreadsheet program imports the file and converts it to a spreadsheet format.
Importing is not available in the Bulk Editor Tool but only through the customized product listing component, which uses the bulk editor as its basis. You can import content from any tab-separated (.tsv) file. In order for importing to work properly, the column headings (first row of cells) must match the column headings of the table you're importing to.
When you re-import content, you erase any previous content for those nodes. Be careful not to overwrite important information.
To import content:
Either create a product listing paragraph or open an existing one. The product listing paragraph is not enabled by default. To enable it, see the section called “Developing Components”.
In the product listing component, you see the list of existing information.
CQ WCM asks you to navigate to the file you want to import. Navigate to the
.tsvfile and click
OK. The infomation is added to the product listing paragraph.
OKto see the changes listed on the page.