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 RepliesIs it possible to write an Illustrator (CS4) script that would find and replace 2 instances of text using the actual file name to supply the changing text?
Our current file naming system uses a Part Number, Catalog Number and Run Date. (example: 123456_ABCDEF_2014 JN)We are currently saving a master file as the new Part Number and simply doing 2 separate find and replace functions for the Catalog Number and Run Date. Unfortunately we have over 500 parts to change and thought we could narrow down the 1000 find and replace to just 500. Although this may not appear like such a time saver, the key factor would mean entering the changing data just once per file, minimizing errors and eliminating proof reading the actual file.
Here is what I have used for a simple find and replace script, but I cannot seem to find any information to connect the file name data.
[code]
var active_doc = app.activeDocument;
var search_string = /ABCDEF/gi; // g for global search, remove i to make a case sensitive search
var replace_string = "GHIJKL";
var text_frames = active_doc.textFrames;
var search_string2 = /1234 XX/gi; // g for global search, remove i to make a case sensitive search
var replace_string2 = "5678 YY";
[code]....
I have a form I have to fill out every day several times according to the client, but this information comes from a spreadsheet.
View 8 Replies View RelatedI 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 RelatedIs there a script that can create layers with csv file?
View 5 Replies View RelatedI 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 ?
Autodesk Inventor Professional 2011
I have developed a script to perform some Custom action in Illustrator. I want to make this script run from a a File Menu Item so it can be invoked easily. Is there a way to customize Illustrator to add a new menu item or modify the existing menu tems functions. For example if the script needs to be invoked when the user click "Save" is there a way that could be done.
View 4 Replies View RelatedI'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?
I was wondering if there was a way to import excel datat into illustrator, then it populates a vector pie or bar chart for me?
[URL]
I have a drawing with so many rectangles in one layer. i want the sizes of those rectangles( ie L x B) is there any way to get the sizes of a rectangles from autocad and paste it into excel.
View 9 Replies View RelatedI am searching for a simple automated Find and Replace script, the idea is that in Excel the Find and Replace with texts are located. The script finds the textblock in Illustrator and replaces it with the value from Excel "New number".
Example Illustrator:
Example Excel Find and Replace:
I was wondering if there was a way to extract data from Excel to be used in Illustrator. I know there is an option of variables and xml, and I don't want that. I've seen and tried out how to read illustrator and write to excel, and I get that. What I would like to do is pretty much the opposite:
1.Pre-fill in an Excel file(.xls,.csv, doesn't matter) with data such as a filename in column 1 and (Replacement Text) in column 2 and close manually.
2. Run script(VBSCRIPT,Javascript, doesn't matter)
3.For each column in Excel file where cell in first column is not empty, open Illustrator Template with placeholder of "DWG" textframe and replace the frame titled "DWG" with Replacement text from Excel in Column2.
4, Save each to a PDF file and name file with text from Excel Column1(Filename)
In a nutshell, there will be a single illustrator template with a premade textFrame with a name of "DWG". Excel will contain two columns, one for the filename to be named and one for the relative text to replace with the placeholder in AI.
I want to send the contents of A1 to an Illustrator document at 135, 172 and B1 to 135,190, same with A2/B2 will be at different coordinates as will A3/B3 and so on... I want to do this 6 times and save the document as a PDF. Then, it should clear and do it again. The columns will ALWAYS be A and B.
View 5 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!
the Script of creating mirror text and stroke text in Adobe illustrator scripting.
View 4 Replies View Related[I moved this over from the Creative Cloud forum FWIW] I'm a packaging designer and recently have encountered a very problematic glitch.
I have a flat carton layout with an assortment of fonts. I saved the file one day – typical Save – just with PDF Content unchecked since that slows down my workflow. Several days later, I reopened it and all of those fonts were defaulted to Myriad Pro Regular.
Font auto-activation has been a problem in Creative Cloud, but that's not the problem. The fonts are active – they even appear properly in another layout using the many of the same text treatments.
And typically when a font is inactive and text is defaulting to Myriad, the character pallette shows you the intended font between < >
Not in this file. Every defaulted bit of text is indicated to be Myriad Pro Regular. No asterisk, No < >, No nothing.It's as if the font information was lost the last time I saved the file, and the only way to fix it is to manually replace each bit of text with the appropriate font.
Other designers in my group have noticed this happening occasionally as well.
I'm on a iMac running 10.7.5 and all 3 of my Adobe products (Illustrator CS5.1, Photoshop CS5.1 and Flash CS5.5) have the same issue, the file info window is blank. It dosen't freeze up my machine but I have to force quit the program. I trashed the prefs file for photoshop and still no luck. The extension are whatever came with the install. It's the only menu item this happens with.
View 1 Replies View RelatedQ) A user will enter information for a new drawing into the Excel file, this will generate an autocad drawing (title block and attribute information) and fill in the title block based on the information in excel file.
OR
Q) a user will create a new autocad drawing from the new templates and fill in the title block. This information will automatically fill in the Excel file.
How to create a excel file using ilogic?
View 6 Replies View RelatedI am looking to import an excel file to creat points within LT 2012. Can this be done?
View 4 Replies View RelatedWhat if for some reason a person wants to actually make an XML file and stick some <![CDATA[]]> in it? I looked through some manuals & OMV fairly quickly to discover no methods for that. Was wondering if there was some technique.And, just as pointed out in the indesign forums, a string of "]]>" makes the script hang up and debugging have to be stopped with the final message "Cannot execute".
View 9 Replies View RelatedI 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 RelatedI am writing a script for Illustrator. I created a palette with some buttons. I like to keep the palette open while working in Illustrator. The problem is, that the buttons don't work. For example, I have a delete button that should delete my active selection. When I change the Window Type from palette to dialog everything works correctly.
var w = new Window ("palette");
w.orientation = "row";
w.text = "Path Transform";
var f = File ("/C/icons/corner-tr.png");
var corner_tr = w.add ("iconbutton", undefined, f );
var corner_tl = w.add ("iconbutton", undefined, f );
var corner_br = w.add ("iconbutton", undefined, f );
var corner_bl = w.add ("iconbutton", undefined, f );
corner_tr.onClick = function () {
selectedObject[0].remove();
createLines();
}
Can this be done in illustrator scripting??
[URL]
creating a rectangle around selected object or objects and set margins...
I would like make a config file for my script that i would like to put in the %appdata%adobe folder.
How can i reah the value of %appdata% inside javascript?How do i create and read files?
I am currently reading the Extendscript javascript toolsguide but i cant figure out how to create a file:
Should not this code create a file in C: directory?
Fille = new File('C: est.txt');
Fille.write("Testwriting!");
Fille.close();
As I´m studying JavaScript and the user interface creation...would like to ask (more for curiosity):
Is it possible to create a new panel for Illustrator using JavaScript? Or this is only possible using C++?
(in the Window Class UI we have the "palette" creation method..so wondering the result of it too)
Is there a good reference that deals with command line formats in scripts?
I'm trying to create a script from an Excel file with a sequence of line commands. However, it seems I have to add a blank line in between each one to end the input. Is there something I can add at the end to avoid having to insert blank lines?
Also have the same problem with the -layer set command.
I'm new to scripting What I want to do and don't know how to go about it is to run a script that collects the saved file name and the full path where the file is saved on the network and displays it on my document.
View 2 Replies View RelatedI'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 RelatedI'm trying to challenge myself here, I want to create a copy of every gradient in the active document and give it an assigned name like "Batman 1" "Batman 2" ect.
I can add new gradients and set their stop colors ect but I can't figure out how to create a perfect copy of the gradient in the swatch library.
I've been looking and the only thing I found that comes close was an older script that's only compatibale with CS. In this they're copying EVERYTHING I just wanna stick to gradients at the moment. Here's the link: [URL]
I looked to this as an example of how to do something like this but since it wont work with CS6 I cant really experiment or tinker to figure out how it works.