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)