[teiid-issues] [JBoss JIRA] (TEIID-4034) date parsing in google spreadsheet translator expects soecific timestamp format

[Marco Ardito (JIRA)]

Marco Ardito created TEIID-4034:
-----------------------------------

             Summary: date parsing in google spreadsheet translator expects soecific timestamp format
                 Key: TEIID-4034
                 URL: https://issues.jboss.org/browse/TEIID-4034
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 8.12.3
            Reporter: Marco Ardito
            Assignee: Steven Hawkins


A VDB connecting to a google spreadsheet datasource fails to create the model, and thus fails,  probably due to the fact that one of the spreadhseet fields is formatted timestamp, but uses a different format (dd/MM/yyyy hh:mm:ss) than the one the translator expects (yyyy-mm-dd hh:mm:ss). 

This spreadsheet cited in the forum reference is, in particular, directly generated by google forms, and the timestamp field is created by the form engine to record when the form if fille dby a user with a  timestamp, so no control on the field is possible in the source...

see forum reference for full details/description



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)