Maya :: Excel Spread Sheet Data As Input For Animation?
Aug 16, 2012
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 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 ???
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 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.
I´m having a couple of problems with getting data correctly from an Excel Sheet. I´m using the Excel Sheet to get Data for the Stock Number based on geometry.
First time the Excel File get´s opened it always cannot find the first sheet. I´m using a german Version and Sheet1 is Tabelle1 in german.
It always searches for sheet1 the first time the script runs on a new derived assembly. The second time (on second part) it correctly finds Tabelle1 and reads the correct value.Here is the code I´m using:
And there is another issue which I have solved already but still gives me a bit of a headache. When the userdefined property IdentNr gets written into the part it always defaults to a numerical value, which means that I always get a comma at the end of the Stock Number.
Only when I define IdentNr like this:
Dim IdentNr As String
the format is correctly set to Text.I expected that when you read a value from an Excel Cell that the Format of the Cell gives the format of the user defined property. Is that not correct?
I have made a data link to an excel file. Then I bring it in as a table. I then adjust the text height and remove all formatting from the table. Unfortunately, after closing and re-opening the file, the table changes. I lose formating/cell alignment/text height. It isn't even consistent across the table. The lost formatting is only on the 2nd split of the table, the first side retains the corrected formatting. I have selected the option to not update excel formatting. I don't even get a notification the table is updating. There haven't been any changes to the excel sheet either....
I have been using a lisp routine to strip formatting from a linked excel sheet. (stripmtextV5) .When I try and run it on a sheet today it says some cells are locked. I've changed the cell format in the excel file to unlocked. I have unlocked the cells in the linked table. Yet it still says that some cells are locked...I have even picked in each cell to verify each one is unlocked.
Is there a possibility to furnish a hyperlink linking on a defined Excel-data sheet within an Excel file? Are there other possibilities to tie together to a drawing object external additional information, e.g., a product name, product data or product pictures?
I am trying to map the mocap data to my character. In order to do that, i thought i just have to label the joints for each character and retarget. but in maya 2012 i cannot find the re targeting menu. I just found out that there is something called HumanIK, which i am guessing that it is very new.
Is there a way to use the mocap data in visor and map it to my character in maya 2012? without using HumanIK characterization Tool? also can i use mocap data(skeleton) in visor as HumanIk character ?or it is two different thing?
I 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?
When 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 .
So 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..
I have rigged a character and made it into a character set in which i have locked the scaling attribute , I have then saved this file. I have then referenced this file and and have done a walk cycle animation and saved this file. I have then realised that I needed the scaling attribute when I have added other parts of my scene. Is there a way to unlock the scaling attribute in my walk cycle animation file or will i have to go back and change it in the rigged file, create a new character set and do the walk cycle animation again?
My current scene has 10 animation layers for a character, and seeing every f-curve from all layers, although grey and locked, when I only need to see the f-curves in layer I'm working on is really cluttering the graph editor. My current work around is selecting my active layer in the Layer Editor every time I select a rig control. Simple enough, but a pretty inefficient way of working. I can't seem to find a setting that allows me to just see ONLY the fcurves in the active layer. I imagine some of you out there may have hundreds of animations for a single game character.
I'm trying to animate a moving rope based on simulation data. I know how to import my motion data for individual objects.I've seen lots of tutorials where one uses simulations or soft bodies with IK in order to create a rope. how to use all these features and I want the rope to follow my coordinates exactly. I was hoping I could do something like the following:
1. create points in Maya which correspond to my data points 2. connect the points with a curve 3. loft a circle using the curve as a path in order to make a rope 4. move the points. due to History, the rope position is updated
Is there a way to do something like this in Maya? I've tried, and it looks like ep points do not have key-able channel data, so I can't create animations for them separately. I'm using .mov data file imports to generate x, y, and z motion keys for the points.
I have an assignment for a class where part of the final project is detailing the construction of a mold for a part. The animation that I would like to do would show the build up of the part in a 3D printer layer by layer. The closest method of animating this that I can think of is unfortunately backwards.
As I would have the part and a camera facing up from the bottom of the part and would have a plane that would recede upwards in the y direction. This would reveal the part as the plane translates in the y direction.
This might be okay, but the problem is that I would like to show this from a camera on top facing down instead of a camera on bottom facing up. How I can create the look of a part being built up in this additive method?
I am trying to add an expression to the standard Mudbox car to make the wheels turn when the vehicle moves in both the X & Z dimension. I have found many scripts that let me do this in a single dimension. I have found some others that claim to work for both dimensions, but at certain angles the wheels turn in the wrong direction.
My work flow is as follows: 1 - Export car from Mudbox to Maya 2 - Separate the wheels & center pivot all items 3 - Add NurbsCurves to create a rig 4 - Parenting the elements of the car 5 - Add an expression based on this web post [URL]....... 6 - Test the animation
It works great when translating the car in the Z axis, but when the car is rotated 95 degrees in the Y axis the wheel will only go backwards no matter which direction the car is moved.
I have attached an MB (Maya 2013) so you can see the
translate facial motion capturing data (basically 2d point clouds) to blendshape weights. I finished rigging my character and wanted to drive my blendshapes by the relative position of my tracking data, e.g. distance between corners of the mouth drive the "wide" blendshape and so on...
Hope YOU know a solution for this, I believe blendshapes are THE way to create realism in tracked animation but I was not able to find ANY reference to something like that. I'd like it to be customizable and not to expensive, so the imagemetrics faceware service won't do for me
How come baking some part of animation in graph editor deletes everything before and after the part i bake and how can i bake that part while leaving the rest untouched?
I have a character with animation. Another character is the same(same bones, meshes), but with no animation, 100 times larger in size and I resize the head to make the head looks slimmer. They are saved in different fbx files and I imported them into mb scenes. I select the root bone and "select hierarchy", the export options is shown below. Then select in the same way in the larger character's scene, the importer options is shown below. THE PROBLEM is: after I import the atom, the character becomes shrinked to the same size as the former one and the ratio of head becomes the same as the former one too.
For some scenes we have a chain which is wrapped around several cogs, just like a bicycle. In this scenario we need the chain links to follow the path and retain their relationship to each other.
In other scenes we have a chain which follows along a changing path. Imagine this if you can: A heavy weight has a chain attached which goes vertically up, over a pulley and down the other side where it is attached to a lorry. The lorry drives off pulling the weight upwards. This is my challenge!
Should I individually constrain the links using a Pin constraint and use dynamics completely to keep the chain taught?
Was wondering if there is a way of getting random camera movements? For example, i am doing a fly through of an earthquake scene and as the camera animates along the street it randomly shakes with the earthquake shocks.
I know I could animate it by hand but I wondered if there was a way (perhaps an expression) to make it more simple?
I wish to input the GPS data (latitude, longitude) manually in the ways:
- Insert the value directly into the GPS field on the image (in map mode). It is pretty hard. In fact, I try to copy/paste value but I failed. I wish to be able to simply add manually GPS data to a picture.
- Move the map to a point giving llatitude, longitude. Maybe add a field close to "search".
A: Can I export skinning information from one mesh to another. I have two identical versions of the character except I forgot to weld some verts on the model before skinning. Can I weld the verts and then export > import the skinning data? If so how?
B: I have someone working on some animation for me in CAT, I have since made some minor changes to the CAT rig (increased width of chest bones, that is all). I also changed all the skinning. Is it possible to export the animation data and load it onto an almost identical CAT rig? If so how?
I want to key frame animate something to go in a straight line but it seems to start out slowly, speed up, and then slow down again at the end. Is there a way to make it so the object moves the same speed throughout?
I have an animation layer that I have exported and Im trying to import it into a new file and then merge it down to the base layer.
what ends up happening is that when I do the merge i get two additional layers. and the layer with the animation stays there. and nothing gets baked. the animation stays in the imported layer.
I should be able to import/export animation layers right?
I have a image plane. I would like to move the image of the plane in animation. It looks out then masking. I need only some parts of the image in frame one, and I need other parts of the image on frame 100. The plane isn't moving, only the image is moving in the box.
