Category Articles RSS Feed
GN: MDAC Information
Viewed 22514 times since Mon, Nov 29, 2010
Revision Date: 2010-11-29 Both CHARTrunner and SQCpack use Microsoft Data Access Components (MDAC) in order to access database data.  Microsoft includes MDAC as part of the operating system in Windows ME and higher. Versions of Windows prior to... Read More
CR: Oracle Data Source
Viewed 10421 times since Fri, Nov 9, 2007
Revision Date: 13-Dec-2005 This article covers issues involved with using Oracle as a CHARTrunner data source. On the Data definition tab of the chart definition the SQL Settings button allows you to specify whether to "Surround table names and... Read More
CR: Using Oracle Stored Procedures
Viewed 5620 times since Fri, Nov 9, 2007
Revision Date: 13-April-2006 Q. Can CHARTrunner use an Oracle stored procedure as the data source for a chart? CHARTrunner version 1.6.87 (and higher) has been configured to work with Oracle stored procedures.  Prior versions of CHARTrunner may... Read More
CR: Using a Text File as a Data Source
Viewed 5388 times since Tue, Feb 5, 2008
Problem: When you specify a text file as the CHARTrunner data source, the data from the text file will not be read correctly if the format of the text file is “nonstandard”.  In CHARTrunner, the symptom of this condition is... Read More
Query to fetch the Last N rows of data from a table or view
Viewed 5176 times since Thu, May 28, 2009
Revision Date: 2009-05-28 Problem: I have tables and views in my database that contain a large number of rows of data. My CHARTrunner charts using this data take a long time to render. I only want to chart the most recent rows from the data source.... Read More
CR: SQL Server Data Source
Viewed 4241 times since Fri, Nov 9, 2007
(Updated: 14-May-2007) This article covers issues involved with using SQL Server as a CHARTrunner data source. On the Data source tab of the CHARTrunner chart definition you can specify the Type as either ADO; OLE DB provider or ODBC; Open database... Read More
CR: Chart refresh is not refreshing when data is added
Viewed 3005 times since Mon, Mar 3, 2008
Ref # 644 Problem: When I press F5 to refresh my displayed chart, or if the chart refreshes automatically every N seconds, the "refreshed" chart doesn't show any newly added data. Solution: Microsoft Access Data Source If Microsoft Access is being... Read More
CR: Simultaneous Use of CHARTrunner and Excel with a Workbook
Viewed 2934 times since Fri, Nov 9, 2007
Revision Date: 2005-11-07 Problem: Under some circumstances you may experience problems when using Microsoft Excel to open or edit a workbook file at the same time that CHARTrunner is using that same workbook file. The issues discussed here do not... Read More
CR: Using a Password Protected Microsoft Access Database
Viewed 2844 times since Fri, Nov 9, 2007
Problem: Ref #757, Last Revision 02-14-2003. A Microsoft Access database can be password protected using one of the following methods: ·        Database Password – A password is applied to the entire MDB file.... Read More
CR: Charting from IndustrialSQL Server
Viewed 2726 times since Fri, Nov 9, 2007
Problem: You need to setup a CHARTrunner chart definition to chart data from tags that reside in Wonderware's IndustrialSQL Server. IndustrialSQL Server is a real-time relational database that sits on top of SQL Server.  An... Read More
CR: MySQL Data Source
Viewed 2660 times since Tue, May 20, 2014
This article explains how to use MySQL as the data source for CHARTrunner or CHARTrunner Lean. CHARTrunner Lean is used in this discussion, but the concepts also apply to CHARTrunner. CHARTrunner and CHARTrunner Lean are 32-bit programs, so you need... Read More
CR: Excel Data Source Requirements
Viewed 2649 times since Fri, Nov 9, 2007
CHARTrunner allows you to create charts using data from a variety of sources. However, CHARTrunner thinks about data with a database metaphor. In a database, a table contains many rows (or records) of data. Each row will have the same fields (or... Read More
CR: Minitab as a Data Source
Viewed 2629 times since Fri, Nov 9, 2007
Ref # 636 CHARTrunner can chart data that is stored in Minitab files. By default, Minitab stores data in Projects .MPJ and Worksheets .MTW but by using the following steps, you can store data in other formats. To do this: While in Minitab, open... Read More
CR: Installable ISAM Error
Viewed 2596 times since Thu, Feb 23, 2012
Problem: While trying to create or display a chart when using CHARTrunner or CHARTrunner Lean, the following error message is diplayed: Could not find installable ISAM. This may occur when the data source is an Access database, an Excel spreadsheet,... Read More
CR: Using Custom Parameters in Your Custom Queries
Viewed 2498 times since Fri, Nov 9, 2007
(Updated 02-July-2004) On the "Data definition" tab of the chart description you can choose "Custom query" as the "Source for data records" which allows you to enter the SQL (Structured Query Language) statement that will be passed to the underlying... Read More
CR: Charting from a FoxPro Data Source
Viewed 2304 times since Fri, Nov 9, 2007
Ref # 616 To use FoxPro 2.0, 2.5, 2.6, or 3.0 data within CHARTrunner, you must follow these steps: On the Data source tab, set the Type to ADO; OLE DB Provider.In the ADO; OLE DB Provider field, select ODBC Driver for Visual FoxPro—without... Read More
CR: Honeywell Uniformance as a Data Source
Viewed 2186 times since Fri, Nov 9, 2007
Ref #717 If you want to use a Honeywell Uniformance database, contact PQ Systems technical support: In North and South America, contact our US office at:800-777-5060 or 937-885-2255 or In Europe or Africa, contact our UK... Read More
CR: FoxPro and MDAC Information
Viewed 2129 times since Fri, Nov 9, 2007
CHARTrunner is shipping with MDAC 2.5. MDAC stands for Microsoft Data Access Components. This is a set of files required for accessing various data sources. MDAC 2.1 allowed users access to FoxPro 2.0, 2.5, and 2.6 databases by using the Jet... Read More
CR: Charting from a Paradox Data Source
Viewed 2098 times since Fri, Nov 9, 2007
Ref # 615 Paradox 3 databases usually require you to use the "Custom query" option. Selecting "Table" with Paradox 3 databases will give you an error. If you have both the Paradox table AND the primary key table, you might be able to use the "table"... Read More
CR: Missing the First Row of Data from an Excel Data Source
Viewed 2062 times since Fri, Nov 9, 2007
Ref # 635 Problem When linking to Excel, CHARTrunner uses the first row as a header. If the spreadsheet starts with the data, i.e. no header or column title, the first row will not be charted. Solution Insert a title in the first row.   Read More
CR: Charting from a Paradox password protected database
Viewed 1982 times since Fri, Nov 9, 2007
Problem: With a Paradox 5 table that is password protected, CHARTrunner is unable to chart this using the standard Paradox choice under "Type" on the data source tab. Solution: Setup an ODBC driver for Paradox using Start/Settings/Control Panel... Read More
CR: CHARTrunner locks data source
Viewed 1977 times since Fri, Nov 9, 2007
Problem: When I draw a CHARTrunner chart, the data source cannot be accessed. Solution: Download an updated version of CHARTrunner version 1.1.185 or higher from the CHARTrunner Maintenance Release page. Follow the directions on the maintenance... Read More
CR: Fetching Specification Limits from the Data Source
Viewed 1926 times since Fri, May 30, 2008
Revision Date: 2008-05-30 Problem: How can I have CHARTrunner fetch the specification limits for a chart from the data source? Solution: CHARTrunner 2.0 and above has the ability to treat a column from the data source as a specification limit. This... Read More
CR: Lotus Data Source
Viewed 1920 times since Fri, Nov 9, 2007
Following is a brief description for creating a DSN for users to connect to Lotus Notes (*.nsf) databases with CHARTrunner. To create a DSN to connect Lotus Notes (*.nsf) databases with CHARTrunner: 1.   You must have one of the following... Read More
CR: Tips for Using Microsoft Access as a Data Source
Viewed 1885 times since Fri, Nov 9, 2007
Ref #728 In general, the format for data in Microsoft Access is that each row of the table is a set of data points connected to a time event, e.g., taken at 9:00 am, for the month of May, etc. A characteristic with a sample size of five would fill... Read More