# Perspective Manual Data Entry to SQL?

**URL:** <https://forum.inductiveautomation.com/t/perspective-manual-data-entry-to-sql/40823>\
**Category:** Ignition\
**Tags:** perspective, ignition80\
**Created:** [November 19, 2020, 9:06pm UTC](https://forum.inductiveautomation.com/t/perspective-manual-data-entry-to-sql/40823 "2020-11-19T21:06:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mason.Younger](https://avatars.discourse-cdn.com/v4/letter/m/50afbb/32.png) [@Mason.Younger](https://forum.inductiveautomation.com/u/Mason.Younger)\
**Post date:** [November 19, 2020, 9:06pm UTC](https://forum.inductiveautomation.com/t/perspective-manual-data-entry-to-sql/40823/1 "2020-11-19T21:06:13Z")

</div>

I’m trying to create a data entry page for operation to capture data points that are not collected in the PLC, things like planned downtime, scrap, etc.

What is the most efficient way of writing property values (text boxes and label values) to a SQL table along with tag values?

I can write the stored procedure to handle the DB side, but not sure on the ignition/scripting side.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/5/a5d7c5aafa63c8d1c94b58ed38c0c653a8625844.png)

Thank you!

---

<div class="post-metadata">

**Author:** ![rbabcock](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rbabcock/32/13425_2.png) [@rbabcock](https://forum.inductiveautomation.com/u/rbabcock)\
**Post date:** [November 20, 2020, 1:05pm UTC](https://forum.inductiveautomation.com/t/perspective-manual-data-entry-to-sql/40823/2 "2020-11-20T13:05:37Z")

</div>

On your “Write this data to SQL” button I would make an ‘onActionPerformed’ script that gathers all the data, like a list or dictionary, or some combination. Use something like:

```auto
SQL['scrapReels']['value'] = self.getSibling("Scrap Reels Input Component").props.text

```

to get the data from each component. To use a stored procedure, if that particular flavor is supported, you’ll also need to send an index and “system.db.” with each parameter.

[https://docs.inductiveautomation.com/display/DOC80/SQL+Stored+Procedures#SQLStoredProcedures-StoredProceduresinPythonScripts](https://docs.inductiveautomation.com/display/DOC80/SQL+Stored+Procedures#SQLStoredProcedures-StoredProceduresinPythonScripts)

I apologize if all that is too vague, the question itself is pretty broad. I will be happy to clarify any point(s), though, just ask 🙂