0

I made a SQLServer database structure based on an XSD schema I got. In that schema two fields have gml:TimePeriodType. In database I put two columns for each field of this type (begin and end) and the datatype is datetime. I use FME to translate database into GML, and then MapForce to map that GML to XSD schema.

I supposed that I can map begin and end column to some attributes of TimePeriod columns in my XSD schema. But (guess), I cannot do it. Can some help me what I need to do and where I am wrong?

FME is translating this columns into string (e.g. 20140522000000.000), which is weird to me (I think I need 2014-05-22T00:00:00 format).

What I am missing?

Sorry if question is stupid, but I am new to all of this, and I need pointers for going forward.

1 Answer 1

1

On the FME side of things you need to add a DateFormatter transformer into your workspace. Use it to convert the source date (20140522000000.000) to ISO DateTime (2014-05-22T00:00:00)

enter image description here

Also make sure the GML Writer is set to use a DateTime for the output, and not a char field:

enter image description here

2
  • My FME is quite different, but I will try. Thanks.
    – Aleksandar
    Commented Jul 22, 2014 at 23:07
  • Make sure you are using FME Workbench (and not just the FME Quick Translator) Commented Jul 23, 2014 at 15:10

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.