Error opening macro: Unable to convert AlteryxBasePluginsGui.MacroInput to Macro Input

Hi,

I'm working on a workflow that the person before me for some reason saved as a macro, and today after making some adjustments and saving it, I cannot reopen it. The following error message shows up:

Unable to convert AlteryxBasePluginsGui.MacroInput.MacroInput to Macro Input.

Any help is greatly appreciated!

Error Message

Macros

Accepted answers

lecorrea09

I managed to solve the issue, although I would it say it wasn't the most clean solution. Opened the xml and deleted all Macro Input and Macro Output nodes and also deleted all references made to those nodes. This allowed me to open the workflow but I needed to recreate those inputs and their connections, so it's useful to keep the node information from the xml to look at the file it references and the Connections of those nodes to replicate them.

All comments

Felipe_Ribeir0

Hi @lecorrea09

Can you share the workflow? Maybe changing some things inside of the xml could solve the issue.

lecorrea09

Not sure if I should share and it's a complex workflow, but I can share the snippets of the xml where "AlteryxBasePluginsGui.MacroInput.MacroInput" appears. It appears 4 times and I'm not sure where the error is, so I'm attaching the section of the xml code for the 4 macro inputs.

Please let me know if you need any other part of the xml shared to solve the problem.

Thanks in advance!

-Luis

<Node ToolID="433">
          <GuiSettings Plugin="AlteryxBasePluginsGui.MacroInput.MacroInput">
            <Position x="1242" y="209" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <UseFileInput value="True" />
              <Name>V</Name>
              <Abbrev>V</Abbrev>
              <ShowFieldMap value="False" />
              <Optional value="False" />
              <FileInput>
                <Configuration>
                  <Passwords />
                  <File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">\\10.21.2.31\Planning\Temp\PI-NS-FPS_BC_STEP5-010.yxdb</File>
                  <FormatSpecificOptions />
                </Configuration>
              </FileInput>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>STEP 5
VALIDATION</AnnotationText>
              <DefaultAnnotationText>PI-NS-FPS_BC_STEP5-010.yxdb</DefaultAnnotationText>
              <Left value="True" />
            </Annotation>
            <MetaInfo connection="Output">
              <RecordInfo>
                <Field name="MONTH" source="Summarize: GroupBy - MONTH (BatchMacro) (BatchMacro) (BatchMacro)" type="Date" />
                <Field name="CG" source="Summarize: Sum - CG (BatchMacro) (BatchMacro) (BatchMacro)" type="Double" />
                <Field name="IC" source="Summarize: Sum - IC (BatchMacro) (BatchMacro) (BatchMacro)" type="Double" />
                <Field name="GD" source="Summarize: Sum - GD (BatchMacro) (BatchMacro) (BatchMacro)" type="Double" />
                <Field name="CC" source="Summarize: Sum - CC (BatchMacro) (BatchMacro) (BatchMacro)" type="Double" />
                <Field name="LD" source="Summarize: Sum - LD (BatchMacro) (BatchMacro) (BatchMacro)" type="Double" />
                <Field name="PK" source="Summarize: Sum - PK (BatchMacro) (BatchMacro) (BatchMacro)" type="Double" />
                <Field name="ST" source="Summarize: Sum - ST (BatchMacro) (BatchMacro) (BatchMacro)" type="Double" />
                <Field name="BGC" source="Summarize: Sum - BGC (BatchMacro) (BatchMacro) (BatchMacro)" type="Double" />
                <Field name="BGY" source="Summarize: Sum - BGY (BatchMacro) (BatchMacro) (BatchMacro)" type="Double" />
              </RecordInfo>
            </MetaInfo>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxMacroInput" />
        </Node>


<Node ToolID="434">
          <GuiSettings Plugin="AlteryxBasePluginsGui.MacroInput.MacroInput">
            <Position x="282" y="438" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <UseFileInput value="True" />
              <Name>D</Name>
              <Abbrev>D</Abbrev>
              <ShowFieldMap value="False" />
              <Optional value="False" />
              <FileInput>
                <Configuration>
                  <Passwords />
                  <File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">\\10.21.2.31\Planning\Temp\PI-NS-FPS_STEP4_DRIVERS-010.yxdb</File>
                  <FormatSpecificOptions />
                </Configuration>
              </FileInput>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>DRIVERS</AnnotationText>
              <DefaultAnnotationText>PI-NS-FPS_STEP4_DRIVERS-010.yxdb</DefaultAnnotationText>
              <Left value="True" />
            </Annotation>
            <MetaInfo connection="Output">
              <RecordInfo>
                <Field name="MONTH" source="Summarize: GroupBy - MONTH (BatchMacro) (BatchMacro) (BatchMacro)" type="Date" />
                <Field name="FOD" size="25" source="Formula: [_CurrentField_]" type="V_WString" />
                <Field name="Mf" size="100" source="Formula: [_CurrentField_]" type="V_String" />
                <Field name="FT" size="100" source="Formula: [_CurrentField_]" type="V_String" />
                <Field name="ABT" scale="6" size="24" source="Formula: IIF(IsNull([_CurrentField_]),0,[_CurrentField_]) (BatchMacro)" type="FixedDecimal" />
                <Field name="FL" source="Formula: IIF(IsNull([_CurrentField_]),0,[_CurrentField_]) (BatchMacro)" type="Double" />
                <Field name="OBP" source="Formula: IIF(IsNull([_CurrentField_]),0,[_CurrentField_]) (BatchMacro)" type="Double" />
                <Field name="RPMC" source="Formula: IIF(IsNull([_CurrentField_]),0,[_CurrentField_]) (BatchMacro)" type="Double" />
                <Field name="RPMY" source="Formula: IIF(IsNull([_CurrentField_]),0,[_CurrentField_]) (BatchMacro)" type="Double" />
                <Field name="RPMT" source="Formula: IIF(IsNull([_CurrentField_]),0,[_CurrentField_]) (BatchMacro)" type="Double" />
                <Field name="TCP" source="Formula: IIF(IsNull([_CurrentField_]),0,[_CurrentField_]) (BatchMacro)" type="Double" />
                <Field name="TCRPM" source="Formula: IIF(IsNull([_CurrentField_]),0,[_CurrentField_]) (BatchMacro)" type="Double" />
                <Field name="DEP" source="Formula: IIF(IsNull([_CurrentField_]),0,[_CurrentField_]) (BatchMacro)" type="Int64" />
                <Field name="AS" source="Formula: IIF(IsNull([_CurrentField_]),0,[_CurrentField_]) (BatchMacro)" type="Double" />
              </RecordInfo>
            </MetaInfo>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxMacroInput" />
        </Node>


<Node ToolID="435">
          <GuiSettings Plugin="AlteryxBasePluginsGui.MacroInput.MacroInput">
            <Position x="606" y="402" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <UseFileInput value="True" />
              <Name>E</Name>
              <Abbrev>E</Abbrev>
              <ShowFieldMap value="False" />
              <Optional value="False" />
              <FileInput>
                <Configuration>
                  <Passwords />
                  <File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">\\10.21.2.31\Planning\Temp\PI-NS-FPS_STEP4_EXPENSES-010.yxdb</File>
                  <FormatSpecificOptions />
                </Configuration>
              </FileInput>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>EXPENSES</AnnotationText>
              <DefaultAnnotationText>PI-NS-FPS_STEP4_EXPENSES-010.yxdb</DefaultAnnotationText>
              <Left value="True" />
            </Annotation>
            <MetaInfo connection="Output">
              <RecordInfo>
                <Field name="MONTH" source="CrossTab:Group:Sum:" type="Date" />
                <Field name="FOD" size="25" source="CrossTab:Group:Sum:" type="V_WString" />
                <Field name="FT" size="100" source="CrossTab:Group:Sum:" type="V_String" />
                <Field name="MF" size="100" source="CrossTab:Group:Sum:" type="V_String" />
                <Field name="ADF" source="CrossTab:Header:FPS_CAT:ADF:Sum:" type="Double" />
                <Field name="ATOV" source="CrossTab:Header:FPS_CAT:ATOV:Sum:" type="Double" />
                <Field name="MAV" source="CrossTab:Header:FPS_CAT:MAV:Sum:" type="Double" />
                <Field name="PSV" source="CrossTab:Header:FPS_CAT:PSV:Sum:" type="Double" />
                <Field name="ATOF" source="CrossTab:Header:FPS_CAT:ATOF:Sum:" type="Double" />
                <Field name="CGF" source="CrossTab:Header:FPS_CAT:CGF:Sum:" type="Double" />
                <Field name="CGV" source="CrossTab:Header:FPS_CAT:CGV:Sum:" type="Double" />
                <Field name="PSF" source="CrossTab:Header:FPS_CAT:PSF:Sum:" type="Double" />
                <Field name="CRF" source="CrossTab:Header:FPS_CAT:CRF:Sum:" type="Double" />
                <Field name="CRV" source="CrossTab:Header:FPS_CAT:CRV:Sum:" type="Double" />
                <Field name="MAF" source="CrossTab:Header:FPS_CAT:MAF:Sum:" type="Double" />
                <Field name="SDF" source="CrossTab:Header:FPS_CAT:SDF:Sum:" type="Double" />
                <Field name="SDV" source="CrossTab:Header:FPS_CAT:SDV:Sum:" type="Double" />
                <Field name="MCV" source="CrossTab:Header:FPS_CAT:MCV:Sum:" type="Double" />
                <Field name="MYV" source="CrossTab:Header:FPS_CAT:MYV:Sum:" type="Double" />
                <Field name="CRWF" source="CrossTab:Header:FPS_CAT:CRWF:Sum:" type="Double" />
              </RecordInfo>
            </MetaInfo>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxMacroInput" />
        </Node>


<Node ToolID="431">
          <GuiSettings Plugin="AlteryxBasePluginsGui.MacroInput.MacroInput">
            <Position x="870" y="222" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <UseFileInput value="True" />
              <Name>STEP2</Name>
              <Abbrev>2</Abbrev>
              <ShowFieldMap value="False" />
              <Optional value="False" />
              <FileInput>
                <Configuration>
                  <Passwords />
                  <File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">\\10.21.2.31\Planning\Temp\PI-NS-FPS_STEP2-010.yxdb</File>
                  <FormatSpecificOptions />
                </Configuration>
              </FileInput>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>PI-NS-FPS_STEP2-010.yxdb</DefaultAnnotationText>
              <Left value="True" />
            </Annotation>
            <MetaInfo connection="Output">
              <RecordInfo>
                <Field name="DT" source="(Multiple Sources) (BatchMacro) (BatchMacro)" type="Date" />
                <Field name="MONTH" source="Summarize: GroupBy - MONTH (BatchMacro) (BatchMacro)" type="Date" />
                <Field name="DOW" size="15" source="Formula: [_CurrentField_]" type="V_WString" />
                <Field name="FOD" size="25" source="Formula: [_CurrentField_]" type="V_WString" />
              </RecordInfo>
            </MetaInfo>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxMacroInput" />
        </Node>

lecorrea09

Hi @Felipe_Ribeir0 ,

Sorry to bother. Do you have any insights by any chance based on the xml I shared?

I would greatly appreciate any help.

-Luis

Felipe_Ribeir0

Hi @lecorrea09

Unfortunately, with just this part i got this error:

I believe that this is happening because of the lack of Properties/Metainfo inside of the shared XML

lecorrea09

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703