Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About LeviCecil
LeviCecil
Frequent Contributor
since
08-07-2019
Monday
391
Posts created
135
Kudos given
11
Solutions
170
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(10 Idea Submissions)Latest Contributions by LeviCecil
|
POST
|
So I’m trying to utilize the date and time only fields available at Enterprise 11.3. This works just fine in the S123 app, but errors out in the web version, because the time entered does not include seconds. I need parity between the app and web versions because there are people in our org who will never download and use the S123 app. I see that the web version only works with decimal time. Is it possible to specify that in the S123 Excel sheet?
... View more
03-24-2025
10:31 AM
|
0
|
0
|
198
|
|
POST
|
Is there an expression to force the survey into decimal time in the S123 Excel sheet?
... View more
03-24-2025
10:05 AM
|
0
|
0
|
642
|
|
POST
|
I just discovered that this is only an issue in the web survey. A survey submitted through the S123 app returns hours, minutes and seconds. I read that the web app version only works with decimal time. Where do I specify this in the XLS form?
... View more
03-19-2025
11:43 AM
|
0
|
0
|
748
|
|
POST
|
In which column in the XLS form do I specify the time format, like ISO 8601?
... View more
03-19-2025
11:28 AM
|
0
|
0
|
750
|
|
POST
|
Well, according to the link above, it's beta functionality at 11.2. Not sure if it's fully supported at 11.3. Probably not. Two surveys I submitted yesterday after 1pm went through to the table and had the seconds formatting. After this it started failing. I'll try adding formatting in the XLS sheet.
... View more
03-19-2025
09:30 AM
|
0
|
0
|
753
|
|
POST
|
I’m not using AGOL, this is in Enterprise 11.3. The thing is, I submitted several surveys before these errors started happening. The last one was at 1:18pm, which would have been 15:18
... View more
03-18-2025
10:36 PM
|
0
|
0
|
783
|
|
POST
|
Ah OK. When will these fields be "fully supported?" It says they're beta functionality at 11.2, but we're at 11.3
... View more
03-18-2025
10:34 PM
|
0
|
0
|
783
|
|
POST
|
I'm in Enterprise 11.3. I have a survey that's passing the entered time to a time only field in the registered sde table. I don't think it likes surveys taken after noon, because I'm getting this error: {"error":{"code":400,"extendedCode":-2147467259,"message":"Unable to complete operation.","details":["Invalid iso format: 15:25.","Unable to complete operation."]}} Is there a calculation I can put in my XLS form to force the time field to send responses in 12 hour time?
... View more
03-18-2025
03:33 PM
|
0
|
9
|
838
|
|
POST
|
Figured it out. I needed to publish the table as a reference registered feature service, not a hosted table, with replica tracking enabled and sync disabled on the sde table.
... View more
03-18-2025
01:21 PM
|
0
|
0
|
330
|
|
POST
|
I republished the sde table without the timestamp offset field. Now the new records are showing up in the hosted table in the portal, but still not in the sde. Do I need to enable sync for this to work?
... View more
03-18-2025
10:57 AM
|
0
|
0
|
332
|
|
POST
|
I have a standalone table in an Enterprise 11.3 sde geodatabase. I've published this to our Portal as a hosted feature layer and created a survey from this. The problem I'm running into is that survey submissions are only showing up in the S123 dashboard, not in the hosted feature layer or the sde table. I've enabled editing, global IDs, sync and editor tracking and the problem persists. I was having trouble setting up sync because of Time Only, Date Only and Timestamp Offset fields, but that doesn't seem to be the issue. Unless it is?
... View more
03-17-2025
06:20 PM
|
0
|
2
|
379
|
|
POST
|
Thanks for all the replies! I'm a rudimentary Excel user, so I would rather not use it as an interim step to get to Google Sheets. I'll just use export table and do the rest in FME.
... View more
03-03-2025
10:23 AM
|
0
|
0
|
877
|
|
POST
|
So each room has a corresponding Floor ID attribute, which is what I'm splitting by. I'm using the split by attributes tool. The desired outcome is writing each one of these resulting features (rooms on the 1st floor, 2nd floor, etc) to a Google sheet in a directory for that floor. The problem I'm seeing is that when I run the tool, it just splits everything at once. I'm wondering if there's a way to iterate through each group as it's being split, instead of after the fact? I could do that by looping through the resulting features in the temp gdb. And yes, the end result is a sheet that contains all the attributes for each room. ObjectID doesn't need to be included.
... View more
02-28-2025
01:59 PM
|
1
|
0
|
999
|
|
POST
|
I'm writing a script to split a feature class of 15000 rooms, into subgroups of rooms by floor. I'd like to loop through each group as it is split and write this table to csv, or directly to Google sheets if possible. As it stands, it looks like the split by attribute tool just runs and creates a new feature for each group. Will I need to iterate after it runs?
... View more
02-28-2025
01:43 PM
|
0
|
7
|
1002
|
|
POST
|
Hey, yes. The trigger needs to come from a hosted feature layer. So publish with "copy all data" and make sure editing is enabled.
... View more
02-26-2025
08:12 AM
|
1
|
0
|
1143
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | Thursday | |
| 1 | 2 weeks ago | |
| 1 | 09-13-2024 10:43 AM | |
| 1 | 06-05-2025 01:26 PM | |
| 3 | 04-04-2025 10:54 AM |
Activity Feed
- Got a Kudo for Only Show Related Table Specific To Feature Type. Friday
- Posted Only Show Related Table Specific To Feature Type on ArcGIS Field Maps Questions. Thursday
- Got a Kudo for Export Multiple Single PDFs By Group From ArcGIS Pro Map Series. a week ago
- Got a Kudo for Re: Stable alternatives to Power Automate. 2 weeks ago
- Got a Kudo for Re: Cross Feature Editing with Attribute Rules in UN. 2 weeks ago
- Posted Re: Cross Feature Editing with Attribute Rules in UN on ArcGIS Utility Network Questions. 2 weeks ago
- Posted Cross Feature Editing with Attribute Rules in UN on ArcGIS Utility Network Questions. 2 weeks ago
- Posted Cannot Test Attribute Rules on Branch Versioned Utility Network Data on Attribute Rules Questions. 3 weeks ago
- Got a Kudo for Export Multiple Single PDFs By Group From ArcGIS Pro Map Series. 3 weeks ago
- Got a Kudo for Re: Date only Field won't display in ArcGIS Experience Builder Tables. 09-16-2025 11:53 PM
- Got a Kudo for Expiration Dates in Barcode Scanner. 09-15-2025 02:34 AM
- Posted Re: Support for Attribute rules in ArcGIS Online on ArcGIS Online Ideas. 09-10-2025 08:57 AM
- Kudoed Support for Attribute rules in ArcGIS Online for Yann-EricBoyeau. 09-10-2025 08:55 AM
- Got a Kudo for Export Multiple Single PDFs By Group From ArcGIS Pro Map Series. 08-14-2025 02:21 AM
- Got a Kudo for Make Form Fields Editable And Calculated Based On Condition. 06-27-2025 12:01 PM
- Got a Kudo for Re: ArcGIS Enterprise Power Automate Connector Not Working at 11.3. 06-17-2025 08:24 PM
- Posted Re: Can't Toggle Restraint Rules On and Off With Table on Attribute Rules Questions. 06-11-2025 01:21 PM
- Posted Can't Toggle Restraint Rules On and Off With Table on Attribute Rules Questions. 06-11-2025 10:35 AM
- Posted Re: How to Toggle Constraint and Calculation Attribute Rules on and off on Attribute Rules Blog. 06-11-2025 08:31 AM
- Posted Re: How to Email a Survey When Hidden Fields Have Been Edited on ArcGIS Connectors for Power Automate Questions. 06-11-2025 07:53 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Monday
|