Adding fields to existing shp file table

[dhoskings]

Does anyone know how to add more fields to the dbf file of a shp (using AutoCAD Map 2010), other than calculation fields? I am often working on a shp and get asked to add more fileds to hold more data but cannot find a way to do in in AutoCAD (have to resort back to Arcview: but then that causes issues when I go back to the original CAD file that has the data connected to it).


Thanks,
Dave

[jackie.ng]

Copy your SHP file to a directory of your choice. Make sure it has only this one SHP file.

Connect to this directory in the Data Connect dialog using the SHP connection.

In your Map Explorer tab, go to Schema - Edit Schema

Add your new fields, then click apply. Your SHP will have the new fields added. You can verify the new fields are there by removing the connection and repeating the above steps. Your new fields should be there when you bring up the Schema Editor again.

The reason you have to connect to a directory is because for SHP files, schema modification can't work on a single SHP file connection. Secondly, the reason that directory only contains that one SHP file is so that when you apply, it only affects that one SHP file.

Hope that helps.

- Jackie

[Joe-Bouza]

Will that work on an sdf file?

[Murph_Map · Accepted solution]

---

@Joe-Bouza wrote:

Will that work on an sdf file?

---

Yes, in fact you can edit the data/table with out having it in a separate folder. Just edit with the schema editor. Also I shouldn't have to tell you or that W.F.Berry fella north of me to make a back up copy first right. 🙂

[antoniovinci]

dhoskings wrote:
using AutoCAD Map 2010

---

By the way, in my golden olden Map2006, I cannot edit the inner structrure of a shape (as said by Jackie&Murph), so I use the opensource Mapwindow to achieve the goal...

[Joe-Bouza]

Hmmm? That worked great. Is there a way to paste an Excel column into my newly created property field?

[Murph_Map]

---

@Joe-Bouza wrote:

Hmmm? That worked great. Is there a way to paste an Excel column into my newly created property field?

---

Nope, you need to do a data connect to the excell (if it will connect) then do a join and save as a new sdf file.

[randoshadow]

I do this and then I get an error window pop up and it says "This path is not of a legal form."

any idea what I am doing wrong?

Randy

[djlcedar]

Very interesting that I keep coming back to this 2010 post. Just want to create my own shp file from a polyline and add a field for length and another one for name. It feels like I'm the first person to ever want to do what appears to be a overlooked and highly needed function for those that just want to do a couple of things in Map 3D. Why they don't allow you to add fields to a shp file that you create with the Map 3D function seems very odd. 

[Alfred.NESWADBA]

Please don't crosspost ... lets continue >>>there<<<, - alfred -