# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1617 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1618 --- ## [Store and forward data state?](https://forum.inductiveautomation.com/t/store-and-forward-data-state/19167)
**Author:** [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\ **Replies:** 2\ **Last updated:** [August 13, 2018, 5:36am UTC](https://forum.inductiveautomation.com/t/store-and-forward-data-state/19167 "2018-08-13T05:36:16Z")
What happens to data which is stored in store and forward and accidentally the physical machine on which ignition server is installed is restarted? --- ## [SQL Command Available](https://forum.inductiveautomation.com/t/sql-command-available/19212)
**Author:** [@kevin.jones](https://forum.inductiveautomation.com/u/kevin.jones)\ **Replies:** 4\ **Last updated:** [August 12, 2018, 1:03am UTC](https://forum.inductiveautomation.com/t/sql-command-available/19212 "2018-08-12T01:03:14Z")
I'm limping along trying to get some various SQL queries to work and have issues with trying to use IF or CASE in the SELECT statement. Eg: SELECT B28H as State, Count (B28) as Min , SUM ( IF B28H IN (1,2,3,5) THEN 1 E… --- ## [Change language of the Calendar component](https://forum.inductiveautomation.com/t/change-language-of-the-calendar-component/19213)
**Author:** [@mpoulsen921](https://forum.inductiveautomation.com/u/mpoulsen921)\ **Replies:** 0\ **Last updated:** [August 11, 2018, 7:36pm UTC](https://forum.inductiveautomation.com/t/change-language-of-the-calendar-component/19213 "2018-08-11T19:36:53Z")
Hi, Does anyone know how to change the language of the calendar component(names of months and days)? I have chosen the locale to be "da\_DK" in order to have european numbering format of decimal numbers. That way all nu… --- ## [Setting Popup Calendar to current datetime](https://forum.inductiveautomation.com/t/setting-popup-calendar-to-current-datetime/19211)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 3\ **Last updated:** [August 11, 2018, 3:52pm UTC](https://forum.inductiveautomation.com/t/setting-popup-calendar-to-current-datetime/19211 "2018-08-11T15:52:24Z")
Is there a way to use a expression or scripting to set the calenders current date and time when the window opens? --- ## [Gateway and Clients](https://forum.inductiveautomation.com/t/gateway-and-clients/19194)
**Author:** [@rwoolnough](https://forum.inductiveautomation.com/u/rwoolnough)\ **Replies:** 6\ **Last updated:** [August 11, 2018, 12:06pm UTC](https://forum.inductiveautomation.com/t/gateway-and-clients/19194 "2018-08-11T12:06:13Z")
Hi All, Hopefully this is a simple question. I have been through the user manual and this forum with no clear answer, hence the question here. Recently the IT department migrated the Ignition Gateway and client o… --- ## [Ignition Port Usage](https://forum.inductiveautomation.com/t/ignition-port-usage/19208)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 1\ **Last updated:** [August 10, 2018, 10:49pm UTC](https://forum.inductiveautomation.com/t/ignition-port-usage/19208 "2018-08-10T22:49:45Z")
I have a customer that made this request. They want no traffic on port 8088 for security reasons. Is there a way to channel all Ignition activity through port 8043? I turned off the Windows firewall to test, and I foun… --- ## [Ignition Designer Dark Theme](https://forum.inductiveautomation.com/t/ignition-designer-dark-theme/19200)
**Author:** [@stuart.williams](https://forum.inductiveautomation.com/u/stuart.williams)\ **Replies:** 3\ **Last updated:** [August 10, 2018, 10:34pm UTC](https://forum.inductiveautomation.com/t/ignition-designer-dark-theme/19200 "2018-08-10T22:34:11Z")
Hello again everyone, Some colleagues and I were talking and we were wondering if Inductive had any plans of creating a "Dark Theme" for Ignition's Designer environment. Also, I was wondering what other developers th… --- ## [Inserting the last row of a pydataset into a database table](https://forum.inductiveautomation.com/t/inserting-the-last-row-of-a-pydataset-into-a-database-table/19203)
**Author:** [@comaife](https://forum.inductiveautomation.com/u/comaife)\ **Replies:** 4\ **Last updated:** [August 10, 2018, 8:12pm UTC](https://forum.inductiveautomation.com/t/inserting-the-last-row-of-a-pydataset-into-a-database-table/19203 "2018-08-10T20:12:27Z")
Hi: I want to insert the last row of a pydataset into an existing database. However, my current script adds the entire dataset each time it is executed. What modifications can I make to my script (below) to ensure only… --- ## [Historical Queries consuming Connections and Hanging, eventually Fault DB Connection](https://forum.inductiveautomation.com/t/historical-queries-consuming-connections-and-hanging-eventually-fault-db-connection/19199)
**Author:** [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\ **Replies:** 3\ **Last updated:** [August 10, 2018, 7:30pm UTC](https://forum.inductiveautomation.com/t/historical-queries-consuming-connections-and-hanging-eventually-fault-db-connection/19199 "2018-08-10T19:30:40Z")
Hello, I have some users reporting occasional Red Overlays on a Historical Page. I have noticed I get these query strings that hang as Active Queries on my Database Status Page. Is there anyway I can turn on some verbo… --- ## [ClientDBUtilities Keyword String Format](https://forum.inductiveautomation.com/t/clientdbutilities-keyword-string-format/19187)
**Author:** [@anthony.todd](https://forum.inductiveautomation.com/u/anthony.todd)\ **Replies:** 10\ **Last updated:** [August 10, 2018, 4:06pm UTC](https://forum.inductiveautomation.com/t/clientdbutilities-keyword-string-format/19187 "2018-08-10T16:06:42Z")
I am looking for the format of the keyword strings. I have not been able to find this in the documentation. Thank You, Anthony Todd --- ## [Increment tag ID to create a DataSet](https://forum.inductiveautomation.com/t/increment-tag-id-to-create-a-dataset/19173)
**Author:** [@Anne-Marie.Coupal](https://forum.inductiveautomation.com/u/Anne-Marie.Coupal)\ **Replies:** 2\ **Last updated:** [August 10, 2018, 4:06pm UTC](https://forum.inductiveautomation.com/t/increment-tag-id-to-create-a-dataset/19173 "2018-08-10T16:06:27Z")
Hi, I would like to know if there is a simple way to increment a tag ID. I am trying to read the value of different tags to create a dataset then, I want to put it in a table. headers = \["Status", "Permissive"\] blan… --- ## [Dropdown list horizontal scroll bar table mode](https://forum.inductiveautomation.com/t/dropdown-list-horizontal-scroll-bar-table-mode/19191)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 1\ **Last updated:** [August 10, 2018, 2:27pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-horizontal-scroll-bar-table-mode/19191 "2018-08-10T14:27:43Z")
I would like to have a horizontal scroll bar on my drop down list (table mode) so that my user can see all of the columns. Is this doable as of now? --- ## [Type Conversion error on switch statement](https://forum.inductiveautomation.com/t/type-conversion-error-on-switch-statement/19066)
**Author:** [@Anwesha\_Gupta](https://forum.inductiveautomation.com/u/Anwesha_Gupta)\ **Replies:** 2\ **Last updated:** [August 10, 2018, 8:45am UTC](https://forum.inductiveautomation.com/t/type-conversion-error-on-switch-statement/19066 "2018-08-10T08:45:49Z")
Hello All, I am trying to use a template repeater which has a component ‘Status’ (Integer). I am using the following code to drive the ‘Status’ . switch( {AllProjectsSite.SiteName}, ‘PoT’, ‘Broxburn’, ‘TynemouthA’, … --- ## [Users source migration](https://forum.inductiveautomation.com/t/users-source-migration/19166)
**Author:** [@r.lebohec](https://forum.inductiveautomation.com/u/r.lebohec)\ **Replies:** 4\ **Last updated:** [August 10, 2018, 7:17am UTC](https://forum.inductiveautomation.com/t/users-source-migration/19166 "2018-08-10T07:17:53Z")
Hi @Colby.Clegg is it a way to migrate an existing 'Internal User Source' with more than 50 users profiles to a new 'Database User Source'? My orignal issue is that, i'll like to restore backup on a production gateway … --- ## [Scrapping Weather Information from Weather Underground](https://forum.inductiveautomation.com/t/scrapping-weather-information-from-weather-underground/12668)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 1\ **Last updated:** [August 10, 2018, 4:59am UTC](https://forum.inductiveautomation.com/t/scrapping-weather-information-from-weather-underground/12668 "2018-08-10T04:59:30Z")
Tested against Ignition versions using python 2.5 (should also work with python 2.4). This document is attached in a cleanly formatted word doc \[ul\]1. Download json-py 2. Extract the three .py files (though technicall… --- ## [Getting Status from Remote Tag Provider](https://forum.inductiveautomation.com/t/getting-status-from-remote-tag-provider/19192)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 0\ **Last updated:** [August 10, 2018, 2:42am UTC](https://forum.inductiveautomation.com/t/getting-status-from-remote-tag-provider/19192 "2018-08-10T02:42:17Z")
Is there a way to get the OPC status from a Remote Tag Provider? I had a situation where a power outage corrupted an Ignition "Server". When it came back up, my local server connected to the remote server just fine, bu… --- ## [Project Settings Question](https://forum.inductiveautomation.com/t/project-settings-question/19190)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 4\ **Last updated:** [August 9, 2018, 11:14pm UTC](https://forum.inductiveautomation.com/t/project-settings-question/19190 "2018-08-09T23:14:33Z")
I have an application where one project will look at data from multiple sites. The application will be the same, but the database source and security settings will unique for each site. My thinking is to have a generic … --- ## [system.nav.goBack() buggy in 7.9.5?](https://forum.inductiveautomation.com/t/system-nav-goback-buggy-in-7-9-5/16768)
**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\ **Replies:** 5\ **Last updated:** [August 9, 2018, 10:05pm UTC](https://forum.inductiveautomation.com/t/system-nav-goback-buggy-in-7-9-5/16768 "2018-08-09T22:05:15Z")
I've recently upgraded to 7.9.5 on a project (it was 7.9.3 before) and I've noticed that the system.nav.goBack() function doesn't seem to be working reliably. If I navigate through three screens and press a button using … --- ## [Logging bar code data and seeing if it's been scanned twice](https://forum.inductiveautomation.com/t/logging-bar-code-data-and-seeing-if-its-been-scanned-twice/19184)
**Author:** [@stephen.c.wilbur](https://forum.inductiveautomation.com/u/stephen.c.wilbur)\ **Replies:** 1\ **Last updated:** [August 9, 2018, 9:20pm UTC](https://forum.inductiveautomation.com/t/logging-bar-code-data-and-seeing-if-its-been-scanned-twice/19184 "2018-08-09T21:20:39Z")
We are trying to use ignition to data log from a barcode scanner. We also want the ability to if a barcode is scanned twice to write back to the plc with an error. Is this possible within ignition? Warning--- I am a l… --- ## [UDT instances, displaying 'null' values on memory & expression tags](https://forum.inductiveautomation.com/t/udt-instances-displaying-null-values-on-memory-expression-tags/19189)
**Author:** [@user1](https://forum.inductiveautomation.com/u/user1)\ **Replies:** 1\ **Last updated:** [August 9, 2018, 9:17pm UTC](https://forum.inductiveautomation.com/t/udt-instances-displaying-null-values-on-memory-expression-tags/19189 "2018-08-09T21:17:46Z")
Hey, Currently I have UDTs that have 3 OPC tags bringing in values, and also has several expression tags that run some calcs then places the results in the memory tags. I currently have several instances that are using … --- ## [Moving History from one tag to another](https://forum.inductiveautomation.com/t/moving-history-from-one-tag-to-another/19188)
**Author:** [@user1](https://forum.inductiveautomation.com/u/user1)\ **Replies:** 0\ **Last updated:** [August 9, 2018, 8:29pm UTC](https://forum.inductiveautomation.com/t/moving-history-from-one-tag-to-another/19188 "2018-08-09T20:29:24Z")
I'm curious what would be the correct way to migrate history from on tag to another? For example a old tag structure from a previous integrator will be replaced with our structure. Right now both are connecting to kepw… --- ## [Can Schedule Management Times/Status be used outside of user management?](https://forum.inductiveautomation.com/t/can-schedule-management-times-status-be-used-outside-of-user-management/19186)
**Author:** [@bpreston](https://forum.inductiveautomation.com/u/bpreston)\ **Replies:** 0\ **Last updated:** [August 9, 2018, 7:28pm UTC](https://forum.inductiveautomation.com/t/can-schedule-management-times-status-be-used-outside-of-user-management/19186 "2018-08-09T19:28:06Z")
I have reports that are being run each shift and the shift times match the schedules that are set up in schedule management. I'd like to be able to pull out the status for the schedule(if its active or not). I have … --- ## [Script Console doesn't use full screen when maximized](https://forum.inductiveautomation.com/t/script-console-doesnt-use-full-screen-when-maximized/19170)
**Author:** [@Herbie](https://forum.inductiveautomation.com/u/Herbie)\ **Replies:** 4\ **Last updated:** [August 9, 2018, 5:43pm UTC](https://forum.inductiveautomation.com/t/script-console-doesnt-use-full-screen-when-maximized/19170 "2018-08-09T17:43:05Z")
I am using a multiple monitor setup on my Windows 7 machine. When I choose to use my second or third monitor (not the primary) and I maximize the Script Console, it does not fill the entire monitor. This occurs whether… --- ## [Project Memory/Tag Structure With Duplicate Device IP](https://forum.inductiveautomation.com/t/project-memory-tag-structure-with-duplicate-device-ip/19172)
**Author:** [@19tb21](https://forum.inductiveautomation.com/u/19tb21)\ **Replies:** 3\ **Last updated:** [August 9, 2018, 5:11pm UTC](https://forum.inductiveautomation.com/t/project-memory-tag-structure-with-duplicate-device-ip/19172 "2018-08-09T17:11:09Z")
Good Morning, I am getting ready to commission a program change on an Allen Bradley CompactLogix PLC. I intend to test the changes with an Ignition HMI I have built. However right now, I have no OPC tag binding set-up… --- ## [What's my mssql JDBC driver classname?](https://forum.inductiveautomation.com/t/whats-my-mssql-jdbc-driver-classname/19180)
**Author:** [@brian.kehn](https://forum.inductiveautomation.com/u/brian.kehn)\ **Replies:** 5\ **Last updated:** [August 9, 2018, 4:44pm UTC](https://forum.inductiveautomation.com/t/whats-my-mssql-jdbc-driver-classname/19180 "2018-08-09T16:44:52Z")
Does anyone know how to find the classname for the JDBC MS Sql Server driver? When I run this code I get a driver not found error. def testSPCall(): from com.ziclix.python.sql import zxJDBC, Procedure # #create datab… --- ## [RV50 SMS module error send text without country code](https://forum.inductiveautomation.com/t/rv50-sms-module-error-send-text-without-country-code/18705)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 3\ **Last updated:** [August 9, 2018, 4:34pm UTC](https://forum.inductiveautomation.com/t/rv50-sms-module-error-send-text-without-country-code/18705 "2018-08-09T16:34:00Z")
Using the RV50x I’m trying to send an SMS without putting the “1” country code for the USA on the front of my 10 digit phone number. For some reason it is almost always rejected with the message ########## Error Invali… --- ## [Reporting for Ignition - XLReporter](https://forum.inductiveautomation.com/t/reporting-for-ignition-xlreporter/19169)
**Author:** [@timd](https://forum.inductiveautomation.com/u/timd)\ **Replies:** 0\ **Last updated:** [August 9, 2018, 1:28pm UTC](https://forum.inductiveautomation.com/t/reporting-for-ignition-xlreporter/19169 "2018-08-09T13:28:24Z")
XLReporter from Sytech,TheReportCompany.com has 3 data connectors for Ignition. Real-time values, Historical values and data from Ignition Transaction Group are available in XLReporter with no scripting. For more inform… --- ## [Historical pie chart](https://forum.inductiveautomation.com/t/historical-pie-chart/19160)
**Author:** [@Scott.Hann](https://forum.inductiveautomation.com/u/Scott.Hann)\ **Replies:** 1\ **Last updated:** [August 9, 2018, 3:17pm UTC](https://forum.inductiveautomation.com/t/historical-pie-chart/19160 "2018-08-09T15:17:32Z")
I’m trying to compare the power consumption over a region of time for two different areas. I’ve set each tag to log to historian, and bound the Data property of the pie chart to Tag History of the two tags. So, it turns … --- ## [Alarm visibility based on priority - Need Help](https://forum.inductiveautomation.com/t/alarm-visibility-based-on-priority-need-help/19146)
**Author:** [@thomasdouglasshank](https://forum.inductiveautomation.com/u/thomasdouglasshank)\ **Replies:** 22\ **Last updated:** [August 9, 2018, 12:17pm UTC](https://forum.inductiveautomation.com/t/alarm-visibility-based-on-priority-need-help/19146 "2018-08-09T12:17:48Z")
Hello Ignition Forums! Excuse my lack of scripting knowledge, still a nube in training :slight\_smile: I have been given a task that requires me to prioritize the visibility of alarms based on low to critical priority… --- ## [Full Window Mode- Designer](https://forum.inductiveautomation.com/t/full-window-mode-designer/19159)
**Author:** [@kartithamizhchelvan](https://forum.inductiveautomation.com/u/kartithamizhchelvan)\ **Replies:** 1\ **Last updated:** [August 9, 2018, 12:26am UTC](https://forum.inductiveautomation.com/t/full-window-mode-designer/19159 "2018-08-09T00:26:52Z")
Hi Everyone, I have an issue while maximizing the window size. I changed the memory allocation for designer in the settings on the Ignition gateway. Is there a way to resolve this?. I am using multiple displays and als… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1616) [Next page](https://forum.inductiveautomation.com/latest.md?page=1618)