[JBoss JIRA] (TEIIDDES-2815) Flat File Import - "Parse Selected Row" feature works incorrectly
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2815?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2815:
-----------------------------------
Summary: Flat File Import - "Parse Selected Row" feature works incorrectly (was: Flat File Import - Parse Selected Row works incorrectly)
> Flat File Import - "Parse Selected Row" feature works incorrectly
> -----------------------------------------------------------------
>
> Key: TEIIDDES-2815
> URL: https://issues.jboss.org/browse/TEIIDDES-2815
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.6, 10.0.1
> Reporter: Matus Makovy
> Attachments: EmpData.csv, Screen Shot 2016-03-30 at 9.24.56.png
>
>
> In Empdata.csv, there are data that include "annual salary". This value is entered as "$71,000.00" (for example). If you choose "character delimited" column format, click on some row in File Contents Preview and hit "Parse Selected Row" the values are parsed as:
> ... AnnualSalary: $7, Title: 000.00" ...
> Expected result is:
> ... AnnualSalary: $71,000.00, Title: Associate, ...
> Actually, when you finish the wizard and hit preview on the table (or create a VDB and query the table) the value is parsed correctly. Only the "Parse Selected Row" feature parses the row incorrectly.
> Screenshot attached
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2815) Flat File Import - Parse Selected Row works incorrectly
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2815?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2815:
-----------------------------------
Description:
In Empdata.csv, there are data that include "annual salary". This value is entered as "$71,000.00" (for example). If you choose "character delimited" column format, click on some row in File Contents Preview and hit "Parse Selected Row" the values are parsed as:
... AnnualSalary: $7, Title: 000.00" ...
Expected result is:
... AnnualSalary: $71,000.00, Title: Associate, ...
Actually, when you finish the wizard and hit preview on the table (or create a VDB and query the table) the value is parsed correctly. Only the "Parse Selected Row" feature parses the row incorrectly.
Screenshot attached
was:
In Empdata.csv, there are data that include "annual salary". This value is entered as "$71,000.00" (for example). If you choose "character delimited" column format, click on some row in File Contents Preview and hit "Parse Selected Row" the values are parsed as:
... AnnualSalary: $7, Title: 000.00" ...
Expected result is:
... AnnualSalary: $71,000.00, Title: Associate, ...
Actually, when you finish the wizard and hit preview on the table (or create a VDB and query the table) the value is parsed correctly. Only the "Parse Selected Row" features parses the row incorrectly.
Screenshot attached
> Flat File Import - Parse Selected Row works incorrectly
> -------------------------------------------------------
>
> Key: TEIIDDES-2815
> URL: https://issues.jboss.org/browse/TEIIDDES-2815
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.6, 10.0.1
> Reporter: Matus Makovy
> Attachments: EmpData.csv, Screen Shot 2016-03-30 at 9.24.56.png
>
>
> In Empdata.csv, there are data that include "annual salary". This value is entered as "$71,000.00" (for example). If you choose "character delimited" column format, click on some row in File Contents Preview and hit "Parse Selected Row" the values are parsed as:
> ... AnnualSalary: $7, Title: 000.00" ...
> Expected result is:
> ... AnnualSalary: $71,000.00, Title: Associate, ...
> Actually, when you finish the wizard and hit preview on the table (or create a VDB and query the table) the value is parsed correctly. Only the "Parse Selected Row" feature parses the row incorrectly.
> Screenshot attached
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2815) Flat File Import - Parse Selected Row works incorrectly
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2815?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2815:
-----------------------------------
Attachment: EmpData.csv
EmpData.csv attached
> Flat File Import - Parse Selected Row works incorrectly
> -------------------------------------------------------
>
> Key: TEIIDDES-2815
> URL: https://issues.jboss.org/browse/TEIIDDES-2815
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.6, 10.0.1
> Reporter: Matus Makovy
> Attachments: EmpData.csv, Screen Shot 2016-03-30 at 9.24.56.png
>
>
> In Empdata.csv, there are data that include "annual salary". This value is entered as "$71,000.00" (for example). If you choose "character delimited" column format, click on some row in File Contents Preview and hit "Parse Selected Row" the values are parsed as:
> ... AnnualSalary: $7, Title: 000.00" ...
> Expected result is:
> ... AnnualSalary: $71,000.00, Title: Associate, ...
> Actually, when you finish the wizard and hit preview on the table (or create a VDB and query the table) the value is parsed correctly. Only the "Parse Selected Row" features parses the row incorrectly.
> Screenshot attached
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2815) Flat File Import - Parse Selected Row works incorrectly
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2815:
--------------------------------------
Summary: Flat File Import - Parse Selected Row works incorrectly
Key: TEIIDDES-2815
URL: https://issues.jboss.org/browse/TEIIDDES-2815
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 9.0.6, 10.0.1
Reporter: Matus Makovy
Attachments: Screen Shot 2016-03-30 at 9.24.56.png
In Empdata.csv, there are data that include "annual salary". This value is entered as "$71,000.00" (for example). If you choose "character delimited" column format, click on some row in File Contents Preview and hit "Parse Selected Row" the values are parsed as:
... AnnualSalary: $7, Title: 000.00" ...
Expected result is:
... AnnualSalary: $71,000.00, Title: Associate, ...
Actually, when you finish the wizard and hit preview on the table (or create a VDB and query the table) the value is parsed correctly. Only the "Parse Selected Row" features parses the row incorrectly.
Screenshot attached
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2355) Provide an option to import pushdown functions
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2355?page=com.atlassian.jira.plu... ]
Matus Makovy commented on TEIIDDES-2355:
----------------------------------------
[~blafond] I don't have that project anymore, but I'll import from the database once more and let you know.
> Provide an option to import pushdown functions
> ----------------------------------------------
>
> Key: TEIIDDES-2355
> URL: https://issues.jboss.org/browse/TEIIDDES-2355
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Patch Release, Teiid Integration
> Reporter: Steven Hawkins
> Assignee: Barry LaFond
> Fix For: 9.2.1
>
>
> The import property importer.importPushdownFunctions can be set to have Teiid include the pushdown functions as part of the imported schema and there by the ddl used by designer. With TEIID-3098 will prevent there from being ambiguity from doing so (either from multiple models or from the pushdown functions). So Designer should allow users to import these functions if they wish (it could even be a default option).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2809) Import/Export Dynamic VDB utility ignores visibility flag and always sets to true
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2809?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2809.
------------------------------------
Resolution: Done
committed to master and 9.0.x
> Import/Export Dynamic VDB utility ignores visibility flag and always sets to true
> ---------------------------------------------------------------------------------
>
> Key: TEIIDDES-2809
> URL: https://issues.jboss.org/browse/TEIIDDES-2809
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Patch Release
> Affects Versions: 9.2
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Fix For: 10.0.1, 9.0.7
>
>
> import a dynamic vdb in Teid designer, the vdb and related models are generated, however, the visibility flags are not taken into account properly: all models have the visible flag enabled in the vdb, however, i expect models with visbile="false" to have the visible flag disabled.
> Same goes when we export a Teiid vdb to a vdb xml: the visibilty flags are not taken into account properly.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months