GURU'S NEEDED - Help in Special Folder Renaming

CrazyCatGuy

I'm out of my league here! 𝙃𝙚𝙧𝙚❜𝙨 𝙩𝙝𝙚 𝙥𝙧𝙤𝙗𝙡𝙚𝙢:
When you download DAZ3D files, they are usually in a named folder. Well, that's just dandy unless you are trying to create a library with the PROPER 𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗜𝗗 for the folder. The link later below gives an example of how DAZ3D files are enumerated.

You see, I have almost 60-70% of all the DAZ3D/Poser files (from DAZ store) on the internet. I have about 1.2TB files that have a 𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗜𝗗 for the folder, but I probably have that much without a 𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗜𝗗 for the folder. The secret is the 𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗜𝗗 is in the filename of the ZIP file in the folder. Sooooo....

𝗕𝗔𝗧𝗖𝗛 𝗗𝗔𝗭𝟯𝗗 𝗙𝗢𝗟𝗗𝗘𝗥 𝗥𝗘𝗡𝗔𝗠𝗘 𝗣𝗢𝗦𝗦𝗜𝗕𝗜𝗟𝗜𝗧𝗜𝗘𝗦
(Using scripts, PowerShell, a program, whatever can make it happen)

1) Search Folders
2) Find .IM000*.ZIP files
3) Extract (5) NUMBERS following IM000
4) Rename folder using extracted (5) NUMBERS following IM000
5) Rename occurs as PREFIX to folder followed by a hyphen

Example:
1) Search individual folders (e.g.: PW Pirate Treasure)
2) Finds file inside folder named IM00071677-01_PWPirateTreasure.zip
3) The numbers "71677" are extracted.
4) Folder is renamed 71677-PW Pirate Treasure
5) Moves on to next folder.

𝗔𝗟𝗧𝗘𝗥𝗡𝗔𝗧𝗘 𝗠𝗘𝗧𝗛𝗢𝗗 #𝟭

Go to this file list:
http://docs.daz3d.com/doku.php/public/read_me/index/42071/file_list

1) Webcrawl link
2) Select number series
3) Webcrawl links inside umber series
4) Match Folder Name with PRODUCT NAME
4) Extract PRODUCT ID
6) Rename matched folder with PRODUCT ID and hyphen.

Example
1) Searching in 27000-27999 finds "Braided Hair"
2) "Braided Hair" matches existing folder
3) PRODUCT ID is extracted.
4) Existing folder is renamed 27368-Braided Hair

𝗔𝗟𝗧𝗘𝗥𝗡𝗔𝗧𝗘 𝗠𝗘𝗧𝗛𝗢𝗗 #𝟮

http://docs.daz3d.com/doku.php/public/read_me/index/42071/file_list

1) Webcrawl link
2) Select number series
3) Select all Webcrawl links inside umber series
4) From each link, extract PRODUCT NAME and PRODUCT ID
5) Create EMPTY folder from PRODUCT NAME and PRODUCT ID with hyphen separator.

Example:
1) Select 27000-29000 link
2) "Braided Hair" link is crawled.
3) PRODUCT NAME: Braided Hair is extracted
4) .PRODUCT ID: 27368 is extracted
5) Folder name 27369-Braided Hair is created.

Ok, SANET Masters of Programming Goodness out there, how can this be done? If it can be done in a script, I'll need an example. Remember, I'm the broke-ass cripple. :)

AlbinoIvan

CrazyCatGuy Here's Python code that will do what you need in the original requirement. You can change the base_path variable to suit your requirements, this code works on the assumption that it is being executed in the parent folder.

from pathlib import Path
import os, re

base_path = Path('.')
prefix = 'IM000'

for folder in base_path.iterdir():
    if not folder.is_dir() or folder.name.startswith('.'):
        continue
    folder_name = folder.name
    filename_matches = [filename for filename in os.listdir(folder_name)
                        if re.search(r'^IM000.*\.ZIP$', filename, re.IGNORECASE)]    
    if len(filename_matches) > 0:
        filename = filename_matches[0]
        new_folder = filename[len(prefix):len(prefix)+5] + '-' + folder_name
        os.rename(folder_name, new_folder)

abluesboy

Bulk Rename Utility

Freeware version available on net , I use this one :)

Commercial version here :

https://sanet.st/blogs/mordigian/bulk_rename_utility_commercial.3478274.html

CrazyCatGuy

@bubster
Sorry! I wasn't sure if Help Desk meant help with SANET or help in general....in my case, mental help!

abluesboy
BRU has been my friend since it came out! My ex-gf had the picture organization skills of a drunken moose when taking professional pictures. I would use BRU a lot so I wouldn't get screamed at for HER not being able to find anything LOL!

Anyhow, I just went to their forum and downloaded the user manuals, but....I'm not sure how to approach this.

1) Would I focus on using regular expressions (regex) to create a "pseudo-script" that searches in the folder to find the numbers and then appends them as a prefix?
2) There is Append Folder Name (9) in BRU, but again, I need to append a different non-sequential series of numbers to each folder.
3) I can imagine using Move/Copy Parts (6) and Append Folder Name (9) in some way, but it would have to be recursive since the info is coming from inside the folder.

I know...I know...RTFM 🤣 Still, any suggestions on using BRU like I want would help me greatly!

abluesboy

CrazyCatGuy Still, any suggestions on using BRU like I want would help me greatly!

you are already streets in front of me re BRU ... :)

CrazyCatGuy

abluesboy
Ha-ha! I just sound like I know what I'm doing!

If you know anybody else, please have them chime in. Trying to get this finished before I dance with the Devil in the pale moonlight.

Thanks again! 👊

skittles123

Well, I have no script for you. But of you have a word processor and a spreadsheet AND the data is "regular", AND you know your spreadsheet a bit, then you can construct it as follows (it is the long and tedious way.. I promise!). I used snotmonkey as a generic directory name. The following are columns in your spreadsheet.

A you get from dir /S /B *.zip >somefile.txt
Load somefile.txt into a wordprocessor and rename all \ to | (pipe symbol) and save as somefilesep.txt
Import somefile.txt into a spreadsheet/worksheet
import somefilesep.txt into a spreadsheet/worksheet specifying | as field separator
Copy the 2 sheets next to each other (past by value)

You now have columns A thru E

A B C D E F G H I J
C:\library\snotmonkey\IM00071677-01_PWPirateTreasure.zip C: library snotmonkey IM00071677-01_PWPirateTreasure.zip IM00071677- 71677- PWPirateTreasure.zip PWPirateTreasure ren C:\library\snotmonkey C:\library\IM00071677-PWPirateTreasure

F you get thru =RIGHT(LEFT(E5,FIND("-",E5)), LEN(E5)-5)
G thru =RIGHT(F5,LEN(F5)-5)
H thru =RIGHT(E5,((LEN(E5)-FIND("_",E5))))
I thru =LEFT(H5,LEN(H5)-4)
J thru =CONCATENATE("ren", " ",B5,"\",C5,"\",D5," ",B5,"\",C5,"\",G5,I5)

Column J is the rename command (I hope that works in DOS) for each line, just copy all into a batch file and run that.
Try it first on a (partial) copy of your library.
Problem: 4 digit fileIDs will have a 0 prepended, but you can easily get rid of it with Lupas Rename 2000 or some other batch renamer.
If you have variably deep directories... this method will be painful to useless.
You can modify the script to use only the filename to create a dir structure de novo though and generate a copy or move command to file the files away for you.

If some items do not work in Excel you need to look up the equivalent commands.

HTH!

CrazyCatGuy

skittles123
LOL! You're right--that is complicated, and I admit I haven't messed with batch files since the...um...90's. I'm out of practice!

Still, thank you very much for your contribution! I'm going to copy/paste this into a Word file so I can think it through step-by-step.

Funny thing is I can see "HOW" to do all this renaming in my head in my own brain's pseudo-code, but I don't have the skillz to write it out in javascript or some other code. That's what happens when you get in your 50's--your brain turns to slush!

CrazyCatGuy

AlbinoIvan
AWESOME! I'll try to see if I can muck around in Python and make it work :)

𝗧𝗢 𝗘𝗩𝗘𝗥𝗬𝗢𝗡𝗘 𝗧𝗛𝗔𝗧 𝗛𝗔𝗦 𝗖𝗢𝗡𝗧𝗥𝗜𝗕𝗨𝗧𝗘𝗗: This is what makes SANET special! Great software and great contributors!

As an aside, I'm still messing with Bulk Rename Utility for fun. If I come up with a solution using BRU, I'll post it.

CrazyCatGuy

AlbinoIvan
Now, just for the record, this is only the 2nd or 3rd time I've messed with Python, but FUCKING-A, it worked! I had some syntax errors at first, but this worked by placing it in the 2nd directory:

from pathlib import Path
import os, re

base_path = Path('a:/[[[BUNDLE-O-RAMA]]]/2020-10_Daz3D Poser Bundle 7 October 2020')
prefix = 'IM000'

for folder in base_path.iterdir():
if not folder.is_dir() or folder.name.startswith('.'):
continue
folder_name = folder.name
filename_matches = [filename for filename in os.listdir(folder_name)
if re.search(r'^{IM000.*.ZIP$',} filename, re.IGNORECASE)]

if len(filename_matches) > 0:
filename = filename_matches[0]
new_folder = filename[len(prefix):len(prefix)+5] + '-' + folder_name
os.rename(folder_name, new_folder)

I think I peed my trousers a bit with excitement when I saw it changed! 😆
Man, I got to learn Python while I still have the health to do something!

robodo
THAT is a DAMN GOOD suggestion! I screencap shit all the time, but keeping a record of BRU attempts is an excellent idea! Regarding monitor space....well....ummm...
https://www36.zippyshare.com/v/51gkFvQX/file.html
https://www36.zippyshare.com/v/DjsjGqyS/file.html
Sadly, the superwide monitor (PZ2 to DUF in 2nd pic) I got for $279 (reg. $479), got obliterated by one of my cats. Nancy S aka Girlfriend took out both shelves (she's a biggun'!)
The (3) main monitors are those super-duper Dell CAD monitors that last forevever.

As for RegEx...dear God, that is a nightmare! I've downloaded some manuals off here, but [crying ensues].

I ❤️ you guys! This has been the most fun I've had in a long time!

robodo

I imagine folks who understand RegEx would hardly have need of BRU --
or if they did, they'd make BRU do their dishes after the trivial renaming tasks were done! ;)

(My Holidays present to myself -- learn the f*ing RegEx --
that's why you've dL'd 20 different video tutorials from SA for !!)

Some of us other slow-pokes do 1 rename function in BRU at a time, then the next, then the next, etc.

A few weeks ago, I decided to invest a little time in trying to learn the re-numbering function,
so I'd try some stuff and then do a screencap and make my log notes, and so on --
really paid off to record exactly what + what-not-to-do.

I'm still on the 'old' version -- I don't like the way the newer v. eats up EVEN MORE screen space
w/o giving me anything useful in return.

But best of luck - sounds like the Python script may well be the solution
(hopefully Python by NEXT holidays !?! ) Cheers --^--

AlbinoIvan

CrazyCatGuy Have a look for the "Automate the Boring Stuff with Python" book. It should cover almost everything you need.

CrazyCatGuy

AlbinoIvan
Oh, I will be downloading that because changing folders for DAZ3D files that follow the IM00012345.zip format was probably a short yawn 🥱 for you and the other gurus. Changing folders for files from renderosity.com is a coder nightmare in the making. 😫🤬 As for anything from rendererotica.com, only the terminally insane would even open that door to mass confusion hell.

When downloading bundles, you get Renderosity folders with the DAZ store folders. Here's an example of folder content (if you're lucky):
𝗦𝗖 𝗙𝗿𝗲𝘆𝗮 𝗢𝘂𝘁𝗳𝗶𝘁 𝗳𝗼𝗿 𝗚𝗲𝗻𝗲𝘀𝗶𝘀 𝟴 𝗙𝗲𝗺𝗮𝗹𝗲
| Full142089_0b430127e284e59766baf8046eb60d86.jpg
| SC+Frey1_262034.zip, SC+Frey1_262035.zip, SC+Frey1_262036.zip, SC+Frey1_262037.zip
Soooo....which number do we use? 🤔 Wait...how do we know the folder # won't conflict with a DAZ store folder?

This one I have manually named by the convention that is SUPPOSED to be used, but maybe 1 folder in 5,000 will be done right--the designers are just lazy. The CORRECT name of this folder would be:
𝗥𝗢𝟬𝟬𝟭𝟰𝟮𝟮𝟯𝟮-𝗦𝗖 𝗙𝗿𝗲𝘆𝗮 𝗢𝘂𝘁𝗳𝗶𝘁 𝗳𝗼𝗿 𝗚𝗲𝗻𝗲𝘀𝗶𝘀 𝟴 𝗙𝗲𝗺𝗮𝗹𝗲
and yeah (LOL) it took me while to figure this out.

If you are lucky 🤞, the folder will have a .JPG with Full123456_[some random shit]. I can see altering the original Python file to parse the .JPG, grab the numbers, add an "RO" and append it as a prefix. Well, for me, their might be much screaming involved😱...because technically, if the number series is less than (6), "zeroes" would be added after the "RO".

𝘽𝙐𝙏 𝙒𝘼𝙄𝙏! 𝙒𝙝𝙮 𝙨𝙩𝙤𝙥 𝙩𝙝𝙚𝙧𝙚? 𝙒𝙝𝙮 𝙩𝙝𝙖𝙩 𝙨𝙚𝙧𝙞𝙚𝙨? Here we get into the realm of the "hardcore mofo programmer." A DAZ user will have to unzip those files in the example above and manually drag the folders/files into their content directory--suckage at best. The DAZ store IM00012345.zip files contain XML files to load DAZ files through Daz Install Manager (DIM). This is cool because you can uninstall whatever you install, and it keeps a record so duplicates don't get installed.

There's a program called "Content Package Assist" (IM00030735-01_ContentPackageAssistWin.zip) that is loaded through DIM or the .EXE can be extracted and run separately. 𝗜𝘁❜𝘀 𝗼𝗻𝗹𝘆 𝗯𝗲𝗲𝗻 𝗮𝗿𝗼𝘂𝗻𝗱...𝗼𝗵...𝗺𝗮𝘆𝗯𝗲 𝟴-𝟭𝟬 𝘆𝗲𝗮𝗿𝘀, and gosh-golly-gee, it makes .ZIP files that can be added to DIM.

Mighty difficult to use🤯....you know, real Einstein-level stuff like draggin' the aforementioned .ZIP files into a window, dragging the .JPG into a little window, and...hold your breath...typing in the "RO" prefix and the numbers (it automatically adds extra digits). A couple other options, and PRESTO--a file that can be loaded in DIM.

And those muthafuckers on Renderosity rarely, rarely ever use it. I use "Content Package Assist" for all non-DIM files like Renderosity or make my own homebrew groups like WW00000069-WonderWomanHotness.zip

Like Martin Luther King 🤴🏾, I have a dream...a dream of fluffy bunnies 🐇 and sprites 🧚where I had a program that would a) fix the Renderosity folder name and b) hook into "Content Package Assist" and make my happy-snappy DIM file.

Any takers? Mind you, I'm a broke-ass cripple who will likely be pushing up daisies...sometime...so, I can't pay you.😂 But, we can dream like the MLK, my bruthas!👊🏾

CrazyCatGuy

[wide-eyed staring accompanied with drool, and that twitching tick you get under the left eye]
[I ❤️ Python now!]
Um....I'll be blunt: I got a lot of shit, and I haven't touched the Renderosity files. I'm still short on the elusive 38000-41000 series. So,
@silversurfer , @iNDEx , @bubster , @marquard
if you guys ever decide to you'd like to bless me with upload privileges, I have....lots...lots and LOTS of DAZ files!
😸😸😸