Latest Contributions by jaykapalczynski

OK this is the FINAL SCRIPT... I cant thank you all enough for you help... Reads through a Folder looking for CSV or txt files Reads through each CSV file Splits the comma delinted CSV file and write all the vales to variables A couple functions are called to process a couple of the variables to create new values for calculated fields that exist in the Feature Class but NOT the CSV file An if than statement populates a new field BearID based on a value from another field and adds this to the insert. Each row is inserted into the Feature Class Once completed the txt/csv files are moved to another folder for backup import arcpy import datetime import os, fnmatch import shutil # Function to modify two fields into a Time variable def getdate(Hour, Minute):     return datetime.datetime.strptime(str(Hour).zfill(2) + ' ' + str(Minute).zfill(2), '%H %M') #Function to loop through a directory and work through one file at a time def findFiles (path, filter):     for root, dirs, files in os.walk(path):         for file in fnmatch.filter(files, filter):             yield os.path.join(root, file) fc = r'C:\Users\tjv36463\Desktop\BearCollar\BearLocationImports.gdb\BearCollar'   #Insert cursor for the Bikes feature class cursor = arcpy.da.InsertCursor (fc,["CollarSeri", "Year", "Julianday", "Hour", "Minute",          "Activity", "Temperatur", "Latitude", "Longitude", "HDOP", "NumSats", "FixTime",          "Date", "_2D_3D", "BearID", "CalcDate", "CalcDate3", "FileName", "SHAPE@XY"]) #Read through each line of the csv, but skip the first row because it is the header #The count variable skips of the first row for textFile in findFiles(r'C:/Users/tjv36463/Desktop/BearCollar/NewFiles/', '*.txt'):     #Read through each line of the csv, but skip the first row because it is the header     #The count variable skips of the first row     count = 0     for ln in open (textFile, 'r').readlines():         if count > 0:             #Each line in the csv is a string, so turn it into a list so you can reference             #each column             lineSplit = ln.split(",")             #Use index positions to get the right column from the csv             #Make sure the data is the correct type (i.e. X and Y need to be numbers,             #not strings)             CollarSeri = long(lineSplit[0])             Year = str(lineSplit[1])             Julianday = str(lineSplit[2])             Hour = int(lineSplit[3])             Minute = int(lineSplit[4])             Activity = int(lineSplit[5])             Temperature = int(lineSplit[6])             Latitude = float(lineSplit[7])             Longitude = float(lineSplit[8])             HDOP = str(lineSplit[9])             NumSats = int(lineSplit[10])             FixTime = int(lineSplit[11])             _2D_3D = int(lineSplit[12])             Date = str(lineSplit[13])             # convert the two time fields into one field to get 4:02:00PM format             # calls Function getDate at the top             getTime = getdate(Hour, Minute)             getTime2 = str(getTime)             getTime3 = getTime2[-8:]             # concatonate Date and Time to get 6/15/2016 4:02:00PM             getDateTime = (Date + getTime3)             # set variable for the File Name in which the record was take from             FileName = str(textFile)             #print (FileName)                             if CollarSeri == 32488:                 BearID = "1"             else:                   if CollarSeri == 32491:                       BearID = "2"                   else:                     if CollarSeri == 32495:                         BearID = "3"                     else:                         if CollarSeri == 32498:                             BearID = "4"                         else:                             if CollarSeri == 32500:                                 BearID = "5"                             else:                                 if CollarSeri == 32502:                                     BearID = "6"                                 else:                                     if CollarSeri == 32501:                                         BearID = "7"                                     else:                                         if CollarSeri == 33108:                                             BearID = "8"                                         else:                                             if CollarSeri == 32499:                                                 BearID = "9"                                             else:                                                 if CollarSeri == 32488:                                                     BearID = "10"                                                 else:                                                     if CollarSeri == 32496:                                                         BearID = "11"                                                     else:                                                         BearID = "0"             shapeVal = (Longitude, Latitude)             #Insert the values from csv into feature class             #The order of the fields here, matches the order of the fields in line 4             cursor.insertRow ([CollarSeri, Year, Julianday, Hour, Minute, Activity,                     Temperature, Latitude, Longitude, HDOP, NumSats, FixTime, Date,                     _2D_3D, BearID, getTime3, getDateTime, FileName, shapeVal])                         count += 1             del cursor ## make sure that these directories exist # move the files to new location to clear the folder for the next batch of files dir_src = "C:\\users\\tjv36463\\Desktop\\BearCollar\\NewFiles\\" dir_dst = "C:\\users\\tjv36463\\Desktop\\BearCollar\\MovedFiles\\" for file in os.listdir(dir_src):     #print file  # testing     src_file = os.path.join(dir_src, file)     dst_file = os.path.join(dir_dst, file)     shutil.move(src_file, dst_file)             print ("Processing Finished") ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Mitch Holley, Darren Wiens THANK YOU FOR YOUR HELP AND SUPPORT....Things are running great...although not the most efficient way but I got it...with YOUR help of course ANY QUESTIONS:  please feel free to reply and I will get back with you.. THANKS Again Mitch and Darren....SOOOO very much appreciated. 1. Read CSV to file to get all records 2. I calculated the Time field (CalcTime) from an Hour and Minute Field..          12:02:00 AM 3. Once I had that I calculated the Full CalcDateTime field from CalcTime above and the Date field from the CSV           6/29/2016 12:02:00 AM  4. Inserted ROWS into the Feature Class using SHAPE@XY Token to create the geometry Hour Minute from CSV File  0          2 getTime3 Variable - CalcTime Field Result in New Feature Class 12:02:00 AM getDateTime Variable - CalcDateTime field result in the New Feature Class concatenated with the Date field from the CSV File 6/29/2016 12:02:00 AM FULL CODE BELOW import arcpy import datetime def getdate(Hour, Minute): return datetime.datetime.strptime(str(Hour).zfill(2) + ' ' + str(Minute).zfill(2), '%H %M') fc = r'C:\Users\\Collar\BearLocationImports.gdb\BearCollar' cursor = arcpy.da.InsertCursor (fc,["CollarSeri", "Year", "Julianday", "Hour", "Minute", "Activity", "Temperatur", "Latitude", "Longitude", "HDOP", "NumSats", "FixTime", "Date", "_2D_3D", "BearID", "CalcDate", "CalcDate3", "SHAPE@XY"]) for ln in open (r"C:\Users\tjv36463\Desktop\Bear Collar\rangedate_D032495_20160822124736_NH.txt", 'r').readlines(): #Each line in the csv is a string, so turn it into a list so you can reference each column lineSplit = ln.split(",") #Use index positions to get the right column from the csv #Make sure the data is the correct type (i.e. X and Y need to be numbers, not strings) CollarSeri = long(lineSplit[0]) Year = str(lineSplit[1]) Julianday = str(lineSplit[2]) Hour = int(lineSplit[3]) Minute = int(lineSplit[4]) Activity = int(lineSplit[5]) Temperature = int(lineSplit[6]) Latitude = float(lineSplit[7]) Longitude = float(lineSplit[8]) HDOP = str(lineSplit[9]) NumSats = int(lineSplit[10]) FixTime = int(lineSplit[11]) _2D_3D = int(lineSplit[12]) BearID = 0 Date = str(lineSplit[13]) # working with Date Time http://stackoverflow.com/questions/1521906/how-to-specify-date-and-time-in-python getTime = getdate(Hour, Minute) getTime2 = str(getTime) getTime3 = getTime2[-8:] getDateTime = (Date + getTime3) print getDateTime shapeVal = (Longitude, Latitude) #Insert the values from csv into feature class cursor.insertRow ([CollarSeri, Year, Julianday, Hour, Minute, Activity, Temperature, Latitude, Longitude, HDOP, NumSats, FixTime, Date, _2D_3D, BearID, getTime3, getDateTime, shapeVal]) count += 1 del cursor print ("done") ... View more