Photoshop :: How To Import Info Of Excel File To IPTC Of Batch Of JPG
Nov 10, 2012
I have a batch of 5000 pictures (jpg). I need to add the information that I have in an .xls file (Excel), from a column with the description of each picture. Each description is different from the others, so I would have to assign the code number of the file jpg (first colum of the excel) to the correspondance info that exists in the column of the description/caption into the IPTC field.
I have tried several ways, applications that I have found through Google, but I have no way to do it. It seems that the origin of the problem is the xls file or the txt file that I have had to created to try to do the importation. In any case messages of errors like "the file does not exists", etc etc. I don`t know what to do it. It's very important and urgent for my job.
* I work with MAC OX S 10.7.5, Adobe Photoshop CS5.1
* I have tried applications like: DIY Metadata, VRA Export-Import Metadata and another ones... which names I don't remember now.
View 7 Replies
ADVERTISEMENT
Jan 8, 2012
I have the descriptive text for several hundred images in an excel sheet. There are five separate fields (excel columns) - Image filename; Title (Headline); Description (Caption); Keywords; Location how I can import this information into a lightroom catalog and match them up with the relevant images ? I can export the excel informaton into an xml file but would need to know the relevant field names.
View 3 Replies
View Related
Aug 28, 2006
Is there any way to use the "save for web" feature and still keep IPTC (file info) keywords with the file?
View 4 Replies
View Related
Sep 15, 2012
Is it possible to fill IPTC Date Created Field from the raw-file properties at import to LR4?
View 3 Replies
View Related
Sep 21, 2013
I do bird photography and would like to create a smart collection that would capture for example all of the warbler / magnolia that I have captured. I'd like to have the capture date, file name, and keyword in a spreadsheet file.
View 2 Replies
View Related
Apr 4, 2012
This is a technical point...
Step by step:
- with an external dam software (IDimager), I assign the tag Event ("Iptc4xmpExt:Event") with, say, "TEST", to a jpg file.
- I update the file, then close IDimager.
- I open PS, open the jpg file and look at its informations (File > Informations)
Under "IPTC Extension", the box "Event" is empty... No more "TEST". I look at "Advanced" and I find this :
> no "IPTC Extension",
If I check the tag Event with an other program (XnView which allows to see the XMP, or the free and excellent EXIFTool), all is right. There is no problem with this mysterious "_1_" added by PS at the end of the Event tag name.
View 4 Replies
View Related
Mar 21, 2012
I have a general table in my engineered print. It consists of basic columns with text. How can i have Inventor refresh the data if i change the Excel without having to delete and re insert a table ?
Autodesk Inventor Professional 2011
View 1 Replies
View Related
Jun 26, 2013
I have an excel file with thousands of rows, each with a column for the x-coordinate, the y-coordiante, the height, and width of a rectangle. I need a script that will ask me to select the excel file, read the excel file, and create rectangles from each of the thousands of rows. I'm working in a windows environment and have Illustrator CS4. Any scripts out there that might give me a start?
View 7 Replies
View Related
Jun 15, 2013
I've spent the last 4 hours searching for an answer to this question, but I simply can't find one.
As a start I think you have to know that I'm currently using AutoCAD 2012.
Here's the problem: I need to extract some info from an AutoCAD table to a reference file that can be opened in Microsoft Excel. Everything I find on the subject is actually an answer to the question "How does <DATAEXTRACTION> work?" or "How to do an extraction of DATA in AutoCAD?"....
In this particular case I have a set of production drawings (cut tickets) for manufacturing of stone. And in every single sheet I have this material schedule or a table, if you wish, that is made with an AutoCAD table. In this schedule I have the height, width and thickness of the stone plate and with a function it measures it's area and volume. What I want to do is to extract those values into a reference file that I can open with Microsoft Excel, as I already said.
How exactly?
View 3 Replies
View Related
Oct 16, 2011
The IPTC keywords contain tags in many of my photos that have long since been deleted or changed. Is there any way to batch edit this field?
View 1 Replies
View Related
Apr 19, 2007
I'm taking some photos for my portfolio, when I'm done tweaking them in PS, I go up to the title bar of the document>right-click>File Info, then I'll add my necessary info.
Rather than doing this every time, I remember reading or watching a tutorial years ago about importing copyright info automatically into the photo's "File Info".......
Does anyone know about this? Cause I don't remember how the heck to do it!
View 3 Replies
View Related
Feb 6, 2014
I have a very large excel file with a list of companies in this format:
company_category company_name company_description telephone email
In InDesign I have paragraph style for each one but I need a solution to import all this data and apply the styles automatically.
Few things:
- I don't want to import all these into a table. I want all the info in a 3 text columns format that will run accros 150 pages (more or less)
- I'm using InDesign CS6
Is there any way to automate this?
View 2 Replies
View Related
Dec 22, 2011
I am using Auto Cad LT 2012. How do I import an Excel spreadsheet into my drawing?
View 2 Replies
View Related
Feb 9, 2012
I am looking to import an excel file to creat points within LT 2012. Can this be done?
View 4 Replies
View Related
Feb 8, 2013
I know that if I use IMPORTOBJ I can import an excel file....but the file is multiple pages (within the same workbook page). Is there a way to bring that in withought breaking up the Excel file into mulitple files?
View 1 Replies
View Related
Dec 14, 2011
i have made a iLogic Module who, whit an external rules, import the iProperties value from an external exel file.The exel file is connected from SQL with the our managerial software.This in the external rule:
i = GoExcel.FindRow("Z:DISEGNI_INVENTORDescrizioni.xls", "Descrizioni", "Cod.Art.", "=", iProperties.Value ("Project", "Part Number"))iProperties.Value ("Project", "Description") = GoExcel.CurrentRowValue("Descr. Articolo Princ.")'iProperties.Value("Project", "Project")
[Code] .....
It's work fine but i have same question. There is some string to refresh an iLogic Module? When i push the ruel button the rule add the custom value in iProperties, but there are disabled, i have close the module an reopen it for correct display the value of the iProperties.
this module work with single parts. Can I do an rule who do the same thing of my string but in one assembly, do this for every parts of assembly automaticly??
View 7 Replies
View Related
Jul 19, 2011
I have found a few things on here, but not exactly what I want. We have a excel spreadsheet with borehole references and coordinates. I need to be able to insert a block according to these coordinates and the borehole reference as the attribute.
View 5 Replies
View Related
Dec 21, 2005
I've created a custom title block. I'd like to use VB to fill in this title block using info obtained from an Excel Spreadsheet; Company Name, Location, Drawing Title, etc.
View 5 Replies
View Related
Jan 12, 2012
why I can't export the "Distance 1" attribute out of thsi drawing using the ATTOUT command. I need to build a series of constrained drawings using Dynamic blocks so I can send info from an Excel spreadsheet back and forth bewteen a drawing. I think I'll have to buy a 3rd party utility for that but for now, how to simply get the info out of ACAD and into Excel thsat would be a great start.
View 2 Replies
View Related
May 29, 2013
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
View 8 Replies
View Related
Dec 11, 2003
I need to import some vector EPS barcodes into PS7 and then export the document as a PDF but keep the type and the barcodes as vector information. How can I do this?
View 1 Replies
View Related
Feb 23, 2013
How do I import my iPhoto events into Elements 11 Organizer and keep the events separate. They are all named and I want all the information to remain with the event.
View 5 Replies
View Related
Jun 23, 2013
file info in Photoshop shows only an empty box yet works in bridge.
View 1 Replies
View Related
Sep 13, 2012
I used to be able to just open any image and my copyright info would be inserted into the file data. I guess it was a droplet, "when the file is opened or created then add file info from a xmp file". I still have the xmp file with all the data in but i am unsure how to implement it being automatically opened and added to the file when i create a new one? I thought i could handle it, i assume its a droplet of some sort.
View 5 Replies
View Related
Feb 8, 2009
After I save a file for "Web & Devices," when I open it, it returns this message, "This file contains file info data which cannot be read and has been ignored." Will this cause any problem with the file once I place it in the website I'm building? I've never seen this message before on a photo I've edited. The changes I made involved color correction.
View 9 Replies
View Related
May 31, 2012
We have been sending images out to contractors, and sometimes when they come back the files are having this error:
the file contains file info data which cannot be read and has been ignored
When I then try to Photoshop Script the file info it throws errors.
View 5 Replies
View Related
Nov 5, 2012
Is there a way to view exif info of each photo on the LR 4.2 import screen. I'd like to view Exif data before making the decision to import the capture but can't figure out how to do this. Ideally it would appear as a 'tooltip' when hovering over the image in gridview, or, when looking at a single image it using the "I" key should display image info like it does in other modules of LR4. Are there any plugins that could do that?
View 3 Replies
View Related
Apr 1, 2012
I just imported several photos into my catalog using a preset metadata import. After Import I edited all the photos and then was set to export. Unfortunately it was the wrong metadata preset and I want to change it on all my photos. Is there a way that I havent been able to find yet that would allow me to easily change over the metadata copyright info on all the photos without having to start all over again?
View 2 Replies
View Related
Jun 16, 2012
In lr4.1 before Importing images, I'd like to see more info (camera, lens, focal length, f-stop, exposure time etc.) about the images besides just the file name before making the selection to import.
In the library module I just push the i key and it loops through two sets of info and a non-display. Why can't I do this in the Import module? If yes: how? What options do I set and where? If no: Is there a plugin to do so or who do I ask to add this to the next release?
View 1 Replies
View Related
Mar 3, 2011
I'd like to ask something. Suppose I've thousands of files of psd jpg and txt files which can be paired by names like x.psd x.jpg and x.txt. I'd like to import x.txt and x.jpg into x.psd as new layers. a default position for layers are enough for all files.
Can I do this for all files?
View 2 Replies
View Related
Dec 16, 2008
Is there a way to save my copyright info and contact info with a picture but NOT include the Camera Data.
View 2 Replies
View Related
