http://www.digital-clay.com/support/wiki/ 2012-05-19T04:37:22-04:00 http://www.digital-clay.com/support/wiki/ http://www.digital-clay.com/support/wiki/lib/tpl/default/images/favicon.ico text/html 2012-04-23T07:48:38-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/speeding_things_up?rev=1335181718&do=diff ClayCentral Methods * Limit the maximum results in lists/analysis as well as in drop-downs. See Limiting Results for details. * Do not add unnecessary Linked Fields. These add joins that may slow down queries, especially in the case of MDB databases. Use Lookup Lists or Text fields instead of Linked Fields whenever possible. text/html 2012-04-16T10:29:00-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/web_claystation?rev=1334586540&do=diff Overview Web ClayStation is a Web application, a Web version of the ClayStation client which provides the most important features of a Clay client through a standard Web-browser. It consists of: * Any standard Web-server that supports FastCGI with an installed FastCGI module. * A Clay FastCGI module that runs either on the same machine as the Web-server or on a remote machine accessible by the Web-server. The FastCGI module connects to ClayCentral. * The various files needed by both the … text/html 2012-03-29T07:24:33-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/sharing_embedding_objects_as_web_pages?rev=1333020273&do=diff Digital-Clay objects such as dashboards, lists, graphs, charts, analysis tables, document templates and other saved documents may be shared with other users via a URL if Web ClayStation is installed. To get a URL for these objects, either use the 'Save/Share...' button when the object or query is open, and check the 'Get Web URL' option, or, you can get URLs for existing shared objects via the Document Repository. text/html 2012-03-27T06:47:30-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/external_gui?rev=1332845250&do=diff This article covers the various ways in which a custom GUI (which was programmed externally) may be used with Digital-Clay. This includes public web pages as well as custom programming. Obviously, Digital-Clay allows customizing its own various GUI components in many ways with a point-and-click interface. This includes the toolbars, form layouts, dashboards, etc. and new customization options and components are being added all the time. The methods listed here are only needed when the built-in … text/html 2012-02-09T09:27:29-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/analysis?rev=1328797649&do=diff This article is not a how-to guide or a tutorial on how to build analysis graphs and pivot tables, but a conceptual overview on the various tools and settings that are available. It is recommended that you get a basic acquaintance of the analysis tools first and then use this as a reference to learn about more advanced capabilities. Also see the Visualization Gallery for a visual demonstration of the capabilities. text/html 2012-01-24T08:29:03-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/custom_links?rev=1327411743&do=diff What Are Links? A Link is used to join two tables together so that fields in one table may be filtered or sliced by fields in a second table, or so that values may be displayed from more than one table at the same time. For example, to query on Opportunities filtered by the Customer's Country necessitates a Link between Customer and Opportunity. text/html 2012-01-24T07:49:23-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/links_to_multiple_records?rev=1327409363&do=diff Definitions * When a linked field is defined, for example, in the Contact table that links to a Customer, this is a one-to-many link. I.e. one Customer can be linked to many Contacts. In Digital-Clay terms, this link has Contact as its base table and is a link “to another table”. * This same link from the viewpoint of the Customer is a many-to-one link. I.e. many Contacts can be linked to one Customer. In Digital-Clay, this means that a link is defined with Customer as the base table and … text/html 2012-01-18T15:23:06-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/visualization_gallery?rev=1326918186&do=diff This page showcases a variety of examples for visualizing data using Digital-Clay components. Note that any of these components may also be combined together in Dashboards and Document Templates, and fully customized visualizations may also be built using HTML code and web components within Document Templates, HTML Tabs and custom web pages. text/html 2012-01-18T15:22:09-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/?image=advanced_topics_and_tips%3Abi27.png&ns=advanced_topics_and_tips&rev=1326918129&tab_details=history&mediado=diff&do=media <img src="/support/wiki/lib/exe/fetch.php/advanced_topics_and_tips/bi27.png?w=500&h=145t=1326918129" alt="advanced_topics_and_tips:bi27.png" /> text/html 2011-12-15T13:56:13-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/bulk_actions?rev=1323975373&do=diff Bulk Actions, in a nutshell, provide the functionality of Automation 'Set Field', 'Create' and 'Delete' actions for massive amounts of records as quickly as possible. See Automation for more details on these actions. In other words, Bulk Actions allow administrators to change, add or delete large amounts of records in the shortest time possible. When dealing with hundreds of thousands of records, the time Bulk Actions take can be in seconds rather than hours. text/html 2011-11-25T04:00:05-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/basic_training/start?rev=1322211605&do=diff An introduction to Digital-Clay containing an overview of basic Digital-Clay features and a series of training videos. Other training options include: * A knowledge base of Advanced Topics for Digital-Clay developers and administrators. text/html 2011-08-25T14:42:18-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/document_templates?rev=1314297738&do=diff This article is a technical overview on the purpose and capabilities of Digital-Clay Document Templates. It is not a tutorial on how to build Templates. Introduction Document Templates are templates that are used in Digital-Clay to generate documents. The Template may contain static content, as well as instructions for generating dynamic Digital-Clay content which is only filled when the document is generated. In other words, the procedure is: text/html 2011-08-04T19:36:42-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/external_functions?rev=1312501002&do=diff Purpose External Functions are used for integrating with other systems, data sources and custom code. For example: * Notify other systems of data changes in Digital-Clay. This includes calling external triggers, or sending e-mails and SMS messages via the web. * Lookup and retrieve values from an external database or web site. This includes values inside XML and unstructured HTML pages. * Calculate values using custom code. Program your own logic and algorithms, and return a value for st… text/html 2011-07-03T12:45:31-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/advanced_topics_and_tips/database_management?rev=1309711531&do=diff A quick reference for common database tasks like compacting, repairing and creating a backup for databases and setting up SQL Server. Notes on Compacting: Both MDB and SQL Server databases can automatically grow much more than needed due to fragmented data. For this reason it is recommended to regularly compact the databases. Compacting obviously can also make backups and copies much smaller. text/html 2011-06-29T10:31:55-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/?image=advanced_topics_and_tips%3Atemplateseps.png&ns=advanced_topics_and_tips&rev=1309357915&tab_details=history&mediado=diff&do=media <img src="/support/wiki/lib/exe/fetch.php/advanced_topics_and_tips/templateseps.png?w=359&h=406t=1309357915" alt="advanced_topics_and_tips:templateseps.png" /> text/html 2011-04-10T11:05:53-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/?image=advanced_topics_and_tips%3Agroup1.png&ns=advanced_topics_and_tips&rev=1302447953&tab_details=history&mediado=diff&do=media <img src="/support/wiki/lib/exe/fetch.php/advanced_topics_and_tips/group1.png?w=443&h=254t=1302447953" alt="advanced_topics_and_tips:group1.png" /> text/html 2011-04-06T13:21:57-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/?image=advanced_topics_and_tips%3Agroup4.png&ns=advanced_topics_and_tips&rev=1302110517&tab_details=history&mediado=diff&do=media <img src="/support/wiki/lib/exe/fetch.php/advanced_topics_and_tips/group4.png?w=450&h=254t=1302110517" alt="advanced_topics_and_tips:group4.png" /> text/html 2011-04-06T13:21:50-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/?image=advanced_topics_and_tips%3Agroup3.png&ns=advanced_topics_and_tips&rev=1302110510&tab_details=history&mediado=diff&do=media <img src="/support/wiki/lib/exe/fetch.php/advanced_topics_and_tips/group3.png?w=448&h=255t=1302110510" alt="advanced_topics_and_tips:group3.png" /> text/html 2011-04-06T13:21:44-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/?image=advanced_topics_and_tips%3Agroup2.png&ns=advanced_topics_and_tips&rev=1302110504&tab_details=history&mediado=diff&do=media <img src="/support/wiki/lib/exe/fetch.php/advanced_topics_and_tips/group2.png?w=450&h=255t=1302110504" alt="advanced_topics_and_tips:group2.png" /> text/html 2011-04-06T11:51:35-04:00 Zev Toledano http://www.digital-clay.com/support/wiki/doku.php/?image=advanced_topics_and_tips%3Apivtbl.png&ns=advanced_topics_and_tips&rev=1302105095&tab_details=history&mediado=diff&do=media <img src="/support/wiki/lib/exe/fetch.php/advanced_topics_and_tips/pivtbl.png?w=343&h=199t=1302105095" alt="advanced_topics_and_tips:pivtbl.png" />