VERIFIED SOLUTION i

EngageOne Video - regional differences between projects and PURL spreadhseets

Issue

The bulk PURL generation fails when using a CSV created from a different region compared to the project, such as using a US version of Excel to create PURL CSVs for a UK project.

Cause

The cells with a date number type needs to be changed to the region of the EngageOne Video project.  Other regional variances (currency) may be needed to be changed as well, depending on the Data Dictionary of the project.

Resolution

UPDATED: May 31, 2017
Once the number format has been changed to reflect the region of the project, by highlighting the relevant data cells and changing the number format in bulk, the CSV will be accepted upon saving to a CSV.