⚠️ This page has been archived

✅ New page with updated info: ssw.com.au

Home > Archive > Diagnostics > How to Update Diagnostics Version Data

How to Update Diagnostics Version Data

Database: Dragon\SSWDiagnostics

Tables: FileDefinition, Product, ProductVersion

  1. Check whether the product is latest. If not, add the lastest and update old ones.
  2. Check whether the file is latest. If not, the lastest and update old ones.
  3. Check if there's a product version with the same file definition name and product name. If not, add this product version. Then update the 'versionlatest' of this product version and others.
  4. Remember to update 'DateUpdated' and 'UpdatedBy'.

SQL Exmaples

  1. Which product group is a product in and whether the product is the latest
    2. select p.productname, p.productname,p.productlatest, pg.groupname
    from product as p
    inner join productgroup as pg
    on p.groupid=pg.groupid
    order by p.productname
  2. Fetch product info with a file name
    3. select * from product where
    productname like ''
  3. Fetch product info with a product id
    4. select * from product where
    productid=88
  4. Fetch file definition
    5. select * from dbo.FileDefinition
    where filedefinitionid=75
  5. Fetch file definition
    6. select * from dbo.FileDefinition
    where filedefinitionname like ''
  6. Update product version
    7. update productversion
    set versionlatest = ',dateupdated=getdate(), updatedby='David Bian' where filedefinitionid = xx and productid= xx
  7. Add version
    8. insert into productversion (versionnumber, versionlatest, versionfor,productid,filedefinitionid,
    versionxmladd,versionupdateurl,versionname, versiondescription,
    datecreated,createdby,dateupdated,updatedby

How to publish a Versions.xml file

  1. Open SSW Diagnostics solution in VS 2008.
  2. Select SSW.Diagnostics.WebUI project.
  3. Debug it.
  4. Go to XmlGeneration.aspx page, and click the "Rebuild XML" button
  5. When it build successfully, upload the Version.xml file to AU and US, you need upload the file to: ftp://us.ssw.com.au/httpdocs/ssw/diagnostics/ and ftp://us.ssw.com.au/httpdocs/ssw/diagnostics/

FUTURE: User will be able to see how many other people have logged this version on the record in the Diagnostics UI

FUTURE: User will be able to see how many other people have logged this version on the record in the Unrecognized.aspx

FUTURE: After 20 submittions it will show as "Auto recognized (20)"

Acknowledgements

Wilson Wu