Formatting a price updating file (SQL)
Description

Valid formats for price update files

Your price update file must use one of the following formats:

Excel worksheet (XLS)
Comma Separated Value file (CSV)
Text file (TXT)

Cause
Resolution

The following examples of price update files show how to achieve the same price changes in the database with different file formats. Together, the examples:

  • Update the material price to $500 for any items that have a WBS code labeled “Level4” and a value of “01-09-31.50”.
  • Update the subcontract price to $566.14 for any items that have a price code of “U10000”.
  • Update the labor, material, subcontractor, equipment, and "other" price categories for phase 01-45-23.50, item 1800 to 1800, 0.65, 289.81, 578.97, 868.13, and 1157.29 respectively.

Note: For more detailed information about how to structure each type of record (for example, how to enter WBS code and Value fields).

[BCB:164:Chat Estimating US:ECB] 

Steps to duplicate
Related Solutions

Getting Started: Updating prices in the standard database (SQL)