# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1407 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1408 --- ## [Reporting Woes!](https://forum.inductiveautomation.com/t/reporting-woes/15873)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 3\ **Last updated:** [November 3, 2017, 11:50pm UTC](https://forum.inductiveautomation.com/t/reporting-woes/15873 "2017-11-03T23:50:27Z")
I'm trying to build a report that will have two basic elements for four similar pieces of equipment. A graph at the top with some time series analog data, and a table below with alarm events. The analog data is tag histo… --- ## [Search inside named queries/ Reports](https://forum.inductiveautomation.com/t/search-inside-named-queries-reports/15874)
**Author:** [@rmonfront](https://forum.inductiveautomation.com/u/rmonfront)\ **Replies:** 1\ **Last updated:** [November 3, 2017, 9:11pm UTC](https://forum.inductiveautomation.com/t/search-inside-named-queries-reports/15874 "2017-11-03T21:11:17Z")
Hello, Is it normal that a search with Control + F does not display items that are inside the named queries and reports ? It could be very helpful during development and improve maintainability of the project. --- ## [How to copy results from a search?](https://forum.inductiveautomation.com/t/how-to-copy-results-from-a-search/15483)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 5\ **Last updated:** [November 3, 2017, 5:23pm UTC](https://forum.inductiveautomation.com/t/how-to-copy-results-from-a-search/15483 "2017-11-03T17:23:01Z")
I'm trying to use the search feature to see where things are and then manually replace depending on the circumstance of each find. It acts like I can copy the search results... but when pasted its some serialized object … --- ## [Inconsistent data logged by transaction group](https://forum.inductiveautomation.com/t/inconsistent-data-logged-by-transaction-group/15862)
**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\ **Replies:** 5\ **Last updated:** [November 3, 2017, 2:29pm UTC](https://forum.inductiveautomation.com/t/inconsistent-data-logged-by-transaction-group/15862 "2017-11-03T14:29:14Z")
I am having an occasional problem with a transaction group that mixes data from two different subscription updates. The data (a series of process data for a specific machined part) is received by a custom OPC-UA driver t… --- ## [Saving project restarts ALL projects](https://forum.inductiveautomation.com/t/saving-project-restarts-all-projects/15840)
**Author:** [@cmisztur2](https://forum.inductiveautomation.com/u/cmisztur2)\ **Replies:** 3\ **Last updated:** [November 3, 2017, 2:45am UTC](https://forum.inductiveautomation.com/t/saving-project-restarts-all-projects/15840 "2017-11-03T02:45:37Z")
I have a weird issue. I have a dev and prod server, both at 7.9.4. When I save a project on the dev server it only restarts gateway scripts for that project. On the production server when I save a project, all the proj… --- ## [Best Practices for Handling Unusual Modbus Data Types](https://forum.inductiveautomation.com/t/best-practices-for-handling-unusual-modbus-data-types/15830)
**Author:** [@adam.butt](https://forum.inductiveautomation.com/u/adam.butt)\ **Replies:** 2\ **Last updated:** [November 2, 2017, 8:28pm UTC](https://forum.inductiveautomation.com/t/best-practices-for-handling-unusual-modbus-data-types/15830 "2017-11-02T20:28:10Z")
I'm a new developer on the Ignition platform. I've been playing around with the demo for some time, but I finally have my first real-world project. I want to make sure I'm using best practices to so that project modifi… --- ## [Read Data Directly From CSV](https://forum.inductiveautomation.com/t/read-data-directly-from-csv/15854)
**Author:** [@focusengsk](https://forum.inductiveautomation.com/u/focusengsk)\ **Replies:** 8\ **Last updated:** [November 2, 2017, 3:51pm UTC](https://forum.inductiveautomation.com/t/read-data-directly-from-csv/15854 "2017-11-02T15:51:19Z")
Is it possible to read data from specific rows on a csv file, without first importing it into Ignition? Importing is a problem as it's a file being written daily, and the export from the other system doesn't allow format… --- ## [Caret Position](https://forum.inductiveautomation.com/t/caret-position/5649)
**Author:** [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Replies:** 4\ **Last updated:** [November 2, 2017, 3:43pm UTC](https://forum.inductiveautomation.com/t/caret-position/5649 "2017-11-02T15:43:40Z")
I'm currently trying to work with the Text Area component and would like to be able to find the caret position inside the Text Area. I know I can use the getCaretPosition() on the Text Field component but it does not ap… --- ## [Creating a timed loop to show main windows](https://forum.inductiveautomation.com/t/creating-a-timed-loop-to-show-main-windows/15827)
**Author:** [@santiago4ever72](https://forum.inductiveautomation.com/u/santiago4ever72)\ **Replies:** 7\ **Last updated:** [November 2, 2017, 3:23pm UTC](https://forum.inductiveautomation.com/t/creating-a-timed-loop-to-show-main-windows/15827 "2017-11-02T15:23:24Z")
Hello everyone, I wanted to know if it was possible to show the main windows in a loop and repeat the loop depending on the time in which each window has been shown. As if it were a presentation. This is because we want … --- ## [system.db.runQuery formating question](https://forum.inductiveautomation.com/t/system-db-runquery-formating-question/15851)
**Author:** [@trd79](https://forum.inductiveautomation.com/u/trd79)\ **Replies:** 7\ **Last updated:** [November 2, 2017, 1:07pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-formating-question/15851 "2017-11-02T13:07:47Z")
Is there a way to format a large query using system.db.runQuery so that it is easy to read ? For example I would like my query to look something like this , system.db.runQuery("Select something, Case when this … --- ## [TagHistory time stamp in Oracle Database](https://forum.inductiveautomation.com/t/taghistory-time-stamp-in-oracle-database/15837)
**Author:** [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\ **Replies:** 1\ **Last updated:** [November 2, 2017, 9:01am UTC](https://forum.inductiveautomation.com/t/taghistory-time-stamp-in-oracle-database/15837 "2017-11-02T09:01:36Z")
I am using Oracle 11G server to log the tag history data. (Ignition version is 7.8.5 (b2016120813) and Java version is Oracle Corporation 1.8.0\_144) I am trying to convert unix timestamp logged in SQLT\_DATA\_1\_2017\_10 … --- ## [Easy chart tags not plotting](https://forum.inductiveautomation.com/t/easy-chart-tags-not-plotting/15839)
**Author:** [@Dilan](https://forum.inductiveautomation.com/u/Dilan)\ **Replies:** 4\ **Last updated:** [November 2, 2017, 7:49am UTC](https://forum.inductiveautomation.com/t/easy-chart-tags-not-plotting/15839 "2017-11-02T07:49:38Z")
Hello All, I’m experiencing a strange issue with the plotting of an easy chart from tags, I hope someone here has some experience with this. When I plot multiple pens, some seem to show correctly and others not, all de… --- ## [Report schedue by script](https://forum.inductiveautomation.com/t/report-schedue-by-script/15845)
**Author:** [@lyhkch](https://forum.inductiveautomation.com/u/lyhkch)\ **Replies:** 3\ **Last updated:** [November 1, 2017, 8:07pm UTC](https://forum.inductiveautomation.com/t/report-schedue-by-script/15845 "2017-11-01T20:07:46Z")
Hi, I want to use this script : data\_list = \[\["TYN","001"\],\["TYN","002"\],\["TYN","003"\],\["TYN","004"\],\["YPG","001"\]\] today = system.date.now() date = system.date.format(today, "yyyy\_MM\_dd\_HH\_mm\_ss") for data in data\_li… --- ## [Siemens WinCC OPCUA Error](https://forum.inductiveautomation.com/t/siemens-wincc-opcua-error/15844)
**Author:** [@c-w-t](https://forum.inductiveautomation.com/u/c-w-t)\ **Replies:** 3\ **Last updated:** [November 1, 2017, 7:14pm UTC](https://forum.inductiveautomation.com/t/siemens-wincc-opcua-error/15844 "2017-11-01T19:14:18Z")
Hi, I'm trying to connect Ignition's UA client to a WinCC UA server running on the same machine. I can browse the endpoint, but when I finish the connection setup it faults and returns the following error: UaException… --- ## [Alarms in hub and spoke setup](https://forum.inductiveautomation.com/t/alarms-in-hub-and-spoke-setup/15847)
**Author:** [@lujackso](https://forum.inductiveautomation.com/u/lujackso)\ **Replies:** 0\ **Last updated:** [November 1, 2017, 6:01pm UTC](https://forum.inductiveautomation.com/t/alarms-in-hub-and-spoke-setup/15847 "2017-11-01T18:01:29Z")
We have a hub and spoke design where we have about 15 local ignition rolling up to 2 gateway ignition servers. We want to alarm on the servers, not on the spoke. We are trying to test loss of communication. I setup the a… --- ## [Needing some object's library](https://forum.inductiveautomation.com/t/needing-some-objects-library/15846)
**Author:** [@jadachi](https://forum.inductiveautomation.com/u/jadachi)\ **Replies:** 0\ **Last updated:** [November 1, 2017, 5:45pm UTC](https://forum.inductiveautomation.com/t/needing-some-objects-library/15846 "2017-11-01T17:45:43Z")
Hello, I'm developing a SCADA for a storm drain station, where there are 4 giant water pumps. My situation is that I can't find any template or object that can represent those water pumps and pipes. Is there any external… --- ## [Forward Slash in Alarm Name](https://forum.inductiveautomation.com/t/forward-slash-in-alarm-name/15831)
**Author:** [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Replies:** 1\ **Last updated:** [November 1, 2017, 3:55am UTC](https://forum.inductiveautomation.com/t/forward-slash-in-alarm-name/15831 "2017-11-01T03:55:02Z")
I am trying to put a forward slash in the name of an alarm. For example… But on the alarm status table, the alarm name prints out “CONV100 Motor Overload Fault”. Essentially everything after the forward slash. Is t… --- ## [Scraping Web Data](https://forum.inductiveautomation.com/t/scraping-web-data/15834)
**Author:** [@afarzin](https://forum.inductiveautomation.com/u/afarzin)\ **Replies:** 1\ **Last updated:** [November 1, 2017, 1:23am UTC](https://forum.inductiveautomation.com/t/scraping-web-data/15834 "2017-11-01T01:23:56Z")
What is the best/good way to scrape data from a web site and make it available as a tag in the system? My particular application is importing data from a weather station system that does not have any kind of OPC/Modbus f… --- ## [sendEmail attachments](https://forum.inductiveautomation.com/t/sendemail-attachments/7867)
**Author:** [@NorthPoint](https://forum.inductiveautomation.com/u/NorthPoint)\ **Replies:** 3\ **Last updated:** [November 1, 2017, 12:09am UTC](https://forum.inductiveautomation.com/t/sendemail-attachments/7867 "2017-11-01T00:09:25Z")
Hello- I have successfully gotten sendEmail to send emails with attached files, very nice! I have a couple of questions though: 1) Everything works fine when I attach a known file type (PDF, CSV, XLS, etc). But if… --- ## [Mobile gestures on screens](https://forum.inductiveautomation.com/t/mobile-gestures-on-screens/15832)
**Author:** [@rmonfront](https://forum.inductiveautomation.com/u/rmonfront)\ **Replies:** 0\ **Last updated:** [October 31, 2017, 7:51pm UTC](https://forum.inductiveautomation.com/t/mobile-gestures-on-screens/15832 "2017-10-31T19:51:16Z")
Is it possible to use mobile gesture (Zoom In/Out, Scroll up/down) on Template Repeater component over a mobile version ? --- ## [Check user access before opening a file](https://forum.inductiveautomation.com/t/check-user-access-before-opening-a-file/15829)
**Author:** [@dan.kobus](https://forum.inductiveautomation.com/u/dan.kobus)\ **Replies:** 1\ **Last updated:** [October 31, 2017, 7:42pm UTC](https://forum.inductiveautomation.com/t/check-user-access-before-opening-a-file/15829 "2017-10-31T19:42:58Z")
I am using system.net.openURL to open an excel document from the companies network drive, but for some users when i click the button that has been scripted to open the file, nothing happens. we determined that the reason… --- ## [RTSP connection in Ingnition problem](https://forum.inductiveautomation.com/t/rtsp-connection-in-ingnition-problem/15825)
**Author:** [@ahmed.elhagrasy](https://forum.inductiveautomation.com/u/ahmed.elhagrasy)\ **Replies:** 2\ **Last updated:** [October 31, 2017, 6:12pm UTC](https://forum.inductiveautomation.com/t/rtsp-connection-in-ingnition-problem/15825 "2017-10-31T18:12:29Z")
I am using Ignition 7.9 with DSE cameras which uses RTSP facing trouble finding its HTTP URL to connect to Ignition The source page doesn’t contain any working URL Kindly advise about this problem urgently, I… --- ## [Web browser filter](https://forum.inductiveautomation.com/t/web-browser-filter/15824)
**Author:** [@lyhkch](https://forum.inductiveautomation.com/u/lyhkch)\ **Replies:** 0\ **Last updated:** [October 31, 2017, 1:33pm UTC](https://forum.inductiveautomation.com/t/web-browser-filter/15824 "2017-10-31T13:33:10Z")
When I use web browser, browse a lot of PDF file, how can I filter these files by file name ? And display the filtered files in web browser --- ## [System.tag.write](https://forum.inductiveautomation.com/t/system-tag-write/15792)
**Author:** [@bprice](https://forum.inductiveautomation.com/u/bprice)\ **Replies:** 5\ **Last updated:** [October 31, 2017, 1:15pm UTC](https://forum.inductiveautomation.com/t/system-tag-write/15792 "2017-10-31T13:15:02Z")
Is there any way to take a tag value in a PLC and write that value to a new tag and a different value? For example, say the tag in the PLC = 0 and I want the new tag to = recipe1. Or the the in the PLC = 1 and I want the… --- ## [Query data from different tables in the SQL database](https://forum.inductiveautomation.com/t/query-data-from-different-tables-in-the-sql-database/15789)
**Author:** [@lyhkch](https://forum.inductiveautomation.com/u/lyhkch)\ **Replies:** 6\ **Last updated:** [October 31, 2017, 12:51pm UTC](https://forum.inductiveautomation.com/t/query-data-from-different-tables-in-the-sql-database/15789 "2017-10-31T12:51:17Z")
Hi, I want to query data from different tables in the database, then display these data in the Table component by datetime , but ignition will Generate a table every month,like "sqlt\_data\_1\_2017\_10","sqlt\_data\_1\_2017\_09"… --- ## [HIstorical trending of discrete tags](https://forum.inductiveautomation.com/t/historical-trending-of-discrete-tags/15817)
**Author:** [@fledder](https://forum.inductiveautomation.com/u/fledder)\ **Replies:** 1\ **Last updated:** [October 31, 2017, 12:26pm UTC](https://forum.inductiveautomation.com/t/historical-trending-of-discrete-tags/15817 "2017-10-31T12:26:35Z")
Ignition 7.8.5 I'm trying to show a plot with an Easy Chart of some discrete tags that are stored only on change. Using the Raw resolution mode, I get short chunks of lines, as the line doesn't plot if the previous sto… --- ## [PageAccessSynchronizer](https://forum.inductiveautomation.com/t/pageaccesssynchronizer/15822)
**Author:** [@HooK\_a](https://forum.inductiveautomation.com/u/HooK_a)\ **Replies:** 0\ **Last updated:** [October 31, 2017, 12:01pm UTC](https://forum.inductiveautomation.com/t/pageaccesssynchronizer/15822 "2017-10-31T12:01:40Z")
Hi, all. We have redundant igniiton 7.8.4. System Properties Context State Running Redundancy Mode Master Redundancy State Active Version 7.8.4 (b2016082217) Java Version Oracle Corporation 1.8.0\_102 CPU % 18,3 Memory … --- ## [Template Canvas Dataset parameters not changing](https://forum.inductiveautomation.com/t/template-canvas-dataset-parameters-not-changing/14636)
**Author:** [@Yoan](https://forum.inductiveautomation.com/u/Yoan)\ **Replies:** 5\ **Last updated:** [October 31, 2017, 10:26am UTC](https://forum.inductiveautomation.com/t/template-canvas-dataset-parameters-not-changing/14636 "2017-10-31T10:26:30Z")
Hi, I recently starting to use the Template Canvas object because i want to move the item in the Template Canvas dynamically (you can't do that in Template Repeater). My template used in the Template Canvas have spe… --- ## [Accessing Ignition Data from a 3rd party web app](https://forum.inductiveautomation.com/t/accessing-ignition-data-from-a-3rd-party-web-app/15745)
**Author:** [@snoopyflyingace](https://forum.inductiveautomation.com/u/snoopyflyingace)\ **Replies:** 4\ **Last updated:** [October 31, 2017, 2:52am UTC](https://forum.inductiveautomation.com/t/accessing-ignition-data-from-a-3rd-party-web-app/15745 "2017-10-31T02:52:42Z")
Hi, I was wondering if I can access my ignition project from a web application. I think I will need to employ some kind of REST API to achieve this but I could not find any documentation on this. Thanks for your assist… --- ## [MSSQL to MySQL/PostgreSQL](https://forum.inductiveautomation.com/t/mssql-to-mysql-postgresql/15816)
**Author:** [@oscar.salcedo](https://forum.inductiveautomation.com/u/oscar.salcedo)\ **Replies:** 3\ **Last updated:** [October 30, 2017, 11:53pm UTC](https://forum.inductiveautomation.com/t/mssql-to-mysql-postgresql/15816 "2017-10-30T23:53:55Z")
Hi all, Has anyone moved a project from MSSQL to MySQL or PostgreSQL? What can I expect? Is it safe to assume that most queries would have to be rewritten to work with the new databases? We are scaling out our architec… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1406) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1408)