nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Custom Formulas in RuntimeData\FormulaAddIn not loading after updating to version 2024.2

Kaloust

Hello,

I updated my desktop designer to version 2024.2.1.14 and my custom formulas are not showing in the tools anymore. I am not getting any error message that could indicate the source of the problem. I checked the custom formulas xml file and it is installed in the correct location. The only thing I noticed is that the category name I have been using so far is not showing up among the function categories in tools like Multi-Row. I also tried changing the category name in the xml file to match one of the existing ones in the default functions list but it did not help.

I've been using these formulas since 2016 and I never had a problem when updating to new versions.

Please advise.

Thank you.

Developer

Accepted answers

patrick_digan

@ChrisK good question, I restarted Designer. I even reduced the noise by just using the sample.xml which contains the formula SampleFormulaAddInFormula. Even with only 1 xml with 1 function, it still was giving a bogus error in the formula tool.

Thankfully the function still works as expected with no errors when run. I would have assumed it's just something about my setup, but it seems like @Kaloust and @flying008 were having the same experience as me.

All comments

OTrieger

@Kaloust

This is the documentation on it.

https://help.alteryx.com/current/en/developer-help/platform-sdk/legacy-sdks/build-custom-formula-functions.html#idm45729592892608

It says: "To make the functions available in Alteryx Designer, go to the RuntimeData folder in your Alteryx Designer installation. Check for a folder titled \FormulaAddIn. If the folder does not exist, create it."

I only can guess that this folder was deleted when you install the new version.

I assume that if you did not created a backup or copy of it that you will need to recreate it.

Kaloust

Hi @OTrieger

Thank you for your response and sharing the documentation.

The folder is not deleted and the xml file is installed where it should be. I tried creating a new XML file for the sample function mentioned in the documentation and even that is not working on this new version. It is working on the previous version (2024.1).

Any thoughts?

flying008

Hi, @Kaloust

Do you open the AMP or shift the Encode your XML file or already changed your install path? maybe you can try turn on or off this option?

Kaloust

Hi @flying008

I usually keep the AMP off for new workflows, but I tried enabling it to see if it will have an impact and it did not. I even tried enabling it from the user settings and restarted alteryx with the same result.

Can you please elaborate on what you mean when you say "Encode your XML file or already changed your install path"?

Thank you.

flying008

Hi, @Kaloust

1- Check your encode of xml file like utf-8 or other?

2- before you updated to v2024.2, Admin or NoAdmin version changed?

3- you can rebuild a custom function in *\FormulaAddIn to test again.

Kaloust

Hi @flying008 ,

Thank you for your response.

1-The encoding is UTF-8.

2-I've been using Non-Admin version and it did not change.

3-Already tried that using the sample xml code in the documentation and it is not loading in version 2024.2.

flying008

Hi, @Kaloust

Jesus! I'm just try to modify the sample.xml then run the v2024.2, nothing can loaded in the formula like you!

patrick_digan

@Kaloust and @flying008 I just wanted to confirm that I had the same experience where I can't get custom functions to load in 24.2. Did either of you submit a support ticket? Tagging @NicoleJ in case she has any insights.

Kaloust

Hi @patrick_digan

I tried sending an email to Mission Control but looks like this email address is not valid anymore.

patrick_digan

@Kaloust I'll log a ticket with support and let you know what I hear!

ChrisK

I have found a bad bug in error handling. 24.2 detects a problem that was previously undetected, that there is more than one function "S" and "N" declared. (in this case Digan.xml and MiscUtils.xml both define <Name>S</Name> There is a bug in handling the error, and it's hard to tell just what the program will do. This is a problem, but it is not the only problem here.

patrick_digan

@ChrisK Thanks! I can't believe I had duplicate functions I've deleted the duplicates and I'm one step closer. Now the functions work when I run a workflow, but the expression editor still doesn't realize that any of the custom functions exist and throws an error. Again, everything appears to run ok, so it's not as big as an issue. In my picture you can see the error in the expression editor, but my results window is correct.

ChrisK

I am puzzled. I see your case working. Could it be you edited the .xml files but did not restart Designer? The Designer reads the files only once on startup, and won't notice changes.

patrick_digan

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703