ASCII Export

Last modified

ASCII Export Tab

In addition to creating databases in the MetaStock format, Your SOFTWARE can also be set export data in an ASCII format for use by third party applications.

The Export Specification selection dialog contains a number of common third-party formats.

You can also use the ASCII Export Specification Wizard to make custom specifications which will also be added to the selection dialog's list.

ASCII format is essentially a text-only file, having no formatting information and being composed only of the 256 ASCII characters including letters, numerals, punctuation marks, control characters, and other symbols.

The American Standard Code for Information Interchange scheme was developed in 1968 to standardize data transmission among different hardware and software systems.

From this dialog you can access the ASCII Export Specification Wizard to create file specifications suitable for use by third party applications.

The ASCII compliant file will define all the criteria in the proper format required by the software and can be set to be exported directly into the software's database each time data is distributed from the HUBB server. In this way both Your SOFTWARE and other third party software will be able to use the fresh data downloaded from the HUBB server.

In order to export a specific ASCII file to a particular database, three steps are required:

  • Create an ASCII file specification using the ASCII Export Specification Wizard
  • Select the Specifications to be included in routine the data distributions
  • Set Your SOFTWARE to perform the data export at the completion of each data distribution of Update Manager downloads

The last two steps are accessible from the Application Settings' ASCII Export tab, while the access to the ASCII Export Specification Wizard is via the ASCII Export Specification selection list dialog.

Set Specifications for Automatic Export

Specifications are templates that Your SOFTWARE uses to produce files formatted for use in the databases of third-party software.

Users must create their own Specification to meet the criteria of the third-party software using the ASCII Export Specification Wizard.

The ASCII files to be created are listed in the Specifications list of the ASCII Export tab:

vgappsts_ascii.png

apst_asciexpt.png

To automatically refresh and export files to their predefined locations, check the Export Ascii data at Completion of Distribution checkbox.

Note - Historical data is not available for ASCII export.

The ASCII export feature will only create data files based on files downloaded through the Update Manager.

Refer to the Historical Data Copy Wizard topic in the Shared Utilities section for more information on setting up third party databases.

Result of ASCII Export

At completion of the next Update Manager data download, Your SOFTWARE will use the fresh data to create an ASCII file based on the criteria contained in each specification in the list.

After creating the file it will distribute it to the database location set in the specification.

A file will be exported for each specification in the list. The file can be set to overwrite the current file in the database, or be added to an existing file, or be given a sequential name/time stamp and added to the database.

Disabling the Export Function

Un-check the Export Ascii data at Completion of Distribution checkbox to turn this function off.

Note - By default there are no Specifications in the list, Ascii file specifications are purely used defined objects, and this function is disabled.

Manage Specifications list

If you no longer need a specification to be exported at each data update, delete it from the list by selecting the Specification and clicking the Remove button.

The specification will be removed from the Specification list on the ASCII tab, but will remain in the Available Specifications list of the Ascii Export Specifications selection dialog, see next section.

Select Specifications for Export

Click the ASCII Export tab's Add button to open the ASCII Export Specifications dialog:

asciexpvizopen.png

This list contains some of the more common third-party software formats, as well as all the Ascii file specification templates that you have previously created using the Wizard and saved.

You can create as many ASCII export Specifications as you need.

To add a specification for inclusion in the routine export process, select one from the Available Specifications list and click Select.

The selected Specification will be included in the Specifications list of the ASCII Export tab, see above.

Managing Available Specifications

Remove

To remove an redundant or unwanted specification from the Available Specifications list, select the specification and click Delete.

Edit

The criteria and definition of currently available specifications can be altered by the user. Select the specification and click Edit. The ASCII Export Specification Wizard will open, make the necessary changes in each page of the Wizard, and click Finish at the end.

Create New Ascii Export Specifications

Users create new ASCII file specifications using the ASCII Export Specification Wizard. Click Add to open the Wizard.

Users can also modify an existing Specification by clicking on the Edit button, in this case the wizard will also be used, but the current settings will populate some of its settings..

When a new ASCII file Specification is created it is added to the Available Specifications list of the ASCII Export Specifications dialog. Specifications from that list can be Selected for inclusion in the Specifications list of the ASCII Export tab.

Open the Wizard

Click the Add button on the ASCII Export Specifications dialog to open the Wizard.

Follow the steps in the wizard to set the specifications that you require for your data export.

For a full explanation of the Wizard and its components, go to the ASCII Export Wizard topic.

Page statistics
979 view(s) and 7 edit(s)
Social share
Share this page?

Tags

This page has no classifications.

Comments

You must to post a comment.

Attachments