# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1749 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1750 --- ## [Hub and Spoke Configuration Installation](https://forum.inductiveautomation.com/t/hub-and-spoke-configuration-installation/11364)
**Author:** [@tim.andy](https://forum.inductiveautomation.com/u/tim.andy)\ **Replies:** 0\ **Last updated:** [March 15, 2016, 1:56pm UTC](https://forum.inductiveautomation.com/t/hub-and-spoke-configuration-installation/11364 "2016-03-15T13:56:34Z")
I'm beginning a project for a client using the Hub and Spoke system. We are going to use the tag historians as the spoke. Before I install ignition at the spoke level PCs do those machines need to have a SQL database ins… --- ## [system.date.setTime() Question](https://forum.inductiveautomation.com/t/system-date-settime-question/11357)
**Author:** [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Replies:** 2\ **Last updated:** [March 14, 2016, 6:06pm UTC](https://forum.inductiveautomation.com/t/system-date-settime-question/11357 "2016-03-14T18:06:54Z")
I've finally gotten around to delving in the "new" system.date scripting functions and I've been having a problem with the .setTime() function. For the hour variable, when I enter an integer less than 12 it will set the… --- ## [Historic for array](https://forum.inductiveautomation.com/t/historic-for-array/11361)
**Author:** [@benoit](https://forum.inductiveautomation.com/u/benoit)\ **Replies:** 0\ **Last updated:** [March 14, 2016, 5:33pm UTC](https://forum.inductiveautomation.com/t/historic-for-array/11361 "2016-03-14T17:33:01Z")
Hi ! I have some difficulties to retrieve data from historic. When I have a look at my SQLserver base, I have some questions about the way data are stored: It seems to me the table saves scalar values, and not array. … --- ## [Bug in easychart legend / marquee mode / point mode](https://forum.inductiveautomation.com/t/bug-in-easychart-legend-marquee-mode-point-mode/11359)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 0\ **Last updated:** [March 14, 2016, 8:50am UTC](https://forum.inductiveautomation.com/t/bug-in-easychart-legend-marquee-mode-point-mode/11359 "2016-03-14T08:50:22Z")
In the list of pen, I put some html to have pen's legend splitted in multiple line. In point mode the tooltip is OK (if I suppress html tag with getXtraceLable extension function) \[attachment=1\]easy01.png\[/attachment… --- ## [Access to \_RETARGET\_FROM\_PROJECT](https://forum.inductiveautomation.com/t/access-to--retarget-from-project/11358)
**Author:** [@gekkoman](https://forum.inductiveautomation.com/u/gekkoman)\ **Replies:** 0\ **Last updated:** [March 14, 2016, 4:17am UTC](https://forum.inductiveautomation.com/t/access-to--retarget-from-project/11358 "2016-03-14T04:17:05Z")
On \>7.7 Scripting namespace appears to vary depending on which event triggers. In this case from a button. eg actionPerformed event performs as expected: if "\_RETARGET\_FROM\_PROJECT" in globals(): global \_… --- ## [Program From 7.8.1 to 7.6.7](https://forum.inductiveautomation.com/t/program-from-7-8-1-to-7-6-7/11355)
**Author:** [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Replies:** 2\ **Last updated:** [March 13, 2016, 8:16pm UTC](https://forum.inductiveautomation.com/t/program-from-7-8-1-to-7-6-7/11355 "2016-03-13T20:16:00Z")
Hey folks, Rookie move here. Developed several windows for a client in 7.8.1, client is running 7.6.7. Upgrading client is not an option for the time being. I'm wondering if there is any way to import the windows int… --- ## [UDT Indirection Anomaly](https://forum.inductiveautomation.com/t/udt-indirection-anomaly/11354)
**Author:** [@cmisztur2](https://forum.inductiveautomation.com/u/cmisztur2)\ **Replies:** 1\ **Last updated:** [March 12, 2016, 6:16pm UTC](https://forum.inductiveautomation.com/t/udt-indirection-anomaly/11354 "2016-03-12T18:16:01Z")
Today one of my templates stopped writing to Kepware OPC server through a UDT instance (7.. I thought it was my code, but it isn’t. I have a UDT with four instances and am using indirection into a template. Using a bu… --- ## [Astronomical libraries compatible with Ignition](https://forum.inductiveautomation.com/t/astronomical-libraries-compatible-with-ignition/11341)
**Author:** [@DuctSoup](https://forum.inductiveautomation.com/u/DuctSoup)\ **Replies:** 5\ **Last updated:** [March 12, 2016, 2:45pm UTC](https://forum.inductiveautomation.com/t/astronomical-libraries-compatible-with-ignition/11341 "2016-03-12T14:45:06Z")
Hi, We use Ignition running on Linux to manage our buildings. I want to run a global gateway timer script to create and periodically update tags for things like: local sunrise and sunset - power up or down the par… --- ## [V7.8.2 Gateway backup](https://forum.inductiveautomation.com/t/v7-8-2-gateway-backup/11353)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 2\ **Last updated:** [March 12, 2016, 1:53pm UTC](https://forum.inductiveautomation.com/t/v7-8-2-gateway-backup/11353 "2016-03-12T13:53:32Z")
Upgraded an ongoing installation from V7.8.1 to V7.8.2 this AM. My gateway backup size has gone from 170Meg down to 20Meg. Does this seem right or is V7.8.2 more efficient with back ups? \[attachment=0\]2016-03-11 19\_33… --- ## [Update data from a table to DB](https://forum.inductiveautomation.com/t/update-data-from-a-table-to-db/11330)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 3\ **Last updated:** [March 12, 2016, 11:57am UTC](https://forum.inductiveautomation.com/t/update-data-from-a-table-to-db/11330 "2016-03-12T11:57:40Z")
I have used a binding function to populate data in table.In the execute() method i have done a select query operation which fills the table. When i change the table properties to editable and edit data, it goes back to o… --- ## [Table component from RootContainer](https://forum.inductiveautomation.com/t/table-component-from-rootcontainer/11350)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 0\ **Last updated:** [March 11, 2016, 5:57pm UTC](https://forum.inductiveautomation.com/t/table-component-from-rootcontainer/11350 "2016-03-11T17:57:32Z")
I have dropped a table in the designer. I want to get the component dropped in the Root Container. How do i get it? I used Component components\[\] = context.getRootPaneContainer().getRootPane().getContentPane().getC… --- ## [Connecting to DBF](https://forum.inductiveautomation.com/t/connecting-to-dbf/11348)
**Author:** [@MoisesZV](https://forum.inductiveautomation.com/u/MoisesZV)\ **Replies:** 0\ **Last updated:** [March 11, 2016, 2:05pm UTC](https://forum.inductiveautomation.com/t/connecting-to-dbf/11348 "2016-03-11T14:05:45Z")
Hi, I'm trying to connect to a DBF file from SAP, I just found one topic talking about this https://inductiveautomation.com/forum/viewtopic.php?f=70&t=5960&p=16405&hilit=dbf&sid=6fedfdf16ce1342384db9e013304a6fb#p16405 … --- ## [Inheriting users properties](https://forum.inductiveautomation.com/t/inheriting-users-properties/11347)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 0\ **Last updated:** [March 11, 2016, 1:27pm UTC](https://forum.inductiveautomation.com/t/inheriting-users-properties/11347 "2016-03-11T13:27:43Z")
Hi, I would like to structure my security as follows: - a number of basic roles (about 30) are defined by me in the gateway at design time; - about 10 basic users are defined by me in the gateway at design time: each of … --- ## [Current alarms and alarm history](https://forum.inductiveautomation.com/t/current-alarms-and-alarm-history/11343)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 0\ **Last updated:** [March 10, 2016, 7:13pm UTC](https://forum.inductiveautomation.com/t/current-alarms-and-alarm-history/11343 "2016-03-10T19:13:56Z")
I’m confused now… I’ve deleted from my SQL database all tables, that Ignition 7.8.1. creates (I first stopped Ignition). But I can still see current alarms in Alarm status table and alarm history in Alarm Journal Ta… --- ## [Designer doesn't load NoClassDefFoundError BytePackedRaster](https://forum.inductiveautomation.com/t/designer-doesnt-load-noclassdeffounderror-bytepackedraster/11223)
**Author:** [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\ **Replies:** 7\ **Last updated:** [March 10, 2016, 5:56pm UTC](https://forum.inductiveautomation.com/t/designer-doesnt-load-noclassdeffounderror-bytepackedraster/11223 "2016-03-10T17:56:15Z")
Designer doesn't load after Java Splash Screen. Windows 7 64-bit Ultimate jre-8u74-windows-x64 Ignition Version 7.8.1 (b2016012216) Java Version Oracle Corporation 1.8.0\_74 When trying to open designer on window… --- ## [Does java client support deep linking?](https://forum.inductiveautomation.com/t/does-java-client-support-deep-linking/11339)
**Author:** [@ywen](https://forum.inductiveautomation.com/u/ywen)\ **Replies:** 3\ **Last updated:** [March 10, 2016, 5:25pm UTC](https://forum.inductiveautomation.com/t/does-java-client-support-deep-linking/11339 "2016-03-10T17:25:53Z")
We want to leverage ignition in combination with a custom portal UI outside of the Ignition stack. This portal UI may have specific resource visible on the screen. Access to additional info on the resource would be acc… --- ## [DataBase access from the client](https://forum.inductiveautomation.com/t/database-access-from-the-client/11328)
**Author:** [@benoit](https://forum.inductiveautomation.com/u/benoit)\ **Replies:** 7\ **Last updated:** [March 10, 2016, 3:46pm UTC](https://forum.inductiveautomation.com/t/database-access-from-the-client/11328 "2016-03-10T15:46:27Z")
From both client and designer java applications how to get the JDBC driver from the default database ? It is possible to get the database name from clientContext.getDefaultDatasourceName(); But how to perform an SQL … --- ## [Reporting : Overflow behavior of Table cell](https://forum.inductiveautomation.com/t/reporting-overflow-behavior-of-table-cell/11334)
**Author:** [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\ **Replies:** 1\ **Last updated:** [March 10, 2016, 2:21pm UTC](https://forum.inductiveautomation.com/t/reporting-overflow-behavior-of-table-cell/11334 "2016-03-10T14:21:39Z")
I am using “Ignition 7.8.1 (b2016012216)” In reporting Overflow behavior (behaviour) of Table cell “Shrink Text to fit” not working. Do we have any stable version of reporting module, which will work without issues? --- ## [Alarms - Display path expression](https://forum.inductiveautomation.com/t/alarms-display-path-expression/11338)
**Author:** [@AleInge](https://forum.inductiveautomation.com/u/AleInge)\ **Replies:** 2\ **Last updated:** [March 10, 2016, 8:05am UTC](https://forum.inductiveautomation.com/t/alarms-display-path-expression/11338 "2016-03-10T08:05:22Z")
Hi all, I have an UDT tag with some alarms and I'd like to configure the display paths as an expression, but I am having some troubles... I would to concatenate an UDT parameter and a tag value (string), then I tried: … --- ## [Text Data from SQL Query](https://forum.inductiveautomation.com/t/text-data-from-sql-query/11337)
**Author:** [@boster281](https://forum.inductiveautomation.com/u/boster281)\ **Replies:** 1\ **Last updated:** [March 9, 2016, 11:01pm UTC](https://forum.inductiveautomation.com/t/text-data-from-sql-query/11337 "2016-03-09T23:01:53Z")
Not sure if this is possible but figure i might a well ask. I want to do an sql query that returns a number SELECT PartStatus FROM \[Thermoplastics\].\[dbo\].\[PartTracking\] WHERE Container like '{Root Container.Containe… --- ## [Update data from a table to DB](https://forum.inductiveautomation.com/t/update-data-from-a-table-to-db/11340)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 0\ **Last updated:** [March 9, 2016, 7:23pm UTC](https://forum.inductiveautomation.com/t/update-data-from-a-table-to-db/11340 "2016-03-09T19:23:22Z")
I have used a binding function to populate data in table.In the execute() method i have done a select query operation which fills the table. When i change the table properties to editable and edit data, it goes back to o… --- ## [Transaction Group Quality Code](https://forum.inductiveautomation.com/t/transaction-group-quality-code/11336)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 1\ **Last updated:** [March 9, 2016, 5:35pm UTC](https://forum.inductiveautomation.com/t/transaction-group-quality-code/11336 "2016-03-09T17:35:35Z")
In a Transaction group what is the "Store quality code" value derived from? 1 tag, all tags........ --- ## [Sql query The multi-part identifier could not be bound](https://forum.inductiveautomation.com/t/sql-query-the-multi-part-identifier-could-not-be-bound/11335)
**Author:** [@boster281](https://forum.inductiveautomation.com/u/boster281)\ **Replies:** 0\ **Last updated:** [March 9, 2016, 2:00pm UTC](https://forum.inductiveautomation.com/t/sql-query-the-multi-part-identifier-could-not-be-bound/11335 "2016-03-09T14:00:05Z")
The error message i am getting: File "", line 43, in Thermoplastics.dbo.PartTracking set Thermoplastics.dbo.PartTracking = 97 from Thermoplastics.dbo.PartTracking inner join Thermoplast… --- ## [Ignition OPC UA interoperability](https://forum.inductiveautomation.com/t/ignition-opc-ua-interoperability/11327)
**Author:** [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\ **Replies:** 3\ **Last updated:** [March 9, 2016, 1:53pm UTC](https://forum.inductiveautomation.com/t/ignition-opc-ua-interoperability/11327 "2016-03-09T13:53:48Z")
I am carrying out some interoperability tests of Ignition OPC UA client/server with other OPC UA vendors. Recently i tried to connect UaExpert OPC UA client (Unified Automation) with Ignition server. I noticed a lot of … --- ## [Reporting 7.8 date error](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093)
**Author:** [@heybales](https://forum.inductiveautomation.com/u/heybales)\ **Replies:** 6\ **Last updated:** [March 9, 2016, 1:18am UTC](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093 "2016-03-09T01:18:55Z")
I'm getting the following warnings when running a report. WARN: Ending date {StepFinish} for tag history in report Report could not be parsed as a date. WARN: Using Historical date range, but could not parse {StepSTart… --- ## [Valid data point calculation from SQL](https://forum.inductiveautomation.com/t/valid-data-point-calculation-from-sql/11090)
**Author:** [@emanuel](https://forum.inductiveautomation.com/u/emanuel)\ **Replies:** 3\ **Last updated:** [March 8, 2016, 9:57pm UTC](https://forum.inductiveautomation.com/t/valid-data-point-calculation-from-sql/11090 "2016-03-08T21:57:21Z")
I have a customer that currently uses an Excel to log data through another SCADA package that I am replacing with IA. The data they log is just simple temperatures and average that data at the end of the day (24-hour), b… --- ## [Comments panel unstick link not obeying foreground color](https://forum.inductiveautomation.com/t/comments-panel-unstick-link-not-obeying-foreground-color/11325)
**Author:** [@fledder](https://forum.inductiveautomation.com/u/fledder)\ **Replies:** 0\ **Last updated:** [March 7, 2016, 10:51pm UTC](https://forum.inductiveautomation.com/t/comments-panel-unstick-link-not-obeying-foreground-color/11325 "2016-03-07T22:51:45Z")
Ignition 7.8.0 On the comments panel, the Unstick link is always black text, no matter what the foreground color is set to. --- ## [Script execution while button pressed](https://forum.inductiveautomation.com/t/script-execution-while-button-pressed/11324)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 1\ **Last updated:** [March 7, 2016, 10:33pm UTC](https://forum.inductiveautomation.com/t/script-execution-while-button-pressed/11324 "2016-03-07T22:33:57Z")
Hi I would like a script to execute repeatedly while a button is pressed down. For example, increment a number by 1 while the button is pressed down, and stop incrementing when the button is no longer pressed/in focus. … --- ## [Report Parameters for table cells](https://forum.inductiveautomation.com/t/report-parameters-for-table-cells/11323)
**Author:** [@Caleb\_Bohon](https://forum.inductiveautomation.com/u/Caleb_Bohon)\ **Replies:** 0\ **Last updated:** [March 7, 2016, 9:50pm UTC](https://forum.inductiveautomation.com/t/report-parameters-for-table-cells/11323 "2016-03-07T21:50:36Z")
Is there any way to quickly change a parameter on multiple table cells / text shapes? I have a table where I want the cell borders to show, and I had all the columns setup to do that, but when I extended the table it d… --- ## [Tag history table Fixed sample size returns extra sample](https://forum.inductiveautomation.com/t/tag-history-table-fixed-sample-size-returns-extra-sample/11322)
**Author:** [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\ **Replies:** 4\ **Last updated:** [March 7, 2016, 8:23pm UTC](https://forum.inductiveautomation.com/t/tag-history-table-fixed-sample-size-returns-extra-sample/11322 "2016-03-07T20:23:40Z")
I’m having problems I’m trying to retrieve a number of values to a table from tag history for a single point in time. take a look at the image. I’m asking for four records, the sample size is fixed at 1, but I’m get… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1748) [Next page](https://forum.inductiveautomation.com/latest.md?page=1750)