/
Bridge screen map and steps to load Work Order Cost

Bridge screen map and steps to load Work Order Cost

Owned by Claire Aleman
11 13, 2024

Issue/Symptom/Question

What is the Bridge screen map and the steps for loading Work Order Cost?

Applies To

Bridge Load

Loading new Work Order Cost

Resolution/Fix/Answer

SMS006.bat

Template for the Work Order Cost Bridge Load:

Steps to complete Bridge Loading of Work Order Cost to the Work Order Cost window:

  1. Download the Work Order Cost Bridge Load template as an excel file.
  2. Save the file to a local directory.
  3. Using the template example, enter the required and/or option items in the rows below the example row.
  4. Delete the two example rows after updating the information.
  5. Example Bridge excel file: 
  7. Save the file as an MS Dos txt file.
  8. Open the txt file using Notepad or Notepad ++ to edit the file.
  9. Example txt file ready for bridge: 
  11. Save the txt file as SMS006.bat
  12. Using FileZilla, WinSCP or another FTP application, save the SMS006.bat file to the directory where it will be available to bridge

Using FileZilla:

  1. Once logged in, save the file to the user's desktop

            

        2. Move the to the Linux User's home directory

          

       3. Log into CoStar with the Linux User and password and hit enter until you get to the /penta> prompt. Type penta at this prompt

          

       4. Choose the Database with Bridge Option that will be used to bridge the Work Order Cost(s)

          

       5. Log into the database as you would log into Penta

           

       6. Using the arrows on your keyboard navigate to System Management > Initial Load > Job Management > Work Order Cost

            

Once this window opens, the screen will flash to reflect the work order cost(s) being loaded. Once the load is complete, Penta will exit the window and return to the Work Order Cost window. If there are errors, the SMS006.err file will be generated in the FTP application. You will need to review the file to determine what needs to be updated to complete the bridge process. 

If you need assistance with resolving any errors or with this process, please submit a Service Desk ticket and reference this article.