On several projects there are long lists of images linked in the Illustrator file. I need to find a way to export the names of these links to a spreadsheet for another department to reference. Is there a way to do this (in Illustrator Cs5 or CS6)?
View 1 RepliesI have just inherited a project where I have been asked to supply our purchaser with a list of non-stocked fixings.
OK so far, i hear you ponder, but the designer for reasons of speed (his words) didn't add the fixings to the assmbly!
Is there any way to list all tapped hole features to an excel spread sheet so that i could then just sort and count and then be able to hilite the specific parts in inventor to find the length?
The prospect of looking at each individual part for tapped holes fills me with dread (shudder).
HP z210 16Gb ATI FirePro5800
Autodesk Produst design Suite 2012
In Bridge tools in CS2, at least with Mac version, there is Export files to a spreadsheet --
Is this gone is CS3?
I am trying to export some data from my BOM. I require the part names, quantities and lengths. I have followed a previous topic in these discussions which is now closed. it seems simple to follow but requires me to click on the export BOM icon in the top left of the browser. In my instance this is greyed out. D
View 4 Replies View RelatedIm struggeling with creating a code that opens a certain Excel spreadsheet and retrieves / inserts info.
the spreadsheet is a list containing part numbers for purchased components, therefore the list must be filled with information from iproperty. But it has to be where the next available number is. i had this working in iLogic, but have to move it to VBA for better use. the code that worked in iLogic is this one.:
[URL]
If possible it would be nice if the code at the same time retrieves the new partnumber and saves the active part as this part numeber...
I need to find a way to export my BOM data to an Excel spreadhseet. Some of my BOM's are in tables, most are not. I found a lisp routine that will export this data to a csv file, but it's clunky at best. I don't want to use the "ole" method, I don't feel like fighting that battle.
So outside of plotting to a "png", and pasting that into Excel, are there any other options that are feasible?
°°AutoCAD Rel 1 - 2014°°
I’m trying to export from my drawing point X-Y position coordinates to Excel for use in programming a metrology that will measure at these locations.
When I use the EATTEXT command to pull up the data extraction wizard, it will export the positions & extracts the locations to a spreadsheet format. But coordinate numbers I get, seem to be relative to the World USC system & not the origin I align & set in the center.
Yet when I use ID Point, to check positions the coordinates of the points are correct & relative to the center origin. How to get the location coordinates relative to the center USC origin I've located in the center of my part?
I'm reconstructing an old document originally developed with PageMaker. I've recreated a half dozen pages hopefully with more uniform techniques. The original line art for the pages was created in AutoCad and some were scans. To bring them into InDesign some of the art is now in psd format and some of the newer art is in Illustrator AI format.
I've noticed that the pages with photoshop art print pretty quickly (about 30 seconds). The ones with Illustrator art take much longer (about 1:30 seconds). They go through a flattening process.
I print these 50 page books on demand and that additional time would add about an hour.
I guess the question is whether this is normal and to be expected or not. If it is I'll likely turn everything into raster before going into InDesign. That, however, seems like quite a bit of extra work. Going from AutoCad to Illustrator (to add stroke) then to PhotoShop to change to raster and then into InDesign seems like a pretty convoluted work flow.
I have a document that I would like to import an Microsoft Excel spreadsheet into.
Basically, my document is a diploma that can range anywhere from 15-250 different names and corresponding dates with those names. It would save a great deal of time if I didn't have to manually type the names and dates into their respective spots.
I have a Microsoft Excel spreadsheet that if possible, I would like to autofill the information into the Illustrator file.
Between the second & third lines of text is where I would like to enter the first column of text. It would be NAMES that go here.
Then, between the fifth & sixth lines of text is where the second column of text from my spreadsheet would go. This area would be filled with dates.
I'm putting together some design specs and I want to create a clickable table of contents that will navigate to a different section of the document. IE. artboard #27
From what I've seen thus far it looks like I can add links but only to websites and they are only clickable in PDF mode.
Is it possible at the very least to make my clickable TOC when converting my document to a PDF? and, is it possible to make it clickable even if it is in .ai format?
Every time I open an Illustrator file, I get an error that it can't find my links and I have to re-link all of my images. Why is this happening, when I haven't moved either the linked image or the Illustrator file? Even if I save my Illustrator file, then open it right back up this happens.
View 3 Replies View RelatedI'm using AI CS6 at work and when I place files, they don't show up in the links window and changing the original file does not affect the placed image.
View 3 Replies View RelatedWhen Illustrator files are created by my colleague on his PC, he drags and drops images from various folders into his Illustrator document. The file opens fine on our other PC's, but not on our Macs. We always get broken links messages which is horribly cumbersome.
View 5 Replies View RelatedI have several .ai files that have linked files that I suddenly can not see in my layout. I checked the links and they are unbroken. Others in the office running the same Illustrator version can open and see them fine. Have I inadvertently change a view setting in my app?
View 2 Replies View RelatedProblem:
How to read real number data from selected columns in an Excel spreadsheet into an illustrator javascript array variable, so that then I can use this information to construct an illustrator polygon.
Further information:
I am new to javascript (and not much of a programmer in the best case, but do have some basic knowledge using ancient languages like FORTRAN 88). I am sure I am just missing an important step here despite all morning browsing with Google for answers (something to do with variable definition I assume?). I have some survey data defining the outline of features in map view listed in a string of point (x,y) values in adjacent columns in excel (these x,y point values calculated from GPS data using a commercial program to converted 3D position to a 2D x,y by geoid projection, and then in excel to re-scale point locations to illustrator’s artboard). What I am trying to do is select columns of x,y value pairs in an excel spreadsheet, copy these values to the clipboard, and then develop an IA JavaScript to draw a polygon through the specified set of x,y points. It seems easy enough to script illustrator to draw the polygon once I get the values from the clipboard are in a javascript array (lots a good tips here [URL] ....), but pulling in the clipboard data seems to be beyond me. I have tried populating a defined array with various combinations of array declarations and app.paste(); or windows.clipboardData.getData('text/plain'); with no satisfaction. I then had the idea to try to pull in the clipboard to one long continuous string, place that in a text box (see see its structure), andthen read and split up the text in a loop to populate the JavaScript array…but that deposited a complex illustrator table object into my text box, and several attempts to force the clipboard to paste text did not work (again probably having problems understanding variable type declaration).
I would be happy to find any method of scripting the pull of the selected on an excel spreadsheet for use in an Illustrator script…so if I am making this all harder than it needs, be I would be grateful to know that also!
I have an illustrator file which contains linked images. I want the images to link to images in a different folder on a different hard drive. They are the same images, but just in a different location.
I am thinking of temporarily changing the name of the first hard drive (which the images are currently linked to), in order to break the original image links. That way, I can re-open the illustrator file, and when it asks me to find the links, at that point I can direct illustrator towards the links on my other hard drive.
I will then save the file with the images linking to the images on the new hard drive.
At that point I will re-name the first hard drive back to it's original name.Will all of my other illustrator files loose their links if I temporarily change the name of my hard drive, and then change it back to it's original name?
(I have used this technique by changing folder names, and it has worked. But I was afraid to change the name of my Hard Drive because there are a guzillion files on it, and I can't afford for my illustrator files to lose any of their links.)
I updated to Illustrator 17.1, and now my image links no longer auto-update after they have been edited in Photoshop. As most should know, this has long been a feature: tweak an image file in Photoshop, save it (same file name), and Illustrator will recognize the image has been edited and ask if you want to update it automatically. Hit 'Return', as 'Okay' is the default dialog button action, and image updated: one step. Without auto-update, user must manually access link palette, select edited image link, and 'Relink' the image ('Update Link' unavailable here now as well): three-plus steps (including identifying and selecting image file after 'Relink').
View 2 Replies View RelatedI have a series of folders and I have linked art and the files they are linked to all mixed up in these folders. My file structure is as such;
myFilesHH01000-01999HH01000-HH01099HH001001.PDF
and now I need to change the file structure to this;
myFilesHHHH01000-01999HH01000-HH01099HH001001.PDF
adding the folder HH breaks the links.
What is the best way to identify the broken link and change its path with JSX?
I am working on a file that has some shapes with gaussian blurs. Everything appears fine until I save it and reopen the file to see that each of the objects with a blur has been converted to an embedded link as a raster image. Is there a setting that I need to change to preserve the vector shapes with the blur effects?
View 2 Replies View RelatedI'm trying to find a way to get the links and link statuses in Adobe Illustrator. It doesn't seem to be at all similar to InDesign DOM.
What I'd like to be able to do is check whether a file has a missing link. I have been able to trace it to a "placedItem" which is inherently a "pageItem". So is it possible to find the link status? Been going through the DOM for about a half hour now and still can't find it.
app.documents[0].placedItems[0] <--- How to get link status?
changing the file path for links in an Illustrator document?
For example, let's say my Illustrator document is stored at: /Volumes/Storage/Projects/Client/AAA001/designs/concept1.ai
and I have placed 2 linked visuals:
/Volumes/Storage/Projects/Client/AAA001/visuals/big_retouch.psd
/Volumes/Storage/Projects/Client/AAA001/visuals/flattened.jpg
When I open the .AI I noticed that the reference to the visuals is under a %DocumentFiles section:
%%DocumentFiles:/Volumes/Storage/Projects/Client/AAA001/visuals/retouc hed.psd
%%+/Volumes/Storage/Projects/Client/AAA001/visuals/flattened.jpg
I need to replace "/Volumes/Storage/Projects" with "/Volumes/Projects". (There are some more complex replacements I need, but let's start here.)
When I click "Edit Original" with a jpeg selected in the links panel it opens Microsoft Paint! In Windows (7) the file association is Windows Picture Viewer (NOT Paint!) and in Bridge it is associated with Photoshop CC. In InDesign we have the option of choosing which program to edit linked files with. In Illustrator we are stuck with the astounding Paint! Why?? 17 versions and this still bugs me!
View 2 Replies View RelatedHow can I export the blocks that i created to create a parts list.
I have a drawing with several different custom Blocks in it that i created. How can i extract the blocks to a excel spreadsheet so i can see how may parts(blocks) i need to order?
I want to export a spot i made in premiere but i can't see the mxf op1a in the export list. What should i do??
View 5 Replies View RelatedI am trying to export attributes from an autocad file using LIST and I keep running into trouble with the file cutting out data. I am wondering if there is a way to print the LIST file that AutoCAD creates to a text file so that I can get all of the data in one go instead of having to repeatedly "Press ENTER to continue:"
View 5 Replies View RelatedI use Lightroom 5 for managing my web galleries, but I have my own software to run them. My workflow is this: I use "Publish to folder" to generate the needed JPEG images, and I use another software to sync them to my serverI use the "Web Gallery" feature only to define the list and the order of photos in each galleryI use the "Export..." feature in Web Gallery to get the .XML file with the list of photos - this file can be directly read by my softwareThe problem is that "Export..." also generates the images for the gallery, and after the XML has been generated I have to stop this task manually - it's an annoyance. Furthermore, it would be nice if I could export all my galleries in a single step, with multiple files generated, one per gallery. I don't need anything else other than the image file name: the metadata are extracted from JPEGs. All file formats would be ok (XML, TXT, JSON, whatever).
View 2 Replies View RelatedI got this routine off the In The Trenches blog and am trying to change it, some. For some reason when I export I can only get 4 columns to export. So what the heck am I missing here? The Part List I am using has all the colums I am trying to export on it.
'-------------Start Of ilogic ------------------------------------------------
'get the path and name of the drawing file
path_and_name=ThisDoc.PathAndFileName(False)' without extension
'define oDoc
oDoc=ThisDoc.Document
[Code] ....
Inventor Pro 2013 (PDS Ultimate)
Vault Pro 2013
Windows 7 64
Xeon 2.4 Ghz 12GB
I need to generate an iLogic rule exporting Parts List (not BOM) from a IDW to a specific folder in XLS format.
Using Autodesk AutoCAD Inventor 2011
Suddenly when I do a File>Export and try changing the "save as" type to PDF, it's missing from the list of file extensions. I recall having this option earlier this year and have exported hundreds of files to PDF. Now it's gone. Same installation of Xara. See the attached screenshot for proof!
View 3 Replies View RelatedYou can't export parts list to Excel file but you can export CSV file without any problems.
View 3 Replies View RelatedWe would like to be able to export parts lists from our drawings into Excel, so we can build a master item list on a project to get purchasing information on long lead purchased items early in the design phase.
We are thinking of exporting the part list to an Excel file named the same as the drawing file each time the drawing is checked in to the vault. We will have another VBA routine that does some sorting and other magical things to build the master list in Excel.