Latest Contributions by RandallClark1

Hi vince, Thanks for the response. the database is sql server 2008. so how is that i can make a feature data set with no problem? and how do i determine what the correct schema is? ... View more

Hi George, I will edit my question too but 1. What ArcGIS Desktop version is being used and license level (Basic, Standard or Advanced)? Standard 2. What RDBMS is being used? (Oracle 11.2.0.3. SQL Server 2008, etc...) SQL Server 2008 3. What are the permissions of the user that is loading the data into the geodatabase? Admin. 4. What version was the enterprise geodatabase created at? 10.2.x ... View more

So here is the original # -*- coding: utf-8 -*- """    This script will convert a table to an excel spreadsheet. If the third-party    module xlwt is available, it will use that. Otherwise, it will fall back to    CSV. """ import arcgisscripting import os gp = arcgisscripting.create(9.3) def header_and_iterator(dataset_name):     """Returns a list of column names and an iterator over the same columns"""     data_description = gp.Describe(dataset_name)     fieldnames = [f.name for f in data_description.fields if f.type not in ["Geometry", "Raster", "Blob"]]     def iterator_for_feature():         cursor = gp.SearchCursor(dataset_name)         row = cursor.next()         while row:             yield [getattr(row, col) for col in fieldnames]             row = cursor.next()         del row, cursor     return fieldnames, iterator_for_feature() def export_to_csv(dataset, output):     """Output the data to a CSV file"""     import csv     def _encode(x):         if isinstance(x, unicode):             return x.encode("utf-8")         else:             return str(x)     def _encodeHeader(x):         return _encode(x.replace(".","_"))             out_writer = csv.writer(open(output, 'wb'))     header, rows = header_and_iterator(dataset)     out_writer.writerow(map(_encodeHeader, header))     for row in rows:         out_writer.writerow(map(_encode, row)) def export_to_xls(dataset, output):     """     Attempt to output to an XLS file. If xmlwt is not available, fall back     to CSV.            XLWT can be downloaded from http://pypi.python.org/pypi/xlwt"""     try:         import xlwt     except ImportError:         gp.AddError("import of xlwt module failed")         return     header, rows = header_and_iterator(dataset)     # Make spreadsheet     workbook = xlwt.Workbook()     worksheet = workbook.add_sheet(os.path.split(dataset)[1])     #Set up header row, freeze panes     header_style = xlwt.easyxf("font: bold on; align: horiz center")     for index, colheader in enumerate(header):         worksheet.write(0, index, colheader.replace(".","_"))     worksheet.set_panes_frozen(True)     worksheet.set_horz_split_pos(1)     worksheet.set_remove_splits(True)     # Write rows     for rowidx, row in enumerate(rows):         for colindex, col in enumerate(row):             worksheet.write(rowidx+1, colindex, col)     # All done     workbook.save(output)     if __name__ == "__main__":     dataset_name = gp.GetParameterAsText(0)     output_file = gp.GetParameterAsText(1)     format = gp.GetParameterAsText(2)     if format == "CSV":         export_to_csv(dataset_name, output_file)     elif format == "XLS":         try:             export_to_xls(dataset_name, output_file)         except:             import traceback             gp.AddError(traceback.format_exc())     else:         raise ValueError("Don't know how to export to %r" % format)     print "FINISHED" and here is yours added. Did i get it right? # -*- coding: utf-8 -*- """    This script will convert a table to an excel spreadsheet. If the third-party    module xlwt is available, it will use that. Otherwise, it will fall back to    CSV. """ import arcgisscripting import os gp = arcgisscripting.create(9.3) def header_and_iterator(dataset_name):     """Returns a list of column names and an iterator over the same columns"""     data_description = gp.Describe(dataset_name)     fieldnames = [f.name for f in data_description.fields if f.type not in ["Geometry", "Raster", "Blob"]]     def iterator_for_feature():         cursor = gp.SearchCursor(dataset_name)         row = cursor.next()         while row:             yield [getattr(row, col) for col in fieldnames]             row = cursor.next()         del row, cursor     return fieldnames, iterator_for_feature() def export_to_csv(dataset, output):     """Output the data to a CSV file"""     import csv     def _encode(x):         if isinstance(x, unicode):             return x.encode("utf-8")         else:             return str(x)     def _encodeHeader(x):         return _encode(x.replace(".","_"))             out_writer = csv.writer(open(output, 'wb'))     header, rows = header_and_iterator(dataset)     out_writer.writerow(map(_encodeHeader, header))     for row in rows:         out_writer.writerow(map(_encode, row)) def export_to_xls(dataset, output):     """     Attempt to output to an XLS file. If xmlwt is not available, fall back     to CSV.            XLWT can be downloaded from http://pypi.python.org/pypi/xlwt"""     try:         import xlwt     except ImportError:         gp.AddError("import of xlwt module failed")         return     header, rows = header_and_iterator(dataset)     # Make spreadsheet     workbook = xlwt.Workbook()     worksheet = workbook.add_sheet(os.path.split(dataset)[1])     #Set up header row, freeze panes     header_style = xlwt.easyxf("font: bold on; align: horiz center")     for index, colheader in enumerate(header):         worksheet.write(0, index, colheader.replace(".","_"))     worksheet.set_panes_frozen(True)     worksheet.set_horz_split_pos(1)     worksheet.set_remove_splits(True)     # Write rows     for rowidx, row in enumerate(rows):         for colindex, col in enumerate(row):             worksheet.write(rowidx+1, colindex, col)     # All done     workbook.save(output)     if __name__ == "__main__":     dataset_name = gp.GetParameterAsText(0)     output_file = gp.GetParameterAsText(1)     format = gp.GetParameterAsText(2)     if format == "CSV":         export_to_csv(dataset_name, output_file)     elif format == "XLS":         try:             export_to_xls(dataset_name, output_file)         except:             import traceback             gp.AddError(traceback.format_exc())     else:         raise ValueError("Don't know how to export to %r" % format) print "Finished" #start new script import csv, os table = r"C:\temp\python\XY.csv" outFile = r"C:\temp\python\XY_1.csv" outFile2 = r"C:\temp\python\XY_2.csv" #read lines of CSV f = open(table, "r") lines=f.readlines() lines=lines[1:] f.close() #write all lines except header to CSV f = open(table, "w+") for line in lines:     f.write(line) f.close() #remove first column with open(table,"r") as input:     with open(outFile,"w+") as output:         writer=csv.writer(output)         for row in csv.reader(input):             writer.writerow(row[1:]) #remove empty rows input = open(outFile, 'rb') output = open(outFile2, 'wb') writer = csv.writer(output) for row in csv.reader(input):     if row:         writer.writerow(row)         input.close() output.close() os.remove(table) os.remove(outFile) #rename to original CSV os.rename(outFile2, table) print "Finished" ... View more

Hi Andrew, No nothing yet, But still hoping. If i figure something out i will let you know Randall Clark GIS Manager InDepth Corporation ... View more

Denise thank you. ... View more

So then to build something for a android device i have to use the ArcGIS Runtime SDK for Android? or can i build it using ArcGIS Mobile and port it over to an android device. ... View more