[JBoss JIRA] Created: (TEIIDDES-1068) Import of Salesforce model does not map the BusinessHours table columns correctly
11:21 p.m.
Import of Salesforce model does not map the BusinessHours table columns correctly
---------------------------------------------------------------------------------
Key: TEIIDDES-1068
URL: https://issues.jboss.org/browse/TEIIDDES-1068
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.4
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 7.6
Import from salesforce instance does appear to be mapping the BusinessHours column types
correctly. The SundayStart,SundayEnd,MondayStart,MondayEnd,etc types should map to a time
based datatype. It either does not get mapped or it maps to a string.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:54 p.m.
New subject: [JBoss JIRA] (TEIIDDES-1068) Import of Salesforce model does not map the BusinessHours table columns correctly
[
https://issues.jboss.org/browse/TEIIDDES-1068?page=com.atlassian.jira.plu...
]
Mark Drilling commented on TEIIDDES-1068:
-----------------------------------------
Fixed the salesforce modelgenerator to correctly interpret salesforce fields with Time
datatype and set the imported columns correctly. This solves the import in designer, but
I logged an issue with the teiid salesforce translator - since the translator does not
handle the time columns when queried. (see JIRA TEIID-1852)
The workaround to allow queries until TEIID-1852 is resolved - change the columns with
Time datatype to String datatypes...
Import of Salesforce model does not map the BusinessHours table
columns correctly
---------------------------------------------------------------------------------
Key: TEIIDDES-1068
URL: https://issues.jboss.org/browse/TEIIDDES-1068
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.4
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 7.6
Import from salesforce instance does appear to be mapping the BusinessHours column types
correctly. The SundayStart,SundayEnd,MondayStart,MondayEnd,etc types should map to a time
based datatype. It either does not get mapped or it maps to a string.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:56 p.m.
New subject: [JBoss JIRA] (TEIIDDES-1068) Import of Salesforce model does not map the BusinessHours table columns correctly
[
https://issues.jboss.org/browse/TEIIDDES-1068?page=com.atlassian.jira.plu...
]
Mark Drilling updated TEIIDDES-1068:
------------------------------------
Workaround Description: Until TEIID-1852 is resolved, set the columns with
'time' datatype to 'string'
Workaround: Workaround Exists
Import of Salesforce model does not map the BusinessHours table
columns correctly
---------------------------------------------------------------------------------
Key: TEIIDDES-1068
URL: https://issues.jboss.org/browse/TEIIDDES-1068
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.4
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 7.6
Import from salesforce instance does appear to be mapping the BusinessHours column types
correctly. The SundayStart,SundayEnd,MondayStart,MondayEnd,etc types should map to a time
based datatype. It either does not get mapped or it maps to a string.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:15 p.m.
New subject: [JBoss JIRA] (TEIIDDES-1068) Import of Salesforce model does not map the BusinessHours table columns correctly
[
https://issues.jboss.org/browse/TEIIDDES-1068?page=com.atlassian.jira.plu...
]
Mark Drilling commented on TEIIDDES-1068:
-----------------------------------------
After more discussion, was decided to set the imported column type to 'string' for
salesforce 'time' (for now) - until the translator can handle them.
Added a TODO in 'RelationalModelgenerator.java'.
Pushing this JIRA to 7.7 - implement the TODO once TEIID-1852 is resolved.
Import of Salesforce model does not map the BusinessHours table
columns correctly
---------------------------------------------------------------------------------
Key: TEIIDDES-1068
URL: https://issues.jboss.org/browse/TEIIDDES-1068
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.4
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 7.6
Import from salesforce instance does appear to be mapping the BusinessHours column types
correctly. The SundayStart,SundayEnd,MondayStart,MondayEnd,etc types should map to a time
based datatype. It either does not get mapped or it maps to a string.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:17 p.m.
New subject: [JBoss JIRA] (TEIIDDES-1068) Import of Salesforce model does not map the BusinessHours table columns correctly
[
https://issues.jboss.org/browse/TEIIDDES-1068?page=com.atlassian.jira.plu...
]
Mark Drilling updated TEIIDDES-1068:
------------------------------------
Fix Version/s: 7.7
(was: 7.6)
Import of Salesforce model does not map the BusinessHours table
columns correctly
---------------------------------------------------------------------------------
Key: TEIIDDES-1068
URL: https://issues.jboss.org/browse/TEIIDDES-1068
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.4
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 7.7
Import from salesforce instance does appear to be mapping the BusinessHours column types
correctly. The SundayStart,SundayEnd,MondayStart,MondayEnd,etc types should map to a time
based datatype. It either does not get mapped or it maps to a string.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:23 p.m.
New subject: [JBoss JIRA] (TEIIDDES-1068) Import of Salesforce model does not map the BusinessHours table columns correctly
[
https://issues.jboss.org/browse/TEIIDDES-1068?page=com.atlassian.jira.plu...
]
Mark Drilling resolved TEIIDDES-1068.
-------------------------------------
Resolution: Done
changed the mapped datatype to 'time' since the dependent jira has been
addressed.
Import of Salesforce model does not map the BusinessHours table
columns correctly
---------------------------------------------------------------------------------
Key: TEIIDDES-1068
URL: https://issues.jboss.org/browse/TEIIDDES-1068
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.4
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 7.7
Import from salesforce instance does appear to be mapping the BusinessHours column types
correctly. The SundayStart,SundayEnd,MondayStart,MondayEnd,etc types should map to a time
based datatype. It either does not get mapped or it maps to a string.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4578
days inactive
4681
days old
teiid-designer-issues@lists.jboss.org
5 comments
4 participants
participants (4)
-
Mark Drilling (Commented) (JIRA) -
Mark Drilling (JIRA)
-
Mark Drilling (Resolved) (JIRA)
-
Mark Drilling (Updated) (JIRA)