TMS Issue Tracking - QA and Production

MG Extracts/Outputs Needed for FDR

From: Astrophel Evora <ASTROPHEL.EVORA@pb.com>
Sent: Monday, March 23, 2020 12:31 PM
To: TMSCore <TMSCore@pb.com>; Geno Schwartz <geno.schwartz@mercurygate.com>; Mark Engebos <mark.engebos@mercurygate.com>; charles.logon@mercurygate.com
Subject: MG Extracts/Outputs Needed for FDR

It looks like there are 4 outputs from MercuryGate

  1. AdvNotify

    1. SN202003050959159.xml is an example

    2. We didn’t talk about this on the call, but this would need to be recreated in ezVision as well

  2. DailyShipments

    1. This is the NewgisticsReportWriter shipment report, Extract Carrier Performance Report (CSV), that Geno is going recreate in ezVision

    2. Charles is copying the code table needed down

    3. The report will be modified to Filter out the Fleet enterprise SO’s/shipments

  3. MBL

    1. This is a Legacy load extract, Extract Transport (XML) version 2.09, that sends the shipment plans to FastTrak

    2. It needs to remain in this old format so no development work is needed on the PB side to have FastTrak be able to consume this file

    3. Charles will do some work so that the Other Actions will have this extract option available on the ezVision levels

    4. Stephanie’s line haul team will need to recreate and maintain these scheduled load reports

  4. Status

    1. Example, Status-78330625420.xml attached

    2. These are the 214 load status updates that the tracking team uses and updates the underlying packages on shipments

    3. Need to validate that the configuration in ezVision is set up to extract these xml files when the status messages are received/updated in MercuryGate

Example scheduled report for Bullet point 3. MBL

  • Kayvan Shadpour
  • Mar 23 2020
  • Resolved
  • Attach files
  • Kayvan Shadpour commented
    May 07, 2020 19:17

    EZV Carrier extract : By changing Carrier SCAC to Ref:SCAC the field is now populated. All good

  • Astrophel Evora commented
    April 09, 2020 15:08

    Update on 2. NewgisticsReportWriter is set up on Newgistics level, however, the shipment report is missing SCAC. Need to get SCAC updated on the shipment