Creating a Text File
PartBridge.com users post capital and expensed equipment to buy and/or sell in a tab-delimited text file with the proper columns and information. A tab-delimited text file is a file with the extension txt (for example, it will have a name such as excess_furniture.txt) that has tabs separating each of the data elements.
The same text file can describe both equipment in excess and equipment in shortage, because the information you provide for each line item is exactly the same whether the equipment is in excess or shortage; the only difference is that the quantity for equipment in excess is always a positive number and the quantity for equipment in shortage is always a negative number.
The file must contain the following columns in the order presented here:
| Column Heading |
Req'd? |
Description |
| email_address |
Yes |
The email address of the individual responsible for making buy/sell decisions for the corresponding equipment. Example: cee_user@my_company.com |
| entity |
No |
The site entity number, if applicable, posting the equipment. Example: 5000 |
| department |
Yes |
The 4-digit number of the department of the entity posting the equipment. If not applicable, enter None. Example: 4040 |
| sub_category |
Yes |
Description category defined as either Process Equipment, Test and Measurement Equipment, Material Handling Equipment, Furniture, Office Supplies, or Other. |
| date_available |
Yes |
The date the equipment will be available or needed. (mm/dd/yyyy) Example: 05/16/2002 |
| net_book_value |
Yes |
The current value of the equipment being carried on the company books; this value should equal the original value (per unit in $US) less depreciation (if buying, enter 0). Example: $2.435 |
| min_acceptable_bid |
Yes |
The minimum acceptable offer (per unit in $US) from a potential buyer (If buying, enter 0). Example: $100.00 |
| equipment_location |
Yes |
The physical location of the equipment (city, state/province, country separated by commas). City and country are required if selling. Example: Sacramento, California, USA |
| mfr |
Yes |
The equipment's manufacturer. Example: Phillips |
| qty |
Yes |
The quantity of the equipment (integer only, no decimals or fractions); a negative number indicates a shortage, a positive number indicates an excess. Example: 500 |
| description |
Yes |
A description of the equipment. Example: fax machine |
| model_no |
No |
The model number of the equipment, if available. |
| serial_no |
No |
The serial number of the equipment, if available. |
| asset_no |
No |
The asset number of the equipment, if available. |
| comments |
No |
Comments input by the user posting the equipment |
|
Instructions for creating tab-delimited text files are available:
Related topics:
