| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-219582 - Install New Scale Web Service for LV Controls.|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-219582]
We have created a test version of the exiting web service that is now pointed to the westloTE data base on Westlock in IIS.
I then created the origin table westloTE.dbo.gasctmst on the server.
After that we were able to run the new TE web service to insert a row to the origin table.
The more I think about this, what we need now is likely not a view. We need something that points to i21 tables mapping back to the fields in gasctmst. The table gastmst as well as all fields in that table must be kept as is, including that exact name, as the origin programs require it. The i21 view needs to be able to allow that inserted data to be pushed to the corresponding i21 tables and fields.
It seems to me this may be some sort of triggered SP. It would need to take the data from gasctmst, do the mapping (like a view) to the i21 fields to insert to all the correct tables and then remove that processed record from gasctmst. I know it woudl for sure insert in to tblscticket and tblscticketdiscount, possibly tblscticketsplit and maybe others I am not famliar with.
!pastedImage_d106760_0.png!
NOTE: just to be clear, we are not taking data in i21 and using the view to see that data as a view named gasctmst. We have no need for that. We need to push data in to i21 from a table holding the origin values temporarily.
As an example, I inserted this row in to gasctmst using the LV control webservice (in westloTE DB)
!pastedImage_d106760_1.png!
I would expect to be able to go in i21 scale and see this ticket now.
!pastedImage_d106760_2.png!
|