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.
31
Web Server - Ask For Help / Re: Progress Bar not seeming to work the same.
« on: January 07, 2017, 10:57:17 PM »
HI Ashley try this code between where you set the PercentageComplete in the loop and p_web.SetProgress()
PercentageComplete = RecordCount*100/FileRecords ! calculate the percentage complete, using whatever code is applicable to your process
If PercentageComplete < 1
PercentageComplete = 1
ELSIF PercentageComplete > 99
PercentageComplete = 99
END
p_web.SetProgress(loc:ProgressName,PercentageComplete,'') ! set the progress bar to that number.
PercentageComplete = RecordCount*100/FileRecords ! calculate the percentage complete, using whatever code is applicable to your process
If PercentageComplete < 1
PercentageComplete = 1
ELSIF PercentageComplete > 99
PercentageComplete = 99
END
p_web.SetProgress(loc:ProgressName,PercentageComplete,'') ! set the progress bar to that number.
32
Web Server - Ask For Help / Re: Progress Bar disappearing during process
« on: December 30, 2016, 09:04:06 AM »
Hi Bruce.
Attached is the same example with your suggested code inserted.
I still see the same issue, the progress bar disappears. In fact I had already used your suggestion in my standard code when I was trying to solve the problem myself.
However if I have debug view on when I run the code the bar disappears after only 10 or so records have been processed, not when the PercentageComplete is anywhere near 100%.
Going back to my observation what would be the result if after the 2 second waiting interval at the beginning of the process the calculated PercentageComplete was less than 1. I think this is where the problem appears.
It also explains why the same source procedure of mine has no problem when it is processing a file with a few records in it but later fails as the number of records it is processing increases. Solving that issue could then be done by increasing the waiting period
If you look at the attached code I have added a line which is currently remmed out.
IF PercentageComplete < 1 THEN PercentageComplete = 1.
If you run the procedure with this line remmed out the progress bar disappears after about 10 records have been looped through.
If you enable this line then irrespective of the size of the waiting interval the code completes.
Attached is the same example with your suggested code inserted.
I still see the same issue, the progress bar disappears. In fact I had already used your suggestion in my standard code when I was trying to solve the problem myself.
However if I have debug view on when I run the code the bar disappears after only 10 or so records have been processed, not when the PercentageComplete is anywhere near 100%.
Going back to my observation what would be the result if after the 2 second waiting interval at the beginning of the process the calculated PercentageComplete was less than 1. I think this is where the problem appears.
It also explains why the same source procedure of mine has no problem when it is processing a file with a few records in it but later fails as the number of records it is processing increases. Solving that issue could then be done by increasing the waiting period
If you look at the attached code I have added a line which is currently remmed out.
IF PercentageComplete < 1 THEN PercentageComplete = 1.
If you run the procedure with this line remmed out the progress bar disappears after about 10 records have been looped through.
If you enable this line then irrespective of the size of the waiting interval the code completes.
33
Web Server - Ask For Help / Progress Bar disappearing during process
« on: December 29, 2016, 10:22:01 PM »
Hi Bruce
Following on from yesterday's Webinar regarding the progress bar issue experienced by myself and Ashley.
I have modified the web72 example.
Before these changes I ran the example and it completed the file make.
In the ProcessMakeFile procedure.
DataSection
I added a variable recordsize as a long
ProcessedCode
Before the loop I set recordsize to 5000
I then looped from record 1 to 5000
I changed the percentagecomplete calculation to x * 100/recordsize
I added a StringTheory Local Object (st) and added a st.trace to monitor the process
On running this it exhibits exactly the symptoms we described.
The progress bar displays for a short while and then disappears.
However the process still continues.
Checking Web72.exe in TaskManager shows cpu activity (mine hovers around 12)
Using debugview I can see each traceline
Observations.
If I rem out the artificial delay the progress bar does not disappear ( in this example)
As I mentioned anectodally if I change the StartProcess File Tab PageProcess Progress Timer to (say 20000) the progress bar stays visible.
As a layman's observation it seems as though if the ProgressTimer interval is not large enough for 1% to be calculated in the loop that is when the progress bar disappears.
What I mean is if the progressInterval is 2000 (2 seconds) and it takes more than 2 seconds for 50 records to be processed in this example then the progress bar disappears
Following on from yesterday's Webinar regarding the progress bar issue experienced by myself and Ashley.
I have modified the web72 example.
Before these changes I ran the example and it completed the file make.
In the ProcessMakeFile procedure.
DataSection
I added a variable recordsize as a long
ProcessedCode
Before the loop I set recordsize to 5000
I then looped from record 1 to 5000
I changed the percentagecomplete calculation to x * 100/recordsize
I added a StringTheory Local Object (st) and added a st.trace to monitor the process
On running this it exhibits exactly the symptoms we described.
The progress bar displays for a short while and then disappears.
However the process still continues.
Checking Web72.exe in TaskManager shows cpu activity (mine hovers around 12)
Using debugview I can see each traceline
Observations.
If I rem out the artificial delay the progress bar does not disappear ( in this example)
As I mentioned anectodally if I change the StartProcess File Tab PageProcess Progress Timer to (say 20000) the progress bar stays visible.
As a layman's observation it seems as though if the ProgressTimer interval is not large enough for 1% to be calculated in the loop that is when the progress bar disappears.
What I mean is if the progressInterval is 2000 (2 seconds) and it takes more than 2 seconds for 50 records to be processed in this example then the progress bar disappears
34
Web Server - Ask For Help / Re: Progress Bar not seeming to work the same.
« on: December 29, 2016, 10:16:41 PM »
Hi Ashley take a look at my topic
35
Web Server - Ask For Help / Re: Restricting user access to a net web report that is in use.
« on: December 26, 2016, 06:37:49 AM »
Hi Richard. As an alternate suggestion, why don't you add the sessionid to the table and restrict the report to that session variable? Then you remove the records for that sessionid in the file after printing. That way all your users can print the report at the same time without affecting the others.
36
Web Server - Ask For Help / Re: Drop list behaviour in a form.
« on: December 15, 2016, 07:06:13 AM »
Bump
37
Web Server - Ask For Help / Re: Cache interfering with report print pdf display.
« on: December 13, 2016, 08:49:26 AM »
Thanks Bruce
38
Web Server - Ask For Help / Re: Cache interfering with report print pdf display.
« on: December 12, 2016, 04:10:32 AM »
Hi Bruce Yes.
Turning off the caching then displyed the new dtata each time it was printed. Setting the cache on stored and displayed the first report information
Turning off the caching then displyed the new dtata each time it was printed. Setting the cache on stored and displayed the first report information
39
Web Server - Ask For Help / Drop list behaviour in a form.
« on: December 02, 2016, 08:08:12 PM »
If I have a droplist in a form there are 3 methods I can use to select a record from it:-
Use a mouse to click on the down arrow to the right of the field display. This then shows the drop list which I can navigate using the keyboard or a mouse
I can use a mouse to click on the display field and once more the drop list appears and I can navigate using keyboard or mouse
However if I only want to use the keyboard and I tab onto the field and use the keyboard down arrow only the first record after the displayed record appears, thereafter the displayed record does not change.If I click on this record I can once more see the droplist and can navigate as before.
This is definitely a problem since my users, and myself, prefer to use the keyboard as much as possible since tabbing from field to field is much more efficient than swapping from hands on keyboard to mouse operation and then back to keyboard.
Another situation where this causes an issue is where I have a droplist which when a record is selected it populates other fields in the form depending on which record is selected. Because only the the next record is selected and you can go no further with a keyboard operation you then need to click on the downarrow and select the correct record.
When tabbing onto a droplist is there a method to display the available records below the droplist as if I had clicked on the down arrow to the right of the droplist?
Tested on Firefox Chrome Opera and Internet Explorer 11
Use a mouse to click on the down arrow to the right of the field display. This then shows the drop list which I can navigate using the keyboard or a mouse
I can use a mouse to click on the display field and once more the drop list appears and I can navigate using keyboard or mouse
However if I only want to use the keyboard and I tab onto the field and use the keyboard down arrow only the first record after the displayed record appears, thereafter the displayed record does not change.If I click on this record I can once more see the droplist and can navigate as before.
This is definitely a problem since my users, and myself, prefer to use the keyboard as much as possible since tabbing from field to field is much more efficient than swapping from hands on keyboard to mouse operation and then back to keyboard.
Another situation where this causes an issue is where I have a droplist which when a record is selected it populates other fields in the form depending on which record is selected. Because only the the next record is selected and you can go no further with a keyboard operation you then need to click on the downarrow and select the correct record.
When tabbing onto a droplist is there a method to display the available records below the droplist as if I had clicked on the down arrow to the right of the droplist?
Tested on Firefox Chrome Opera and Internet Explorer 11
40
Web Server - Ask For Help / Cache interfering with report print pdf display.
« on: December 02, 2016, 07:43:14 PM »
I have a browse with an inline other button which prints a pdf report (using pdf tools).Its job is to print all the detail in a file.
I nominate a file name and the pdf file is created in a folder under web.In this instance
The report prints fine and displays in the web pdf viewer correctly. If, however, I change some information in the file and reprint, the pdf file displayed in the viewer is the previous pdf file, not the version that has been recreated in the web folder. It is obviously a situation where the cache has not been cleared.
If I shut down and restart and reprint I get the correct pdf in the viewer.
In the performance tab of the Nettalk webserver extension there are 3 fields that should solve my problem Enable File cache, cache files less than and Max cache size.
Under most situations I prefer cache on since I understand that it improves speed. In this instance, but not always the created pdf file is +-26Kb in size so since currently Cache files less than is set to 1000000 this is the reason why the file is cached.
So my questions.
will setting the Cache files less than to 1000 affect performance significantly?
Is there a method that will let me clear the cache only for the pdf file I am regenerating?
Should I uncheck the Enable file Cache, and will that have a performance impact?
I nominate a file name and the pdf file is created in a folder under web.In this instance
The report prints fine and displays in the web pdf viewer correctly. If, however, I change some information in the file and reprint, the pdf file displayed in the viewer is the previous pdf file, not the version that has been recreated in the web folder. It is obviously a situation where the cache has not been cleared.
If I shut down and restart and reprint I get the correct pdf in the viewer.
In the performance tab of the Nettalk webserver extension there are 3 fields that should solve my problem Enable File cache, cache files less than and Max cache size.
Under most situations I prefer cache on since I understand that it improves speed. In this instance, but not always the created pdf file is +-26Kb in size so since currently Cache files less than is set to 1000000 this is the reason why the file is cached.
So my questions.
will setting the Cache files less than to 1000 affect performance significantly?
Is there a method that will let me clear the cache only for the pdf file I am regenerating?
Should I uncheck the Enable file Cache, and will that have a performance impact?
41
Web Server - Ask For Help / Re: Filtering in a NetTalk browse
« on: November 13, 2016, 08:31:41 PM »
Hi Richard.
In the browse filter:
'PL:name = <39>' & p_web.GSV('Name') & '<39>'
Couple of points When you use p_web.GSV('Name') you don't need to clip
I use <39> above since I find it easier that having to put 3 ' characters in a row but it is the same thing.
In the browse filter:
'PL:name = <39>' & p_web.GSV('Name') & '<39>'
Couple of points When you use p_web.GSV('Name') you don't need to clip
I use <39> above since I find it easier that having to put 3 ' characters in a row but it is the same thing.
42
Web Server - Ask For Help / Re: Look up in forms, Name key
« on: November 12, 2016, 09:37:37 PM »
Hi Edvard. I may be misunderstanding the question. In the lookup settings of the NetWebForm the value field is the value that will be stored in your table, the Description field is the field that will display if Display Description instead of value is checked.
43
Web Server - Ask For Help / Re: Look up in forms, Name key
« on: November 11, 2016, 08:19:50 PM »
Hi Edvard.
The description key has to be unique (otherwise how will Nettalk know which Edvard in you first name list is the person you are dealing with). It means that you would probably be better off creating a field in your table combining first+Last plus something to make it unique and giving that a unique key to use.
The description key has to be unique (otherwise how will Nettalk know which Edvard in you first name list is the person you are dealing with). It means that you would probably be better off creating a field in your table combining first+Last plus something to make it unique and giving that a unique key to use.
44
Web Server - Ask For Help / Re: Send file between 2 apps across the internet?
« on: November 03, 2016, 07:27:12 PM »
Hi Johan.
Probably running a webservice on the one application and a webclient on the other.
From what I understand from your query it is the same app on both so this would also allow transfer to flow the other way if you wanted.
Probably running a webservice on the one application and a webclient on the other.
From what I understand from your query it is the same app on both so this would also allow transfer to flow the other way if you wanted.
45
Web Server - Ask For Help / Progress Bar disappearing
« on: November 01, 2016, 09:08:40 PM »
I have an issue with the progress bar disappearing intermittently in certain procedures.
This happens in more than one StartProcess/MakeFile pairing
Situation
The database is MSSQL
I start the memory form that calls the MakeFile procedure.
I enter parameters and click the Start button.
The progress bar displays with a percentage of 1
At this point 2 things can happen
1. The progress bar continues displaying incrementing percentages and at the end of the MakeFile procedure the download message link displays
2. The progress bar disappears but the MakeFile procedure continues in the background and the file is created as a $$$$ file but no link appears.
In situation 2. under certain circumstances starting the memory form from the menu again without pressing the start button on the form results in the progress bar reappearing and operating normally.
This happens in more than one StartProcess/MakeFile pairing
Situation
The database is MSSQL
I start the memory form that calls the MakeFile procedure.
I enter parameters and click the Start button.
The progress bar displays with a percentage of 1
At this point 2 things can happen
1. The progress bar continues displaying incrementing percentages and at the end of the MakeFile procedure the download message link displays
2. The progress bar disappears but the MakeFile procedure continues in the background and the file is created as a $$$$ file but no link appears.
In situation 2. under certain circumstances starting the memory form from the menu again without pressing the start button on the form results in the progress bar reappearing and operating normally.