Help

Import/Export Status

Import Status Overview
View Import Status
Import Status Field Definitions
Import Details
Related Import Topics

Export Status Overview
View Export Status
Export Status Field Definitions
Export Details
Related Export Topics

Note
Please see Export Error Messages for a list of the export error messages that display below the table in the Export Status Tab.

Import Status

Import Status Overview

Use the Import Status Tab to view a list of imports that were run either by you or by a member of your firm on a specified date and to display detailed information about these imports.

Using the icons in the upper right portion of the screen, you can:

Refresh: Update the contents of the Import Status Tab. This feature enables you to monitor the progress of your imports without closing and then re-opening the pop-up screen.
Export as CSV: Export the current contents of the Import Status Tab to a CSV file.
Print PDF: Create a PDF file that contains the current contents of the Import Status Tab.
Help: Display the online help information for the Import Status Tab.

Top

View Import Status

Select Tools > Imports & Exports > Import/Export Status. The Export Status Tab displays by default.
Select the Import Status Tab.
The status for the current day's imports display by default. If you wish to view the imports for another day (the previous day, for example), complete the Date field using the associated Calendar icon; the Imports for the selected date display.

Note
Import Status is available for the current date (the default) and up to 120 days prior.
If there are more imports than can display in the scrolling area of the screen, you can use the Previous and Next links below the list to sequence through them to locate a specific import.
Use the Filter By User drop-down list to filter the contents of the tab based on your selection; options are the imports you performed, the imports another member of your firm performed, or all imports performed by your firm.

Note
The menu is blank if there are no imports for you or for members of your firm for the selected date. If you executed an import on the selected day, the filter defaults to your name and only your imports will appear.
Select on an entry to display details of the import below the list. In the event of an error with the import, you can use this information to help to resolve the issue.

Top

Import Status Field Definitions

Note

Select a column heading that displays in blue to sort the list in ascending or descending order according to that criterion. The sorting method of the list is indicated by a caret in the selected column heading; the caret points upward for ascending ordering and points downward for descending ordering. Selecting the column toggles between ascending and descending order. The default sort is in ascending order according to Import Name.
You can use the drag-and-drop feature to reposition the columns in the list. However, this setting is not persistent, meaning it is not saved when you close the Import/Export Status pop-up screen or when you log out of the platform and then log back in.
A tooltip containing the complete content of a cell displays when you move your cursor over any cell where the full content does not display due to the column width.

Field	Definition
User Note You can sort the list in either ascending or descending order according to this column.	The import requestor's name.
Import Name Note You can sort the list in either ascending or descending order according to this column.	The user-defined name of the import, if available. Note Default primary sort criterion for the list.
Import Type Note You can sort the list in either ascending or descending order according to this column.	The type of import; options are: Clients, Groups, Account Custom Information, Order, Advent MOXY, TPA Order, and Trade Restrictions.
Status Note You can sort the list in either ascending or descending order according to this column.	The status of the import; options are: In process, Successful, Completed with errors, and Failed.
Records Successful	The number of records that were imported successfully into the platform. Note 0 in this field indicates the entire import failed. A dash (--) displays in this field if the import's Status is In process.
Records with Errors	The number of records that failed to be imported, along with a red exclamation point icon (if the number is other than 0). This number is a link that, when selected, displays a Records with Errors screen that provides the following details concerning the import errors: Date/Time, Record Identifier, and Error Description. Note 0 in this field indicates there were no errors with the import.
Domain	The domain of the import requestor.

Top

Import Details

Field	Definition
Import Name	The user-defined name of the import, if available.
Files Imported From	The path to the source of the import records.
File Name	The user-defined name of the source file for the import.
Request Received	The date and time that the import request was initiated by the user. Note Format is MM-DD-YYYY HH:MM:SS AM or PM Eastern time.
Request Completed	The date and time that the import request was completed by the platform. Note Format is MM-DD-YYYY HH:MM:SS AM or PM Eastern time.
Records Successful	The number of records that were imported successfully into the platform. Note 0 indicates the entire import failed. A dash (--) displays if the import's Status is In process.
Records with Errors	The number of records that failed to be imported, along with a red exclamation point icon (if the number is other than 0). This number is a link that, when selected, displays a Records with Errors screen that provides the following details concerning the import errors: Date/Time, Record Identifier, and Error Description. Note 0 indicates there were no errors with the import.

Top

Export Status

Export Status Overview

Use the Export Status Tab to view a list of exports that were run or scheduled either by you or by a member of your firm on a specified date and to display detailed information about these exports.

Using the icons in the upper right portion of the screen, you can:

Refresh: Update the contents of the Export Status Tab. This feature enables you to monitor the progress of your imports without closing and then re-opening the pop-up screen.
Export as CSV: Export the current contents of the Export Status Tab to a CSV file.
Print PDF: Create a PDF file that contains the current contents of the Export Status Tab.
Help: Display the online help information for the Export Status Tab.

Top

View Export Status

Note

Exported files are available for download via the Export Status Tab for 120 days.

Select Tools > Imports & Exports > Import/Export Status. The Export Status Tab displays by default.
The status for the current day's exports display by default. If you wish to view the exports for another day (the previous day, for example), complete the Date field using the associated Calendar icon; the Exports for the selected date display.

Note
Export Status is available for the current date (the default) and up to 120 days prior. Please see Export Error Messages for additional information.
If there are more exports than can display in the scrolling area of the screen, you can use the Previous and Next links below the list to sequence through them to locate a specific export.
Use the Filter By User drop-down list to filter the contents of the tab based on your selection; options are the exports you ran, the exports another member of your firm ran, or all exports run by your firm.

Note
The menu is blank if no exports were executed for you or for members of your firm for the selected date. If you executed an export on the selected day, the filter defaults to your name and only your exports will appear.
Select on an entry to display details of the export below the list.
Select the Download File link in the Action column of an export to save the file to your system so you can incorporate its contents in your portfolio management system or contact management system.

Top

Export Status Field Definitions

Note

Select a column heading that displays in blue to sort the list in ascending or descending order according to that criterion. The sorting method of the list is indicated by a caret in the selected column heading; the caret points upward for ascending ordering and points downward for descending ordering. Selecting the column toggles between ascending and descending order. The default sort is in ascending order according to Export Name.
You can use the drag-and-drop feature to reposition the columns in the list. However, this setting is not persistent, meaning it is not saved when you close the Import/Export Status pop-up screen or when you log out of the platform and then log back in.
A tooltip containing the complete content of a cell displays when you move your cursor over any cell where the full content does not display due to the column width.

Field	Definition
Status Note You can sort the list in either ascending or descending order according to this column.	The status of the export; options are: Pending, In Process, Successful, and Failed.
User Note You can sort the list in either ascending or descending order according to this column.	The export requestor's name.
Export Format Note You can sort the list in either ascending or descending order according to this column.	The type of export; possible contents are: Clients, Groups, Account Custom Information, Orders, Statements, Confirms, Standard Format A, Standard Format B, and Custom.
Export Name Note You can sort the list in either ascending or descending order according to this column.	The user-defined name of the export, if available. Note Default primary sort criterion for the list.
File Type Note You can sort the list in either ascending or descending order according to this column.	The type of export file; options are: Account Custom Information, Clients, Groups, Accounts, Balances, Bulk Confirms, Bulk Statement, Name & Address, Orders, Positions, Positions & Balances, Prices, Securities, and Transaction History.
Scheduled Note You can sort the list in either ascending or descending order according to this column.	Indicates whether the export was run manually (Unscheduled) or Scheduled. Note Exports run using the Run Now button are categorized as Unscheduled, since you run the export manually.
Time	A timestamp reflecting when the export ran. Note Format is HH:MM:SS AM or PM Eastern time. Displays for both successful and failed exports.
Action	A Download File link for exports that are available to download.
Domain	The domain of the export requestor.

Top

Export Details

Note

A Run Export button displays if there is an error or a warning associated with the export highlighted in the Export Status Tab. Selecting this button enables you to re-run a failed export directly from the Export Status Tab. If you select the button, a pop-up screen displays prompting you to confirm that you wish to re-run the export since it will export all the file types associated with it. Select the OK button to close the pop-up and proceed with the re-run or select the Cancel button to close the export without re-running the export.
Exports run using the Run Export button are categorized as Unscheduled, since you run the export manually.

Field	Definition
Name	The user-defined name of the export, if available.
File Creation	The manner in which the export was created; options are Create Files On Demand, Create Files Automatically, and Create & Download Files Automatically.
File Path	The path to the destination of the export records. Note Applicable to Create & Download Files Automatically.
Scheduled Day(s)	The days of the week that the export runs. Note Applicable to Create Files Automatically and Create & Download Files Automatically.
Scheduled Time	The time of day the export downloads. Note Applicable to Create & Download Files Automatically.
File Name	The user-defined file name of the exported file.
Export Created	The date/timestamp of when the file was prepared.

Top