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.
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.
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 ?
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?
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.
I am trying to export each sheet in an Excel file to an separateTXT files.
I currently have code to read each cell in a sheet, but unfortunately some of the Excel sheets have in excess of 5000 cells and it is taking too long to read. So I am switching to another method.
The program will check dates of TXT files and XLS file to make sure TXT files are current (if not, open and recreate TXT files).Then read the TXT files (much faster).
Where I am getting stuck is 2 places -
Get the names of each sheet in the excel file (not always a known name)
Save each sheet as separate TXT file.
Here is condensed code so far without error checking, etc -
I see that keyboard shortcuts in revit 2013 can be eported as xml and imported back from an xml? Is it possible to export the shorcut list as a simple txt file or excel file, for printing purpose. Some of the bim modellers in my office would like to print the shorcut and stick it on their desk.
Is there a way to export jpegs with some exif info (creation date and tile) which should be saved directly on the image. Like the showing of the timestamp on the picture which can be turned on on some cameras.
Reasoin is: I want to use those pics on a digital image frame and I want to show some image data as well. As there are no options in the software of the digiframe to display exifs I have to integrate them in the pictures...
if it is not possible with lightroom then probably you can tell me another way (bridge, photoshop, ...) - just not manually...
I have a lot of AutoCAD files which have embedded OLE objects (excel) inside. I want to be able to export only the text from the Excel OLE object using VBA (or Lisp, I don't mind which) without having to fire up the OLE application (i.e. Excel).
The embedded OLE objects have no link to any external files - so I imagine it must all be held somehow inside the AutoCAD file, but how it can be accessed?!!?
I am using PSE 10 in Windows 7 environment. Have thousands of photos and hundreds of Keyword tags and many Categories and Sub-Categories.
It would be nice to have these Tags & Categoris names in an Excel file (or, comma separated text file) that I can use to easily see what Tags I have so that I don't create new tags with slightly different names. Such an easy-to-access and mange Excel file will be very useful, I think, to the overall cration and management of Tags.
I want to extract the metadata I have added to my images and export it into an Excel spreadsheet. Can this be done within LR4.4? If the software doesn't have a function for this is there another way to do it?
I have been searching for a macro to export the start and end point of a line coordinates to excel, but I can only find information on how to export 3D Points.
Is it possible to program a macro that allows me to export the start and end point of various lines in a sketch?
The objective of this is to connect an excel file which is updated when I create a line with it correspondent points, then i could not only import these x,y,z coordinates from excel to inventor but I whould be able to update my spreedsheet whenever I change my sketch.
I am using Civil3D 2010. I am trying to export the offset/elevation data from my cross sections to a text file or excel file so i can paste the info into another program. so far i've been labeling the offset/elevation info on the section and typing it into excel by hand.
We have standard XMP files with metadata for our collections - box number, folder number, copyright, creator, etc. Is there a way to add this to Smart Preview so that it will apply it to all photos at the same time?
It would save so much time to be able to use Smart Preview and apply all the metadata and just tweak it for descriptions, than to upload the XMP files for each image.
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.
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.
in LR3 custom package did not support photo info. Has this changed in LR4 - is there a way to add a caption to a jpeg file generated via the custom package?
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.
In Bridge, they have a way to get an excel file of a web gallery, which is so useful. Only thing is now I make my web galleries in LR, and I shuffle image order around. Any way to do that with LR too?
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.
I need to find a way to export the selected face to dwg and to have the Part Number and if possible the description written under the exported face. I don't know if it's possible to do this. I know it's possible to export programmatically the selected face, but is it possible to get the name + description into the drawing too?
We're just looking for a way to "automate" the creation of our laser drawings.
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.