SAF Import Fails with Datetime Conversion

Forum / Questions & Answers

zach_hoskin
10 days ago
3replies
Answered

Hi,

I have been trying to import a CSV to create some local data tags for use with the data entry tool in Axiom. However, every time that I drop the CSV file into the directory folder, the CSV is processed and moved to the designated folder, but I get an error message stating that the datetime could not be converted and no tags are created in the dataset.

I have attached a screenshot of the error, the SAF_import config and the CSV that I am dropping in the directory folder.

I have tried multiple date and time formats and I have tried combining them into one column and using TimeStampOffset instead of the individual offsets.

I am sure that I'm missing something simple.

Thanks for your assistance,

Zach.

- smason
- 9 days ago
- Reported - view
Hi ,

I think you just need to shift your column offsets by 1. The column offset count starts at 0, not 1. Let me know if that works.
- zach_hoskin
  
  9 days ago
  
  Reported - view
  Hi ,
  
  That worked, I had tried adding an extra column to the CSV, but changing the SAF_Import config file did it.
  
  Thanks for your help, I thought it would be something simple.
- smason
  
  8 days ago
  
  Reported - view
  You're welcome ! Glad it worked!