Allow users to join table to layer, any update?

Permanently deleted user

10. September 2018 15:14

I found this 2014 link (https://support.geocortex.com/essentialsGSCForum?sub-nav=forum&main-nav=essentials&#!/feedtype=SINGLE_QUESTION_DETAIL&criteria=ALLQUESTIONS&id=906600000000AyeAAE) asking if users can join a table to a layer. There were no answers and I want to do the same thing. Specifically, I want the appraisers in our Assessor's office to be able to spit out an excel or csv table from their CAMA software which has just the parcel tax accounts they are interested in, import it and join it to the parcel layer by account number for display and perhaps manipulation of symbology. Is this possible? Through a workflow maybe? Thanks.

0

• 

  Permanently deleted user

  5. Oktober 2018 00:20

  Hi Heather, 

   

  Unfortnately it's not yet possible for end users to manipulate relationships, whether it be for existing layers or user-added ones.  I'd suggest posting it as an Idea (https://support.geocortex.com/GSCIdeas?c=09a6000000008RsAAI&filter=1&categ=all&sub-nav=ideas&main-nav=essentials&page=1) .

   

  With a workflow, you could have them provide an excel file, read it into a data table, do a query on your parcel layer using values from your datatable to build the where clause, and make a selection in the results list from the resulting features.  You might even be able to find a way to add the attributes from the table to the features before making the selection. That would let you see and/or symbolize the results, but it doesn't create a true layer than you could run queries or filters or use other tools on.  I think doing that would require custom development.

  0
• 

  Permanently deleted user

  5. Oktober 2018 04:42

  Thinking out load here,

   

  I wonder if a geoprocessing task that could create a joined shapefile and return it zipped could be called with a workflow. The workflow could add it to the viewer. If you have python skills I think that aproach would be worth testing. It also depends on how many tax parcels. I think adding shapefiles to geocortex viewer has a limit. 1000? maybe thats arcgis online.

   

   

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.