topic Re: csv script in Fusion API and Scripts Forum

csv script

daniel_lyall — Thu, 26 Nov 2015 01:40:10 GMT

is it possible at this time to create a script to take all parameters from a file, they will be user created parameters put it out as a csv file, then have a script to import the csv file and it put's the user parameter back in as user parameters or would it be easyer to put them back in as modle parameters.

this just a question at this time as this would be handy for doing cabint makeing. it is something I may try to do soon but I am not very good with codeing.

Re: csv script

marshaltu — Thu, 26 Nov 2015 05:23:13 GMT

Hello,

If you just want to import data from a file and use them to create user parameters, the following codes would demostrate that. The file content is like below:

d1=10 mm

d2=5 in

d3=30 degree

#Author-
#Description-

import adsk.core, adsk.fusion, traceback

def run(context):
    ui = None
    try:
        app = adsk.core.Application.get()
        ui  = app.userInterface
        
        design = adsk.fusion.Design.cast(app.activeProduct)
        if not design:
            ui.messageBox('No active Fusion design', 'Import Spline csv')
            return
        
        dlg = ui.createFileDialog()
        dlg.title = 'Open CSV File'
        dlg.filter = 'Comma Separated Values (*.csv);;All Files (*.*)'
        if dlg.showOpen() != adsk.core.DialogResults.DialogOK :
            return
        
        filename = dlg.filename
        f = open(filename, 'r')
        parameters = design.userParameters
        line = f.readline()
        data = []
        i = 0
        while line:
            pntStrArr = line.split('=')
            for pntStr in pntStrArr:
                data.append( pntStr)
        
            if len(data) >= 2 :
                i += 1
                parameters.add(data[0], adsk.core.ValueInput.createByString(data[1]), '', 'MyParameter{}'.format(i))

            line = f.readline()
            data.clear()            
        f.close()         

    except:
        if ui:
            ui.messageBox('Failed:\n{}'.format(traceback.format_exc()))

Thanks,

Marshal

Re: csv script

daniel_lyall — Thu, 26 Nov 2015 06:06:39 GMT

Thank you very much @marshaltu at the moment I cant do anything with it, for some reasion all paramaters are missing from all of my designs. I am going to have to fix them all before I get back to this.

thanks

Re: csv script

daniel_lyall — Thu, 26 Nov 2015 08:25:05 GMT

I have been playing with the code if I run it to open a .csv with just the 3 lines you did it works if I try one taken from a sketch it does nothing.

this is the code I am useing to get the paramaters

#Author-Brian Ekins
#Description-Dumps out parameter info to a specified csv file.

import adsk.core, adsk.fusion, traceback

def run(context):
    ui = None
    try:
        app = adsk.core.Application.get()
        ui  = app.userInterface
        
        # Get the name of the file to write to.
        fileDialog = ui.createFileDialog()
        fileDialog.isMultiSelectEnabled = False
        fileDialog.title = "Specify result filename"
        fileDialog.filter = 'CSV files (*.csv)'
        fileDialog.filterIndex = 0
        dialogResult = fileDialog.showSave()
        if dialogResult == adsk.core.DialogResults.DialogOK:
            filename = fileDialog.filename
        else:
            return

        des = app.activeProduct

        result = 'Name,Expression,Units,Value (database units),Comment,Type,Component\n'

        # Get the data for all user parameters.
        for userParam in des.userParameters:
            result += (userParam.name + ',' + userParam.expression + ',' + userParam.unit + ',' + 
                       str(userParam.value) + ',' + userParam.comment + ',User\n')

        for comp in des.allComponents:
            for modelParam in comp.modelParameters:
                result += (modelParam.name + ',' + modelParam.expression + ',' + modelParam.unit + 
                           ',' + str(modelParam.value) + ',' + modelParam.comment + ',Model,' + comp.name + '\n')

        output = open(filename, 'w')
        output.writelines(result)
        output.close()
        
        ui.messageBox('File written to "' + filename + '"')

    except:
        if ui:
            ui.messageBox('Failed:\n{}'.format(traceback.format_exc()))

do i need to change this bit, parameters = design.userParameters to something like below

# Get the data for all user parameters.
for userParam in des.userParameters:
result += (userParam.name + ',' + userParam.expression + ',' + userParam.unit + ',' +
str(userParam.value) + ',' + userParam.comment + ',User\n')

for comp in des.allComponents:
for modelParam in comp.modelParameters:
result += (modelParam.name + ',' + modelParam.expression + ',' + modelParam.unit +
',' + str(modelParam.value) + ',' + modelParam.comment + ',Model,' + comp.name + '\n')

Re: csv script

marshaltu — Thu, 26 Nov 2015 09:33:07 GMT

Hello,

I changed the codes a little bit to read the data exported from Brain's scripts. Now it should work as expected.

Please note I have to give one space to comments if it is empty in file. There was a bug to create user parameter with empty comments. I have fixed it in our development build. The fix should be availabe in next major update.

Thanks,

Marshal

#Author-
#Description-

import adsk.core, adsk.fusion, traceback

def run(context):
    ui = None
    try:
        app = adsk.core.Application.get()
        ui  = app.userInterface
        
        design = adsk.fusion.Design.cast(app.activeProduct)
        if not design:
            ui.messageBox('No active Fusion design', 'Import csv')
            return
        
        dlg = ui.createFileDialog()
        dlg.title = 'Open CSV File'
        dlg.filter = 'Comma Separated Values (*.csv);;All Files (*.*)'
        if dlg.showOpen() != adsk.core.DialogResults.DialogOK :
            return
        
        filename = dlg.filename
        f = open(filename, 'r')
        parameters = design.userParameters
        line = f.readline()
        data = []
        while line:
            pntStrArr = line.split(',')
            for pntStr in pntStrArr:
                data.append( pntStr)
        
            if len(data) >= 5 :
                if data[0] != 'Name' and data[1] != 'Expression': 
                    comments = data[4]
                    if comments == '':
                        comments = ' '
                    parameters.add(data[0], adsk.core.ValueInput.createByString(data[1]), data[2], comments)

            line = f.readline()
            data.clear()            
        f.close()         

    except:
        if ui:
            ui.messageBox('Failed:\n{}'.format(traceback.format_exc()))

Re: csv script

daniel_lyall — Thu, 26 Nov 2015 10:09:47 GMT

thanks @marshaltu it's not working very well it got the first 4 parameters then stopped and came up with an error. i have attached the .csv file I am getting the parameters from, thank you for your help so far.

I just tryed it on another file and it worked. as fails, 11 works, this is going to save me a lot of time thank you

I think what is makeing it fail is what is in the Expression 11 has number and letter's, AS has words it fail on the 5th line what has words it does not matter to much as if this is the problem I can just change it what is in 11 is how I do it now

Re: csv script

marshaltu — Thu, 26 Nov 2015 10:28:30 GMT

Hello,

I am not clear how you generate the file? There were two kinds of errors in the file:

1. Special character to express "deg". I would like to suggest to replace all of them by "deg".

d52,0.0 ∞,deg,0,,Model,layout sheet

2. There was an additional item in Line #6. We have to remove "Draw_depth".

d43,Draw_depth - 18 mm,mm,38.2,,Model,Draw`s

After I correct the errors, I can import those data and create user parameters.

Thanks,

Marshal

Re: csv script

prainsberry — Thu, 26 Nov 2015 16:56:05 GMT

Hey Daniel I am actually working on a script to do something really similar. Like you want to be able to switch between different versions of the design really quickly? Might have it done this weekend.

Stay tuned.

Re: csv script

daniel_lyall — Thu, 26 Nov 2015 20:37:44 GMT

@marshaltu wrote:
Hello,

I am not clear how you generate the file? There were two kinds of errors in the file:

1. Special character to express "deg". I would like to suggest to replace all of them by "deg".
d52,0.0 ∞,deg,0,,Model,layout sheet
2. There was an additional item in Line #6. We have to remove "Draw_depth".
d43,Draw_depth - 18 mm,mm,38.2,,Model,Draw`s

After I correct the errors, I can import those data and create user parameters.

Thanks,
Marshal

@marshaltu I have look at some other Model's they have 1. the same that's down to fusion.

I just did a quick test this is what should comes up from a press pull

0.00 °

deg

Model

(Unsaved)

all the spots where there is a deg in the files paramaters like above for press pull, some are like above, but others have a number string changeing them to 0 fixes the problem like you said.

in the paramater's they are fine it is when they are dumped to the csv file, some have gone bad.

here is a link to the file http://a360.co/1Q09V2U if you have a look your self you will see they are fine until you dump the file to a csv, it could mean the are not at 0 deg they could be a bit out of squire

I just did this file http://a360.co/1NaBCRt it has the same problem as the file above.

so what is makeing this happen I would not have a clue

2. that's how I use to do the paramater's I use letter code's now

Re: csv script

daniel_lyall — Thu, 26 Nov 2015 20:44:50 GMT

@prainsberry wrote:
Hey Daniel I am actually working on a script to do something really similar. Like you want to be able to switch between different versions of the design really quickly? Might have it done this weekend.

Stay tuned.

take you time your meant to be on holiday.

sound good it would be good to have a script where you build one model say a cabint then you can run a script that will fire out a copy but it opens a dialog so you can change the sizeing before it builds that model as a new model. this would make the hobby boys quite happy and cabint maker's. doing scripts like this would make fusion a almost do everything program and should get you a pay rise.

Re: csv script

prainsberry — Fri, 27 Nov 2015 21:37:51 GMT

Now you are talking sounds good to me haha. Unfortunately this is actually what I think is fun to do on my holiday 🙂

Check this out. I am still seeing some problems when you try to un-suppress many features at once but the parameters parts is working pretty good if you want to take a look at it.

https://github.com/tapnair/configSaver

Will still probably work on it a bit more before making a video or anything.

Let me know what you think.

Re: csv script

daniel_lyall — Sat, 28 Nov 2015 00:12:31 GMT

@prainsberry it took a bit to work out how to use it, I think I am not useing it correctly what am I supost to do with the xml file

Re: csv script

prainsberry — Sat, 28 Nov 2015 01:10:17 GMT

You should not have to do anything with the xml. Just save a config then you can set the model back to it. I'll make a quick video. Regards, Patrick Rainsberry

Re: csv script

prainsberry — Sat, 28 Nov 2015 14:47:24 GMT

@daniel_lyall hey i think i made it a little easier to use. Download the updated version. Seperated the save configuration from the switch configuration into two commands. Let me know what you think.

Also made a super quick video here:

https://youtu.be/9VTTctoid2E

Re: csv script

daniel_lyall — Sat, 28 Nov 2015 19:44:39 GMT

@prainsberry I was using it wrong got the idea now.

supper dupper job dude. it will save time for making bespoke stuff, now I just need to see if it will work with a nested cabinet what is linked to the original model, if it does you just need to make one Model, one nested copy and just run through each change in cam and post as you are going.

it's going to make changing my custom wheelchair table east as.

thank you @prainsberry I will put you in for a payrise

Re: csv script

daniel_lyall — Sat, 28 Nov 2015 20:36:20 GMT

it's good for finding mistakes as well

Re: csv script

marshaltu — Mon, 30 Nov 2015 03:35:25 GMT

Hello,

I am aware that there is a setting to control if unit (deg) or symbol(o) is shown in parameter dialog, which might impact the results outputed to dump file by Brian's script.

You could find the setting by right-top corner -> "Your account" -> Preferences -> Units and Value Display -> "Display symbols for units" and just uncheck the option for workaround. Though I can export unit as "deg" since I check the option in my machine. I am not clear if any region settings in your machine impact the results. My region is en-US.

About "d43,Draw_depth - 18 mm,mm,38.2,,Model,Draw`s", I found it wasn't an error. Sorry for misleading. It was saying parameter "d43" depended on parameter "Draw_depth". We might need some enhancement to deal with the dependencies among parameters in Brian's script so that the dependent parameters can be exported firstly. For example: "Draw_depth" would be prior to "d43".

It looked "prainsberry" has provided other solution for you. Please let me know if you still need these scripts.

Thanks,

Marshal

Re: csv script

daniel_lyall — Mon, 30 Nov 2015 04:30:13 GMT

@marshaltu yer it's a bit funny that, that paramater failed and other's did not but you may be correct about the order that info get's spat out, could well be the problem.

the deg thing they where from the press pull and they could be at that angle in the sketch but sinces the press pull was not done at a angle it could be stuffing it up, that's over my head.

I have changed the way I set up the parmater's now and none of them have failed at all, the way I use to do it they can have the same problem, some have done the same thing.

it works fine with how I do it now and yes I still will use it, it saves a lot of typeing if you think you can make it better go for it other wise what ever goes.

thank you for all the work you have done.

the stuff @prainsberry has done is really good for doing changes once's the model has been done and the other bits he has added, it's the bees knees. the two together makes life just that bit more easy, for what I do.if he could added it into his script that be even better, it's good haveing all his scripts in the same place. I use them quite often.

anyway thankyou both of you.

Re: csv script

marshaltu — Tue, 01 Dec 2015 03:35:23 GMT

Hello,

I changed a little bit the script to dump out paramaters from design. Now it should be able to handle dependencies among parameters. Please let me know if you see any issues.

Thanks,

Marshal

#Author-Brian Ekins
#Description-Dumps out parameter info to a specified csv file.

import adsk.core, adsk.fusion, traceback

def insertParameter(param, allParams):
    allParams.append(param)
    dependentParams = param.dependentParameters
    for dependentParam in dependentParams:
        if dependentParam in allParams:
            allParams.remove(dependentParam)
            allParams.append(dependentParam)

def run(context):
    ui = None
    try:
        app = adsk.core.Application.get()
        ui  = app.userInterface
        
        # Get the name of the file to write to.
        fileDialog = ui.createFileDialog()
        fileDialog.isMultiSelectEnabled = False
        fileDialog.title = "Specify result filename"
        fileDialog.filter = 'CSV files (*.csv)'
        fileDialog.filterIndex = 0
        dialogResult = fileDialog.showSave()
        if dialogResult == adsk.core.DialogResults.DialogOK:
            filename = fileDialog.filename
        else:
            return

        des = app.activeProduct

        # Get sorted parameter list according to dependencies
        allParams = []
        modelParamCompNames = {}
        for userParam in des.userParameters:
            insertParameter(userParam, allParams)
            
        for comp in des.allComponents:
            for modelParam in comp.modelParameters:
                insertParameter(modelParam, allParams)
                modelParamCompNames[modelParam.name] = comp.name

        result = 'Name,Expression,Units,Value (database units),Comment,Type,Component\n'
        
        # Get the data for all parameters.
        for param in allParams:
            compName = modelParamCompNames.get(param.name)
            if compName != None:
                result += (param.name + ',' + param.expression + ',' + param.unit + 
                           ',' + str(param.value) + ',' + param.comment + ',Model,' + compName + '\n')
            else:
                result += (param.name + ',' + param.expression + ',' + param.unit + ',' + 
                       str(param.value) + ',' + param.comment + ',User\n')

        output = open(filename, 'w')
        output.writelines(result)
        output.close()
        
        ui.messageBox('File written to "' + filename + '"')

    except:
        if ui:
            ui.messageBox('Failed:\n{}'.format(traceback.format_exc()))

Re: csv script

daniel_lyall — Tue, 01 Dec 2015 04:43:28 GMT

thanks @marshaltu that work's better one small problem tryed a file with a scale in it, it failed at the line before it.

this is the line

d64

0.1

Model

12mm finger tenions (2)

there are a few scale's in the sketch, it fail at the one like above.

if it is like this d64_1 it's fine

all other files work, other that if there is a scale like above.