<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Hi Dan, Try this….<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I think *** (and that is a dangerous thing) that this will work.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">You should be able to import the ASCII txt file into Excel, and then reposition the columns, and then copy and paste back into a txt file.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Here’s how…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Save your ascii file as a text document (for lack of a better file name I’ll say “ascii.xtx”)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Open Excel,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">[File], [open], under file type, choose text file, select ascii.txt.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">It will open an “Import Wizard”.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">On the various tabs of the wizard, you can select how it determines what info goes into which columns. There is a preview pane, so you can see how it will be
displayed as you select different options… it’s pretty easy to figure out.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Once it looks like you want, click OK, and you’ve got it in Excel. Then simply move your columns into whatever order you desire.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Then… [Save as] file type “Unicode Text”. This should leave everything in the right order, but in a txt file to reimport into ascii.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">-HTH,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Ford Sellers<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Senior Product Development Manager<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Chauvet Professional Lighting & Iluminarc<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">5200 NW 108th ave<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Sunrise, FL 33351<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Phone: 800-762-1084<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Fax: 800-544-4898<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Stagecraft [mailto:stagecraft-bounces@theatrical.net]
<b>On Behalf Of </b>Dan Sheehan via Stagecraft<br>
<b>Sent:</b> Wednesday, August 05, 2015 1:15 PM<br>
<b>To:</b> Stagecraft Mailing List<br>
<b>Cc:</b> Dan Sheehan<br>
<b>Subject:</b> Re: [SML] ASCII file reader<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Thanks all for suggestions.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Probably would not have worked anyway.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Here's the situation and interesting, but not useful, results<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> (somewhat lengthy description):<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">One of several community theatre groups I assist recently<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">started using a venue which has a 72-dimmer Unison system<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">controlled by a NSI [Leviton] 7532, which can run as 64 channels wide.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">(Dimmer sys orig install was 48 wide, later added 3rd Unison box & 2nd FOH pipe]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">By patching many houselight dimmers into a few channels the <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">64-wide 7532 can handle the 72 dimmers OK.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The group had an ETC Smartfade 2496 gathering dust. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thought that would be a better tool than the NSI 7532,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">mainly because it could be used with SmartSoft in a laptop<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">for runtime display of levels etc, <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">control via computer instead of console buttons,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">hence less reliance on wheel for tasks like patching (ugh!),<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">file save and load capability, offline emulation, etc.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">and everything you can do with an offline SW pkg.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">ETC Tec Support got me through getting SmartSoft SW and Smartfade HW<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">to talk to each other. Never would have got there without that help.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Maybe it's just an olde pharte syndrome, but I find the<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">hover-the-mouse-and- *wait*, to see one patch connection at a time,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">and the drag-and-drop to create patch links, klutzy.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I like the way it works (and displays) on the Express.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">And I like... in fact, insist on... a patch list ( p/o magic sheet) on paper<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">during the run of the tech & show.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Surprised that the offine SW does not provide printable reports.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Since "ETC" (!) SmartSoft, and ETC Express EOL, both import<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">and export USITT ASCII, I thought maybe....<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">since one strong purpose of USITT ASCII is to enable <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">data sharing between different consoles...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">but not quite.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">EOL refuses to read ASC file written by SmartSoft,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">because manufacturer (and console) do not match.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">(USITT ASCII includes both).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Tricked around that by replacing the Express patch info<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">in the EOL file with the patch info from the SmartSoft file.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Resulting imported patch was wrong.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">EOL patch info is Ch:Dim; SmartSoft patch info is Dim:Ch.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">They can't both be right , can they ? :)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">EOS OLE says it reads the SmartSoft .ASC file successfully<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">(I think... read status flashes by pretty quickly),<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">but the resulting patch is blank.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Importing patch from Express EOL .ASC into EOS OLE works correctly.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">===<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Have not been successful trying to find the USITT ASCII spec on USITT website.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Any suggestions ?<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">...Dan Sheehan<br>
Fixer of things that break<o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>