I have a job to photograph 300 items and use lightroom to number each one with its own product code.
Then I need to add the barcodes to the images so the client can scan them
They have a spread sheet with all the data on but can a sript be written to do this action ???
I am very new to autocad and i am using 2013 student..
1) I have drawn a curved line for a Directional Drill Shot and need to create a points on it every 2 metres to give a Cord position,
2)I need to be able to transfer these points into a excel spread sheet.
If you review the attached screen shot of a PDF you will see that my Excel spreadsheet object prints very light. This is added to a Paper Space layer that is same layer as the Title Block, which is printing fine. The colorful solid objects are each in their own viewports.
I have set the OLE property "Plot Quality" to "Monochrome", also I have set the "Plot Style Table" to "monochrome.ctb".
To place the spreadsheet table I have Excel open, I select the columns/rows that I want and then Ctrl-C, I flip over to ACAD and Ctrl-V to place the object, I then resize it by dragging its handles. On screen, in ACAD, it looks fine.
I am creating the PDF using "Cute PDF Writer", which does an excellent job creating PDFs from many applications. I don't think it's related to my problem. I have tried ACAD's "DWG To PDF.pc3", but had a similar problem, but worse in other aspects.
I have a spreadsheet in Excel that is split into columns. The first is the frame number, and the subsequent columns are the rotations about the X, Y and Z axis. There is also a column that has the location in the Z axis from the origin (0). These values are currently being input manually and keyed. The object being animated is a locator node which will form the parent of an object.
Is there a way to have these values read in automatically and for each frame to then be keyed to that value?
As I've never touched MEL or Python I wouldn't have a clue where to start trying to write some sort of script to do this.
I am trying to link a Excel spread sheet to an Inventor 2009 part. It worked great on Friday now it is not working. The only thing that changed was that there was a windos update. When it does work I am unable to update any of the parametes that are linked to Excel file as the update button has disappear.
View 2 Replies View RelatedI just upgraded from AutoCAD LT 2004 to 2006. The work that I have been doing requires that I insert Excel spreadsheets on all of my drawings. In 2004 it was quite easy to size the spreadsheet.
When you pasted it AutoCAD LT would prompt me for a size which would get me close and then I could drag the corners to perfectly fit the spreadsheet. With 2006 it does not prompt me for a size AND dragging a corner is not as easy. Sometimes it will not let me drag it smaller. I then have to use the scale command.
I know you can insert an Excel spread sheet into the general table and have that show up on the drawing, but it has limitations to it that Excel gives you. My question is there a way to bring the Excel spread sheet into the drawing that would give you Excel functionality?
View 9 Replies View RelatedWhen you extract information from attribute blocks to form a spreadsheet can you specify that the spreadsheet also lists the co-ordinates x,y, z for that block? For example, you have an attribute block with information regarding, station number, chine number. When I extract the information I would like to list the x, y co-ordinate point of the circle block .
View 2 Replies View RelatedSo I am Loving the use of Attout and Attin for updating block attributes from a spread sheet...Currently I am producing drawings with names on desks. I have created a block with the attributes of Name and desk.
I am currently updating the drawings blocks so that I can input an excel spreadsheet with over 1500 names into the drawing using Attin (changed the .xls to .txt and roberts your mothers brother)
Unfortunately the spreadsheets I have been given have the name as one field. i.e name: Joe Bloggs, Ideally I would have the information as First Name: Joe last name: Bloggs and create two associated attributes which would enable a nicely displayed block..
is there any way that I can format the block so that the attribute displays as a multi line..e.g.
Joe
Bloggs
not
Joe Bloggs.
I know I can go into each attribute (although trying to remember that command "A something Edit" I think) and edit it like a piece of txt. I would rather not have to go and do that if there is another work around..
you know if it's possible to scale a image in differente sizes automatic. f.e. I have a image 1200x2000 an I would like to get 3 new images like 800x1000, 500x700 and 350x500 AUTOMATIC and without programming. It would be possibe with photoshop?
View 1 Replies View RelatedI want to place text in the bottom right of a series of images. The problem is not all images are the same size. Some are verticle and some are horizontal and even those arent all the same size. However, 99% are 768 high. How do I specify a certain margin from right and bottom so I can use the text action on all images regardless of image width?
View 3 Replies View RelatedI am looking for an action or preferably a way to create one, that takes a GIF file with multiple images (=animation) and puts all images side by side and saves it.
View 9 Replies View RelatedI have an excel file with a column containing polygon vertices like follows:
Row 1 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
Row 2 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
Row 3 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
I am looking for a .Net code that can read each row cell and draw the polygons automatically in AutoCAD window. I am having a bout 100 rows (polygons) and hence I prefer that the code will display all polygons at once in AutoCAD window and not draw them one by one.
I am already having Autolisp code to draw them one by one but I wish to have a .Net code to allow batch polygons drawing instead.
"Contact page" when images get transported on to page they reduce in size.I have also tried dragging the pictures onto the page but they still reduce in size.
View 2 Replies View RelatedI have been working on a series of drawings for a catalogue. I am using solidworks, creating a sheet, all line thicknesses are changed to 0.05mm and then exporting the sheet as .AI. Every drawing I create is saved using identical settings.Out of say 10 only 3 of them are okay and can be edited as vectors. The rest seem to turn themselves into a series of images.
View 4 Replies View RelatedI want to export a series of images from a video, but only, say, one frame every three or four seconds. One out of every 90 to 120 frames of the video. Can this be done in AE, or do I need to do this in another CC program?
View 5 Replies View RelatedI'm trying to create a series of sphere images that are to be used as an animation, whereas in my case I have a transparent background layer and a layer containing a sphere. Then I want to add a 15 degree rotation for each new image. The problem is that every time I select the rotate tool and click on the image to enter the value, the sphere is moved slightly.
View 3 Replies View RelatedSo I was oot and aboot yesterday and I took a series of pictures of a drummer in action. It was a rapid series, like five pictures covering five seconds of him rocking out. I want to combine all those five pictures into one ... "master" picture. My idea for the "master" picture is one single picture, where you can see his arm and body movements (and the drum cymbals moving) from all the five pictures.
That's probably a terrible way of describing it, but that's what I want to do.... I tried layering the pictures together as overlays, but while that combined all the images together, the end result was too blurry to make anything out.
I'm using a Javascript that will export as JPG a series of images from an AI file (that part is working fine), then rename them (that part isn't working). Writing and troubleshooting with Extendscript.
Trying to eliminate as many possible places to go wrong, I came up with the following:
myfile = new File; myfile = myfile.openDlg();
var newName = "NEW.ai";
myfile.rename(newName);
When run targeting Illustrator, it does nothing.
When run targeting ExtendScript, for some reason this blasts the file into oblivion, never to be found again.
I have a series of images taken with different settings and I want to quickly compare them at 1:1 in different areas of the image, center and corners. I have discovered that if I select the series I want to examine and then go to the first image and zoom that image to the position that I wish to when I use the arrow keys to move to each subsequent image will be shown zoomed into the same position
If I don't ever go to any of the other images and zoom anywhere this works just fine. The zoom location is remembered just for the first image. However, if i accidentally or deliberately zoom on one of the other images it will remember that zoom location forever which breaks the technique described above.
how to remove the remembered zoom location from an image like it is when you first import it into LR?
How can i export a series of images in different aspect ratios to the same height?
I wish to make a slider callery for my website. all the images need to be 750 Pixels high, the width does not matter. I have a mixture of square pandscap and protraite images can i do thing as one export or do i have to do it twice? Once for long edge and once for shot edge?
I am trying, to make a data extraction with Link External data with linking to a excel sheet. Everything works fine, with the data extraction.
Then I try using upload to source/download to source update, but end up with this msg. every time:
1 object(s) found.
1 data link(s) do not allow their data to be written out.
0 data link(s) written out successfully.
I have tried when it said, successful all the way, but nothing have happen in the excel sheet at that time.
What I am trying to do, is make it automatic or manual update in the attributes in the drawing. If I change something in my excel sheet and ofc. the other way around to if possible.
I've to put some data as like table beside the figure. I've these data in a excel sheet. Can i import that sheet in CAD? or I need use table and re-type all data?
View 4 Replies View RelatedCurrently i am trying to get an Excel sheet incorporated into my AutoCAD layout. I get it in and it seems way to small. I re-scale the excel insert and get it right then update the sheet to get the new info and it shrinks back down. Now i thought at first it was the excel insert that was the problem, but now looking my layout seems to be extremely large and that's why the excel sheet is off. How can i take my existing layout and change it to fit 11x17. I really don't want to have to redraw the whole layout to make it fit 11x17.
View 9 Replies View RelatedWhat is the best way to Insert an Excel sheet into autocad?
View 4 Replies View RelatedI've made a big calculation in a Pipe Stress Analysis program and the program has auto created 10 autocad drawings that is used to find points in the system.The problem is that the program has random numbered (with no intelligence) and now I have a big report which for example points at a number some where in the 10 drawings, which is hopeless to find.
Can I somehow:
1. Find all numbers in this drawing.
2. Put them into Excel.
3. Sort them after size.
4. Add an extra column which tells which drawing I can find the number.
5. Last put all the numbers from all the drawing into one Excel sheet and sort them after size, now I have a number index, so I can find which number is in which drawing.
Can Autocad find all numbers in a drawing and let me copy them to Excel for editing?
I want to link an excel sheet with a drawing, so changing the excel changes the drawing.
I used this awesome site to learn about going to Edit->Paste Special->Paste Link->AutoCAD Entities...but I don't have that choice. Just the one that makes the OLE image. While that will work, that is less than ideal. It appears in just normal paste, but not under paste link.
AutoCAD 2007, A.54; Excel 2003 SP3; Windows XP SP3.
I have a drawing with an embedded Excel sheet. I want to read the contents of the excel sheet. Maybe in combination with Microsoft.Office.Interop.Excel?
View 9 Replies View RelatedI am extracting attributes from an AutoCAD 2011 drawing into an Excel sheet using EATTEXT. I am then manually adding columns to the Excel sheet. How can I update the Excel sheet with new attributes values later on without overwriting the modified sheet and losing the added columns?
View 2 Replies View RelatedI am working on a new iLogic rule that will create and IDW with automate views of the folded model of the sheet metal part in front view, right view, top view and the flat pattern I have success with all views except the flat pattern view creation codes. Does anyoone have knowledge of what the code terminology is to add a flat pattern view through ilogic to an idw?
Also, if this is possible, I want to create a bend table and a hole table using ilogic to automate these processes.
So far, I can create any view off the folded model but I do not know the code to create a flat pattern view.
Saw something in a magazine the other day: photos of products with a "smart phone" icon and caption saying "Scan this photo to be shown a video (or product info)."
Am I right in thinking that some kind of QR-type code is embedded within the printer dots of those photographs? And, can we produce such images in Photoshop (CS6)?