Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
Web Server - Ask For Help / NT 14.20 API error
« on: August 31, 2024, 04:10:02 PM »
Hello all,
I'm getting an error 40 when trying to use an API to delete a record. I'm trying from the JSON Post example created in the API documentation in my app.
Please see attached image JSONPOST.png. I'm confused by the error definition as it indicates trying to save a record when I'm trying to delete a record.
Interestingly, the HTTPGET method does delete the record as expected. See image HTTPGET.png
I cannot see where the issue is in the JSONPOST. Can anyone help?
Thanks,
Jeff
I'm getting an error 40 when trying to use an API to delete a record. I'm trying from the JSON Post example created in the API documentation in my app.
Please see attached image JSONPOST.png. I'm confused by the error definition as it indicates trying to save a record when I'm trying to delete a record.
Interestingly, the HTTPGET method does delete the record as expected. See image HTTPGET.png
I cannot see where the issue is in the JSONPOST. Can anyone help?
Thanks,
Jeff
2
Web Server - Ask For Help / Media field type question, part 4
« on: August 26, 2024, 12:10:04 PM »
Hi Bruce,
I'm still working on my app with the Media field type on a form. One thing I have noticed is the Media field stays at the width and height set in the template...that is it is not responsive to resizing the containing form. Please see the attached image. Can you suggest a way to make the Media field width be bound to the right margin and the height to be bound to the bottom margin? I'm looking for some CSS to add to my custom.css file but have not found anything yet.
Thanks,
Jeff King
I'm still working on my app with the Media field type on a form. One thing I have noticed is the Media field stays at the width and height set in the template...that is it is not responsive to resizing the containing form. Please see the attached image. Can you suggest a way to make the Media field width be bound to the right margin and the height to be bound to the bottom margin? I'm looking for some CSS to add to my custom.css file but have not found anything yet.
Thanks,
Jeff King
3
Web Server - Ask For Help / Media field type question, part 3
« on: August 19, 2024, 10:46:57 AM »
Hello all,
I have the Media field type working pretty well now. However, I would like to be able to hide or disable certain functions on the Media field menu/tool bar. For example, I don't want the user to be able to print or save the viewed PDF. Is it possible to control these menu/tool bar options?
Thanks,
Jeff King
I have the Media field type working pretty well now. However, I would like to be able to hide or disable certain functions on the Media field menu/tool bar. For example, I don't want the user to be able to print or save the viewed PDF. Is it possible to control these menu/tool bar options?
Thanks,
Jeff King
4
Web Server - Ask For Help / Media field type on tabbed form, questions, part 2
« on: August 17, 2024, 05:12:44 PM »
Hello,
In part 1 of this topic, I mentioned I had the Media field type on a tab, of a multi-tab form, to display a PDF document. This works but is a bit cumbersome, moving between the PDF tab and other tabs where data is to be entered. Instead, I would like the Media field to display the PDF document to the right of the tabs on the form.
The only way I can think to do this, is to create a memory form, and place two procedures on it. One for the actual tabbed update form and one for the display of the PDF in a Media field. I have this memory form called by the corresponding browse and it does look good. However, the update form on this memory form, does not do Inserts, Changes, or Deletes. Is there a way to code this to properly update my target file from the memory form? I'm looking at the "Browseless Form" section in the NetTalk book, but so far I have not made this work.
Thank you,
Jeff King
In part 1 of this topic, I mentioned I had the Media field type on a tab, of a multi-tab form, to display a PDF document. This works but is a bit cumbersome, moving between the PDF tab and other tabs where data is to be entered. Instead, I would like the Media field to display the PDF document to the right of the tabs on the form.
The only way I can think to do this, is to create a memory form, and place two procedures on it. One for the actual tabbed update form and one for the display of the PDF in a Media field. I have this memory form called by the corresponding browse and it does look good. However, the update form on this memory form, does not do Inserts, Changes, or Deletes. Is there a way to code this to properly update my target file from the memory form? I'm looking at the "Browseless Form" section in the NetTalk book, but so far I have not made this work.
Thank you,
Jeff King
5
Web Server - Ask For Help / Media field type on tabbed form, questions, part 1
« on: August 17, 2024, 04:57:54 PM »
Hello everyone,
I have placed a Media field type on the last tab of a multi tab form. The idea is to allow the user to view a PDF of a report, from which they will do manual data entry. The source of the PDF documents is in the uploads folder under the web folder. The Media control will only download the PDF document and not display it. However, if I place the PDF documents directly in the web folder, they do display as expected. On the Media field's Media tab, I set the URL to the following:
'\uploads\'&p_web.GSV('InvPHI:Patient_ID')&'.pdf'
When I put the PDF's in the web folder, I use the following:
p_web.GSV('InvPHI:Patient_ID')&'.pdf'
The same thing happens in the example app web74. Can anyone offer a solution? I really want the PDF's to be in the uploads folder, or some other custom folder, not in the web folder.
Thank you,
Jeff King
I have placed a Media field type on the last tab of a multi tab form. The idea is to allow the user to view a PDF of a report, from which they will do manual data entry. The source of the PDF documents is in the uploads folder under the web folder. The Media control will only download the PDF document and not display it. However, if I place the PDF documents directly in the web folder, they do display as expected. On the Media field's Media tab, I set the URL to the following:
'\uploads\'&p_web.GSV('InvPHI:Patient_ID')&'.pdf'
When I put the PDF's in the web folder, I use the following:
p_web.GSV('InvPHI:Patient_ID')&'.pdf'
The same thing happens in the example app web74. Can anyone offer a solution? I really want the PDF's to be in the uploads folder, or some other custom folder, not in the web folder.
Thank you,
Jeff King
6
Web Server - Ask For Help / File Upload button on MemForm
« on: May 23, 2024, 04:12:36 PM »
Hi Bruce,
I'm trying to use a MemForm, with a single FileUpload button on it, to upload files to the web\uploads folder. The web log does show the POST /dataupload event but the actual file is not in the uploads folder. I have tried this running a local exe and also from a server using a dll with the multi-site host.
I have run the example app, which uses a normal NetWebForm, and the file does get uploaded properly. Is it possible it won't work with a MemForm?
Thanks,
Jeff King
I'm trying to use a MemForm, with a single FileUpload button on it, to upload files to the web\uploads folder. The web log does show the POST /dataupload event but the actual file is not in the uploads folder. I have tried this running a local exe and also from a server using a dll with the multi-site host.
I have run the example app, which uses a normal NetWebForm, and the file does get uploaded properly. Is it possible it won't work with a MemForm?
Thanks,
Jeff King
7
Web Server - Ask For Help / mac version of chrome gives snap error 11 with drop down lists (NT 14.20)
« on: April 24, 2024, 12:45:04 PM »
Hello all,
I have a co-worker who is running NetTalk 14.20 web apps from his MAC with the latest Chrome browser. When he clicks on a drop list he gets the Chrome "Aw Snap" error 11 message. See attached image. The app does work as expected with Safari on this same MAC. In addition, the app works as expected on his Windows 11 machine. Anyone have any thoughts on the cause and a fix?
Thanks,
Jeff King
I have a co-worker who is running NetTalk 14.20 web apps from his MAC with the latest Chrome browser. When he clicks on a drop list he gets the Chrome "Aw Snap" error 11 message. See attached image. The app does work as expected with Safari on this same MAC. In addition, the app works as expected on his Windows 11 machine. Anyone have any thoughts on the cause and a fix?
Thanks,
Jeff King
8
Web Server - Ask For Help / API problem, NT 14.20
« on: April 10, 2024, 12:18:47 PM »
Hi Bruce,
I have an API set up. An app in California is the client, sending data to a target tps file called Enrollment.tps on a remote server. Numerous fields are loaded with data but one is not. It is called BCS_Status. In looking at the log in the Multi-site host (this app is a dll app) I do see the JSON, which shows the data is there. See the attached image. It shows: "BCS_Status":"DRTBeforeSurgery", circled in blue.
Using TPSSCAN I view the Enrollment table and see the BCS_Status field is blank. All other fields contain data as expected. I don't understand why this field is not assigned. My API is set up with the Parameters tab with just the Enrollment table added. The Returns tab just has two fields inserted. I'm only allowing this API to do an Insert action.
I can use Postman to send data to this API and all fields are filled in.
Any thoughts as to why just one field is not filled when it does show in the JSON?
Thanks,
Jeff King
I have an API set up. An app in California is the client, sending data to a target tps file called Enrollment.tps on a remote server. Numerous fields are loaded with data but one is not. It is called BCS_Status. In looking at the log in the Multi-site host (this app is a dll app) I do see the JSON, which shows the data is there. See the attached image. It shows: "BCS_Status":"DRTBeforeSurgery", circled in blue.
Using TPSSCAN I view the Enrollment table and see the BCS_Status field is blank. All other fields contain data as expected. I don't understand why this field is not assigned. My API is set up with the Parameters tab with just the Enrollment table added. The Returns tab just has two fields inserted. I'm only allowing this API to do an Insert action.
I can use Postman to send data to this API and all fields are filled in.
Any thoughts as to why just one field is not filled when it does show in the JSON?
Thanks,
Jeff King
9
Web Server - Ask For Help / Multi-Site host question
« on: March 26, 2024, 05:30:14 AM »
Hi Bruce,
I have the multi-site host running on two servers. One host has 8 dll apps running, the other has two dll apps running. All this runs great. However, when there is a new version of NetTalk posted, I must recompile the multi-site host and all individual apps with the same version of NetTalk. Then, copy the dll's and web folders to each server. This is becoming very time consuming. Will it ever be possible to mix NT versions of apps in the future? Or, is there a way to do this now?
Thanks,
Jeff King
I have the multi-site host running on two servers. One host has 8 dll apps running, the other has two dll apps running. All this runs great. However, when there is a new version of NetTalk posted, I must recompile the multi-site host and all individual apps with the same version of NetTalk. Then, copy the dll's and web folders to each server. This is becoming very time consuming. Will it ever be possible to mix NT versions of apps in the future? Or, is there a way to do this now?
Thanks,
Jeff King
10
Web Server - Ask For Help / New Partial Save button introduced in 14.17
« on: March 15, 2024, 07:12:52 AM »
Hi Bruce,
I have been experimenting with the Partial Save button added with NT 14.17. I have a GUID field in my tables, which is set as unique. This causes a problem:
When adding a new record the form is in insert mode. Clicking the Partial Save button saves the record, including the GUID field and sets the form to change mode. Upon clicking the Partial Save button again (while in change mode), an error pops up about a duplicate key on the GUID field.
Maybe I can add code to change the GUID when using the Partial Save button, but this does not seem to be a good idea. For now, I have set the Partial Save button to be disabled when in insert mode. Any thoughts on how to handle this issue better?
Thanks,
Jeff
I have been experimenting with the Partial Save button added with NT 14.17. I have a GUID field in my tables, which is set as unique. This causes a problem:
When adding a new record the form is in insert mode. Clicking the Partial Save button saves the record, including the GUID field and sets the form to change mode. Upon clicking the Partial Save button again (while in change mode), an error pops up about a duplicate key on the GUID field.
Maybe I can add code to change the GUID when using the Partial Save button, but this does not seem to be a good idea. For now, I have set the Partial Save button to be disabled when in insert mode. Any thoughts on how to handle this issue better?
Thanks,
Jeff
11
Web Server - Ask For Help / Refresh form fields after a pop-up form closes
« on: March 12, 2024, 07:31:46 PM »
Hello all,
Using NT 14.19. I have a form that displays many fields from a table called surgery. Two fields are also displayed at the bottom, from another table (enrollment), in view only mode, as seen in the attached image. The custom button on this form calls a "browse less" form as a pop-up, on the enrollment file. On this form, the two fields can be edited. Upon returning to the calling form, the fields are not updated. I would like them to update as soon as returning from the pop-up. I have tried calling a Do refresh::My:Field from the GotFocusBack embed without success. How can I refresh the two fields or the entire form when retuning from the pop-up?
Thanks,
Jeff King
Using NT 14.19. I have a form that displays many fields from a table called surgery. Two fields are also displayed at the bottom, from another table (enrollment), in view only mode, as seen in the attached image. The custom button on this form calls a "browse less" form as a pop-up, on the enrollment file. On this form, the two fields can be edited. Upon returning to the calling form, the fields are not updated. I would like them to update as soon as returning from the pop-up. I have tried calling a Do refresh::My:Field from the GotFocusBack embed without success. How can I refresh the two fields or the entire form when retuning from the pop-up?
Thanks,
Jeff King
12
Web Server - Ask For Help / Login window not centered
« on: March 05, 2024, 08:50:13 AM »
Hi Bruce,
I updated to NT 14.19. Now my login form is left justified, see attached. I have the Form Div set at: ' nt-fix-center login-form-width'.
Nothing else has changed in my app. I simply re-compiled after updating to NT 14.19. With NT 14.13 the login form was centered.
I have spent more than an hour trying to fix this without success. All my NT 14.13 apps now have the login form left justified as does the example app Web3. Anything change with CSS formatting since NT 14.13?
Thanks,
Jeff
I updated to NT 14.19. Now my login form is left justified, see attached. I have the Form Div set at: ' nt-fix-center login-form-width'.
Nothing else has changed in my app. I simply re-compiled after updating to NT 14.19. With NT 14.13 the login form was centered.
I have spent more than an hour trying to fix this without success. All my NT 14.13 apps now have the login form left justified as does the example app Web3. Anything change with CSS formatting since NT 14.13?
Thanks,
Jeff
13
Web Server - Ask For Help / Save form as user selects tabs?
« on: March 04, 2024, 06:04:50 PM »
Hello everyone,
I have a complex form with multiple tabs and many fields on each tab. Using NT 14.13.
A user has requested that the form save "partial" results to the file as they select the many tabs. Then, when done, they will select the Save button for a final save to disk. I created a local routine that I try calling from the Tab Changed embed:
SaveTabContents ROUTINE
Access:CRF001_Surgeon.Open()
Access:CRF001_Surgeon.UseFile()
CRF001Sx:Study_ID = p_web.GSV('CRF001Sx:StudyID_key')
Access:CRF001_Surgeon.Fetch(CRF001Sx:StudyID_key)
p_web.SessionQueueToFile(CRF001_Surgeon)
Access:CRF001_Surgeon.TryUpdate()
Access:CRF001_Surgeon.Close()
EXIT
So far, this does not update the file. Maybe a problem with the code in the routine or I'm using the wrong embed to call this? Any thoughts?
Thanks,
Jeff King
I have a complex form with multiple tabs and many fields on each tab. Using NT 14.13.
A user has requested that the form save "partial" results to the file as they select the many tabs. Then, when done, they will select the Save button for a final save to disk. I created a local routine that I try calling from the Tab Changed embed:
SaveTabContents ROUTINE
Access:CRF001_Surgeon.Open()
Access:CRF001_Surgeon.UseFile()
CRF001Sx:Study_ID = p_web.GSV('CRF001Sx:StudyID_key')
Access:CRF001_Surgeon.Fetch(CRF001Sx:StudyID_key)
p_web.SessionQueueToFile(CRF001_Surgeon)
Access:CRF001_Surgeon.TryUpdate()
Access:CRF001_Surgeon.Close()
EXIT
So far, this does not update the file. Maybe a problem with the code in the routine or I'm using the wrong embed to call this? Any thoughts?
Thanks,
Jeff King
14
Web Server - Ask For Help / Troubles with conditional hide filter.
« on: February 20, 2024, 05:22:57 PM »
Hello,
I'm struggling with how to construct the conditional hide on a field in a NT app. This is what I would like:
CRF002Rad:Recommend_RT_PBI <> 'Other' OR
CRF002Rad:Recommend_RT_WBI <> 'Other'
I know this has to be a string so I have tried the following:
'CRF002Rad:Recommend_RT_PBI <> Other OR ' &
'CRF002Rad:Recommend_RT_WBI <> Other'
Still getting errors. Can anyone help me construct this properly?
Thanks,
Jeff King
I'm struggling with how to construct the conditional hide on a field in a NT app. This is what I would like:
CRF002Rad:Recommend_RT_PBI <> 'Other' OR
CRF002Rad:Recommend_RT_WBI <> 'Other'
I know this has to be a string so I have tried the following:
'CRF002Rad:Recommend_RT_PBI <> Other OR ' &
'CRF002Rad:Recommend_RT_WBI <> Other'
Still getting errors. Can anyone help me construct this properly?
Thanks,
Jeff King
15
Web Server - Ask For Help / New API troubles
« on: February 19, 2024, 06:01:08 PM »
Hello all,
I'm trying a new API in my app. I have a Users file, and I want to use an API to see if there is an email address in this file. I want to do a get, see if the email is in the file and then return three fields.
On the Parameters tab, I set the parameter type to table, set the table to Users.tps, choose the unique key on the email field, and then check Allow Read.
On the Returns tab, I set the three fields in the Users table I want to return. They are: Usr:EMail, Usr:Access_List and Usr:AcctStatus
The response I get back is:
{
"EDC_Users_response" : {
"Usr:EMail" : "",
"Usr:Access_List" : "",
"Usr:AcctStatus" : ""
}
}
In the "Try It" section of the API documentation, HTTP GET (JSON Response), I set the Usr:Email field to jking@health.usf.edu and this email record does exist in the Users tps file. I would expect the get to succeed and return the three fields. Still, I get empty fields. I can't seem to find where I'm going wrong. Any thoughts?
Thanks,
Jeff King
I'm trying a new API in my app. I have a Users file, and I want to use an API to see if there is an email address in this file. I want to do a get, see if the email is in the file and then return three fields.
On the Parameters tab, I set the parameter type to table, set the table to Users.tps, choose the unique key on the email field, and then check Allow Read.
On the Returns tab, I set the three fields in the Users table I want to return. They are: Usr:EMail, Usr:Access_List and Usr:AcctStatus
The response I get back is:
{
"EDC_Users_response" : {
"Usr:EMail" : "",
"Usr:Access_List" : "",
"Usr:AcctStatus" : ""
}
}
In the "Try It" section of the API documentation, HTTP GET (JSON Response), I set the Usr:Email field to jking@health.usf.edu and this email record does exist in the Users tps file. I would expect the get to succeed and return the three fields. Still, I get empty fields. I can't seem to find where I'm going wrong. Any thoughts?
Thanks,
Jeff King