Skip to end of metadata
Go to start of metadata

Wind2 is an accounting package that is also known as Deltek FMS and has since been discontinued. Very old versions use a FoxPro database source, newer versions have a SQL backend. This article explains how to import from the SQL version of Wind2/FMS.

  1. Follow the steps in Importing Billing Codes from a SQL database to set up a connection to Wind2/FMS.
  2. Select "Use SQL Statement"  and enter the following query: SELECT * FROM BMPROJ WHERE Linactive = 0
  3. Select "CPROJECT" from the Number drop-down field
  4. Select "MPROJTITLE" from the Name drop-down field
  5. Leave all other fields unchecked
  6. Click "Preview" to verify the project list is correct
  7. Click the "Phase" tab
  8. Select "Use SQL Statement"  and enter the following query: SELECT * FROM BMPHASE a INNER JOIN BMPROJ b ON a.bmproj_id = b.bmproj_id WHERE a.Linactive=0
  9. Select "CPHASEID" from the Number drop-down field
  10. Select "CPHASEDESC" from the Name drop-down field
  11. Select "CPROJECT" from the Project Number drop-down field
  12. Leave all other fields unchecked
  13. Click "Preview" to verify the phase list is correct
  14. Click "OK"

http://docs.sepialine.com/display/argos7/Importing+Billing+Codes+from+a+SQL+database