thanks for the reload. Here are some instructions to help mass convert the files to usable format for mgalaxy
How to convert screen shot to the right format for mgalaxy
Need to convert .jpg to .png
Need to remove the _1
RECOMMEND you create a back up copy of all your files before you try this
- Open the file where all the screen shots are located, Copy the path in the explore search bar
- Paste into google chrom search bar (this will produce a list of all the files)
- Ctrl+A (will select all the files names)
- Ctrl+C (copy all files)
- Open excel
- Ctrl+P paste the list of all the files
- Delete all columns except the file names, column A
- Select column header (will highlight all file names)
- Ctrl+C (copy column)
- Select column D
- Right click paste special, values
- Delete column A (this will change the column the name are in to column C)
- Click sheet on bottom and right click, then chose move or copy, click box next to copy, ok (Create a copy that column on to a new sheet, sheet 2)
- On sheet 2, Ctrl+F (find/replace)
- find“_1” and replace “no text” this will remove the _1 from all the titles
- Find “.jpg” and replace “.png” (this will replace all .jpg with .png)
- Copy and paste the column containing the new names, 2PCASH_NUDGER. png to sheet 1 column “I”
- Enter the following in each column A=rename, B=”, C =original name, D=”, E= no text, F=”,G= new name, H=”
- For column I need to use the concatenate formula it wil look like this for row 4, =CONCATENATE(A4," ",B4,C4,D4," ",F4,G4,H4)
- Column I now contains the text to create a batch file
- Highlight all the cells you want to copy, Ctrl+C (copy all the cells containing the file names you want to convert)
Create a batch file
- Open note pad
- Ctrl + P (paste all the names)
rename "2PCASH_NUDGER_1.jpg" "2PCASH_NUDGER.png"
rename "5pReady2Rumble_1.jpg" "5pReady2Rumble.png"
- File, Save as, enter a file name.bat and you must change the save file type from .txt to all file types
- Save created batch file in the folder that has all the .jpg images
- click the newly created batch file, all your screen shots should be rename and in the right format to use in mgalaxy
enjoy