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.
16
Web Server - Ask For Help / Re: NetWebYear Calendar changing date and tim to startdatetimestamp_DATE etc problem
« on: April 24, 2018, 02:48:51 AM »
I converted a TPS based app(where everything was running fine) to ODBC - lots of bugs now.
On a hunch I changed the filter NetWebYear Data
from
'UPPER(boo:peopleguid) = ''' & upper(p_web.GSV('CalendarBookingsLocums_TPE_GUID')) & ''''
to
'UPPER(clip(boo:peopleguid)) = ''' & upper(clip(p_web.GSV('CalendarBookingsLocums_TPE_GUID'))) & ''''
now it shows each persons bookings in tpeople calendar.
Still have problems with the update form cannot select dates, cant save.
In example app the start and end dates were LONG in startdatetomestamp_GROUP they are DATE?
Now working with a SQL table. Is that my problem?
OK looks like PostGreSQL want the dates as DATE and time as TIME for the timestamp to work. Found out more and more settings that disappeared from certain procedures after switching from TPS to ODBC. Still cannot create or update a booking (like Rooms and Meetings in example) but the existing bookings now show in NetWebYear per person, just cannot Update them.
On a hunch I changed the filter NetWebYear Data
from
'UPPER(boo:peopleguid) = ''' & upper(p_web.GSV('CalendarBookingsLocums_TPE_GUID')) & ''''
to
'UPPER(clip(boo:peopleguid)) = ''' & upper(clip(p_web.GSV('CalendarBookingsLocums_TPE_GUID'))) & ''''
now it shows each persons bookings in tpeople calendar.
Still have problems with the update form cannot select dates, cant save.
In example app the start and end dates were LONG in startdatetomestamp_GROUP they are DATE?
Now working with a SQL table. Is that my problem?
OK looks like PostGreSQL want the dates as DATE and time as TIME for the timestamp to work. Found out more and more settings that disappeared from certain procedures after switching from TPS to ODBC. Still cannot create or update a booking (like Rooms and Meetings in example) but the existing bookings now show in NetWebYear per person, just cannot Update them.
17
Web Server - Ask For Help / Re: NetWebServerSettings Control Template WebServer Settings Tab Update
« on: April 24, 2018, 01:43:00 AM »
Anything funny there?
18
Web Server - Ask For Help / NetWebYear Calendar changing date and tim to startdatetimestamp_DATE etc problem
« on: April 24, 2018, 01:30:41 AM »
1. it would appear that NetWebYear does not like startdatetimestamp_DATE and startdatetimestamp_TIME. The dates that have been activated before does not appear on calendar anymore.
And now one cannot add any dates, the Update form comes up with no default dates in From and To and no dates can be selected.
And now one cannot add any dates, the Update form comes up with no default dates in From and To and no dates can be selected.
19
Web Server - Ask For Help / NTWS Print Calanders NetWebYear
« on: April 23, 2018, 01:30:23 AM »
Hi,
Can one print either/or/both as attached
Can one print either/or/both as attached
20
Web Server - Ask For Help / Re: user must >= level
« on: April 23, 2018, 12:55:50 AM »
I'm sure NetTalk won't mind LOL- but I was thinking more in the line of Business Rules, conventions, logic, common sense.
21
Web Server - Ask For Help / Re: NTWS app - changed TPS table to ODBC(PostGreSQL) PROBLEMS?
« on: April 23, 2018, 12:45:20 AM »
Since removing the relationship between tpeople ODBC and the TPS table error 48 at least has gone away, I can now add to and update tpeople in Desktop and web app.
But error 33 still occurs when I run the Process.
And the locator problem is still there, only locates on one character.
!jvz20180410
loc:flag01 = 0
if clip(tpe:username) = ''
loc:flag01 = 1
tpe:username = 'Not SET!'
!tpe:username = tpe:cellno
END
!IF clip(tpe:password) = '' or len(clip(tpe:password))<4
! loc:flag01 = 1
! tpe:password = st.random(4)
!
!END
!
!if tpe:isavailable = ''
! tpe:isavailable = 'Never'
! Access:tpeople.Update()
!end
!if tpe:preference = ''
! tpe:preference = 'Never'
! Access:tpeople.Update()
!end
!if tpe:fromdb = 'peopleold'
! tpe:guid = st.makeguid()
loc:flag01 = 1
! Access:tpeople.Update()
!end
if loc:flag01 = 1
Access:tpeople.Update()
end
But error 33 still occurs when I run the Process.
And the locator problem is still there, only locates on one character.
!jvz20180410
loc:flag01 = 0
if clip(tpe:username) = ''
loc:flag01 = 1
tpe:username = 'Not SET!'
!tpe:username = tpe:cellno
END
!IF clip(tpe:password) = '' or len(clip(tpe:password))<4
! loc:flag01 = 1
! tpe:password = st.random(4)
!
!END
!
!if tpe:isavailable = ''
! tpe:isavailable = 'Never'
! Access:tpeople.Update()
!end
!if tpe:preference = ''
! tpe:preference = 'Never'
! Access:tpeople.Update()
!end
!if tpe:fromdb = 'peopleold'
! tpe:guid = st.makeguid()
loc:flag01 = 1
! Access:tpeople.Update()
!end
if loc:flag01 = 1
Access:tpeople.Update()
end
22
Web Server - Ask For Help / Re: NetWebServerSettings Control Template WebServer Settings Tab Update
« on: April 22, 2018, 11:33:26 PM »
Ok did that an still get these errors.
23
Web Server - Ask For Help / NetWebServerSettings Control Template WebServer Settings Tab Update
« on: April 22, 2018, 08:02:36 AM »
Installed NT 10.19 trying to update the WebServer Settings Tab.
Cannot find NetWebServerSettings Control Template as per NetTalk Webinar 185 at 12:50
Cannot find NetWebServerSettings Control Template as per NetTalk Webinar 185 at 12:50
24
Web Server - Ask For Help / Re: NTWS app - changed TPS table to ODBC(PostGreSQL) PROBLEMS?
« on: April 21, 2018, 04:32:39 AM »
Thx.
Apparently position is not a reserved word in PostGreSQL(possibly in other flavors) but when I noticed that inside Navicat that position was renamed POSITION I wrongly? assumed the name position is a problem for PostGreSQL, and I maybe overreacted and changed it to tpeposition in DCT and on the backend, without informing FM3 about this!
All my other SQL tables work just fine, only this one that I have messed up does not.
Maybe the answer lies within FM3 Upg table?
Apparently position is not a reserved word in PostGreSQL(possibly in other flavors) but when I noticed that inside Navicat that position was renamed POSITION I wrongly? assumed the name position is a problem for PostGreSQL, and I maybe overreacted and changed it to tpeposition in DCT and on the backend, without informing FM3 about this!
All my other SQL tables work just fine, only this one that I have messed up does not.
Maybe the answer lies within FM3 Upg table?
25
Web Server - Ask For Help / Re: user must >= level
« on: April 21, 2018, 04:26:19 AM »
Hi
Thx for that!
In my users table I have usr:userlevel
After login in webhandler
p_web.SSV('loggedinuseruserlevel',usr:userlevel)
p_web.SetSessionLevel(p_web.GSV('loggedinuseruserlevel'))
in Menu choice I have set the two levels to 0 and 0.
So if userlevel is <> 0 then that menu choice is hidden.
I have it that low levels have more access ...
I don't suppose that is serious?
'
Thx for that!
In my users table I have usr:userlevel
After login in webhandler
p_web.SSV('loggedinuseruserlevel',usr:userlevel)
p_web.SetSessionLevel(p_web.GSV('loggedinuseruserlevel'))
in Menu choice I have set the two levels to 0 and 0.
So if userlevel is <> 0 then that menu choice is hidden.
I have it that low levels have more access ...
I don't suppose that is serious?
'
26
Web Server - Ask For Help / Re: NTWS app - changed TPS table to ODBC(PostGreSQL) PROBLEMS?
« on: April 20, 2018, 12:07:56 PM »
PostGreSQL
I have other Browses and Forms connecting to SQL tables in the same app so the connection string is not the problem.
And I can browse the tpeople table
I have a desktop app mx_utl that contains FM3 runtimefilemanager with the same connection string that works perfectly, it shows tpeople with the number of records etc.
Ok now I have created tpeople browse and form, giving me compile errors, complaining about tpe:tpeposition and tpe:date.
Now I remember that I changed the name from position to tpeposition in the tpeople SQL table as well as in the DCT, because in SQL running a script changed the name from position to POSITION, so I assumed it did like position(reserved word?) Now I vaguely remembered that you cannot just do that in a FM3 enabled app. I have now done the OldName thingy in DCT but it does not help. Cannot remember that my only date related field was ever called date, it is addtimestamp? Now how do I fix this. OK now maybe not a NTWS problem but a FM3/DCT problem?
I have other Browses and Forms connecting to SQL tables in the same app so the connection string is not the problem.
And I can browse the tpeople table
I have a desktop app mx_utl that contains FM3 runtimefilemanager with the same connection string that works perfectly, it shows tpeople with the number of records etc.
Ok now I have created tpeople browse and form, giving me compile errors, complaining about tpe:tpeposition and tpe:date.
Now I remember that I changed the name from position to tpeposition in the tpeople SQL table as well as in the DCT, because in SQL running a script changed the name from position to POSITION, so I assumed it did like position(reserved word?) Now I vaguely remembered that you cannot just do that in a FM3 enabled app. I have now done the OldName thingy in DCT but it does not help. Cannot remember that my only date related field was ever called date, it is addtimestamp? Now how do I fix this. OK now maybe not a NTWS problem but a FM3/DCT problem?
27
Web Server - Ask For Help / NTWS app - changed TPS table to ODBC(PostGreSQL) PROBLEMS?
« on: April 19, 2018, 01:58:39 PM »
THIS IS A SHOWSTOPPER!
Started this table (tpeople) as TPS and have been using it for a while, have now changed File Driver to ODBC using global connection string.
That table can be browsed but one cannot insert or edit anything. On Save it just bombs out of server app.
This site can?t be reached
localhost refused to connect.
Search Google for localhost Browse People
ERR_CONNECTION_REFUSED
Also, the locator on that browse does not work as it should, if you type one letter it will filter the browse on that one letter, which is still fine, but if you type anymore than one, the browse becomes empty.
people
Locate (Contains) fullname:
zy
Search
Clear
no people
How now brown cow?
Started this table (tpeople) as TPS and have been using it for a while, have now changed File Driver to ODBC using global connection string.
That table can be browsed but one cannot insert or edit anything. On Save it just bombs out of server app.
This site can?t be reached
localhost refused to connect.
Search Google for localhost Browse People
ERR_CONNECTION_REFUSED
Also, the locator on that browse does not work as it should, if you type one letter it will filter the browse on that one letter, which is still fine, but if you type anymore than one, the browse becomes empty.
people
Locate (Contains) fullname:
zy
Search
Clear
no people
How now brown cow?
28
Web Server - Ask For Help / Re: user must >= level
« on: April 19, 2018, 01:47:40 PM »
OK
I log in - my userlevel = 0
p_web.GSV('loggedinuseruserlevel') goes into =>
In the other <= put 0
Therefore only users with userlevel 0 can see this page?
Have I got it now?
I log in - my userlevel = 0
p_web.GSV('loggedinuseruserlevel') goes into =>
In the other <= put 0
Therefore only users with userlevel 0 can see this page?
Have I got it now?
29
Web Server - Ask For Help / user must >= level
« on: April 19, 2018, 10:36:28 AM »
user must >= level
What exactly does one put there
I have users and userlevels tables.
Login and password is verified against users and the userlevel is in the same table usr:userlevel.
Must I SSV this usr:userlevel on login and here I put the GSV?
OK resolved.
p_web.GSV('loggedinuseruserlevel') did the trick.
Couldn't find this any docs.
Wait - what did it verify it against?
What exactly does one put there
I have users and userlevels tables.
Login and password is verified against users and the userlevel is in the same table usr:userlevel.
Must I SSV this usr:userlevel on login and here I put the GSV?
OK resolved.
p_web.GSV('loggedinuseruserlevel') did the trick.
Couldn't find this any docs.
Wait - what did it verify it against?
30
Web Server - Ask For Help / Re: How to LetsEncrypt?
« on: April 16, 2018, 04:19:21 AM »
Webinar no ? Please?
Or any new docs out there?
OK found it!
http://www.capesoft.com/accessories/NetTalkUserGroup.htm
Or any new docs out there?
OK found it!
http://www.capesoft.com/accessories/NetTalkUserGroup.htm