Sheeter - Google Sheets Connection for Fusion 360

Sheeter - Google Sheets Connection for Fusion 360

prainsberry
Autodesk Autodesk
24.547Aufrufe
64Antworten
Nachricht 1 von 65

Sheeter - Google Sheets Connection for Fusion 360

prainsberry
Autodesk
Autodesk

I wanted to post this here i case anyone is interested in checking it out.  Something I have been working on for awhile and decided to put it out there to see what people think.  

 

This allows you to connect a Google Sheet (spreadsheet) document to a Fusion 360 design.  Then you can define multiple sizes.  Once you have defined the sizes you can switch sizes back in Fusion, or generate new Fusion models, export neutral files, or post process g-code for each size.

 

It is really just a bit of a hobby project for me so I make no guarantees, but in the tests I have done it has been pretty reliable.  

 

Let me know what you think. 

https://github.com/tapnair/FusionSheeter

 



Patrick Rainsberry
Developer Advocate, Fusion 360
Akzeptierte Lösungen (1)
24.548Aufrufe
64Antworten
Antworten (64)
Nachricht 41 von 65

n3rDlab
Participant
Participant

Do any of the other commands work?  

0 „Gefällt mir“-Angaben
Nachricht 42 von 65

Rafa_Navarro
Participant
Participant
Well, I guess the issue came because I was using a link to a spreadsheet made with the previous version.

I have added to new sheets to my old spreadsheet, "Properties" and "Sketch Text", as required in the new version, and everything works fine.

Great job! I'll let you know my impressions with this new version.
0 „Gefällt mir“-Angaben
Nachricht 43 von 65

Rafa_Navarro
Participant
Participant

Well, I guess the issue came because I was using a link to a spreadsheet made with the previous version.

I have added two new sheets to my old spreadsheet, "Properties" and "Sketch Text", as required in the new version, and everything works fine.

Great job! I'll let you know my impressions with this new version.

0 „Gefällt mir“-Angaben
Nachricht 44 von 65

n3rDlab
Participant
Participant

Oh yah, thats not good thanks!  I'll see if I can get a fix asap that won't break compatibility with older versions.

0 „Gefällt mir“-Angaben
Nachricht 45 von 65

managementSJGDP
Observer
Observer

Hey @prainsberry I found one other small bug in the new version. After changing size the "Quick Pull" button at the bottom of the window didn't update the size that it was linking to for that quick pull.

 

So as an example:

I used "Change Size" to go from size 1 to size 2 inside the fusion project, and everything updated accordingly. But then after making a Sheets change and trying to update the currently active "size 2" part using "Quick Pull", everything reverted to size 1. 

 

The only thing that seems to update the quick pull linkage is if you run the main "Sync With Google Sheet" button select your current size in the "Current Size (Associated Sheet Row)" and run the sync. Maybe this is expected behavior, but IMO the ideal functionality is for the Quick Pull to update its linkage in coordination with a size change

0 „Gefällt mir“-Angaben
Nachricht 46 von 65

n3rDlab
Participant
Participant

Hey thanks, yah that is a bug.  Currently working on version 3.1.0 and I'll incorporate this fix as well.  

Sorry for the rushed release and lack of testing, once I got into it I've been making tons of improvements and haven't had as much time to test over the past couple days. 

Almost done with latest changes, should be published later today.

0 „Gefällt mir“-Angaben
Nachricht 47 von 65

n3rDlab
Participant
Participant

Ok new version (3.1.0) is published to the site.  

https://n3rdlab.com/

Fixes a few bugs and problems with incompatibility with older spreadsheets.

Also added some more performance improvements.  

0 „Gefällt mir“-Angaben
Nachricht 48 von 65

en9y37
Advocate
Advocate

Hi Patrick!

 

I'm testing your new version and I've found a couple of bugs. I can't link my design to an existing sheet, and the Sync features suppression doesn't work at all, it seems it's completely passed by.

0 „Gefällt mir“-Angaben
Nachricht 49 von 65

n3rDlab
Participant
Participant

Hello, thanks again for the feedback.  I can't believe I missed those, result of one of the last changes I made. 

I just uploaded version 3.2.0, hopefully I got all the kinks out this time.  

Nachricht 50 von 65

Rafa_Navarro
Participant
Participant

Hats off!!

 

Both bugs completely solved. I love the improvement in the G-code interface too 😍

 

I've been browsing the code in the config.py file, is the "post_name" variable meant to preset a post in the G-code interface?

 

Rafa_Navarro_0-1648785572091.png

 

....and one suggestion, would be possible to add some kind of "Select all" for the setup selection so as to not have to mark them one by one?

Rafa_Navarro_2-1648785847418.png

 

Thanks again for all!!

 

 

 

0 „Gefällt mir“-Angaben
Nachricht 51 von 65

florianADZZ4
Explorer
Explorer

After the major update of fusion last week I can't run the add-in anymore, unfortunately. I have downloaded the latest version, but without any luck. Is there a special trick to make it work again? 

 

Thanks for the help!Sheeter.png

0 „Gefällt mir“-Angaben
Nachricht 52 von 65

n3rDlab
Participant
Participant

It looks like you are still using the old one.  Did you download the latest from:

https://n3rdlab.com/downloads/sheeter/

Make sure in the scripts/add-ins dialog you are pointed at the right version, should be 3.2.0 as of today.

n3rDlab_0-1649097429565.png

 

 

Nachricht 53 von 65

florianADZZ4
Explorer
Explorer

I accidently mixed-up the two versions. So thanks for your fast reply! 

 

It's a really helpful tool. Make's my live a lot easier! So thanks for that! 

 

 

0 „Gefällt mir“-Angaben
Nachricht 54 von 65

en9y37
Advocate
Advocate

Hi @n3rDlab

 

I keep on testing your new version and I have found a bug. When I launch Generate G-code for all sizes, none of the operations is recalculated before the post processor, so any operation that needs recalculation appears in the output.

 

en9y37_0-1651646392876.png

 

0 „Gefällt mir“-Angaben
Nachricht 55 von 65

a.monopoliQCTV2
Participant
Participant

thanks for sharing it!

It works!

 

0 „Gefällt mir“-Angaben
Nachricht 56 von 65

florianADZZ4
Explorer
Explorer

The last couple of weeks I have been working on a new design with two sizes. But lately I can't change between the two sizes any more. I get the following info when trying. It looks like I deleted some feature's that where connected to the google sheet. But I can't figure out which one exactly. Is there a way to figure out which one i'm missing? 

Sheeter error.png

Thanks for the help!

0 „Gefällt mir“-Angaben
Nachricht 57 von 65

prainsberry
Autodesk
Autodesk
Probably the best thing is to just create a new sheet.


Patrick Rainsberry
Developer Advocate, Fusion 360
0 „Gefällt mir“-Angaben
Nachricht 58 von 65

jhogarthHG7H
Observer
Observer

Having this window pop and not finishing the task. 

 

jhogarthHG7H_0-1685979243400.png

 

0 „Gefällt mir“-Angaben
Nachricht 59 von 65

Christoph_360
Collaborator
Collaborator

Hello

 

I'm looking for the possibility to control variant models in Fusion via a table and came across the possibility of Sheeter in the forum here and was very pleased at first, because it seems to be what I am looking for.

 

But Sheeter can't be found in the Fusion 360 App Store and since I'm a layman, I can't judge if that's a serious thing.

 

Maybe they can help me and thank you very much

 

Mfg

Christoph

0 „Gefällt mir“-Angaben
Nachricht 60 von 65

golds2
Observer
Observer

Looks like its broken again. Python updates?