We are using SSM, and it is getting quite annoying right clicking each sheet to input the info for each sheet, as not each sheet has the same info. Is there not a way to import the data from a spreadsheet, so you can fill out all the data in a spreadsheet how you want it, then import it into the SSM?
View 2 RepliesI 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 have problem with Hole and Thread load menu input Thread.
i see only Loading thread data spredsheet .Please wait
win xp x32
inventor 2013
I already have a cut list template in Excel that calculates my stock material, volume, etc when I populate the appropriate fields. It is also connected to an access database that has various information that automatically generates the final price of my product based on various suppliers prices and data with whom I do business with and so on.
I would like to know if there was a way with iLogic to make Inventor populate specific cells with information found in the BOM such as: description; Qty and custom iProperties value like dimensions, etc?
The reason why I'm making a new topic out of this is that I have read previous post about the issue, but they were regarding "exporting the BOM to an excel". I, on the other hand, would like to populate an already existing spreadsheet with data from the BOM
After exploring the iLogic snippets, I've only found the "export" option. It referenced the API snippets, but with limited programming knowledge there is not much I can understand.
I have a map in AutoCAD and I would like to fill certain sections of it. The colour that I require the fill to be changes according to varying data in an excel spreadsheet. Is there a way of linking the two?
View 2 Replies View RelatedI have a database with the polyline reference/handle (i.e. '13EE6A') and each polyline has a 'door number' associated with it.
I can easily create a query that produces a table of polyline ref and associated door number.
I need to somehow import that door number into the middle of each polyline on the drawing - i.e. if there is a polyline with that handle, put the associated door number in the middle of the polyline on a certain layer. I do NOT need an active link between the database and drawing - it's just to initially populate several thousand rooms numbers!
If it's possible to import Excel spreadsheets into my drawing, instead of using the tables? (Using AutoCAD LT 2014)
I guess technically it would be easiest if I could import LibreOffice Calc spreadsheets, but I can get access to Excel easily enough if it's the only option.
I am using Auto Cad LT 2012. How do I import an Excel spreadsheet into my drawing?
View 2 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...
Problem:
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!
how to import point data that has Map Object Data also attached to it? "import it by attaching to a data source".
Example: I have a bunch of manholes. Each MH has X,Y,Z, but also Type, Invert Elevs., Pipe Sizes, Pipe Materials, Pipe Directions, Structure Type/Material, etc. etc. etc. I may have point data representing MH's, airport runway ends, trees, anything you can imagine, with all kinds of data imaginable.
I want to import this data directly into Autocad/Civil 3D as either Autocad points, lines, or closed polylines (I also have utility lines, parking lots, etc.- all with data associated with it), all with the data attached as object data. I know that anything more complex than points might be hard to explain here, so I am hoping at least for a solution on how to import points - I have 99,999 MH's and obviously I don't want to have to type all that data in one by one.
I basically suck at using sql server. I can get around using the Map workspace and the different tabs. I have never used FDO, and I am not even sure what it is.
I fooled it today by creating 99,999 Autocad points at the correct XYZ, attaching the correct object data to them, then exporting as a shp file. I went into the shp_name.dbf file and edited it to add the data I wanted by cutting & pasting from Excel. then I re-imported the shp file. but, this is a workaround at best.
Surely Map can import objects and their associated data fields, all populated with valid data! all I need is to know how to do it. I mean, if this is not something I can do directly using Map commands should I take the money I earned by surveying 99,999 MH's with my GIS data collector that allows me to assign 101data fields to each object I survey, and buy something better?
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
when I import PNEZD format .csv using import wizard the coordinates get transformed. all points are shifted about 20' in northing and 5 feet in easting. I have to use the import wizard w/ survey database in order to process linework codes.
View 5 Replies View RelatedI want to import a csv file into map3D and set the layers to which the blocks with attributes are inserted on. Using
Click Home tab > Data panel > Import From Files > mapimport.
Problem is, when I do this, I do not get the dialog that the help file says I should, like a place to define an insert layer or schema. All I get is the plain dialog that asks for formatting (file format such as autodesk up loadable file), Z unit, Coordinate system, and create block.
I also want to export the attribute data into a survey point file.
I am trying to import XY data into Matlab from an Autocad 10 DXF export ASCII file. This data is from a flat drawing (no Z dimension.) When I import the lines, polyline, and hatches, some of the data has a different coordinates system than the others, and possibly a different scaling.
Are there some DXF attributes I should check to find the appropriate reference points and scaling for each entity type, or does this need to be discovered in the native Autocad 10 DWG file?”
How I can attach some external data to an AutoCAD object. I found on the internet the object data solution for AutoCAD MAP 3D, but my boss meant, I should find a possibility to import data into AutoCAD without MAP 3D.
View 2 Replies View RelatedI have an excel file containing xyz co-ordinates that i wish to import to AutoCAD (2005).
I realise you can probably do this using the lisp function, but i don't know how they work, and wanted to know if there is an easier way.
I want to create a site layout that would consist of multiple buildings. I have the AutoCAD drawing of each building and the location and orentation of each building in ArcGIS. Is there a way to import the data from ArcGIS into AutoCAD for my use?
Also if this isnt the correct location for this could administrator move it for me?
How to import data from .txt files? Or from Excel? I'd like to specify some points and lead a spline through them. I've made a list (quite long) of coordinates in Excel and I wish I didn't have to type them all
View 2 Replies View RelatedI try to import geotechnical data into Civil 3D 2014 but see this message: Object reference not set to an instance of an object .
View 9 Replies View RelatedImport Data into the Industry Model,
I am supposed to go to the insert tab and run convert to industry modle.
However it does not exist in this tab, I could not get the help file to show be where I could find this command.
Also where is the dataset for this module. I followed the link from the help file to [URL].... but could not see any data set for this module
I have collected point data for the positions of trees using PocketGIS software. The software produces a csv. file with the Northings and eastings of each point surveyed to which are attached a number of other attributes (e.g. tree tag number, height, species etc.).
Is it possible to import and plot these points directly into AutoCAD?
Can some or all of the attributes be included (i.e. it would be very useful if the positions could be plotted together with the tag number)?
How to import data from excel (from particular cell) to AutoCAD Drawing. I have already Created a template for both Excel and AutoCAD. I want to do Whenever i am changing the datas in excel sheet corresponding changes to be done in AutoCAd drawing.
I am using AutoCAD 2010 and Microsoft excel 2007.
I'm using Map 3D 2012 with Oracle 11g. I created an enterprise project with an industry model with water and wastewater modules. After this i created my feature classes and defined the utility model linking the geometry feature class to the attribute ones (ex: WA_POINT to WA_ARMATURE, WA_VALVE, WA_HYDRANT etc.).
At this moment i have to import a large amount of data from *.shp or *.sdf files, but theese files contain geometric and attribute data together.
How can i import the geometry from the shp or sdf file to the geometry feature class (ex: WA_POINT) and the attributes to the attribute feature class (ex: WA_VALVE), while creating the reference between the geometry and attribute feature classes?
I tried bulk-copying the geometry, but it doesn't create the coresponding attribute feature.
I setting up constraint parametric drawing and store data in parametric manager table, but I don't know how to export & import this data to excel sheet or use data for input the program.
View 1 Replies View RelatedHow can I import excel data for a hydrograph into SSA for a sub basin? I have 10 subbasins each with their own hydrograph.
View 1 Replies View RelatedIt's possible to import datas from other simulation software ( Moldex 3D ) in to the Inventor.
View 1 Replies View RelatedI am creating a template for my company with associated description keysets. The codes and attributes have already been created in an excel spreadsheet. Currently I am typing these all individually by hand but would like to import the excel data if possible.
View 2 Replies View Relatedwe recently were trying to import an excel table via data link function. Initially this works fine and the table appears in the drawing however when we want to break the link by deleting it in the data link table autocad tells me that the link is in use. We routinely do this in autocad mechanical 2010. The reason we do this is to be able to bring in the table and preserve formatting. How can we easily delete the data link in 2010 LT?
View 9 Replies View RelatedI have just down loaded some commercially available 3D models needed for some presentation work.
I would like to turn these into 2D orthographic views, without the polymesh, is this possible.
File formats downloaded are .fbx .lwo .max .obj .xsi
the polymesh converter in autocad did not work.
It was in Feb - March 2012. I was then using AutoCAD Civil 3D 2012. I had faced a problem of getting ground data for a large surface by using satellite imageries processed by some government wing of USA (NASA?), have lost track of it.
View 6 Replies View RelatedI use a Sokkia total station along with a data collector. I use this to bring measurement points in to another program that will draw a scaled map. I'm forced to use this other program and its supposed to be able to export the drawing into DXF format. It wont bring in the z coordinates. Is there a way I can use the total station to collect the points and then get them into AutoCAD 2013 so i can work my magic. Basically I draw crash scenes for a police department.
View 2 Replies View Related