Missing LOG(x) function ?

[alexjohnlittle]

I'm pretty sure I've missed something here, but I seem to have 'lost' the LOG(x) function from the formula tool (and all other tools too), see below:

and here is a shot of a colleagues function list,

We're both on 2019.3. Any ideas appreciated.

[patrick_digan · Accepted solution]

@alexjohnlittle I'm assuming you have @jdunkerley79 's formula add ins as he accidentally overwrote the log function. You'll want to change the miscutils.xml file found here for non-admin install:

%localappdata%\Alteryx\bin\RuntimeData\FormulaAddIn

or here for admin install:

%Programfiles%\Alteryx\bin\RuntimeData\FormulaAddIn.

You should have a function named log in that xml file. Change the name and insterttext lines to logtofile:

  <Function>
    <Name>LOGTOFILE</Name>
    <NumParams variable="false">3</NumParams>
    <Category>Specialized</Category>
    <InsertText>LOGTOFILE(ReturnValue, FileName, Message)</InsertText>
    <Description>Write a message to a log file</Description>
    <Dll>
      <Name>AlteryxAbacus.dll</Name>
      <EntryPoint>Log</EntryPoint>
    </Dll>
  </Function>

He also fixed it in this version on github if you want to reinstall/update from there.

[alexjohnlittle]

Brilliant. Thank you Patrick.

Thought I'd eliminated jdunkerley's formula add ons since another colleague who also has the add ons had the LOG(x) function! I must have been using an older version.

Uninstall and re-install of the new pack worked.

Many thanks,

John.