Editing your ProLogger II data before upload - "String was not recognised as a valid DateTime" error

Editing your ProLogger II data before upload - "String was not recognised as a valid DateTime" error

In some cases, you may want to edit your ProLogger .csv data file before you upload it to PATGuard Cloud. 

Excel can be used for this, but when saving the file from Excel back to .csv format, Excel will change the date format to a different format to the one used by the ProLogger. This will cause the import to fail with a "String was not recognised as a valid DateTime" error. 

To avoid this issue, follow the following steps when editing your .csv data file in Excel:
  1. Open Excel
  2. Select Data -> From Text from the menu and open your ProLogger .csv file.
  3. In the Text Import Wizard, in Step 1, select the Delimited option.
  4. Press Next.
  5. Select the Comma check box, and uncheck all other Delimiter check boxes.
  6. Press Next.
  7. In the Data preview section in the lower part of the dialog, select all columns:
    - Select the first column
    - Scroll all the way to the right by dragging the scroll bar to the right
    - Hold shift, click on the last column and release shift to select all columns.
  8. Select the Text option from the Column data format section in the upper left of the dialog. (This tells Excel to not try and understand the date data as dates, but instead treat everything simply as text.)
  9. Click Finish and select New worksheet in the dialog box that appears next.
  10. Make any required changes to the data.
  11. Save the data as a csv file and import it to PATGuard Cloud in the usual way.


    • Related Articles

    • Administering data lists in PATGuard Cloud

      This feature provides the ability to administer a series of dropdown lists in PATGuard Cloud including Asset Class, Test Type and Test Type Result dropdown lists. To access and manage the lists: Select 'Settings' from the more menu Click the 'Manage ...

    • How to change data import settings in PATGuard Cloud

      There are 3 options to import data into PATGuard Cloud, and these methods can be changed by going into Settings > Data in the app. Data Import Options The options for importing data are: Unique Asset IDs Site/Location/Asset ID Matching Track for ...

    • Custom Fields in PATGuard Cloud

      PATGuard Cloud has the ability for additional user chosen fields (called custom fields) to be added to certain objects in the system for tracking your own values. Summary The following is a summary of features: Add additional fields (of varying data ...

    • Download and Upload from a Seaward Primetest Elite/Apollo 600 via Bluetooth

      lease use the following instructions to download a GAR file from the Primetest Elite/Apollo 600 to/from PATGuard Cloud Pre-Requisites Testing Device has the target mobile device selected Before uploading and downloading from a device via Bluetooth is ...

    • HireHop Integration Overview with PATGuard Cloud

      When enabled, the PATGuard Cloud HireHop integration enables asset testing information to be sent to HireHop automatically. Pre-requisites In HireHop, your subscription must be a paid tier and not the freemium tier. This is mainly due to the Testing ...