West Midlands Trains - Wi-Fi Data Import (January 2025 Validation Updates)

West Midlands Trains - Wi-Fi Data Import (January 2025 Validation Updates)

Regular price
Price on Application
Sale price
9 Service Credits


Project outline

  • The CTS team have built a solution to import the Wi-Fi CSV files provided by GoMedia via an SFTP. These files contain information about contact registrations and logins for West Midlands Trains (WMT). The custom solution handles the daily imports of the Wi-Fi CSV files. The files are imported into the two Dotdigital accounts London Northwestern Railway (LNR.SocialMedia.Twitter@wmtrains.co.uk) and West Midlands Railway (WMR.SocialMedia.Twitter@wmtrains.co.uk). The daily import is scheduled to run at 2:00 AM.
  • Updates are required to the solution to:
    • Bypass pre-agreed file validation and process the initial 6 files on the SFTP. These files do not contain all of the expected email, first name, surname, postcode, receive_email and timestamp values.
    • Manually process the six files with validation temporarily disabled.
    • Reinstate the file validation to as scoped for the ongoing daily files/import
  • Validation will be re-enabled for future files, as GoMedia has now made these fields mandatory on their form.
  • For full details of the solution, and the updates, please see the document 'Dotdigital Project Scope - West Midland Trains - Wi-Fi Data Import - v1.3.pdf'.


Project requirements

  • Updates due to be made live in February 2025

Cost and additional information

  • Number of credits = 9

 

Professional Services Terms

The work described hereunder must be redeemed within 12 months from purchase, on a date and time to be agreed with Dotdigital. Unless due to the availability of the Dotdigital platform, any failure to instruct Dotdigital to commence or agree the work described (in whole or in part) will result in forfeiture of the entirety of the fee and no credits or refunds, pro rata or otherwise, will be provided. In addition to the Dotdigital Terms, this product is also subject to the terms found at: https://dotdigital.com/terms/ps-terms/