Open topic with navigation
Export FootPrints Service Core Data to a File
Use this option to export Workspace data from the current
Workspace to another FootPrints Service Core
Workspace, database, or application.
To export Workspace
data:
- Select Administration
| System | Workspaces | Export FootPrints Service Core data from the
Toolbar.
- Click GO.
- Use the Fields
to be exported dialog to choose the columns (and column order)
for the export file.
- Select the criteria
for the Issues to be exported. To export the entire workspace, highlight
all statuses (and do not make any other restrictions).
- Click GO.
- Enter a file name.
- Browse for the directory
in which to save the export file
- Click Save. The
file is saved in comma-separated-variable (CSV) format, suitable
for editing or loading into a Workspace in CSV format. For more information, refer to .
If Assignees
is selected, the user IDs of the assignees are output to the report (e.g.,
bsmith).
This is suitable for importing the report output into another Workspace.
To create a file that includes assignees full names (e.g., Bob
Smith), use the Report Text
File option.
If you plan to export BMC FootPrints Service Core
data to a .CSV file for manipulation in Excel for eventual re-importing
in (i.e., open the
.CSV file in Excel for manipulation, re-save it to a .CSV file, and then
load it back into )
you must perform certain steps if your data contains Date or Date/Time
fields:
- After
you open the .CSV file in Excel, it is displayed suitably for your
locale. For example, in the United States, the date 2003-02-14
in the import file is displayed as 2/14/03.
- You
must change the format of that column by selecting Format
| Cells | Custom. Select one of the existing formats and then input
into the Type
box YYYY-MM-DD
for a date field and YYYY-MM-DD
HH:MM:SS for a Date/Time field.
- Make
any additional changes desired and then save it as a .CSV file for re-importing
into .