I have a file, which has a bunch of tags in it, because it is a component file. I need to get this information into an Excel spreadsheet, so I can organize the info for planning purposes. I'm looking for a way to convert this file, so I can prevent the need from having to do it manually.
The file looks like this:
I'm looking to get this all into a spreadsheet where the first column tells us the type of variable it is. This is the first part of the opening tag, e.g. text, number, date, multiple choice, computation, dialog. Then we need it's name, prompt, default format, and format, if those are available. If there is a script, that can be an extra column as well.
Anyone know a good way to make this conversion happen more efficiently than by doing it manually? Not only will that take forever, I will have to periodically re-do it all.
Thank you for any help!
The file looks like this:
Code: Select all
<hd:text name="CityTown TE">
<hd:defFormat>Like This</hd:defFormat>
<hd:prompt>Property City or Town</hd:prompt>
</hd:text>
<hd:number name="Zip NU" maximum="99999">
<hd:defFormat>99999</hd:defFormat>
<hd:prompt>Zip Code</hd:prompt>
</hd:number>
<hd:date name="MonthYear DocPrepared DT">
<hd:defFormat>June, 1990</hd:defFormat>
<hd:prompt>Date Document was Prepared:</hd:prompt>
<hd:fieldWidth widthType="calculated"/>
</hd:date>
<hd:trueFalse name="StateForm TF">
<hd:defFormat>true/false</hd:defFormat>
<hd:prompt>State Form (Add more text)</hd:prompt>
</hd:trueFalse>
<hd:multipleChoice name="County MC">
<hd:defFormat>Like This</hd:defFormat>
<hd:prompt>County</hd:prompt>
<hd:options defMergeText="Albany/Allegany/Bronx/Broome/Cattaraugus/Cayuga/Ch">
<hd:option name="Albany"/>
<hd:option name="Allegany"/>
<hd:option name="Bronx"/>
<hd:option name="Broome"/>
<hd:option name="Cattaraugus"/>
</hd:options>
<hd:singleSelection style="dropDownList"/>
</hd:multipleChoice>
<hd:computation name="OrgID CT" resultType="text">
<hd:script>IF HaveOrgIDNONE TF = TRUE
OrgID TE
ELSE
""
END IF
</hd:script>
</hd:computation>
<hd:dialog name="Title ABC" linkVariables="false">
<hd:contents>
<hd:item name="Field1"/>
<hd:item name="Field2" onPreviousLine="true"/>
<hd:item name="Field3" onPreviousLine="true"/>
<hd:item name="Field4"/>
<hd:item name="Field5" onPreviousLine="true"/>
<hd:item name="Field6"/>
<hd:item name="Field7" onPreviousLine="true"/>
<hd:item name="Field8" onPreviousLine="true"/>
</hd:contents>
<hd:script>HIDE Field1
HIDE Field2
IF Field3 ="xyz"
SHOW Field1
SHOW Field2
ELSE
HIDE Field1
HIDE Field2
END IF</hd:script>
</hd:dialog>
Anyone know a good way to make this conversion happen more efficiently than by doing it manually? Not only will that take forever, I will have to periodically re-do it all.
Thank you for any help!