The following settings can be customized for each Export Action by administrative users on the Export Actions page in your ExportZen Studio, accessible via Site Settings / ExportZen Studio / Export Actions:
(Text box)
This name will typically not be visible on content pages to end users, but helps you stay organized.
(Descriptor for a set of SharePoint Web Sites)
Optionally select in which web sites this Export Action will be available. By default, it will be available in all web sites and this usually does not need to be changed during your first explorations within this software. Only perform changes if you are familiar with the terminology presented in the above property editor. Should your changes not result in the expected outcome, you can always easily set this back to "all web sites, no exceptions" and then resume experimenting incrementally with your exceptions.
To define the set of Web Sites, first select either Available in all Web Sites or Available in no Web Sites, then click the except... link to describe which web sites to exclude from that selection. You can exclude:
(Descriptor for a set of SharePoint Lists and Views)
Select in which Lists this export action will be offered as a menu item to end users (in the SharePoint 2007 "Actions" toolbar menu and in the SharePoint 2010 "Connect and Export" ribbon group (both only if the "ExportZen List Integration" Site Collection feature is activated too and for List Views, only with their Toolbar Type property set to Full or Show, not Summary or None).
To define the set of Lists, first select either Show in all Lists or Show in no Lists, then click the except... link to describe which Lists to exclude from that selection. You can exclude:
To define the set of Views, first select either Show in all Views or Show in no Views, then click the except... link to describe which Views to exclude from that selection. You can exclude:
(Text box)
Specify the caption for this CSV export action to be shown in the export menu item for the Lists specified above. (If you do not specify a caption, the above name for this export action will be used, or if blank, its internal ID.)
Default value for new Export Actions:
$Resources:Tool_ExportActions_DefTitle
(Text box)
Specify the description for this CSV export action to be shown in the export menu item for the Lists specified above.
(Text box)
Specify the List Columns (one per line) to include in that order in output CSV data files generated by this export action. (To rename a Column in the exported CSV, enter the List Column name, followed by a colon (:) and the CSV column name.) Be sure those Columns will be available in the exported List, otherwise the CSV column will remain empty.
If you clear this setting and keep it blank, the export will include all available View Columns shown.
Default value for new Export Actions:
Title
(Text box)
Optional: if you'd like ExportZen to append an additional column recording all version history per item (only for the Columns specified above, in a simple plain-text format), specify your preferred name for this CSV column here. Leave blank to not append a version history column.
Not applicable to User Profile exports via PeopleZen.
(Check box option)
Instead of keeping all version history in a single column, you can export each version in the history to its own row. These versions will appear underneath the data item row, in descending sort order, and in this case you'll need a separate CSV column to denote the version number of each history record. You need to enter this CSV column name (for example 'Version') above this check-box option if ticked.
Not applicable to User Profile exports via PeopleZen.
(Check box option)
If ticked, this export action only ever exports items included in the currently displayed List View, applying the View-defined default sort orders and filters (but not currently user-applied live sort order, filters or paging); otherwise, all List items are exported, unfiltered and in their original sort order.
Not applicable to User Profile exports via PeopleZen.
(Check box option)
If ticked, this export action only ever exports items included in the filtering currently applied to the applicable List View (only supports filters supplied by a currently connected FilterZen Filter Web Part).
(Check box option)
Not recommended unless you and your users intend to only ever open these CSV exports in Microsoft Office Excel AND Excel displays all comma-separated column values in a single cell (some internationalized Excel versions do that, some don't).
(Check box option)
If un-ticked, ExportZen generates CSV data files using escaping patterns (for critical characters such as commas, line-breaks and quotes) that software written for Windows or Office is more likely to read flawlessly. Tick this check box to generate CSV data files using UNIX-style escaping patterns instead (only recommended if you get errors while feeding your exported CSV data files to other, non-Office software).
(Culture picker)
This setting controls how numbers and dates are represented in this export. For example, dates may be stored in an US format (due to your SharePoint installation) but your export consumers may use a different-locale version of Excel (such as for example German), which would then mis-read and mis-represent factually-correct, but US-formatted date values. Keep the default choice to start with and experiment as needed if results do not meet expectations.
The drop-down menu provides all standard-defined regions. You can also choose from the following "dynamic" cultures:
The default choice is: Server-side 'current' locale.
(Encoding picker)
Only if your exports contain international characters that don't look as expected in external software importing this export should you start experimenting with different export encodings. The Unicode / UTF encodings are the recommended choices to test before trying other encodings. Keep this set to Default UNLESS your exported contents are not decoded correctly by external software that needs to consume this export in production.
The drop-down menu provides all standard-defined text encodings. The default choice is: Server-side default encoding, meaning the default encoding defined for the Windows and/or ASP.NET installation on the server.
(Check box option)
ONLY tick this option if you selected the UTF-8 encoding above AND your exported contents are not decoded correctly by the external software that needs to consume this export in production. Recommended for opening UTF-8 exports in Excel.