[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