we have built a model with hard coded pricing in grasshopper- i am looking for an external way to update those prices out side of grasshopper----our developer proposes a google sheet integration, where when we change the price in the cell it updates grasshopper with a new price— is this possible? are there integratable apps to do such a thing?
Yes, there are plugins for reading Excel spreadsheets or you can parse CSV formatted files yourself.
I’m not sure if they ever got the Mac implementation working, but these old GHPython scripts still appear to work:
Don’t know how your data is organized in GH or why you are using GH at all instead of a web app? A ShapeDiver app, perhaps?
But you could consider something in between in the form of a PHP REST interface where GH generates url params for REST queries and PHP reads Google Sheet files and organizes data for REST replies.
Hi……I am starting to understand what I am needing. So bharat is telling me that when we change costing in grasshopper, we have to reload onto Shapediver
This is not what I want to do.
I want be able to change the grasshopper price file that is in shapediver. So I don’t have to upload .
I will have 12 models in Shopify that are grasshopper/shapediver files. The problem is the price maintenance as they are live in Shopify.
Thus the desire is to be able to change the price file in grasshopper while it is live in shapediver …Is this possible?
If not, then I guess I will have to create a monthly routine of update and reload. Of which I did not want to do.
Also, for some reason bharat was not able to have success with your approach for some reason
@Larry_Trimboli I gave several options to solve exactly your issue in this topic: External price on shapediver using Excel or Google sheet - #2 by mathieu1
These all involve a centralized way to store your data (either in Google Sheets or an Excel file) which is connected to your ShapeDiver models, meaning you can update the data without having to re-upload your models.