I have a shp file for pipe less the inverts. I have excel with the inverts. Other than hand entry how can I get these data together?
Maybe I am dreaming but I imaging I could make a table in Map connect to excel and then merge the tabels.
Dreaming?
Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Hi Joe,
If you have a common field you can >>>Create a Join<<<. If not you're hosed.
Dave
Dave Stoll
Las Vegas, Nevada
To answer your question...... Yes, you can.....but it might not return the results you really want..
Examine the three pairs of numbers below, i.e., purple pair, blue pair and the red pair. Those paired numbers can serve as a KEY that will 'link' a green record with a white record. In effect, a green Excel row can correspond to a white one when the key matches in both the Excel file and the database file.
<<A row is considered a record while a column is considered an attribute.>>
It might not work in all cases because the length may not serve the purpose you want. What does that mean? It means AutoCAD might get confused if the KEY appears multiple times. For example, the purple pair is 221. That value 221 also appears again at the Orange Arrow. So where should the Excel value 12" go? Should it go to (a) top white row, (b) white row with orange arrow, or (c) both purple and orange in the white table?
In another case it might be appropriate. For example, if you wanted to link all homeowners on a specific street to be alerted when their water is shutoff due to a repair job then multiple identification (such as all homes on Maple St.) is good.
From a practical point of view, it seems unlikely length work because 'length' is shaky. Why is it shaky? Because there could be several instances where length is 221 feet but not all of those specific pipe lengths will correspond to 12" diameter.
Could you find or create a better KEY to make the Excel and database relate to one another?
Chicagolooper
Sorry I didn’t mean to waste your time I missed a corresponding cell NAME is the same in each table
Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Hi Dave
That’s exactly bwhat I want and what I have, but does FDO connect to the excel?
Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Hi Joe,
"...FDO connect to the excel?"
Map 3D will with an ODBC connection. Like >>>This<<<.
QGIS will do this directly and easily.
Dave
Dave Stoll
Las Vegas, Nevada
<<...does FDO connect to the excel?>>
No, it doesn't connect per se.
AutoCAD will use a Windows thingy called an ODBC. This Windows thang is the mechanism that allows Microsoft and Autodesk to communicate. Without an ODBC that data won't move from one to the other cuz they won't be able to see each other's business. No not that kind of business, data business.
On top of that, your data must have a KEY that links both files. For example, you may have an existing homeowner list compiled by the Tax Assessor. The assessor used his data to create a shapefile with owner name, street address, parcel PIN, square footage, tax rate, and tax amount. You also have a second list containing names, home addresses and phone numbers from the local school district.
You may link the phone numbers with each resident using the street address because the address appears in both lists. You are fairly confident it will work because it's unlikely two homes will have the same phone number. If, however, your data was jacked with specifics, maybe if both lists contained parcel PINs, then you'd be extremely confident since every home has a 'unique' PIN. Y'know some homeowners might not have a phone (or have a very private number, Hollywood style).
An ODBC would be able to LINK Autocad Data to an external file such as one in Excel or Access format.
If you really want the ODBC driver, you can read about and download the Microsoft database engine >>HERE<<
If you work in a firm with an IT department that values security, you might not be able to install the driver without their consent. In some firms you cannot install a mouse driver or a new font without putting in a ticket with IT. Even worse is installing the ODBC driver itself......it's a BEAR and appears to require some IT-geeky-know-how in order to wade through the security stuff. Be forewarned.
Chicagolooper
I get to this point but there is no opportunity to choose an excel file. The video flashes by that step and is mysteriously connected to MyCity yada yada.
what di I miss?
Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
The original provider updated the shp so the inverts are in
Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
OK, that's great.
Two questions:
Would it be possible to upload screenshots of your Excel file and the shapefile database Table View? Screenshots can go a long way in developing step-by-step instructions that can be posted in forum. When taking screenshots, go W-I-D-E, include the column headings and several data rows. The more headings and columns you capture in the screenshot the better. Alternatively, upload your shapefile and your Excel sheet.
Chicagolooper
Thanks but I’m done with this.
privider gave me a new file
Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
I sent you a PM but that was done
Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
