Post Handheld Data to a Database, a File or a Web Service
Send what workers collect to a database table, a file or Excel workbook, or a web service. Every send is one sentence, and a Post button runs them all.
What you will learn
- Set up a send to a database table and match its columns
- Decide what happens when a send cannot be completed
- See how file, Excel and web service sends work
- Add a Post button for the worker
Transcript
In this guide you will send the data a worker collects to its destination. We will set up a send to a database table, and then look at sending to a file and to a web service, and add a Post button for the worker.
This app, Count Sync, collects an Item and a Quantity. A database connection to the server has already been added. Open Data, then Send data. Here you choose where the data goes: a database table, a file or Excel workbook, or a web service.
Choose A database table. Every send reads as one sentence. When Post is pressed, send this entry, add a new row, in the database connection. Pick the connection, and type the name of the table.
Under Columns, press Match by name. StepVane gives each column the field with the same name, here the item, the quantity, and the time it was counted. You can also add a column yourself, and choose which field or value fills it.
Scroll down to decide what happens if the send cannot be completed. By default the entry is kept on the phone and sent later, once, so a worker with no signal never loses a count.
Add another send for a file or Excel workbook. The sentence is the same: when, what, and how, in a file connection. A file connection is added the same way as a database one, and the columns work the same way too.
And a send to a web service. Here you choose the method, whether to send all the lines in one request, and you shape the request body the endpoint expects. The inventory guide shows this in detail.
Last, the worker needs a button. Press Make a Post button, and StepVane adds one to the page, ready to send everything you set up. Sends that are not on a button can run after each sync, or on a schedule.
That is how you post data. Each send is one sentence: when, what, and where. Use as many sends as you need, so one Post can reach a database, a file and a web service.
Related
More guides
Start with one device today
Free for Studio, one handheld and one worker. No cloud account, no credit card.