Any way to batch rename a folder full of image files to reflect a specific column in an excel sheet? I have a client who I am shooting product photography for, but I need to rename these images to reflect the part number of each item. These are not in any sequential order.
Either using LR5, CS6 or Bridge.
I am not sure about the etiquette of this as I asked the question at NAPP and have as yet gotten nothing. Of course that could be because I'm impatient and more so after I realized I stood a better chance of not just an answer but several variations on the theme.
For years I have stored my images in a folder that is named for the day they were offloaded into the Windows OS computer. I have accepted Nikon, Canon,and Olympus' name for the individual image. So an image would be E:Images20041107DSC_8765.nef.
I wish to go to my files and rename the files with the date ( the image was) actually taken by the camera. I think this is in the EXIF data but how can I access it?
What I want to end up with would have the same format up to the actual image name but the renamed image would be yyyymmdd[taken]DSC_#####.nef where the ##### would be a sequential number generated by the batch or even me.
I imported a batch of file with the file name ©garylittle....nef I need to remove the ©garylittle from the name for the whole batch. F2 doesn't seem to do the job for me. I had before used Bridge becuase it has a much much more well developed file name faciltiy that LR does not have.
I guess one of my questions is "can I use Bridge and have it recognize renaming in LR?"
BTW, there are hundreds of these files so you can see I cannot do each one seperatly and even if I did, the F2 doesn't work right.
i want to export my part list with ilogic in a excel template but dont want all the part list column and dont erase the column i skip in excel?
View 3 Replies View RelatedI'm trying to get an excel sheet to open and count cells based on the text inside a selected column then compare it to cad. The column says "red" or "green" and I want to compare it to a count of red and green hatches in cad.
I managed to get them to be counted in cad but I'm not sure how to get the excel part to work.
Note: I posted an earlier post thinking to count the actually color in the excel cells rather than the words but that ended up being quite complicated.
I am trying to rename/renumber a folder of 100 pictures, so they are all in 3 digits, but remain in the order & have the same number associated with the same file. Right now the folder is numbered 1, 2, 3, 4, etc.. I attempted to do the batch rename through Photoshop to make the folder 001, 002, 003.etc, BUT when I did this, the first picture 1 turned into 001..which is great...but the old 2 turns into 002, but is actually what 10 used to be.
19 turns into 011 instead of 019
40 turns into 035 instead of 040
Why is Photoshop changing the original number to a 3 digit, but changing the number it should have been. I just want it to be 001, 002, 003, 004, 005, 006, 007, 008, 009, 010, 011, 012..
Is there a way to have an image automatically go in to a smart collection when exporting to a specific folder? I have a folder on my desktop that I export every image I want to upload to flickr. I'd like very much for these to also be added to a smart collection.
View 15 Replies View RelatedAt center line I want to place a small perpendicular line in specific length and put their coordinate to excel sheet(export coordinates).
I have already two programs for this, one for placing objects on curve with specific length and 2nd for pick & export coordinates to excel or other type of file. but this is very lengthy process & need too big time. but I think it cab be done in a single command written in lisp.
Is it possible to unfold a sheet metal part and save as a dwg in a specific folder automaticaly using ilogic?
Inventor 2012 Pro
Windows 7 64 bit
Core I5 2410M processor | GeForceGT 525M graphics card | 8G RAM
When importing something off of a DVD or CD how do I direct Lightroom to copy the imported images or folder to a specific folder on my hard drive? It seems to default to MyCatalog but leaves the location on the CD rather than copying it to the drive. If I remove the CD the images is reported as missing.
When I go to the top of the screen for importing I can change the source but the location info on the right is not active or changeable.I am new to lightroom and coming from Photoshop Elements background.
I'd like to make a contactsheet.
To do so, I first have to rename my files from numbers to letters, because otherwise the photo's are at a wrong place in my contactsheet.
I make numbers like: 01, 02 ,03 etc.
When I want to batch the files to rename them with letters, in bridge or with an action in photoshop, then all the files are at another order.
What I have to do so that I can rename it easily and that the programme does what I want?
I know that I am being really obtuse, but batch renaming a set of files really eludes me.My Canon 5D2 has now taken over 20000 images, so I want to place a number before the present file number.eg _MG_2459.CR2 to _MG_022459.CR2. This is easily done in Bridge, but I cannot workout how to do such a simple thing in Lightroom.
View 2 Replies View RelatedWhen I try to rename a folder in LR 5.3, a pop-up tells me the folder cannot be renamed or moved.
View 3 Replies View RelatedI love the batch rename tool in lightroom, but I don't like how it handles duplicates. Is there are way I can change or define how it handles duplicate names. I want it to do xxx (1), xxx (2), xxx (3), etc. instead of xxx, xxx-1, xxx-2, etc.
View 2 Replies View Relatedwhen you rename a photo in LR the name should also change in the root folder.However this does not seem to be happening, I have checked the name in Lightroom and it has changed, ie. family_trip_100 then I go into the folder and bring up the only and exact same photo and it says it is family_trip_7-2
View 2 Replies View RelatedI want to change the names of my files to YYYMMDD-City-State, type of format.. I tried using the file naming template but all that show on the photos is the date.file extension.
View 3 Replies View RelatedI need to be able to choose a specific folder to generate image assets to! Is there some way to do this?
Instead of just creating a folder called nameOfMyFile-assets, I want to generate assets to a folder elsewhere!
How do I apply an edit to every file in a folder? Every time I need to do this, I end up flailing around for 10 minutes before I can finally get it to work. Or, sometimes I give up and manually paste the copied settings to each file one at a time. It seems a no-brainer that "copy settings" followed by "paste settings" to all files selected would do the trick. Or "copy settings" foillowed by "Sync settings." But it doesn't work.
View 3 Replies View RelatedWhen opening a step file and trying to save it, it keeps trying to save it in the 'My Documents/inventor' folder. Even if i select save as and pick a specific folder elsewhere it only saves the top assembly in that location and all sub assemblies and parts are then saved in the My Documents/Inventor folder.
Additional info:
I am operating Autodesk inventor pro 2013.
My project is set to a folder C:inventor workspace
And the folder i am trying to save into is in that folder
Elements 11. I have a folder that I want to just see images that are in aspecific album.
When I click on the folder I see every image whether or not they are in a album. That is I see all images from all albums.
How do I find the ones in the folder that are in a specific album?
I need one ilogic or macro for import the iproperties into excel sheet in a particular folder files.
for example
1.Author
2.Company
3.Part number
4.Description
5.Revision Number
6.Project
7.Designer
8.Creation Date
9.some of the custom iproporties
I want to know if the metadata for each FOLDER I add can be stored separate from all the metadata file, so I could delete just a folder for later recuperate it individually and have it´s metadata?
View 3 Replies View RelatedI have the latest update in LR. I have had this problem on and off and thought maybe it was a bug and once I did the update things would work, but doesn't
So I want to export a folder from LR onto one of my external hard drives however when I click to export my only choice is Desktop. I can open that "tree" as far as it goes but it NEVER shows Computer so I can select which external hard drive to export files to as a backup.
When I go to explorer from the start menu I can see all my files in Explorer including Computer with my external drive just not in LR.
I have restarted my computer, I have tried two different hard drive thinking it just might not recognize one of the drives but that isn't it either.
I have had this problem in the past and haven't been able to figure why sometimes I see my Computer and other times all I see is Desktop as an export option.
I created an Action to batch export a folder of .ai files to create 300dpi .png's of the .ai file's artboard. I did this by simply recording "Export...as png" with my desired settings then Batch running the Action on desired folder of .ai files. The files were successfully exported, the trouble is that the exported files lack a .png file extension. My intent is to take these PNG files and merge them into a single PDF using Acrobat Pro. Unfortunatly, without the .PNG extension, Acrobat Pro does not recognize the file types and does not let me use the Combine Files feature on them. Going back and manually adding a .png at the end of the exported files defeats the time-saving purpose of Batch Processing all together. Is there something I am missing or doing incorrectly? I have included screenshots of 1) My Batch Action settings 2) folders showing files without .png extension and 3) visual of what I see when I am trying to combine PNGs into a PDF.
View 4 Replies View RelatedHow can I import JPEG files with dashes in the file names into the library? In batch from a folder?
View 5 Replies View RelatedI'm getting ready to build a new PC, and I'm trying to plan out how to move my LR catalog/images.
The problem is that since I've been upgrading my current PC for years and moving user data since XP. The result is that my LR catalog expects some older images to be in c:documents and settings... XP-style, others in c:usersxxx when I moved to Vista, and others in d:usersxxx when I moved my user data to a bigger hard drive. The images are actually all in one location, and there are various OS mappings that make it all work.
I'd like to avoid all this mess with my new setup. Is there a way to essentially do "update folder location" on many folders at once? Unfortunately, they are top-level and don't have a parent folder I could do that to.
Oh yeah, using x64 Lightroom 4 on Win7.
I am trying to do a rename of several files at once, but I would like it to use a Custom Name WITHOUT a sequence on the first file. I should be able to select several files and the first file will get the custom name, the second file will get -2, then -3, and so on. If I select 30 files, the first file gets the custom name correctly, then the second file get -31, then -32, and so on. It is counting the number of files I have selected, and then renaming them based on that count!!
The way I have to do it now is to select the first file, do custom name, then select the rest of the files and do sequence.
Lightroom version: 4.4 [891433]
Version: 10.6 [8]
Application architecture: x64
Logical processor count: 4
Processor speed: 3.0 GHz
Built-in memory: 12288.0 MB
Real memory available to Lightroom: 12288.0 MB
Real memory used by Lightroom: 2508.2 MB (20.4%)
Virtual memory used by Lightroom: 4140.8 MB
Memory cache size: 1882.9 MB
Maximum thread count used by Camera Raw: 2
Displays: 1) 1920x1080, 2) 1680x1050
I just renamed all my files using Lightroom (select all; rename files)
Unfortunately, this did not rename the correponding xmp files. Since this is irrevercible, I'm now in a tight spot. I'm stuck this thousands of files with "lost" xmp files
(Also, it is very annoying that the renaming changes the file creation dates! This pretty much destroys my backup routine..)
I recently had a number of old transparencies scanned at a local service bureau and delivered as jpegs on disc. The images import just fine into Lightroom from the disc, but when I try to rename them, I get a dialogue box telling me I can't rename them "...because they are missing or not writable." Thinking, perhaps, that Lightroom was somehow trying unsuccessfully to rename them on the source disc, I tried downloading them to my computer first, ejecting the disc, then importing them into Lightroom. Same result. What am I doing wrong? How do I rename these images?
View 1 Replies View RelatedI set up a template to rename my files, the template was set up to show the date, a job ident and the city and state where the photo was taken. Everything works except I can not get the job ident to show in the name. I made sure in the metadata that the indent was there in the work flow section. I have gone back redone the template.
View 2 Replies View RelatedHow can I resize a batch of files, all to same smaller file size, then export to a new folder?
View 4 Replies View Related