You can export reference information from web-based AASHTOWare Project in the current export formats. This information can be imported into the client/server versions of PES (including Project Worksheet), LAS, CAS, Cost Estimation, and SiteManager. To begin, select Execute System Interface from the Actions menu on the Menu bar. For more information about the System Interface component, see Executing System Interfaces.
To export reference data for import into PES (including Project Worksheet), LAS, CAS, or Cost Estimation, choose Export Reference Data from the System Interface component, and choose the types of reference data you want to export from the Parameters setting.
To export funding information and code table information for import into Estimator catalogs, choose Export Reference Data from the System Interface component, and choose the types of reference data you want to export from the Parameters setting.
Note: Reference item data for Estimator should be generated from BAMS/DSS, rather than from Preconstruction. This ensures that the data is consistent with the item selection used for bid histories.
To export reference data for import into SiteManager, choose Export Reference Data to SiteManager from the System Interface component, and choose the types of reference data you want to export from the Parameters setting.
Caution: When you export contract data to SiteManager, the system produces a contract file and a file containing only sufficient reference data for importing the selected contracts. This partial reference data file has the same name as the complete reference data file, SITEMANAGER_REFERENCE.CSV, and will overwrite a file that is in the specified output location on the server. Therefore, if you want to update all SiteManager reference data, be sure to copy the exported file from the server before running the contract export. See Exporting a Contract to SiteManager for more information.
To export funding information and reference item information in the aecXML format, choose Export to AEC on the System Interface component. This export produces two export files, one for funding information and the other for reference items.
The system generates the export files and saves them in the default location with the default names shown in the table below. Any existing export files with the same names are automatically overwritten.
Application |
Export File |
Project Worksheet, CAS, and Cost Estimation |
EXPORT_<entity table name>.TXT |
Estimator |
EXPORT_REFCODETABLEVALUE.TXT |
SiteManager |
SITEMANAGER_REFERENCE.CSV |
aecXML |
AECITEM.XML and AECFUND.XML |
The system also generates a log file containing a summary of the information that was successfully exported and any errors that occurred. The log file is saved in the default log files location. To view the contents of the export files, you will need to have access to the default folder where the system places them.