topic Re: CREATE MACRO TO IMPORT STOCK MODEL in PowerMill Forum

CREATE MACRO TO IMPORT STOCK MODEL

diegoverciano85 — Wed, 15 Jul 2020 02:41:20 GMT

Due to the wide variety of projects in various situations, we export stock models for other programmers to import if necessary.

Instead of looking in windows explorer, I would like to create a macro where I would type in the name of the project (first 4 digits of the file) and it would list only the files with these conditions where I would choose the one and import it.

Re: CREATE MACRO TO IMPORT STOCK MODEL

TK.421 — Wed, 15 Jul 2020 13:51:20 GMT

try this:

STRING filePath = "C:/Users/David/Desktop/test"
STRING LIST $stockFiles = list_files('files', $filePath, '.stkmd')
STRING fileName = INPUT "Enter File Name"

//create a new list stockNames
STRING LIST $stockNames = {}
FOREACH file IN stockFiles {
     IF position(file, fileName) > -1 {
          INT $Ok = add_last($stockNames, TOKENS($File, "/")[SIZE(TOKENS($File, "/"))-1])
     }
}

//display desired in pulldown list
INT $C = INPUT CHOICE $stockNames "Select Stock File"

Re: CREATE MACRO TO IMPORT STOCK MODEL

diegoverciano85 — Wed, 15 Jul 2020 14:12:11 GMT

Re: CREATE MACRO TO IMPORT STOCK MODEL

TK.421 — Wed, 15 Jul 2020 14:14:26 GMT

Great! you figured out the error? What was it?

Re: CREATE MACRO TO IMPORT STOCK MODEL

diegoverciano85 — Wed, 15 Jul 2020 14:16:47 GMT

I had edited the wrong way. Then I saw the error and fixed it and then it worked. So I edited the response where it said it was wrong to correct. To import the chosen file as a stock model should I insert a command in the macro?

Re: CREATE MACRO TO IMPORT STOCK MODEL

TK.421 — Wed, 15 Jul 2020 14:39:37 GMT

sorry, yes. put this at the end of your macro:

IMPORT STOCKMODEL ${$stockFiles[$C]}

Re: CREATE MACRO TO IMPORT STOCK MODEL

diegoverciano85 — Wed, 15 Jul 2020 19:09:41 GMT

@TK.421

Now testing the macro at work, I report the following problem. In the list that is created after typing, for example, 1404, I chose the fourth item in this list, but accepting it does not matter this item, but the fourth file in the folder in question (in alphabetical order).

Attached image with the reported error

Re: CREATE MACRO TO IMPORT STOCK MODEL

TK.421 — Wed, 15 Jul 2020 19:14:31 GMT

Yes, I see the error in my logic. Give me a few minutes to fix it

Re: CREATE MACRO TO IMPORT STOCK MODEL

TK.421 — Wed, 15 Jul 2020 19:27:55 GMT

ok, try this. I cleaned it up a little and added some better comments for you.

//---------- initialize variables: ---------// // -the filepath of the stock model folder // // -a list of all the .stkmd files only // // -the file name prefix // // -declare empty variable to hold the path // //------------------------------------------// STRING filePath = "C:/Users/David/Desktop/test" STRING LIST $stockFiles = list_files('files', $filePath, '.stkmd') STRING fileName = INPUT "Enter File Name" STRING stockModelPath = "" // create a new list for only the // names with the input prefix STRING LIST stockNames = {} // loop through the directory and add // those to the list FOREACH file IN stockFiles { // if the name contains the prefix, add // it to the list IF position(file, fileName) > -1 { INT $Ok = add_last(stockNames, TOKENS(file, "/")[SIZE(TOKENS(file, "/"))-1]) } } // display desired in pulldown list INT i = INPUT CHOICE $stockNames "Select Stock File" // create the file path for the // selected stock model $stockModelPath = $filePath + "/" + $stockNames[$i] // import the stock model IMPORT STOCKMODEL $stockModelPath

Re: CREATE MACRO TO IMPORT STOCK MODEL

diegoverciano85 — Wed, 15 Jul 2020 20:00:15 GMT

Now it's perfect. You are awesome. Thank you very much.

Re: CREATE MACRO TO IMPORT STOCK MODEL

TK.421 — Wed, 15 Jul 2020 20:01:58 GMT

great! sorry I messed up earlier, I should've paid more attention when I was testing it.

Re: CREATE MACRO TO IMPORT STOCK MODEL

diegoverciano85 — Wed, 15 Jul 2020 20:43:25 GMT

Don't worry, your willingness to help those who are not easy with macros is the most important.