|
DynamicMSS 1.0 Purchase it Description NEW: DynamicMSS 1.0 is now available as a web service. NEW: If you would like to use DynamicMSS 1.0 to generate documents that include multiple tables, or to query your database from within the tag, ask for our customization option. Send us an email to support@gilgamesh-solutions.com with the features you would like to see added to DynamicMSS 1.0, and we will build the tag that is right for you. Using DynamicMSS 1.0, you can generate Text/HTML documents, or Microsoft Word/Excel/PowerPoint reports to represent your data from a database. All you have to do is send a file name that will hold your generated data. The tag will understand what type of file you want to generate based on the extension (.doc or .xls for example). You can send an optional query name to this tag with formatting options on how you want your data to be laid out, and you will see your generated file in the format you asked for. You can also now include optional introductory and ending paragraphs formatted using HTML. Once your file is generated, you can FTP it, re-save it, email it, or display it on the browser for your user to download. The new powers of DynamicMSS 1.0 give you the following capabilities:
This great flexibility and control from your ColdFusion application add a new power to your generated framework. Example Usage Purchase it <cf_DynamicMSS Query="get" Headers="ip: IP Address, referrer:Referring Page, current_page:Current Page, entrydate: Date Created" DDateFormat="mm/dd/yyyy" DataBgColor="lightblue, white" Beginning ="<center><h3>Gilgamesh Solutions, Inc.</h3></center> <table width='100%'> <tr><td align='left'> <a href='http://gilgamesh-solutions.com/'> <img src='http://gilgamesh-solutions.com/lion.png' width='100' height='75' border='0'> </a> </td><td align='right'> <a href='http://gilgamesh-solutions.com/'> <img src='http://gilgamesh-solutions.com/lion.png' width='100' height='75' border='0'> </a> </td></tr></table>" File= "myDocument.doc" FilePath="C:\Dummy" FileAction="Write" FileOverwrite="overwrite" Ending=" <strong><center>Gilgamesh Solutions Inc. All Rights Reserved 2001-2004</center> </strong>"> The example above will generate a Word document with an introductory paragraph centered H3 format in the top of the page with the text "Gilgamesh Solutions, Inc." Then, a table will follow with two images, one left justified, and the other right justified. Both images will be clickable to point to http://gilgamesh-solutions.com. After that, another table will follow with the following column headers: IP Address, Referring Page, Current Page, Date Created. The first part of each column header will be the actual column header from the database table, while the other part after the ":" will represent the alias to be printed out to the document. Anytime Date field printed out to the document will be formatted using the mask "mm/dd/yyyy" as in DateFormat function. "Query" will be the query carrying all the data after pulling it from the database. An ending paragraph with the text "Gilgamesh Solutions Inc. All Rights Reserved 2001-2004" will be bolded and centered following the table in the generated document. The data will be presented in an alternating lightblue and white rows. Your generated document will be saved to your server at the directory C:\Dummy, under the name myDocument.doc. If there is already a document under the same name in the same directory, you are requesting that the tag should overwrite it. You can view the document here. Optional Features Purchase it Upon request, the following features could be added to DynamicMSS 1.0: 1. Multiple tables. 2. Multiple Paragraphs (in between tables). 3. Database querying (instead of sending query directly) with filtering options (using WHERE keyword in SQL)! 4. Others. Just send us an email to support@gilgamesh-solutions.com, and tell us what your requirements are. Syntax Usage Purchase it <cf_DynamicMS Query="your query here" Headers="column name list" Beginning="an optional beginning paragraph or multiple paragraphs formatted using HTML to be displayed before the table" Ending="an optional ending paragraph or multiple paragraphs formatted using HTML to be displayed after the table" File= "File Name including the extension" FilePath="File path of your generated file" FileAction="Write/Append data to the file specified" FileOverwrite="error/makeunique/overwrite/skip actions when there is a name conflict" DDateFormat="works as DateFormat. Send the date mask to format your Date outputs" ColumnWidth="width of all columns" HeaderBold="y|n" HeaderItalic="y|n" HeaderUnderline="y|n" HeaderColor="any valid HTML color by name or hexidecimal (no leading #)" HeaderBgColor="any valid HTML color by name or hexidecimal (no leading #)" HeaderFontFamily="Any HTML valid font family (Arial, etc.)" HeaderSize="header size (not font size, this is equivalent to <font size='+[num]'>" HeaderAlign="left|center|right" HeaderVAlign="top|center|bottom" DataBold="y|n" DataItalic="y|n" DataUnderline="y|n" DataColor="any valid HTML color by name or hexidecimal (no leading #)" DataBgColor="any valid HTML color by name or hexidecimal (no leading #). You can apply alternating colors" DataFontFamily="Any HTML valid font family (Arial, etc.)" DataSize="data size (not font size, this is equivalent to <font size='+[num]'>" DataAlign="left|center|right" DataVAlign="top|center|bottom" Border="[number] thickness of the border around the data" BorderColor="border color" CellPadding="equivalent to <table cellpadding=' '>" CellSpacing="equivalent to <table cellspacing=' '>" > |