- Administering User Guide overview
- Sites Features
- Website Administration
- Asynchronous Jobs
- Reusing Content: Multi Site Manager and Live Copy
- Live Copy Overview Console
- Configuring Live Copy Synchronization
- Creating and Synchronizing Live Copies
- MSM Rollout Conflicts
- Troubleshooting MSM Issues and FAQ
- MSM Best Practices
- Translating Content for Multilingual Sites
- Managing Translation Projects
- Identifying Content to Translate
- Preparing Content for Translation
- Creating a Language Root Using the Classic UI
- Connecting to Microsoft Translator
- Configuring the Translation Integration Framework
- Language Copy Wizard
- Translation Enhancements
- Translation Best Practices
- Configurations and the Configuration Browser
- AEM FAQs
- Operations
- Dashboards
- Operations Dashboard
- Backup and Restore
- Data Store Garbage Collection
- Monitoring Server Resources Using the JMX Console
- Working with Logs
- Audit Log Maintenance in AEM 6
- Configure the Rich Text Editor
- Configuring RTE for Producing Accessible Sites
- Configuring Undo for Page Editing
- Configure the Rich Text Editor plug-ins
- Configure the Video component
- The Bulk Editor
- Configuring Email Notification
- The Link Checker
- Troubleshooting AEM
- Managing Access to Workflows
- Starting Workflows
- Administering Workflows
- Administering Workflow Instances
- Using cURL with AEM
- Proxy Server Tool (proxy.jar)
- Configuring for AEM Apps
- Configuring Search Forms
- Tools Consoles
- Reporting
- Configuring Layout Container and Layout Mode
- Editor
- Enabling Access to Classic UI
- Admin Consoles
- Security
- User Administration and Security
- User, Group and Access Rights Administration
- Security Checklist
- OWASP Top 10
- Running AEM in Production Ready Mode
- Identity Management
- Adobe IMS Authentication and Admin Console Support for AEM Managed Services
- Creating a Closed User Group
- Mitigating serialization issues in AEM
- User Synchronization
- Encapsulated Token Support
- Single Sign On
- How to Audit User Management Operations in AEM
- SSL By Default
- SAML 2.0 Authentication Handler
- Closed User Groups in AEM
- Granite Operations - User and Group Administration
- Enabling CRXDE Lite in AEM
- Configuring LDAP with AEM 6
- Configure the Admin Password on Installation
- Service Users in AEM
- Encryption Support for Configuration Properties
- Handling GDPR Requests for the AEM Foundation
- Principal View for Permissions Management
- Content Disposition Filter
- Custom User Group Mapping in AEM 6.5
- Same Site Cookie Support
- Personalization
- Integration
- Integrating with Third-Party Services
- Integrating with Salesforce
- Integrating with Adobe Target
- Integrating with Adobe Learning Manager
- Integrating with Adobe Analytics
- Connecting to Adobe Analytics and Creating Frameworks
- Configuring Link Tracking for Adobe Analytics
- Mapping Component Data with Adobe Analytics Properties
- Configuring Video Tracking for Adobe Analytics
- Integration with Adobe Analytics using IMS
- HTTP2 Delivery of Content FAQ
- Troubleshooting your Adobe Campaign Integration
- SharePoint Connector Licenses, Copyright Notices, and Disclaimers
- SharePoint Connector
- DHTML Viewer End-of-Life FAQs
- Integrating with Adobe Campaign Classic
- Related Community Articles
- Integrating with Adobe Campaign Standard
- Flash Viewers End-of-Life Notice
- Integrating with Adobe Dynamic Tag Management
- Opting Into Adobe Analytics and Adobe Target
- AEM Portals and Portlets
- Integrating with Dynamic Media Classic (Scene7)
- AEM Livefyre Recipes
- Troubleshooting Integration Issues
- Integrating with BrightEdge Content Optimizer
- Catalog Producer
- Integrating with Silverpop Engage
- Integrating with Adobe Campaign
- Integrating with ExactTarget
- Analytics with External Providers
- Integrating with the Adobe Marketing Cloud
- Manually Configuring the Integration with Adobe Target
- Prerequisites for Integrating with Adobe Target
- Integration with Adobe Target using IMS
- Adobe Classifications
- Solutions Integration
- Exporting Experience Fragments to Adobe Target
- Best Practices for Email Templates
- Integrating with Livefyre
- Best Practices
- Content Management
The Bulk Editor
The Bulk Editor allows for efficient editing when the visual page context is not needed as it lets you:
- search for (and display) content from multiple pages; this is done using GQL (Google Query Language)
- edit this content directly in the Bulk Editor
- save the changes (to the originating pages)
- export this content to a tab-separated (.tsv) spreadsheet file
You can also import content into the repository, but by default this is disabled for the Bulk Editor as available in the Tools console.
This section describes how to work with the Bulk Editor in the Tools console. Typically, administrators use the Bulk Editor to search and edit multiple items. This is done by populating the table using a GQL query and then by selecting the content items to work on. Authors generally use the Bulk Editor as part of a customized Bulk Editor application accessible through the product listing component.
With the deprecation of the Classic UI in AEM 6.4, the Bulk Editor has also been deprecated and thus Adobe does not plan to further enhance the Bulk Editor.
Example Use Case for the Bulk Editor
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 to illustrate such a use case is included in the Geometrixx web site:
-
Navigate to the Support page and then to the Customer Service Satisfaction survey.
-
Edit the Start of Form paragraph. In the dialog box, click the Advanced tab, expand the Action Configuration, then click View Data….
-
The Bulk Editor is fully customizable, though in this example the Bulk Editor does not allow users to edit the content, but only lets them export the information to a spreadsheet.
How to Use the Bulk Editor
The Bulk Editor lets you:
Searching and Editing Content
To use the Bulk Editor to edit multiple items simultaneously:
- In the Tools console, click the Importers folder to expand it.
- Double-click the Bulk Editor.
- Enter your selection requirements:
| 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:Page looks for all pages in the root path, text:professional looks for all pages that have the word "professional" in them, and "jcr:title":English looks for all pages that have "English" as the title. You can only search for strings. |
| Content Mode check box | Select this check box so you can read properties within the jcr:content subnode of the search results if exists. Use for pages only. Property names are prefixed with "jcr:content/" |
| 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/Columns field. 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, AEM 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. |
For example:
-
Click Search. The Bulk Editor displays the results.
For the example above, all the pages that meet your search criteria are returned and displayed with the requested columns.
-
Double-click a cell so you can make any changes.
-
Click Save to save your changes (the Save button is activated after you have edited a cell).
CAUTIONThe changes you make here are written to the repository content; for example, the page referenced in Path.
Additional GQL Query Parameters
- path: only search nodes below this path. If you specify more than one term with a path prefix, only the last one is considered.
- type: only return nodes of the given node type. This includes primary and mixin types. You may specify multiple comma-separated node types. GQL returns nodes that are of any of the specified types.
- order: order the result by the given properties. You may specify multiple comma-separated property names. To order the result in descending order simply prefix the property name with a minus. For example, order:-name. Using a plus sign returns the result in ascending order, which is also the default.
- limit: limits the number of results using an interval. For example, limit:10…20 The interval is zero-based, start is inclusive, and end is exclusive. You may also specify an open interval:limit:10… or limit:…20
If the dots are omitted and only one value is specified, GQL returns at most this number of results. For example, limit:10 (returns the first ten results).
Exporting Content
If necessary, export content into an Excel spreadsheet to make any changes. For example, you may want to export a mailing list and change the area code of all the listed phone numbers directly in Excel, or add additional lines.
To export content:
-
Search for content as described in Searching and Editing Content.
-
Click Export so you can export the changes into a tab-separated Excel spreadsheet. AEM WCM asks you where you want to download the file.
NOTEBy default, changes are encoded in Windows-1252 (also known as CP-1252). You can check UTF-8 to export the changes in UTF-8.
-
Select the location and confirm that you want to download the file.
-
After you download the file, you can open it from your spreadsheet program, for example, Microsoft® Excel. The spreadsheet program imports the file and converts it to a spreadsheet format.
Importing Content
By default the import functionality is hidden when you open the Bulk Editor. Simply adding the parameter hib=false to the URL displays the Import button on the Bulk Editor page. You can import content from any tab-separated ( .tsv) file. For importing to work properly, the column headings (first row of cells) must match the column headings of the table you are importing to.
When you reimport content, you erase any previous content for those nodes. Be careful not to overwrite important information.
To import content:
- Open the Bulk Editor.
- Add
?hib=falseto the URL, for example:
https://localhost:4502/etc/importers/bulkeditor.html?hib=false - Click Import.
- Select the
.tsvfile. The data are imported into the repository.
Resources
Adobe Account
