2

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'

Improve this question
3
  • 1
    do a tester with 00000000 and replace with a real date (can be 19000101)
    – Mapperz ♦
    Commented 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
    Commented 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
    Commented Mar 2, 2021 at 0:06

0

Reset to default

Your Answer

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

Browse other questions tagged or ask your own question.