I am trying to use an iLogic rule to populate iProperties (some generic, some custom) from a part number spreadsheet (containing columns such as PART NUMBER, DESCRIPTION, FINISH etc) and the rule keeps throwing up the following error 'Conversion from string "" to type 'Double' is not valid.'
Here’s part of the code (would be extended for the required custom iproperties but I’m assuming the same principle is ok)
StartRule: 'read excel file GoExcel.Open("C:DESIGNDocumentsEXCEL FILESPART NUMBERS", "PARTS") 'index row 3 through 10000 For rowPN = 3 To 10000 'find first empty cell in PART NUMBER column (Column A) If (GoExcel.CellValue("A" & rowPN) = "") Then [code]...
Changing the format of the excel data (number or text) has no effect. Is manipulation of the format required so that Inventor can read text and numbers to iProperties in this way?
say you make some parcels in your project with custom data fields like: id_no, permit_no, acres_served etc. you attach an agency provided shape file via an fdo connection that has many fields of information like above.
when you right click on your parcel and do parcel properties you get a tab that lets you input the custom parcel data.
lets say you print an fdo map label showing, say, the id_no, provided in the shape file. Then in your custom parcel properties for id_no you type that in.
is there a way to make an expression to put in the other custom parcel properties that will read, say, the permit_no(id_no) from the fdo like and put that information in the custom parcel property field?
I have some files (OK, 11,000 of them) and they have drawings on the bottom and text on the top. I want to erase this text and replace it with data that comes from a database. I don't know where to start.
I need to: 1. preferably find a way to erase the old data on the top, but I could do it manually 2. Insert data from specific fields into specific spots on the drawings. 3. Each drawing would have the same fields but different data corresponding to an account number. The account number is included in the name of the drawing and is a field in the database.
How to get started? I have Map3D as well, which I was told would work better than regular AutoCAD on this, but I also have regular AutoCAD. I can't even figure out how to make the database connection work.
Any way to create a parcel from an object (closed polyline) and populate the parcel with Object Data from the polyline?
I have imported a .shp file into a drawing and the result is many closed polylines with properties similar to the attached image. I would like to bring this data into a parcel object for labeling purposes.
I was looking for some iLogic Code for Inventor 2013 that would cycle through all the parts in an assembly grabbing the quantity of each part and setting it equal to the custom property "Qty" of each part.
Having a little trouble creating the for each loop and setting reference to each part without referencing each part by specific name.
I have created a data extraction table based on attributes placed on blocks. The data table is in my layout and it includes part number, dimensions, and cost. What I need to do is total the cost of all the items at the bottom of my table. I added in a row for the total cost which is not linked to the table but when I try to add a field in that cell to sum the cells above it (the costs), I get ###. I already tried unlocking the cells, but that didn't do anything.
As the heading says - my Map 3d 2011 rearranges object data fields upon import. If I open the coverage in ArcMAP they are in one order (the correct order), and importing to Map mixes that order up. I have around 125 object data fields for each of 2700 objects. Even if the capability existed in Map, rearranging back to the proper order "by hand" is not an option. Is there a setting or something I overlooked that will tell Map to import the data fields in the same order that they are in before the import?
C3D 2012 on 64bit Win 7 all up to date Dell Precision 7core 8GB RAM NVIDIA Quadro FX 1800M LDT/C3D user since release 12
Since I've updated to Photoshop CC, something has changed in the way the information and data fields display in menus and windows to where I can't see them fully or can't see what I'm entering into them. See the image below for reference.
This is happening to Photoshop CC (both standard and 64-bit version) and somehow has applied this to my CS6 versions of Photoshop. I've updated my other programs to CC (Illustration and InDesign) and don't have this issue. They are working fine.
I've done the following to correct the issue, but have not been able to resolve the issue:
I am creating a data band for Finished Ground. I have created a Top surface from my corridor and have sampled that as well as my original ground. I am trying to add data bands to an existing cross section view. When adding data bands for the cross section, I first go to the Section View Properties, add the data band, in this case, "FG Elevations", In the "Section1" column, I pick the Corridor surface that was sampled.
The data band does not display data. I know the data band works, because I picked the original ground as the "Section1" and it gave me the elevation.
I have noticed that under the "Sections" tab of the Section View Properties, and in the "Type" column, the original ground surface has a different symbol than the corridor surface. I have also noticed that if I have only the "Draw" boxes for the sampled corridor surfaces in the section view checked, nothing is drawn the section view. The corridor surfaces seem like they are not really there. Am I not able to retrieve data band data from a corridor surface?? If this is the case how do I go about making the corridor top surface something I can get data from?
I was wondering if it was possible to say have a cover sheet of a project with fields and then have the other sheets in the project have their fields populate using information from cover sheet?
I have added intermediate sample lines in my corridor. These sections appear in the section editor and I can make changes to the data. The changes show correctly in the section editor and section view, however, when I plot the cross sections some of these added stations do not show the overrides. They are showing the original assembly group parameters. How do I get all the cross sections to reflect the edited data from the section editor?
How to populate an Inventor Multivalue PARAMETER using a For cycle in iLogic according to a variable index corresponding to a different number of array items?
for example:
i grab some data from a Rule and populate an Arraylist variable. I trace the number of instances using a counter. after the data acquisition I want to populate the Multivalue Parameter with the acquired values.
No problem browsing the Arraylist parameter: MyArraylist.(Index)... but what about the Multivalue parameter?
the MultiValue.SetList("Multivalue Parameter", Value 1, Value 2, ... , Value N) provide a defined number of data and cannot be set dynamically according to an Index.
I'm having some problems using some existing MX highway design data I've brought into Civil3D using the genio import extension. Basically I can bring in all the alignments that I want to be able to use but am unsure where to go next in terms of creating a proposed profile line. My goal is to be able to pull out long sections and cross sections based on this data. Ideally I'd like to avoid doubling up on work in MX and Civil3D as much as possible.
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.
I am struggling to populate a list view on my windows form. I have tried various methods but its not working. I can get the values into the listview but where i need 2 columns with many rows, i am just get 5 columns.
my list view needs to populate 2 columns. the first column is visible and shows a part name. the second column is hidden and holds a different value. I recursively loop through records and i need to add a row per record. This is captured with j. How can i add the correct amount of rows per j and the columns to hold the correct data?
Long short, we have dozens of drawings and the original base view was deleted, so the title block uses the next view placed to populate. We would like to drop in a new view, and use that as the view the title block looks to. The only way we've figured how to do this is to delete the other 8 or so views (that are already all detailed)., place the view we want to populate the title block, then redraw all the views we just deleted.
Is there an easier way to chose a new base/primary view for a drawing?
In the parent assembly a text iproperty exists called "child list". I would like to set this value via an ilogic rule that does the following:
For each child in the assembly where paremeter "include" = true, add the value of iproperty "filename" to a comma delimited list that will become the value of text Iproperty "child list" in the parent assembly.
The result should look something Like iproperty"child" = "filename1,filename2,filename3,filename4, etc..."
The rule must iterrogate all children, both parts and assemblies, and must go beyond 1st level children.
The output does not have to be comma delimited but must be delimited with something (eg tab, :, etc..)
The number of children is unknown
Is there a character limit imposed on a text iproperty?
Is there any way to make print merge fields relative in position to other fields or to non-variable text.
For example if I am doing address labels and I have fields for City and State:
Their positions are absolute, and the state ends up overwriting the city for long city text, as does the comma.
What I want is for the comma to follow the last letter of the city, and then state to follow that.
And yes, I realize that I can combine all three into one field, but I am asking this as a general usage of the feature. One doesn't always have control over the source.
I then created a Custom iProperty which consisted of the following "formula": Finished Material Size = <Thickness> x <Width> x <Length> Lg.
eg. of Finished Material Result : Finished Material Size = 6 x 25 x 300 Lg.
The problem comes up when dealing with diametrical components as the above formula will only populate for square or rectangular parts. Which would work if I could use iLogic code to populate the Finished Material Size iProperty. I have tried but failed.
First I created another user parameter called "Geometry Type" which has a drop down selection of either "DIA" or "SQUARE, RECTANGULAR".I then created the following iLogic code to set 0 as the value for the "unused" size parameters
If PART_GEOMETRY = "DIA" Then WIDTH = "0"If PART_GEOMETRY = "DIA" Then THICKNESS = "0"If PART_GEOMETRY = "SQUARE, RECTANGULAR" Then DIA = "0" The part I just can't get to work is as follows.
I need some iLogic code which will populate the "FINISHED MATERIAL SIZE" custom iproperty with one of the following based on my "GEOMETRY TYPE" selection. "DIA" would return the following to "FINISHED MATERIAL SIZE": = Ø <Dia> x <Length> Lg.
While "SQUARE, RECTANGULAR" would return the following to "FINISHED MATERIAL SIZE": = <THICKNESS> x <WIDTH> x <LENGTH> Lg.I tried the following code but it does not work:
If PART_GEOMETRY = "DIA" Then iProperties.Value("Custom", "FINISHED MATERIAL SIZE")= "Ø"DIA "x" LENGTH "Lg."If PART_GEOMETRY = "SQUARE, RECTANGULAR" Then iProperties.Value("Custom", "FINISHED MATERIAL SIZE")= THICKNESS "x" WIDTH "x" LENGTH "Lg."
Is there any way to add an "iProperties" item to the context menu in the drawing environment, so that I can select a part on the drawing and access its iProperties, instead of having to "Open, edit iProp, Close," for each individual part? - Using Autodesk Inventor Professional 2012
Any way of having 2 files with different file name but identical designs what automatic updates the other one?
I need the same valve design with different materials, stock number and part names but I would like to make sure that both files are always updated to latest rev. Without having to remember to do it my self every time.