[resolved] Schemas and XML Export/Import feature

Five Stars JPH
Five Stars

[resolved] Schemas and XML Export/Import feature

Hello,
I actually use TOS for Data Integration.
More exactly i deal with schemas of db connections.
In the schema window, there are 2 columns in the list of schema columns:
"Column" : that shows you a label for the column
"Db Column" : that shows you the physical name of the Db column
In 4.2 version, i used a feature that allows to export a schema in a XML format and then re-import it.
In 5.1.2, it exports correctly the schema:
<?xml version="1.0" encoding="UTF-8"?>
<schema dbmsId="mega_id">
<column comment="" default="" key="false"
label="_310000000D00_Absolute_Identifier_" length="8"
nullable="false"
originalDbColumnName="~310000000D00"
pattern="" precision="0" talendType="id_String" type="MegaIdentifier"/>
<column comment="" default="" key="false"
label="_lfGkEeBZ6910_Aggregated_Status_" length="160"
nullable="true"
originalDbColumnName="~lfGkEeBZ6910"
pattern="" precision="0" talendType="id_String" type="String"/>
</schema>

Then in the XML file, i modify the label in order to make it more user friendly:
<?xml version="1.0" encoding="UTF-8"?>
<schema dbmsId="mega_id">
<column comment="" default="" key="false"
label="MA_Absolute_Identifier" length="8"
nullable="false"
originalDbColumnName="~310000000D00"
pattern="" precision="0" talendType="id_String" type="MegaIdentifier"/>
<column comment="" default="" key="false"
label="MA_Aggregated_Status" length="160"
nullable="true"
originalDbColumnName="~lfGkEeBZ6910"
pattern="" precision="0" talendType="id_String" type="String"/>
</schema>

Then i import this file in the schema using the button called "Replace all rows by import from xml file".
But the value in Column and Db Column are the same and equal to the label.
If i export the new schema it gives me:
<?xml version="1.0" encoding="UTF-8"?>
<schema dbmsId="mega_id">
<column comment="" default="" key="false"
label="MA_Absolute_Identifier" length="8"
nullable="false"
originalDbColumnName="MA_Absolute_Identifier"
pattern="" precision="0" talendType="id_String" type="MegaIdentifier"/>
<column comment="" default="" key="false"
label="MA_Aggregated_Status" length="160"
nullable="true"
originalDbColumnName="MA_Aggregated_Status"
pattern="" precision="0" talendType="id_String" type="String"/>
</schema>

So in fact the physical column name seems to be lost when importing xml file.
Is this a bug or just an error from me?
Thanks

Accepted Solutions
Five Stars JPH
Five Stars

Re: [resolved] Schemas and XML Export/Import feature

Hi all,
For those who are interested in this thread. An issue has been logged in Jira and at this moment it has been solved and it will be available in the next releases 5.1.3 and 5.2.1.
https://jira.talendforge.org/browse/TDI-23890

All Replies
One Star

Re: [resolved] Schemas and XML Export/Import feature

If you change the label name in the schema, the column name changes in both versions.
Five Stars JPH
Five Stars

Re: [resolved] Schemas and XML Export/Import feature

Effectively so my conclusion is that it is a bug, no?
One Star

Re: [resolved] Schemas and XML Export/Import feature

Not necessarily. Why would you want them to be different?
You can give them any name - they don't have to be the same as the database column name.
Five Stars JPH
Five Stars

Re: [resolved] Schemas and XML Export/Import feature

The Db Column name is the one used by talend to make operations on the database table so it must not be at the hand of the user.
One Star

Re: [resolved] Schemas and XML Export/Import feature

Yes on output but not on input.
Five Stars JPH
Five Stars

Re: [resolved] Schemas and XML Export/Import feature

Is it possible to declare a bug in jira for this please?
The problem exists too in Talend 5.2 version.
Five Stars JPH
Five Stars

Re: [resolved] Schemas and XML Export/Import feature

Hi all,
For those who are interested in this thread. An issue has been logged in Jira and at this moment it has been solved and it will be available in the next releases 5.1.3 and 5.2.1.
https://jira.talendforge.org/browse/TDI-23890

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download