Exporting to Merlin CSV

Overview

In order to make a firing script, you need to configure your launch positions with specifications of your firing system. For instructions, please see the Export Overview section. Once you are ready to export your firing script, click the "File > Export firing script > Merlin CSV" menu item.

Understanding the Merlin CSV Format

In the Merlin CSV format, each row corresponds to a group of similar pieces on one shot, or electrical impulse on a pin. A "piece," as described in the "Glossary" section, is an inventory item that has been inserted into the show. Dissimilar groups of pieces on the same shot are split over multiple rows still having the same firing system unit address and pin address, and same shot time. Thus, it may take multiple rows to represent a single shot. The rows are sorted in shot order (as opposed to break order).

"Similar pieces" means pieces that are fired on the same shot, have the same match time, same launch position, same inventory item number, same name, category, prefire, caliber, and if they are part of a chain the same chain type. Similar pieces do not have to have the same mortar angle, however. Pieces shot in a "W" or "V", for example, will appear on the same row, and their angles will appear in a list in the angle field of that row, along with an ASCII art representation of what the angle looks like, such as "\\|//".

The Fields in Each Row

The set of fields in the Merlin CSV row in order are: Shot Number, Shot Time, Break Time, Number Of Devices, Devices Per Piece, Number Of Pieces, ProductID, VendorID, Item Name, Caliber, Angles, Position Name, Module Type, Module Address, Slat Address, Pin Number, Notes. These terms are defined as described in Export to Finale CSV. The Pin Number field is called Pin Address in the Finale Generic CSV format.