dgregor

Need help with a sample tool of an Attribute Editor

Discussion created by dgregor on Sep 7, 2010
Hi,

I am new to ArcObjects therefore a sample script would be very helpful. I would need a tool for comparing attribute structure changes in different Geodatabase versioned environments and that requires fast responses from me. Environments are not always the same, therefore I may not use hard coded table / feature class list and needs to be configurable for a non-developer.

I would need a sample tool for ArcMap using ArcObjects 9.3 that would:

Read TABLE STRUCTURE -> CSV
1. Read a specific list of table names (txt file)
2. Select an ArcSDE connection for the source data (where the tables are located)
3. Export the structure of the tables set in the txt file (column type, length, ...) in one CSV format

Implement structure from a CSV into a TABLE STRUCTURE
1. Select a CSV file
2. Select the ArcSDE connection for the target implementation
3. Commit additions (adding new columns only!) of the new columns

Compare two CSV
1. Select source and target CSV
2. Export the differences into a new CSV


Sample format of the CSV
# File generated by Attribute Manager.ExportAttributes
# Date: 9/3/2010 12:22:44 PM

# ADD/REMOVE/REPLACE;TableName;FieldName;DataType;Alias;AllowNULLValues;Domain;Precision;Scale;Length

REPLACE;ATTACHMENT;OBJECTID;ObjectID;OBJECTID;No;;10;0;4
REPLACE;ATTACHMENT;CATEGORY_NAME;Text;CATEGORY_NAME;Yes;;0;0;20
REPLACE;ATTACHMENT;TYPE_NAME;Text;TYPE_NAME;Yes;;0;0;20
ADD;ATTACHMENT;NAME_2010;Text;NAME_2010;Yes;;0;0;20

Outcomes