You can create an Analytics table by defining and importing an ACCPAC master file. The file can be on your local computer or a network drive, or in a folder located on an Analytics Server (if installed).
- Select .
The first page displayed in the Data Definition Wizard depends on your configuration. If integration with Analytics Server is enabled the Select Platform for Data Source page is displayed, otherwise the Select Local Data Source page is displayed.
- Complete one of the following steps to select the location
of the file:
If the Select Platform for Data Source page is displayed and you want to use Analytics to define the file, select Local and click Next. In the Select Local Data Source page select File and click Next.
If the Select Platform for Data Source page is displayed and you want to use an Analytics Server to define the file, select ACL Server and select the Windows server profile from the drop-down list, and then click Next. In the Select ACL Server Data Source page select Flat Files and click Next.
If the Select Local Data Source page is displayed select File and click Next.
- In the Select File to Define page, locate and select the file you want to create the Analytics table from and click Open.
- In the Character Set page, verify that the correct character set option has been selected and click Next.
- In the File Format page, verify that the ACCPAC master file option has been selected and click Next.
- In the Identify Fields page, complete
any of the following actions to modify the fields identified in
the record:
Delete an existing field separator by clicking on the field separator line you want to remove.
Move an existing field separator by clicking and dragging the field separator line to the new location.
Create a new field separator by clicking the grid in the position where you want to add the field separator.
- When you have identified all of the fields in the record, click Next.
- In the Edit Field Properties page,
you can modify the name and properties for each field by selecting
the column header for the field you want to modify in the preview table
and updating any of the following properties:
Ignore this field – If you do not want the field to be included in the Analytics table layout, select this checkbox.
Name – Keep the name assigned by Analytics for the field in the table layout, or enter a different name.
Column Title – Enter the column title to display in the default Analytics view. If a column title is not specified the Name value is used.
Type – Select the appropriate data type from the drop-down list. For information about the supported data types in Analytics, see Data types in Analytics.
The Decimal and Input Format text boxes appear automatically when you select the corresponding data type.
Value – A read-only property that displays the first value in the field. The value is updated based on any edits you make.
Decimal (numeric fields only) – Specify the appropriate number of decimal places.
Input Format (datetime fields only) – Specify the format that matches the data. For more information about date and time formats, see Formats of date and time source data.
- Click Next after you have finished editing the field properties you want to change.
- In the Final page, verify the settings for the new Analytics table and click Finish.
- Enter a name for the Analytics table you are adding to the project, or keep the default name, and click OK.
