topic Export tMap Mappings to Excel for Review in Talend Studio

Export tMap Mappings to Excel for Review

Anonymous — Mon, 24 Sep 2018 16:41:43 GMT

I would like to export the Source to Target mappings from the tMap into a human readable format (like Excel) so that my client may review and feedback.

How can I achieve this?

Re: Export tMap Mappings to Excel for Review

fdenis — Mon, 24 Sep 2018 16:45:07 GMT

tFileOutputExcel may help you

Re: Export tMap Mappings to Excel for Review

Anonymous — Mon, 24 Sep 2018 16:48:04 GMT

How would I use tFileOutputExcel to get the Source to Target mappings information from the tMap component?

Re: Export tMap Mappings to Excel for Review

fdenis — Mon, 24 Sep 2018 16:58:47 GMT

excuse I did not understood well your question.
if you want to export your tMap Mapping there is 4 way:
1: go to code tab … it's not easy to read.
2: go to project path to extract XMl code of tMAP… it's not easy to read.
3: use Print Screen create your documentation manually
4: use help generator: Right click on job "GenerateDoc as HTML"
good luck

Re: Export tMap Mappings to Excel for Review

Anonymous — Mon, 24 Sep 2018 17:11:00 GMT

None of those options produces an output good enough for a business user to review without massive amounts of effort to convert the content first.

Re: Export tMap Mappings to Excel for Review

Anonymous — Mon, 24 Sep 2018 17:19:53 GMT

To be honest, the business user should provide the mapping specification to the developer. The developer should work to that. However you can build a job to interrogate the job's .item file to pull the mapping info out of that. The .item file is an XML file, so it wouldn't be too hard. However you are likely to pull out a bit of Java. I'm afraid it is unlikely you will get this into an Excel file without a bit of Java to read, without a fair amount of work.

Re: Export tMap Mappings to Excel for Review

fdenis — Mon, 24 Sep 2018 21:17:16 GMT

the solution is on unity test.
it's on dev side.
so make a decision tree to check all cases.
valid them with unity test.
Give this doc to your business user and ask him/her to give you some reals samples/use cases ,to help him/her on validation.
good luck