Articles in this section

Update data in reports

Anders Kristiansen
  • Updated
Follow

note.png NOTE: This article describes how to programmatically updatw reports (UUT/UUR) in WATS. You can also edit single UUT and UUR reports through the web application.

For batch updates, WATS can assist in this process. Use the "Get in touch" option from support.wats.com 

 

  • You can use the WATS Client API to load the reports from the server, apply changes and re-submit them:
TDM api = new TDM();
api.InitializeAPI(true);
ReportHeader[] reportHeaders = api.FindReportHeaders("partNumber eq 'PN1' and revision eq 'v1.2' and reportType eq 'T'", 1000);
foreach (ReportHeader reportHeader in reportHeaders)
{
    UUTReport report = (UUTReport)api.LoadReport(reportHeader.UUID.ToString());
    report.Purpose = "Test";
    report.Location = "Here";
 
    api.Submit(report);
}

note.png NOTE: Using the WATS Client API to re-submit reports changes which client the report belongs to with regards to restricted users.

  • You can use the WATS REST API to get reports, apply changes and re-submit them. Here is an example using PowerShell:
$token = "--your-token-here--"
$url = "http://wats-server.ad.internal"

$headers = @{ 'Authorization' = "Basic $token" }

$getlist = "$url/api/report/query/header?`$filter=PartNumber eq '12345' and Revision eq 'v1.2' and ReportType eq 'T'&`$top=1000"
$list = Invoke-RestMethod -Uri $getlist -Headers $headers

$list | ft -Property UUID,SerialNumber,PartNumber,Start

Foreach ($r in $list)
{
    # Retreive wrml from server
    $uuid = $r.UUID.ToString()
    $reporturl = "$url/api/report/wrml/$uuid"
    $report = Invoke-WebRequest -Uri "$reporturl" -Headers $headers
    $wrml = [xml]$report.Content
    #$wrml.Save("c:\Virinco\WATS\orig-$uuid.xml")

    # Do the modifications:
    $wrml.Reports.Report.Purpose="Test"
    $wrml.Reports.Report.Location="Here"
 
    # Post back to server:
    #$wrml.Save("c:\Virinco\WATS\new-$uuid.xml")
    $xmlstring = $wrml.OuterXml
    $postreporturl = "$url/api/report"
    $result = Invoke-WebRequest -Uri "$postreporturl" -Headers $headers -Method Post -Body "$xmlstring"
    $result
}

Related articles

Comments

2 comments

Date Votes
  • Tue Lunde Schultz

    I want to edit some reports, while maintaining the possibility to review them with the originals.

    Can I modify the above script, to instead of a re-upload, upload it as a new report - new UUID, serial number etc?

    Specifically I want to do some side by side comparison of data structures, and how they impact the Unit Flow.

    I want to maintain the test station in the reports, so I can't upload with the WATS client.

    0
    Comment actions Permalink
  • Anders Kristiansen

    Hi Tue,

    Creating a "duplicate" report will require changing the report id and at least one of serial number, part number, start date/time, or process.

    That would be these modifications:

    $wrml.Reports.Report.ID = New-Guid

    #One of these
    $wrml.Reports.Report.SN="Test"
    $wrml.Reports.Report.PN="Test"
    $wrml.Reports.Report.Start = Get-Date -Format "yyyy-MM-ddTHH:mm:ss.fffffffzzz"
    $wrml.Reports.Report.Process.Code="10"
    $wrml.Reports.Report.Process.Name=$null #Remove process name when changing process code
    if ($wrml.Reports.Report.Process.HasAttribute("Guid")) { $wrml.Reports.Report.Process.Guid=$null } #Remove process guid if it exists when changing process code
    1
    Comment actions Permalink

Please sign in to leave a comment.