community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

lecorrea09
7 - Meteor
‎01-12-2023 01:03 PM

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.

 

lecorrea09_0-1673557394554.png

 

 

Any help is greatly appreciated!

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

5 REPLIES 5
Felipe_Ribeir0
16 - Nebula
‎01-12-2023 01:49 PM

Hi @lecorrea09 

 

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

Reply
0 Likes
lecorrea09
7 - Meteor
‎01-12-2023 02:36 PM

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>

 

Reply
0 Likes
lecorrea09
7 - Meteor
‎01-16-2023 07:52 AM

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

Reply
0 Likes
Felipe_Ribeir0
16 - Nebula
‎01-16-2023 08:30 AM

Hi @lecorrea09 

 

Unfortunately, with just this part i got this error:

 

Felipe_Ribeir0_0-1673886491351.png

 

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

Reply
0 Likes
lecorrea09
7 - Meteor
‎01-16-2023 01:12 PM

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.

Reply
0 Likes
Labels