Advertisement
Guest User

Untitled

a guest
Mar 1st, 2015
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. dictIN= [{'field1':"test1",'date1':'01-02-2015','date1':''},
  2. {'field1':"test2",'date1':'01-02-2015','date1':'01-02-2015'},
  3. {'field1':"test3",'date1':'','date1':''},
  4. {'field1':"test4",'date1':'01-02-2015','date1':''}]
  5.  
  6.  
  7. def setNULLIf(field):
  8. if field == '':
  9. return None #try NULL,'',0
  10. else: return field
  11.  
  12. cursor = arcpy.da.InsertCursor(GDB,("field1", "date1", "date2"))
  13. for x in dictIN:
  14. cursor.insertRow((x[field1'], setNULLIf(x['date1']), setNULLIf(x['date2'])))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement