Top

Introduction

The Export Settings screen allows you to define what data to export, its destination, and various options.

Top

Features

The settings are divided into several sections. The sections that appear depend on the selected export destination.

Export Source

The Export Source section lets you provide details about the data to be exported.

Category (or Location or Action)

Depending on where you started the export (or Share Items) you can choose either the category, location, or action to export. If exporting a category you can further refine the export by choosing a category's group. If exporting a location you can further refine the export by choosing a location's container.

This option does not appear if you are exporting a set of items through bulk selection or a single item.

Filter

If you wish to export a subset of the chosen items then you can select a filter. These are the same filters found on the item list screen.

This option does not appear if you are exporting a set of items through bulk selection or a single item.

Sort

You have the option to sort the exported data. These are the same sorts found on the item list screen.

Include Subgroups (or Include Subcontainers)

If exporting a category you can specify whether to include items from subgroups or not. If ON then items assigned to subgroups of the chosen category will be included. If exporting a location you can specify whether to include items from subcontainers or not. If ON then items assigned to subcontainers of the chosen location will be included. This does not apply when exporting an action.

This option does not appear if you are exporting a set of items through bulk selection or a single item.

Include Actions

This option lets you specify what actions applied to an item should be included in the exported data. Select All Instances to include all actions applied to an item. Select Last Instance to only include the latest instance applied to an item. Select No Instances if you don't want any action instances include with the exported data.

Exported Attributes

This setting allows you to define which attributes will appear in the exported data.

Export Options

The Export Options section lets you provide details about how the exported data is formatted.

Date Format

The items being exported may include dates from different Date attributes. These Date attributes may have various date formats associated with them. This option brings up the Date Format screen and lets you specify how the dates should be formatted on export. Selecting Attribute Format results in each exported date being formatted based on its corresponding attribute. Selecting Default results in every date being formatted the same as specified by the selected Date Format on the Settings screen. You also have the option to select any other suitable date format or create and use a new format.

Time Format

The items being exported may include times from different Time attributes. These Time attributes may have various time formats associated with them. This option brings up the Time Format screen and lets you specify how the times should be formatted on export. Selecting Attribute Format results in each exported time being formatted based on its corresponding attribute. Selecting Default results in every time being formatted the same as specified by the selected Time Format on the Settings screen. You also have the option to select any other suitable time format or create and use a new format.

Duration Format

The items being exported may include durations from different Duration attributes. These Duration attributes may have various duration formats associated with them. This option brings up the Duration Format screen and lets you specify how the durations should be formatted on export. Selecting Attribute Format results in each exported duration being formatted based on its corresponding attribute. You also have the option to select any other suitable duration format.

Currency Format

The items being exported may include currency value from different Currency attributes. These Currency attributes may have various currency formats associated with them. This option brings up the Currency Format screen and lets you specify how the currency values should be formatted on export. Selecting Attribute Format results in each exported currency value being formatted based on its corresponding attribute. You also have the option to select any other suitable currency format.

Locale

The Locale option lets you indicate that you wish to have data formatted appropriate to the selected locale. The locale will affect how numbers, dates, times, and currency values are formatted. Selecting Default uses the current locale of the iOS device.

Remove Branding

By default, when you export data as a PDF or printed report, export data via email, or generate the HTML report, these exports contain references to the MyStuff2 iOS app. By enabling this option, all references to MyStuff2 are removed from these exports.

Note: This option only appears in MyStuff2 and MyStuff2 Pro. This is a premium option that can be purchased from within the app.

Export Destination

Destination

This option allows you to specify how or where the exported data is sent.

Server Accounts
The list of choices begins with the list of server accounts you setup on the Server Accounts screen.
Email
This option allows you to email the exported items. The content of the email depends on the chosen Email options. Regardless of the chosen Email Options the email will include a basic introduction. If the export is for a single category then the email will include a section allowing the email recipient to import the category definition into their copy of MyStuff2. Other Email options allow you to include the exported data as various types of file attachments.
Another App
This option allows you to open the exported data with another app on your iOS device. Select an option from the Export Format section to choose the format of the exported data.
Printer
This option allows you to print a report of your data to a printer. You can select the desired printing options. This option only appears on devices that support printing via AirPrint.

Export Format

This option is not visible if the chosen Export Destination is Print or Email.

Format

You can choose to export the selected data as either a CSV data file, a PDF report, an Excel spreadsheet, or an Open Document spreadsheet.

CSV File
The saved file will either be a single CSV file or a zip file containing one or more CSV files. The zip file may also contain any associated media files if you have chosen to include them. If the exported data has items from more than one category then the zip file will contain one CSV file per category.
PDF Report
This will generate a report of the chosen data as a PDF document. Use the PDF Report Options section to specify details about the PDF report.
Excel Spreadsheet
This will generate an Excel spreadsheet in Office Open (xlsx) format. There will be one sheet for each category in the exported data. If you have chosen to include media, then the exported file will be a zip file containing the xlsx file and all of the media files. Excel File Format section to specify details about the spreadsheet file.
Open Document Spreadsheet
This will generate an Open Document Format spreadsheet (ods) file. There will be one sheet for each category in the exported data. If you have chosen to include media, then the exported file will be a zip file containing the ods file and all of the media files. ODS File Format section to specify details about the spreadsheet file.

Include Media

Turning this option ON means that any pictures, item attachments, and voice memos associated with exported items will be included with the export. If OFF then no pictures, attachments, or voice memos will be included.

Email Options

These options are visible if the chosen Export Destination is Email.

Include CSV File

You can choose to include the exported data as CSV data. If ON then the data will be included as an attachment. You can select the desired CSV File Format.

Include PDF Report

You can choose to include the exported data as a PDF report. If ON then the data will be included as an attachment. You can select the desired PDF Report Options.

Include Excel File

You can choose to include the exported data as an Excel spreadsheet. If ON then the data will be included as an attachment. You can select the desired Excel File Format.

Include ODS File

You can choose to include the exported data as an Open Document Format spreadsheet. If ON then the data will be included as an attachment. You can select the desired ODS File Format.

Item Report Format

The body of the email message may include a report of the exported items. The report can be in one of two formats: Spreadsheet or List. Selecting None results in no item report from being included in the body of the email.

CSV File Format

Include Header Row

If ON the first row of the CSV file will be the column titles. The column titles will match the attribute names of the category. If OFF the CSV will not include the column titles.

Field Delimiter

Despite being called a CSV (comma separated values) file, the values can be separated by punctuation other than a comma. You can choose from several different separators. You would choose a specific value if you plan to import the CSV file into another application that expects a specific separator. If unsure leave the default of a comma.

Text Delimiter

It's possible that a value in the CSV file contains the same punctuation used as the Field Delimiter. When this happens the value must be placed within the Text Delimiter. You can choose either the double-quote or the single-quote. Again, you would choose a specific delimiter if another application expects it.

Multi-value Delimiter

This option let's you specify a delimiter to be used to separate multiple values in the same column. This is used for attributes associated with multi-select lookup lists and for listing picture paths for items with more than one picture. Don't use a value that could appear in the data. This must be different from the chosen Field Delimiter.

Calculated as Values

If the exported data is associated with calculated attributes then you can choose to export the values as either formulas or as the resulting values.

PDF Report Options / Printing Options

Report Format

The report can be in one of two formats: Spreadsheet or List. The Spreadsheet report looks much like a spreadsheet of the data - one line per item with columns for each attribute. The List report uses multiple lines per item.

Page Size

This lets you choose the size used for each page of the PDF report.

Page Orientation

Choose either Portrait or Landscape orientation. Unless your chosen category only has a few attributes you should use Landscape orientation is you choose the Spreadsheet report format. Otherwise the columns in the report will be very narrow and hard to read.

Picture Size

This lets you choose the size used for pictures in the report. Small will fit up to 10 pictures per line. Medium will fit up to 6 pictures per line. Large will fit up to 4 (landscape) or 3 (portrait) pictures per line. This option is disabled if you have not chosen to include media in the Export Source section.

Include Item Summary

When ON you will get an item summary at the end of each category. When OFF the summary is not included.

Include Cover/Index

When ON the report will include a cover page. List reports will also include a table of contents.

Compact Report

When OFF items will not be split across pages (except for long notes). Each category will start on a new page. When ON items may be split across multiple pages and no page break is used for each category. Typically this will result is a few less pages.

Use Scheme Font

When ON the report will be printed in the same font as that used in the currently selected color scheme. When OFF the report will be printed in a basic sans serif font.

ODS File Format

Include Header Row

When ON the first row of each sheet in the spreadsheet will contain the attribute names.

Multi-value Delimiter

This option let's you specify a delimiter to be used to separate multiple values in the same column. This is used for attributes associated with multi-select lookup lists and for listing picture paths for items with more than one picture. Don't use a value that could appear in the data.

Calculated as Values

If the exported data is associated with calculated attributes then you can choose to export the values as either formulas or as the resulting values.

Excel File Format

Include Header Row

When ON the first row of each sheet in the spreadsheet will contain the attribute names.

Multi-value Delimiter

This option let's you specify a delimiter to be used to separate multiple values in the same column. This is used for attributes associated with multi-select lookup lists and for listing picture paths for items with more than one picture. Don't use a value that could appear in the data.

Calculated as Values

If the exported data is associated with calculated attributes then you can choose to export the values as either formulas or as the resulting values.