I am unable to integrate new data into a PostGIS table with FME, I get this error message. Yet, the original data in the Shapefile is already in date type. Some of the values are just 00000000 (when date is unknown), while others are YYYYMMDD.

Value of attribute 'xxx' could not be converted to type 'date'. Feature will be logged and skipped

Attribute(encoded: UTF-8) : xxx has value `00000000'

Attribute(encoded: UTF-8) : xxx has value '19880101'

  • 1
    do a tester with 00000000 and replace with a real date (can be 19000101)
    – Mapperz
    Mar 1, 2021 at 14:33
  • 2
    it's ok I found out, in fact PostGIS fordbis attribute values ​​'00000000' of type date, I replaced with '99991231' and it works
    – Eliasse
    Mar 1, 2021 at 14:33
  • 1
    @Eliasse, feel free to answer your own question. It ensures that others with this question can scroll past the comments and find the answer easily.
    – Fezter
    Mar 2, 2021 at 0:06


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.