topic Re: File to cmis in Talend Studio

File to cmis

phiibuntu — Sat, 16 Nov 2024 07:07:57 GMT

hello,

I need help for, I hope, a simple scenario :

I 've got files in a repertory (file name = Id)

I've got mysql database with id and name file and some fields from documents from my CRM.

I want to send renamed files in Alfresco with tadvancedcmisoutput

I try tfilelist and tdbinput(mysql) with tmap and tadvancedcmisoutput ....but I don't manage to rename files ....so I can't send them with cmis in Alfresco. I hope I'am clear enough to have some help

Re: File to cmis

Anonymous — Thu, 06 Dec 2018 04:23:16 GMT

Hi,

Could you please share the current screenshot of your job so that we will get a better idea of the flow?

Warm Regards,

Nikhil Thampi

Re: File to cmis

phiibuntu — Thu, 06 Dec 2018 05:45:36 GMT

Hi thanks for help here the screenshot.

The excel output is only for verifcation about my mysql inner joint.

I think I miss the files transfert and rename to cmis, I have correct metadata with the tmap

but no files in cmis (sorry for my bad english).

Re: File to cmis

Anonymous — Thu, 06 Dec 2018 08:14:34 GMT

Hi,

Since you are using a custom CMS Output component, I will not be able to comment on it.

But if you are trying to rename the file, you can go ahead and change the name using tFTPRename component.

Below are the details of the component.

You can pick one file at a time using tFTPList and pass it as input parameters to the tFTPRename component.

Warm Regards,

Nikhil Thampi

Re: File to cmis

phiibuntu — Fri, 07 Dec 2018 07:34:13 GMT

thanks for anwser, I understand for custom component, but tfilelist and tfilecopy (witherename option) can't be use to do the same thing?

tftp nedd to install ftp server, where tfilecopy works in local isn't it? or do I miss something?

Re: File to cmis

Anonymous — Fri, 07 Dec 2018 07:38:14 GMT

Hi,

You are right. You can use the tfilecopy if the fiels are in same server and it will be quite easy.

Somehow I was thinking that you were trying to do it using FTP and that is the reason why I gave previous option. My apologies for that.

Warm Regards,

Nikhil Thampi