Latest Contributions by JoeBorgione

Is it possible to get an attribute rule to fire sequentially as records are appended to a feature class? As a test I set a geodatabase sequence in a file geodatabase with a start value of 100 and increment value of 1.  I then added a standard return NextSequenceValue rule to a field, UniqueID:     return "Prefix-" + NextSequenceValue ("SequenceName")     Then I appended several hundred records from another feature class.  All of the appended records have a UniqueID value of Prefix-100. I was hoping they would have Prefix-100, Prefix-101, Prefix-102 and so on. Is there a way to write a rule that uses a database sequence and will assign incremental values with a multi-record append?   @XanderBakker  ... View more

I have written a script that that (should) step through a list of all the tables in a mySql database and write the contents of each to a csv table.  I've used this basic construct successfully in the past but with specified tables.  This time I'm looping through all the tables in the given database and I'm encountering Unicode errors.  For example: UnicodeEncodeError: 'charmap' codec can't encode character '\x9d' in position 646: character maps to <undefined> The script roles along and creates a couple dozen csv files without a hitch so I looked at what has been created and figured the next table in the list is the culprit.  But I get a different unicode error when I run the script on just that table: UnicodeEncodeError: 'charmap' codec can't encode character '\u0400' in position 1255: character maps to <undefined> Clearly I stand to see these sorts of errors every time through the loop.  Is there way to trap these errors and then exclude the offending character from the output? Here's the code, head to toe:       # -*- coding: utf-8 -*- """ Created on Tue Dec 22 12:37:49 2020 @author: jborgione """ import mysql.connector as mysql from mysql.connector import FieldType import csv,os outFolder = r'N:\GIS\E360' def createCSV(table): cn = mysql.connect(user = 'users', password = 'password', host = 'host', database = 'master_db') cursor = cn.cursor() table = 'complaints' query = f'SELECT * from {table};' cursor.execute(query) rows = cursor.fetchall() column_names = [i[0] for i in cursor.description] dotcsv = f'{table}.csv' outFile = open(os.path.join(outFolder,dotcsv),'w',newline ='') myFile = csv.writer(outFile) myFile.writerow(column_names) myFile.writerows(rows) cursor.close def main(): tableList = [] cn = mysql.connect(user = 'user', password = 'password', host = 'host', database = 'master_db') cursor = cn.cursor() allTables = "show tables" cursor.execute(allTables) for (allTables) in cursor: tableList.append(allTables[0]) cursor.close for table in tableList: createCSV(table) if __name__ == '__main__': #if def main exists, call it main()       ... View more