Latest Contributions by ModernElectric

‎12-03-2019

Thank you for the response. However, the code didn't seem to work. I copied it to my python script to replace the existing and ran the script. Got a response that said: NameError: name 'upper' is not defined

‎12-03-2019

Greetings: I have a python script written that has a small section that converts a date (11/5/2019) in date format into a text format (Nov-2019). The code is within a Calculate Field tool command and it works just fine. However, the end results of Nov-2019 is not exactly what I want. The end result that I am looking for is NOV-2019. Is there a way in the code that I can tell the tool to capitalize the month so it shows up as NOV-2019 instead of Nov-2019? OR is there a different command tool I need to add into my python script to change the month from lowercase to uppercase? Having a hard time finding the answer. Here is my code I have for converting the date-time to text: arcpy.CalculateField_management(ELECTRIC_METER_READING_RAWDATA_VIEW, "READING_DATE_TEXT_CONVERT", "(datetime.datetime.strptime( !READING_DATE_TEXT! ,'%m/%d/%Y %H:%M:%S %p')).strftime('%b-%Y')", "PYTHON", "") if I use the %B it comes out with the full month instead of the abbreviated month. Thank You for your help

‎10-03-2019

Peter: That was my first thought was there was a problem with the File GDB. So, I went through and created a new File GDB and imported the Feature Class(s) into it from the existing GDB (Via Feature Class to Feature Class tool). Apparently, something within the existing File GDB that AGOL's update procedure did not like it. I was able to successfully update the Feature Layer via ArcMap, along with the Python Script collection I have. Still do not know what the problem initially was, but I spent a good day and a half "rebuilding" my working GDB. Thank You

‎09-27-2019

Good Morning. I have been having a specific issue for awhile now and cannot figure out how to resolve it. I have a number of different File GDBs that I started in ArcMap and have recently opened/loaded into ArcGIS Pro. The purpose of doing that is to update my company's ArcGIS Online Feature Layer. I have around 6 different ArcGIS Pro Map(s) for a different GDB that I update/override a Feature Layer in ArcGIS Online. There is (1) GDB/Map that is giving me a constant error and WILL not update. I get an Error that says: Unable to connect o portal - token access failure. My username and password has not changed and I have no problems updating other map(s)/GDB. The Error Log does not tell me why its failing. Any ideas? I have tried deleting the Feature Layer in AGOL and reshare it with the same issue. Thank You

‎08-08-2019

I have a few different GDBs that I am using to update ArcGIS Online. One of them is giving me zero problems when doing the staging process. The path name is really not that long. One thing I have noticed in the GDB that I am having issues with is the Point Feature Class(s) is causing the crash, but not the Line Feature Class(s). I know its not the length of path because the Line Feature Class(s) update just fine but when I include the Point Feature Class(s) - that also have attachments associated to the features, I get the Staging Failure.

‎08-07-2019

Has there been any new information about this problem? I have one File GDB (Electric System) composed of all kinds of points and lines with a number of domains and .PDF attachments. This one has no problem updating into ArcGIS Online. However, I have another File GDB (Water System) also composed of points and lines, domains, attachments. I have one specific feature class that is triggering the failure. Its a point feature class with domains and attachments just like everything else. But, this is the suspect that will not allow the process to finish. Is there something else that will prevent a feature class inside ArcGIS Pro from updating to a feature layer to ArcGIS Online? I cannot figure out why this specific point feature class is making the update process crash. I am working on a project on converting the data from ArcMAP to ArcGIS Pro (Long Story).

‎08-06-2019

This is something that I have been having issues with lately and my Field Foreman from different crews are coming in and complaining that they cannot see specific layers in Explorer, which they too rely on. A little history... I use ArcMap for data editing. We also use ArcReader in the office for our Operation's staff. ArcGIS Online and Explorer is something that we have implemented for a little over a year. My goal was to keep ALL platforms consistant so if one layer's symbol is in ArcMap, it is the same across ALL platforms. I would use ArcMap to update ArcReader's dataset and ArcGIS Online's dataset. The problem came from updating the Feature Layer with the selected symbols in ArcMap for the Web Map for Explorer. NOW, I am working on using the symbol building tool in ArcGIS PRO to mimic the symbol I use for ArcMap and ArcReader and I am able to update the Feature Layer to AGOL and ALL of the symbols work/show in Explorer. I believe this is what you are discussing and wanted to add my input on what is working for me. Also, the Explorer App is used on Apple and Android devices. It would be nice if no matter what editing platform you are using (ArcMAP vs ArcGIS Pro), the symbol selection would be able to be used on all other platforms (AGOL, Explorer, Collector, etc.)

‎07-25-2019

One of my Field Crew members brought in one of our field android tablet(s) that uses ArcGIS Explorer to open company maps from ArcGIS Online and had a problem with certain layers not displaying. Upon some investigation, I determined the symbol(s) that I use all of a sudden do NOT work in ArcGIS Explorer. They use to but now, they are not. Is there a limitation on the type of Symbol type(s) that can be used in Explorer and/or collector that has changed? My process goes from ArcMAP that already has the symbol(s) pre-created and shares a Feature Layer to AGOL. Just wondering if this is a NEW limitation since I checked the Android App store and there is no software update required at this time for ArcGIS Explorer. The reason why I have specific symbols created is because we also use ArcReader in the office and my main goal is consistency. This way, the same symbol for a specific feature class is the same across all platforms within the company. Thank You

‎07-11-2019

I am building a comparison analysis for a database outside of my GDB, but still use the data within the GDB. I have imported the data into a File GDB and have the following fields I am working with: ACLARA_TYPE ACLARA_MODEL METER_TYPE ANALYSIS_FLAG Here is what I am doing: If ACLARA_TYPE = 39 and ACLARA_MODEL = 2 AND EQUALS METER_TYPE = CMT_GEN, then to populate the ANALYSIS_FLAG Field with 1. If it DOES NOT match, then the ANALYSIS_FLAG Field would be populated with 0. Basically, If the METER_TYPE Equals something different (Lets say CMT_1), there is something wrong with the data. The thing is, I am trying to find incorrect METER_TYPE(s) based on the TYPE and MODEL. ACLARA_TYPE ACLARA_MODEL METER_TYPE ANALYSIS_FLAG 39 2 CMT_GEN 1 39 2 CMT_1 0 I Hope this makes sense on what I am trying to accomplish. I am using the CALCULATE_FIELD Tool and will eventually build this process into a Python Script. Thank You

‎06-20-2019

I guess we can disregard this. After spending hours trying to figure out what was going wrong, I figured it out. There were some entries from the raw data from the Oracle database export that was format differently, so when the script got to them, it crashed. Some of those rows had a format of ONLY m/d/y and missing the time. I had to add another tool to select and delete those rows so the script worked perfectly afterwards.

‎06-20-2019

I have done this so far: Taken the Date field (READING_DATE) and copied over to READING_DATE_TEXT (Text Field). I am trying to use Calculate Field tool to convert, but keep getting an error: Here is the READING_DATE_TEXT Field I am trying to convert from: Thank You

‎06-20-2019

I've been doing alot of research on how to accomplish a specific task and from what I can tell, it seems to frustrate many people and I am really starting to agree. I am developing a series of Python Scripts (converting from data models) to import reading data and dates to prepare for our GIS database. One of the tasks in the series is dealing with the date field(s). The raw data for the READING_DATE field (Date Type) comes in as m-d-y-h-m-s (Ex. 1/1/2019 12:10:00). I need to go from this format to a format of m-y (Ex. Jan-2019). I am not sure exactly how to do this. In my data model, I use the Convert Time Field tool. However, when running this tool on over 500,000 records it takes a LONG time. I am thinking about using the Arcpy Update Cursor but still new to using this feature. Would like some help in how to set-up the script code and exactly what field type(s) I need to accomplish this. Thank You

‎06-19-2019

The Convert Time Field tool is being used with a number of other tool(s) in a stand-alone python script that will later be combined into a batch file for easier processing. The code that I am using to convert the raw READING_DATE field to the text file is this: arcpy.ConvertTimeField_management(ELECTRIC_METER_READING_RAWDATA, "READING_DATE", "'Not Used'", "READING_DATE_CONVERT_TEXT", "TEXT", "MM/dd/yyyy;1033;;") Last time I tried to run it with only about 8,000 rows, it took about 25 minutes to run. This is what it looks like when its finally done:

‎06-19-2019

Joe: Thank you for the links. That is a cool script. However, I can I use this within a feature class/table? I have a field (READING_DATE) Date type and (BILLING_DATE) Text type. Example here: I want to run a script that will take the reading date (date type) and convert it to the billing date (text type) and write/update the billing date field. The tool I use now Convert Time Field (Data Management) takes 5 to 6 hours to do this process.

‎06-19-2019

Joe: You been a huge help and I appreciate it. Wanted to see if you could help me on one more thing. One of the process is to take a field called READING_DATE (Date field type) in a m/d/y format and convert it to a field BILLING_DATE (Text field type) in a format of m-y (May-2019). I am currently using the CONVERT_TIME tool in a data model and with almost 15,000 rows it takes almost 5 hours to complete. I want to be able to use a cursor to see if this will drastically decrease the amount of time it takes to convert the field. Thanks Again

Online Status	Offline
Date Last Visited	‎06-10-2026 12:25 PM

My Ideas

Latest Contributions by ModernElectric

Re: Calculate Field convert date to text

Calculate Field convert date to text

Re: Update AGOL from ArcGIS Pro - Token Access Failure

Update AGOL from ArcGIS Pro - Token Access Failure

Re: Staging failed when trying to publish hosted feature layer in Pro

Re: Staging failed when trying to publish hosted feature layer in Pro

Re: Feature Layer Views Not Visible in Explorer?

ArcGIS Explorer Symbol Limitations

calculate field based on match/unmatch

Re: Stand-Alone Python Script - Date Field Modification

Re: Stand-Alone Python Script - Date Field Modification

Stand-Alone Python Script - Date Field Modification

Re: ArcPy Update Cursor if/else

Re: ArcPy Update Cursor if/else

Re: ArcPy Update Cursor if/else

Re: Using Workforce? Check out the new, upcoming t...

Re: Flow error/fail to run notification

Re: Water Utility Network - Model Blow-Off

Re: Workforce Project Sync Delay & Ongoing Issues

Survey123 Power Automate Notification