topic Re: Rename FolderNames present in Same Directory in Talend Studio

Rename FolderNames present in Same Directory

abhi90 — Tue, 20 Mar 2018 15:43:14 GMT

Hi All,

I want to rename Some Folders present in a Directory. Is it possible to achieve in anyway?

Re: Rename FolderNames present in Same Directory

abhi90 — Tue, 20 Mar 2018 15:44:13 GMT

Hi @TRF, @rhall, @manodwhb can u help please

Re: Rename FolderNames present in Same Directory

Anonymous — Tue, 20 Mar 2018 16:16:44 GMT

Have you tried using the tSystem component?

https://help.talend.com/reader/hfF27SBEP9Avc0ofq7IDjw/mdw6s1fJbAlR4WwQQv9PCw

Re: Rename FolderNames present in Same Directory

abhi90 — Tue, 20 Mar 2018 16:21:11 GMT

Hi @rhall,

What to give command over there? Basically I have to rename all the folder names in that directory to foldername_Sysdate. Sydate I am getting in the Jobflow. Using Global variable of tflowtoiterate I can get that. But How to rename all the folder names? is it possible?By Java code? @xdshi

Re: Rename FolderNames present in Same Directory

Anonymous — Tue, 20 Mar 2018 16:31:56 GMT

You could always use a tFileList and set it to look for directories, then connect a tJava component and use this code....

java.io.File dir = new java.io.File(((String)globalMap.get("tFileList_1_CURRENT_FILEDIRECTORY")));

String newFolderName = "my_new_folder";

dir.renameTo(newFolderName);

You may need to tweak the code (written off the top of my head), but it should kind of work.

Re: Rename FolderNames present in Same Directory

abhi90 — Wed, 21 Mar 2018 06:24:13 GMT

Hi @rhall,

My New Folder Name will be OldSubFolderName_Old_Date. Plus the last line of code is giving compilation error.

Re: Rename FolderNames present in Same Directory

abhi90 — Wed, 21 Mar 2018 06:36:54 GMT

One More thing is happening,

When I am printing the tfilelist Current File directory in tjava I am seeing it is printing only the Parent Directory Name. But not taking inside Subdirectory Names

Re: Rename FolderNames present in Same Directory

Anonymous — Wed, 21 Mar 2018 09:38:57 GMT

Sorry, this was written quickly without access to try it. I've just tested it and tweaked it for you. This code will work.....

System.out.println(((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")));

java.io.File dir = new java.io.File(((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")));

String newFolderName = ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))+"_"+routines.TalendDate.getDate("yyyyMMddHHmmss");

dir.renameTo(new java.io.File(newFolderName));

Keep in mind that I had no idea what you meant by "old date" so I have just added some code to add the current date to the end of the folder names. You will need to adjust that.

Re: Rename FolderNames present in Same Directory

abhi90 — Wed, 21 Mar 2018 12:47:55 GMT

Hi @rhall,

Your solution is working. But only Problem is My Folder is being renamed yesterday is also renaming with today's timestamp. But I dont want to touch earlier folders. I want to rename only folders which created in last Run. I have attached the snapshot how folders are creating. Can You please help

RENAMING.JPG
tfilelist.JPG

Re: Rename FolderNames present in Same Directory

Anonymous — Wed, 21 Mar 2018 12:57:57 GMT

I've made an assumption that your folders will only have a "_" character in them if they have already been renamed. There are better ways of doing this using the date stamp, but this will do. A better way of dealing with this would be to move the folder. Your job will end up taking longer and longer with the more folders you build up in this source folder.

Anyway, this code will stop your previously renamed folders from being renamed again. As I said, you may want to think of better logic than just looking for a "_" character....

System.out.println(((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")));

if(((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")).indexOf('_')==-1){

	java.io.File dir = new java.io.File(((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")));

	String newFolderName = 	((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))+"_"+routines.TalendDate.getDate("yyyyMMddHHmmss");

	dir.renameTo(new java.io.File(newFolderName));
}

Re: Rename FolderNames present in Same Directory

abhi90 — Wed, 21 Mar 2018 13:11:47 GMT

Not working @rhall

Re: Rename FolderNames present in Same Directory

Anonymous — Wed, 21 Mar 2018 13:21:11 GMT

I tested it and it worked. That is exactly the code I tested. What is not working exactly?

Re: Rename FolderNames present in Same Directory

abhi90 — Wed, 21 Mar 2018 13:33:40 GMT

RENAME part

Re: Rename FolderNames present in Same Directory

Anonymous — Wed, 21 Mar 2018 13:36:56 GMT

It will rename any flder without a "_" character in it. I've tested that this is the case. Can you give an example of what is not being renamed?

Re: Rename FolderNames present in Same Directory

abhi90 — Wed, 21 Mar 2018 13:47:05 GMT

Hi @rhall,
Yeah none of the folders are being renamed with the new code. Not even the folders with date timestamp.

Re: Rename FolderNames present in Same Directory

abhi90 — Wed, 21 Mar 2018 13:52:15 GMT

Hi @rhall,
With folders being present there still it is unable to rename my folders without timestamp. 😔😔😔😔. It is iterating perfectly from tFilelist. Printing folderNames. But dont know rename part not happening

Re: Rename FolderNames present in Same Directory

Anonymous — Wed, 21 Mar 2018 14:20:05 GMT

Do the folder paths have "_" in them anywhere?

Re: Rename FolderNames present in Same Directory

abhi90 — Wed, 21 Mar 2018 19:27:50 GMT

Hi @rhall,
Dont know how to thanku Sir. 😊 Thanks a lot. Your solution worked like charm. 😊