Latest Contributions by KieranClark

‎02-22-2023

Hey Jason, Thank you for this workaround, it does seem to work on the layout page. However, it still breaks when exporting to PDF as either a single page or the whole map series. Did you ever find a more permanent workaround for this? I'm still trying to figure out what changed between versions as the <CLR> tag used to work perfectly fine in arcade expressions. Edit: Wow, strike all of that - I figured it out. Thanks to your post, I was able to figure out a way to set up the code so I didn't have to duplicate a tag and then manually add a </CLR> at the end since I figured if I wrapped it all into a variable it would work. The new code is as follows: var datafield = $feature.CABLE_IS_COMM_AND_ACCEPT; var comcolor = "<CLR red='84' green='109' blue='63'>" + "Complete" + "</CLR>" var inccolor = "<CLR red='255' green='121' blue='0'>" + "Incomplete" + "</CLR>" Iif(datafield == 1, comcolor, inccolor) This code worked in a test dynamic element but when I applied it to our existing ones, it broke again. However, you had made mention of don't double click bounding boxes but that got me thinking if the bounding box itself was the issue. Our bounding boxes for the dynamic text elements had been 1.2 inches wide with text centered since that made everything line up correctly on our layout. What I did instead was to make them all 6 inches long and shift the X position to offset by 2.4 inches to account for the wider box. This has now allowed the expression to stick while changing pages in the map series and while exporting the series to PDF - all of which had broken before with your workaround of manually adding </CLR> at the end. Additionally, double clicking the bounding box does not break the expression - the full tag text appears when you double click but once you click off the display returns to normal. Seriously, thank you for these thoughts - you really got me on the right track to solve this issue that GRmapper and I have been slamming our heads against for a while.

‎06-24-2021

Hi Matthew, Thanks for responding. So if I go through the extra step of exporting the Query Table to another standalone table, everything works well. However, I would like to remove that extra step, if possible. I'll be automating several Query Table updates to my online map so the more steps I can eliminate the better. Is it potentially an issue with how I've created the Query Table?

‎06-21-2021

I am having an absolutely mystifying issue trying to publish a data table for use in ArcGIS Online. I am able to successfully publish the table from ArcGIS Pro, but once I do, I am missing an entire column of data. Not entirely sure how to describe it so let me add an image to illustrate: This is a query table that I made in ArcGIS Pro. All of the field headings are present, however the data for the first "CableCharacteristics" is missing and has pulled everything else one column to the left, leaving the last column blank. The second column is supposed to read "2,009" and not "2,034" but that entire column of data appears to be missing, even though all field headings are correct and present. Pretty stumped here - I'm not sure where my data is disappearing to!

‎05-17-2021

This is a bit of a follow up to this post: Solved: Re: Removing blank values via Arcade Expression - Esri Community I now have the comma separated lists working with blank values removed. However, for entries where no appropriate company exists for that entry, I would like to return "Not Available" instead of simply leaving the value blank. Here's what it currently looks like: The blank spot next to "System Installer" is what I would like to have say "Not Available" if there are no matches. Currently, the field is set up like so (this is the same way for Supplier/Owners): This works perfectly when there are existing values for this entry in the map series. However, for entries that do not have a matching ROLE_ID I can't figure out how to return "Not Available" instead of just leaving it blank. I don't feel like I'm explaining this particularly well either, so please feel free to ask more pointed questions to help figure out the root of the issue.

‎05-17-2021

Hi Josh, I'm trying to tackle this issue again after a few weeks of working on other things for this publication and I'm having a little trouble understanding how you're suggesting to use the Distinct function. I'm not sure how to set it up properly to even return a value of 0 if nothing matches.

‎04-26-2021

Hi Josh, Sorry to bug you again but I have one last tweak I'm trying to figure out. Some cable systems (mostly planned) do not have a System Installer available yet. What I would like to do is if there are no companies that match ROLE_ID of 11 (System Installer) then display "Not Available"

‎04-23-2021

Wow, yes this is absolutely what I wanted. Thank you!

‎04-23-2021

Hi folks, I've created a map layout that pulls data from various fields in our new database. Everything is connected and working great now and all the data is coming across mostly correct. The one remaining hurdle I have right now is that when trying to pull data for System Supplier, System Installer and Owner(s) it displays the correct company names but it also carries over a bunch of blank values. Like so (outlined in red): My Arcade expression is as follows. var role = $feature.ROLE_ID If(role == 12){ return $feature.COMPANY_NAME } The intent is to check if a company is ROLE_ID 12 (System Supplier in this case) and return the Company name if it is. Where I'm stuck is I am not sure why it is even accounting for other companies that don't match the ROLE_ID and fill up my data fields with blanks. I'm sure it's something simple I'm overlooking but I've been staring at this all day and could use a fresh pair of eyes...

‎04-23-2021

I was actually able to find a way to make this work! I had completely misunderstood what the Microsoft OLE DB Provider for ODBC Drivers was for. If I choose that option and select the MySQL data source that I made through MySQL's OLE DB connection it all works. I guess that option is like a wrapper or whatever to allow connections to other types of database. So if you're in my situation and need to connect to a MySQL server, try the "Microsoft OLE DB Provider for ODBC Drivers" option!

‎04-20-2021

Yeah, I was just hoping there was some sort of workaround. Looks like we'll be moving to PostgreSQL. Not a big deal as there are really good migration tools out there but it would be nice if Esri supported MySQL as well. I feel like it's common enough to warrant compatibility.

‎04-20-2021

I've found some old threads talking about the difficulty connecting to a MySQL and I was wondering if it's even possible to connect to MySQL directly in ArcGIS Pro these days. I've created a data source on my computer, but when I go to add an OLE DB connection in ArcGIS Pro, I don't even have the option to select the MySQL ODBC driver. Is there a setting or plugin/addon I'm missing that would let me do this? I would really rather not have to migrate our database to PostgreSQL if I can avoid it.

‎02-24-2021

Yeah, I think I will need to redraw all the lines that currently cross the Pacific. They do currently break at the date line. Now that the publication I was worried about is published and won't have a new version for another 3 months, I'll have the time to try to sort this out properly. Thanks again for all your help!

‎02-19-2021

Nevermind, I was able to make a custom coordinate system using my current projection and altering where the Prime Meridian is placed. Once that is applied, I can simply export the Pacific systems individually!

‎02-19-2021

Hi Justin, sorry to ping you again but I'm really stuck on the issue of cable systems traversing the Pacific. I had thought that manually framing the map for individual items in the Map Series would allow me to frame those specific systems the way I wanted, but they are still being output based of the automatic map series. Is there a way to set custom extents for individual parts of a Map Series? You had also mentioned making some kind of calculation to determine extent and scale and put that value into a field. That might have to be the answer. I'm somewhat comfortable with Python if needed.

‎02-12-2021

Hm, this didn't seem to work. I should have probably clarified, the reason I need the expression to pull the URL together in the first place is because this needs to be a dynamic element in a map series. I have also figured out a simpler way to get the URL I need by changing my Dynamic Text expression to the following: 'https://subtelforum.com/?s=' + UrlEncode($feature.SystemName);

Online Status	Offline
Date Last Visited	‎04-26-2023 07:35 PM

My Ideas

Latest Contributions by KieranClark

Re: Arrcade - Color Text Conditionally

Re: Sharing table to ArcGIS online removes data column

Sharing table to ArcGIS online removes data column

Arcade help - Return "Not Available" when no values exist

Re: Removing blank values via Arcade Expression

Re: Removing blank values via Arcade Expression

Re: Removing blank values via Arcade Expression

Removing blank values via Arcade Expression

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

ArcGIS Pro Connect to MySQL database via OLE DB connection

Re: Zoom to Selected Feature within Layout Guides

Re: Zoom to Selected Feature within Layout Guides

Re: Zoom to Selected Feature within Layout Guides

Re: Formatting Hyperlinks for PDF Layout Export

Re: Possible to embed YouTube/Vimeo videos in a po...

Re: Arrcade - Color Text Conditionally

Add Google Analytics to web app?

Error with XY Table to Point in Python Script

ArcGIS Pro Connect to MySQL database via OLE DB co...