Mattias Sander, Senior Technical Writer at SimCorp, brings us our latest Guest Post. An engineer by training and a technical writer by trade, Mattias  creates user documentation for one of the world’s most advanced investment management systems. We came across this post on his blog, The TechWriting Engineer, and re-published it here for you to check out:

Generating MadCap Flare Snippet Files Using Excel

If you have a list of phrases (e.g. a list of STE terms) you would like to quickly add to Flare as snippet files to make good use of Flare’s clever “auto suggest based on snippet” feature, keep reading.

The idea is to copy or write the phrases into a spread sheet, add a column for the file name, and another column for the MadCap Flare snippet XML code, then write a short VBA script that creates a new snippet file for each phrase in the spread sheet, and saves the files on your desktop. Take a look at the screen capture:

2013-08-26_0915

The formula for the file name is =LEFT(SUBSTITUTE(B2;” “;”_”);30)&”.flsnp”It first replaces all spaces with “_”, and just keeps the 30 first characters of the phrase, ending with the “flsnp” file extension.

The Excel formula for the MadCap Flare XML code is

=”<!–?xml version=”&CHAR(34)&”1.0″&CHAR(34)&” encoding=”&CHAR(34)&”utf-8″&CHAR(34)&”?>xmlns:MadCap=”&CHAR(34)&”https://www.madcapsoftware.com/Schemas/MadCap.xsd”&CHAR(34)&&#8221; MadCap:lastBlockDepth=”&CHAR(34)&”2″&CHAR(34)&” MadCap:lastHeight=”&CHAR(34)&”43″&CHAR(34)&” MadCap:lastWidth=”&CHAR(34)&”878″&CHAR(34)&”>

<head>
</head>
<body>
<p>“&B2&”</p>
</body>
</html>”

To read the rest of the post, visit The TechWriting Engineer.

About The Author

Jennifer White

About Jennifer White

Jennifer White, a Product Evangelist at MadCap Software, has over 15 years of experience in writing, broadcasting, public speaking, marketing and social media management. Jennifer has also served as a social media manager, blogger, on-air host, writer and content provider for CBS Radio and Fox TV.

Last Modified: October 16, 2014

This entry was posted in Guest Post, MadCap Flare, Tips & Tricks and tagged . Bookmark the permalink.

Comments

  • Excel March 27, 2015 at 12:34 PM

    very cool stuff!

Have Something to Say?

Your email address will not be published. Required fields are marked *