# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=516 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 517 --- ## [Ignition Designer: View Only?](https://forum.inductiveautomation.com/t/ignition-designer-view-only/83387)
**Author:** [@diamond](https://forum.inductiveautomation.com/u/diamond)\ **Replies:** 4\ **Last updated:** [December 20, 2023, 7:48pm UTC](https://forum.inductiveautomation.com/t/ignition-designer-view-only/83387 "2023-12-20T19:48:51Z")
Hello, I was wondering if there is any option for restricting access to ignition designer projects / gateway in some way. We often come across junior developers or auditors who need to be able to view the code/overall p… --- ## [Custom keyboard shortcuts?](https://forum.inductiveautomation.com/t/custom-keyboard-shortcuts/82092)
**Author:** [@Kelltek](https://forum.inductiveautomation.com/u/Kelltek)\ **Replies:** 16\ **Last updated:** [December 20, 2023, 7:20pm UTC](https://forum.inductiveautomation.com/t/custom-keyboard-shortcuts/82092 "2023-12-20T19:20:41Z")
I have looked around the forums and feature requests but either the related options I was able to find are for specific actions or the crawlers pick up everything related to the runtime layout. Is there a way (even hack… --- ## [Spinner button size](https://forum.inductiveautomation.com/t/spinner-button-size/9354)
**Author:** [@DavidWisely](https://forum.inductiveautomation.com/u/DavidWisely)\ **Replies:** 10\ **Last updated:** [December 20, 2023, 6:28pm UTC](https://forum.inductiveautomation.com/t/spinner-button-size/9354 "2023-12-20T18:28:51Z")
Is there any way to make the buttons on the spinner wider? Resizing the spinner only adjusts the button height, but not the width. I will be using Ignition in a touch panel and would like wider buttons so they are easi… --- ## [Printing now(), different output, I am confused](https://forum.inductiveautomation.com/t/printing-now-different-output-i-am-confused/83341)
**Author:** [@Eugene49](https://forum.inductiveautomation.com/u/Eugene49)\ **Replies:** 5\ **Last updated:** [December 20, 2023, 5:38pm UTC](https://forum.inductiveautomation.com/t/printing-now-different-output-i-am-confused/83341 "2023-12-20T17:38:09Z")
So I am processing and printing time. Depending on where I use it, output is different. I want to understand what is the general rule, so I can code properly. below is what I experienced: timeNow = system.date.now()… --- ## [Export Data - Choose or create export file](https://forum.inductiveautomation.com/t/export-data-choose-or-create-export-file/83371)
**Author:** [@HelloWorld](https://forum.inductiveautomation.com/u/HelloWorld)\ **Replies:** 9\ **Last updated:** [December 20, 2023, 4:23pm UTC](https://forum.inductiveautomation.com/t/export-data-choose-or-create-export-file/83371 "2023-12-20T16:23:10Z")
results = system.db.runNamedQuery("Fetch Records",{}) spreadsheet = system.dataset.toExcel(True, \[results\]) filePath = "C:\\\\output\\\\results.xlsx" system.file.writeFile(filePath, spreadsheet) Instead of hard coding the f… --- ## [Tags Broken when opened in client](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378)
**Author:** [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\ **Replies:** 8\ **Last updated:** [December 20, 2023, 4:17pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378 "2023-12-20T16:17:19Z")
I am new to ignition and this is my first project. I have created a KPI Project where I am pulling data from an existing SQL on an existing gateway. I created a bunch of charts. Its working well in designer but when I op… --- ## [\[IGN-1181\] TabIndex in textboxes in perspective](https://forum.inductiveautomation.com/t/ign-1181-tabindex-in-textboxes-in-perspective/83366)
**Author:** [@SHIJI\_SASI](https://forum.inductiveautomation.com/u/SHIJI_SASI)\ **Replies:** 2\ **Last updated:** [December 20, 2023, 4:15pm UTC](https://forum.inductiveautomation.com/t/ign-1181-tabindex-in-textboxes-in-perspective/83366 "2023-12-20T16:15:04Z")
Hello , How can tab index be utilized in textboxes and dropdowns in perspective? Is it possible to specify the tab order for components, including numeric textboxes? Thanks, Shiji --- ## [Calling Stored Procedure Error](https://forum.inductiveautomation.com/t/calling-stored-procedure-error/83379)
**Author:** [@Nicholas\_Houston](https://forum.inductiveautomation.com/u/Nicholas_Houston)\ **Replies:** 3\ **Last updated:** [December 20, 2023, 4:13pm UTC](https://forum.inductiveautomation.com/t/calling-stored-procedure-error/83379 "2023-12-20T16:13:49Z")
I'm trying to EXEC a stored procedure just using the Query Browser for now. I keep getting an error for the stored procedure stating 'A result set was generated for update'. I have attached images. Is this something wron… --- ## [Unable to import tag JSON list in UDT, new or existing](https://forum.inductiveautomation.com/t/unable-to-import-tag-json-list-in-udt-new-or-existing/83313)
**Author:** [@ian.sebryk](https://forum.inductiveautomation.com/u/ian.sebryk)\ **Replies:** 15\ **Last updated:** [December 20, 2023, 2:39pm UTC](https://forum.inductiveautomation.com/t/unable-to-import-tag-json-list-in-udt-new-or-existing/83313 "2023-12-20T14:39:43Z")
i will not manually add 250+ tags to my UDT through the UI. that's just :ox: :tshirt: . when i import an edited list, i get the following error: when i export an existing tag list and try to import it immediately, w… --- ## [Connecting siemens s71200 real tag to ignition](https://forum.inductiveautomation.com/t/connecting-siemens-s71200-real-tag-to-ignition/83368)
**Author:** [@Alex\_Evans](https://forum.inductiveautomation.com/u/Alex_Evans)\ **Replies:** 2\ **Last updated:** [December 20, 2023, 2:07pm UTC](https://forum.inductiveautomation.com/t/connecting-siemens-s71200-real-tag-to-ignition/83368 "2023-12-20T14:07:33Z")
Hi, I have a siemens s7-1200 connected to ignition but need to connect a real tag onto there but don't know what data type to use as the tag? Thanks in advance, Alex --- ## [Report Script error "PyDataSet indices must be integers"](https://forum.inductiveautomation.com/t/report-script-error-pydataset-indices-must-be-integers/83337)
**Author:** [@JinGeun\_Kim](https://forum.inductiveautomation.com/u/JinGeun_Kim)\ **Replies:** 4\ **Last updated:** [December 20, 2023, 1:30pm UTC](https://forum.inductiveautomation.com/t/report-script-error-pydataset-indices-must-be-integers/83337 "2023-12-20T13:30:27Z")
A report script error occurs. It is the same message as the previous error, but the cause cannot be found. Help me!! from system.dataset import toDataSet #from datetime import datetime #start\_date = data\["StartDate"\] #e… --- ## [Read Siemens S1500 Date\_And\_Time value](https://forum.inductiveautomation.com/t/read-siemens-s1500-date-and-time-value/83348)
**Author:** [@Xiao\_Xiao](https://forum.inductiveautomation.com/u/Xiao_Xiao)\ **Replies:** 12\ **Last updated:** [December 20, 2023, 1:28pm UTC](https://forum.inductiveautomation.com/t/read-siemens-s1500-date-and-time-value/83348 "2023-12-20T13:28:10Z")
I try to read a "Date\_And\_Time" value in PLC I used the datetime tag The quaility is My colleague said they used LDT to fix the problem. But in my case, the datablock is an interface that means there will be a … --- ## [Security setting on a oneshot button](https://forum.inductiveautomation.com/t/security-setting-on-a-oneshot-button/83364)
**Author:** [@Michael\_Johannsen](https://forum.inductiveautomation.com/u/Michael_Johannsen)\ **Replies:** 4\ **Last updated:** [December 20, 2023, 1:14pm UTC](https://forum.inductiveautomation.com/t/security-setting-on-a-oneshot-button/83364 "2023-12-20T13:14:59Z")
I have an oneshot button with Security settings on it, tied to different roles, but it does not work. It works on a normal button. Does anybody have the same problem? --- ## [Deleting Large Amount of Tags from Tag Browser](https://forum.inductiveautomation.com/t/deleting-large-amount-of-tags-from-tag-browser/82741)
**Author:** [@Liam\_Dietrich](https://forum.inductiveautomation.com/u/Liam_Dietrich)\ **Replies:** 18\ **Last updated:** [December 20, 2023, 12:49pm UTC](https://forum.inductiveautomation.com/t/deleting-large-amount-of-tags-from-tag-browser/82741 "2023-12-20T12:49:07Z")
I accidently added all of the controller tags from a PLC, including thousands of tags I do not need. Every time I attempt to delete the tags the Gateway crashes and I need to restart it. Are there any tricks or tips to … --- ## [Perspective Symbol Animation](https://forum.inductiveautomation.com/t/perspective-symbol-animation/83352)
**Author:** [@Chandrakant\_Hiwale](https://forum.inductiveautomation.com/u/Chandrakant_Hiwale)\ **Replies:** 5\ **Last updated:** [December 20, 2023, 12:52pm UTC](https://forum.inductiveautomation.com/t/perspective-symbol-animation/83352 "2023-12-20T12:52:21Z")
Hi, I am looking for Perspective Animation for pipe filling colour linearly. I have to do pipes and tank animation , the problem is that the colour of the pipe and have to change following the flow in the pipe. i am us… --- ## [Hide and Unhide rows in Dropdown](https://forum.inductiveautomation.com/t/hide-and-unhide-rows-in-dropdown/83361)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 2\ **Last updated:** [December 20, 2023, 12:33pm UTC](https://forum.inductiveautomation.com/t/hide-and-unhide-rows-in-dropdown/83361 "2023-12-20T12:33:06Z")
Hi, I have dropdown and having 3 rows I want to hide last row and show only first 2 rows Is there any dynamic way to do this? --- ## [Using another column's value as property from same database](https://forum.inductiveautomation.com/t/using-another-columns-value-as-property-from-same-database/83362)
**Author:** [@Anamay\_Belekar](https://forum.inductiveautomation.com/u/Anamay_Belekar)\ **Replies:** 1\ **Last updated:** [December 20, 2023, 12:20pm UTC](https://forum.inductiveautomation.com/t/using-another-columns-value-as-property-from-same-database/83362 "2023-12-20T12:20:38Z")
I have create a dataset with 2 main columns, tag name and tag path The TAG\_PATH column has value of the tag name (value from NAME column) in it. Can I use the column NAME as property in cell binding for column TAG\_P… --- ## [How to concatenate rows in dataset in Ignition](https://forum.inductiveautomation.com/t/how-to-concatenate-rows-in-dataset-in-ignition/83358)
**Author:** [@Anamay\_Belekar](https://forum.inductiveautomation.com/u/Anamay_Belekar)\ **Replies:** 4\ **Last updated:** [December 20, 2023, 12:12pm UTC](https://forum.inductiveautomation.com/t/how-to-concatenate-rows-in-dataset-in-ignition/83358 "2023-12-20T12:12:35Z")
I want to concatenate rows in a dataset. I came across same thing but it is for concatenating column - groupConcat. But I want to do it for rows. --- ## [Reading unpredictable input from serial port](https://forum.inductiveautomation.com/t/reading-unpredictable-input-from-serial-port/83360)
**Author:** [@Jiri\_Pise](https://forum.inductiveautomation.com/u/Jiri_Pise)\ **Replies:** 1\ **Last updated:** [December 20, 2023, 12:06pm UTC](https://forum.inductiveautomation.com/t/reading-unpredictable-input-from-serial-port/83360 "2023-12-20T12:06:08Z")
Hello, I want to read data from serial port in vision. I have experimented with system.serial but there seems to be no way to read unpredictable inputs. I cannot use readBytesAsString since I dont know how many bytes wi… --- ## [How to transpose a dataset using ignition expression?](https://forum.inductiveautomation.com/t/how-to-transpose-a-dataset-using-ignition-expression/83356)
**Author:** [@Anamay\_Belekar](https://forum.inductiveautomation.com/u/Anamay_Belekar)\ **Replies:** 1\ **Last updated:** [December 20, 2023, 12:01pm UTC](https://forum.inductiveautomation.com/t/how-to-transpose-a-dataset-using-ignition-expression/83356 "2023-12-20T12:01:43Z")
I have a dataset in custom property of a component and in another custom property I want to write the transpose of that dataset. Is it really possible with ignition expression? --- ## [Global variable error inside tag change script](https://forum.inductiveautomation.com/t/global-variable-error-inside-tag-change-script/83322)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 3\ **Last updated:** [December 20, 2023, 11:47am UTC](https://forum.inductiveautomation.com/t/global-variable-error-inside-tag-change-script/83322 "2023-12-20T11:47:40Z")
Hello, I run this code successfully in the console script but when I try to run this tag change script I get this error: global name 'contents' is not defined I define content as global inside my assign function but py… --- ## [Import images using scripting](https://forum.inductiveautomation.com/t/import-images-using-scripting/83300)
**Author:** [@Artem\_Eremeev](https://forum.inductiveautomation.com/u/Artem_Eremeev)\ **Replies:** 3\ **Last updated:** [December 20, 2023, 11:13am UTC](https://forum.inductiveautomation.com/t/import-images-using-scripting/83300 "2023-12-20T11:13:43Z")
I am trying to use that ImageManager.insertImage function with code like this: from com.inductiveautomation.ignition.gateway import IgnitionGateway from com.inductiveautomation.ignition.gateway.images import ImageFormat… --- ## [Ignition Tab Container losing custom variable when changing tab](https://forum.inductiveautomation.com/t/ignition-tab-container-losing-custom-variable-when-changing-tab/83304)
**Author:** [@r.p](https://forum.inductiveautomation.com/u/r.p)\ **Replies:** 15\ **Last updated:** [December 20, 2023, 10:49am UTC](https://forum.inductiveautomation.com/t/ignition-tab-container-losing-custom-variable-when-changing-tab/83304 "2023-12-20T10:49:10Z")
Hello, I have the following SSCCE (Simple Self Contained Code Example) of an undesired behaviour in the Tab container component of ignition: I have a Tab container with two subviews (Tab1 and Tab2), I have created a… --- ## [Ability for a reference tag or any other type to point to the source tag history without data duplication (for use in perspective dashboards)](https://forum.inductiveautomation.com/t/ability-for-a-reference-tag-or-any-other-type-to-point-to-the-source-tag-history-without-data-duplication-for-use-in-perspective-dashboards/82208)
**Author:** [@Nicky\_Goethals](https://forum.inductiveautomation.com/u/Nicky_Goethals)\ **Replies:** 3\ **Last updated:** [December 20, 2023, 9:30am UTC](https://forum.inductiveautomation.com/t/ability-for-a-reference-tag-or-any-other-type-to-point-to-the-source-tag-history-without-data-duplication-for-use-in-perspective-dashboards/82208 "2023-12-20T09:30:44Z")
Hi All, I'm currently looking for a solution to the following problem. We would like to make a setup like this. INTERNAL Tag Structure location\_1 \> technical\_category\_1 \> sub\_category\_1 \> sub\_category\_n \> type\_1 \> dev… --- ## [Power Chart pen defaultstyle](https://forum.inductiveautomation.com/t/power-chart-pen-defaultstyle/83285)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 1\ **Last updated:** [December 20, 2023, 8:07am UTC](https://forum.inductiveautomation.com/t/power-chart-pen-defaultstyle/83285 "2023-12-20T08:07:26Z")
Hello power users! Simple question here about the power chart in Perspective. When I drag and drop a tag in the chart, a new pen in created in the pens collection. How can I make sur the default stroke width is 2? Beca… --- ## [Embedded After Change how to resize?](https://forum.inductiveautomation.com/t/embedded-after-change-how-to-resize/83349)
**Author:** [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\ **Replies:** 1\ **Last updated:** [December 20, 2023, 7:51am UTC](https://forum.inductiveautomation.com/t/embedded-after-change-how-to-resize/83349 "2023-12-20T07:51:46Z")
In Perspective,I add Embedded Template. Then I add it in Page. But After a while,I need to change the embedded template. How to resize it in Page? Now I have to click it and change its Size.It's more troubleso… --- ## [Google MAP error in initiating](https://forum.inductiveautomation.com/t/google-map-error-in-initiating/83342)
**Author:** [@ignitionSL](https://forum.inductiveautomation.com/u/ignitionSL)\ **Replies:** 4\ **Last updated:** [December 20, 2023, 5:26am UTC](https://forum.inductiveautomation.com/t/google-map-error-in-initiating/83342 "2023-12-20T05:26:40Z")
When I add the Google map. Why does it give the following error? --- ## [Is a possible to insert device details in SQL through ignition?](https://forum.inductiveautomation.com/t/is-a-possible-to-insert-device-details-in-sql-through-ignition/83252)
**Author:** [@Govind\_Suthar1](https://forum.inductiveautomation.com/u/Govind_Suthar1)\ **Replies:** 6\ **Last updated:** [December 20, 2023, 4:57am UTC](https://forum.inductiveautomation.com/t/is-a-possible-to-insert-device-details-in-sql-through-ignition/83252 "2023-12-20T04:57:59Z")
Hello everyone, I have a question about the SQL query in ignition. Is it possible to insert new device details in SQL through a query using ignition UI? Example,Suppose in the ignition four sensors are connected. (Like… --- ## [Alarms set bit state,how to set Event Value equal to bit value?](https://forum.inductiveautomation.com/t/alarms-set-bit-state-how-to-set-event-value-equal-to-bit-value/77117)
**Author:** [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\ **Replies:** 4\ **Last updated:** [December 20, 2023, 2:37am UTC](https://forum.inductiveautomation.com/t/alarms-set-bit-state-how-to-set-event-value-equal-to-bit-value/77117 "2023-12-20T02:37:05Z")
Tag Alarms set Bit State. How to set Event Value equal to Bit value ,not to Value? --- ## [Perspective Icon Manager import Inkscape Svg](https://forum.inductiveautomation.com/t/perspective-icon-manager-import-inkscape-svg/83305)
**Author:** [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\ **Replies:** 3\ **Last updated:** [December 20, 2023, 1:48am UTC](https://forum.inductiveautomation.com/t/perspective-icon-manager-import-inkscape-svg/83305 "2023-12-20T01:48:34Z")
I download the project from Ignition Exchange- Perspective Icon Manager Ignition Exchange | Inductive Automation I draw a svg in Inksacpe.When I import it into the project. It shows many files. In Perspective can't se… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=515) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=517)