Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
phiibuntu
Contributor
Contributor

File to cmis

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 0683p000009MACn.png

 

 

Labels (3)
5 Replies
Anonymous
Not applicable

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

phiibuntu
Contributor
Contributor
Author

Hi thanks for help 0683p000009MACn.png 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).

 

0683p000009M177.png  

Anonymous
Not applicable

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.

0683p000009M1EN.png

 

 

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

 

Warm Regards,

 

Nikhil Thampi

phiibuntu
Contributor
Contributor
Author

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?

Anonymous
Not applicable

Hi,

 

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

0683p000009M1Mp.png

 

 

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