idea Batch add colors to ArcGIS Pro style in ArcGIS Pro Ideas

Batch add colors to ArcGIS Pro style

FourCornersMapping — Thu, 29 Aug 2024 15:43:59 GMT

Currently I have to enter color values manually to an ArcGIS Pro Style (.stylx), which is time consuming and laborious. I suggest the ability to add colors to an ArcGIS Pro style with a batch process or as a file. I envision something similar to the process of adding swatch files (.ase) to Adobe Illustrator. Alternatively the user could prepare a .csv with HEX, RGB, CMYK values, etc., color mode, and the other field values in Catalog that must currently be entered manually.

Re: Batch add colors to ArcGIS Pro style

BrennanSmith1 — Thu, 05 Sep 2024 14:11:31 GMT

I agree this would be very useful! I found this post a while back, it seems that this can be done with python, but I never figured it out myself. Seeing your post inspired me to take another stab at it. If you update the path to your stylx file and your spreadsheet, something like this should work for you.

import sqlite3 import pandas as pd import json # Connect to stylx file (tested this on a copy of favorites) stylx_file = r"C:\Users\username\AppData\Roaming\Esri\ArcGISPro\Favorites - Copy.stylx" conn = sqlite3.connect(stylx_file) cursor = conn.cursor() # Get the items table cursor.execute("SELECT * FROM Items LIMIT 1000;") items = cursor.fetchall() new_id = len(items)+1 # Load in your colors, assuming you have a spreadsheet with the referenced fields excel_file = r"C:\Users\username\AppData\Roaming\Esri\ArcGISPro\addColors.xlsx" df = pd.read_excel(excel_file) df.fillna('', inplace=True) # Loop through and insert rows for row in df.itertuples(): content = {'type':'CIMCMYKColor','values':[row.C, row.M, row.Y, row.K,100-row.alpha]} new_row = (new_id,1,row.Category,row.Name,row.Tags,json.dumps(content)) cursor.execute('INSERT INTO ITEMS(ID, CLASS, CATEGORY, NAME, TAGS, CONTENT) VALUES(?,?,?,?,?,?)', new_row) new_id += 1 # save and close conn.commit() conn.close()

Re: Batch add colors to ArcGIS Pro style

FourCornersMapping — Thu, 05 Sep 2024 14:21:38 GMT

@BrennanSmith1 That's great! I'll check it out! Thanks.