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 / Re: web26 example File Upload
« on: March 23, 2025, 10:23:19 PM »
Many thanks Bruce.
regards,
Richard
regards,
Richard
2
Web Server - Ask For Help / Re: Coding a date field to be a particular day date
« on: March 23, 2025, 08:43:38 PM »
Thanks Niels for the heads up re "DAY"
FYI
The Code is now sorted , provided the date column in the CSV file is changed to dd/mm/yyyy
herewith for your interest
SET(Lineitems)
Access:Lineitems.usefile
OPEN (Lineitems)
Relate:ImportCSV.OPEN
SET(ImportCSV)
LOOP until Access:ImportCSV.Next()
Lin:UserName = p_web.GSV('Username')
Lin:Quantity = 1
Lin:Product = ImpCSV:Label3
Lin:Price = ImpCSV:Label6
Lin:IncomeItem = 0
IF Lin:Price > 1 THEN Lin:IncomeItem = 1 END
IF LIN:Price < 1 THEN LIN:Price = (LIN:Price * -1 ) END
Lin:Total = Lin:Price
Lin:date = deformat( ImpCSV:Label7),@D6)
locNewDate = LIN:Date
locdaydate = DAY(Lin:Date)
LIN:Date = (locNewDate - locdaydate) +1
INV:Date = Lin:date
IF access:Invoice.Fetch(INV:byDateDescending) = LEVEL:Benign
Lin:InvoiceNumber = INV:ID
END
Access:LineItems.Insert()
END
loc:Alert = 'Your Bank Statement has been Imported.'
Regards,
Richard
FYI
The Code is now sorted , provided the date column in the CSV file is changed to dd/mm/yyyy
herewith for your interest
SET(Lineitems)
Access:Lineitems.usefile
OPEN (Lineitems)
Relate:ImportCSV.OPEN
SET(ImportCSV)
LOOP until Access:ImportCSV.Next()
Lin:UserName = p_web.GSV('Username')
Lin:Quantity = 1
Lin:Product = ImpCSV:Label3
Lin:Price = ImpCSV:Label6
Lin:IncomeItem = 0
IF Lin:Price > 1 THEN Lin:IncomeItem = 1 END
IF LIN:Price < 1 THEN LIN:Price = (LIN:Price * -1 ) END
Lin:Total = Lin:Price
Lin:date = deformat( ImpCSV:Label7),@D6)
locNewDate = LIN:Date
locdaydate = DAY(Lin:Date)
LIN:Date = (locNewDate - locdaydate) +1
INV:Date = Lin:date
IF access:Invoice.Fetch(INV:byDateDescending) = LEVEL:Benign
Lin:InvoiceNumber = INV:ID
END
Access:LineItems.Insert()
END
loc:Alert = 'Your Bank Statement has been Imported.'
Regards,
Richard
3
Web Server - Ask For Help / Re: Coding a date field to be a particular day date
« on: March 19, 2025, 12:40:34 AM »
Thanks but no not yet!
4
Web Server - Ask For Help / Re: Coding a date field to be a particular day date
« on: March 18, 2025, 11:05:48 PM »
Thanks for that Niels, I need it in the format dd/mm/yyyy
I think your expression will return mm/dd/yyyy ?
Could then format newdate as @0D6 ?
Would that work?
Cheers,
Richard
I think your expression will return mm/dd/yyyy ?
Could then format newdate as @0D6 ?
Would that work?
Cheers,
Richard
5
Web Server - Ask For Help / Coding a date field to be a particular day date
« on: March 18, 2025, 08:49:54 PM »
I want to change a date in a month by code say 23/07/2024 to 01/07/2024
In the table there could be a range of dates and I want them all to become the first of the respective month and year
Thanks
Cheers
Richard
In the table there could be a range of dates and I want them all to become the first of the respective month and year
Thanks
Cheers
Richard
6
Web Server - Ask For Help / Re: web26 example File Upload
« on: March 18, 2025, 11:49:34 AM »
Amended File Update example Bruce,
I have deleted the FreeImage template and removed the mailbox and gallery Forms
Everything else is out of the example 26 file.
Although the message "Uploaded" appears, no file of any type is uploaded to the uploads folder
Thank you for your help
Richard
I have deleted the FreeImage template and removed the mailbox and gallery Forms
Everything else is out of the example 26 file.
Although the message "Uploaded" appears, no file of any type is uploaded to the uploads folder
Thank you for your help
Richard
7
Web Server - Ask For Help / Re: web26 example File Upload
« on: March 17, 2025, 04:25:48 PM »
Thanks Ron,
Interestingly, I am able to upload an image to the uploads folder, but not a document viz CSV file
Im not sure where to from here...
the problem I have is that on testing I get the messages that the File has been uploaded, but its not, or doesnt appear to be.
Ive done a search of the PC for a named CSV to see it was uploaded somewhere else....nothing.
I too deleted the Media from the documents page but in so doing, Im not sure whether the blob (document) is integral.
Im also testing locally ie with the amended example app uploading the file to the same machine.
The only way I could get the example to compile without 14 errors was to delete the Free Image template.
I wonder whether the example only works as anticipated if its running from a secure https: site ? which my local pc is not.
Cheers
Richard
Interestingly, I am able to upload an image to the uploads folder, but not a document viz CSV file
Im not sure where to from here...
the problem I have is that on testing I get the messages that the File has been uploaded, but its not, or doesnt appear to be.
Ive done a search of the PC for a named CSV to see it was uploaded somewhere else....nothing.
I too deleted the Media from the documents page but in so doing, Im not sure whether the blob (document) is integral.
Im also testing locally ie with the amended example app uploading the file to the same machine.
The only way I could get the example to compile without 14 errors was to delete the Free Image template.
I wonder whether the example only works as anticipated if its running from a secure https: site ? which my local pc is not.
Cheers
Richard
8
Web Server - Ask For Help / Re: web26 example File Upload
« on: March 16, 2025, 05:10:59 PM »
I thought I would revisit the original unedited example 26 ( I normally work on a copied iteration) but on compiling I get 14 errors....
Error(3): cif$fileopen cfiImgCt.inc The system cannot find the path specified. - D:\Clarion11.1 Examples\nettalk\Web Server\FileUpload (26)\clw\web26.clw:1
On checking, The global extension "Activate Clarion FreeImage for this application" is loaded,
Not a lot of progress, so help would be appreciated please
Thanks
Richard
Error(3): cif$fileopen cfiImgCt.inc The system cannot find the path specified. - D:\Clarion11.1 Examples\nettalk\Web Server\FileUpload (26)\clw\web26.clw:1
On checking, The global extension "Activate Clarion FreeImage for this application" is loaded,
Not a lot of progress, so help would be appreciated please
Thanks
Richard
9
Web Server - Ask For Help / Re: web26 example File Upload
« on: March 14, 2025, 03:55:57 PM »
Thanks Bruce
Yes - The Example "File Upload(26)" is not working for me.
I have opened, checked the Scripts folder, run gzipall, compiled and run the Example 26 File Upload.
I can get a png image to save in the Uploads folder via the Gallery page.
On the documents page, I can load a file so that it displays "waiting" and I can get the subsequent message "uploaded".
I cannot get a document such as a PDF to save to the Uploads folder from the documents page.
I am not sure what the purpose of the other fields on the document page are ie
Name - is it in the format pic.jpg ? and
Hash - What is the hash field recording?
Do these fields need to be populated?
All files attempted are small 16 kb and are either pdf tps or csv.
I am unfamiliar with your question "is it set to save to disk?"
The aim of incorporating this example into my online apps is to be able to upload a bank statement as a csv file into a NT app and then manipulate it once there, as per a client request.
Cheers,
Richard NT 14.28
Yes - The Example "File Upload(26)" is not working for me.
I have opened, checked the Scripts folder, run gzipall, compiled and run the Example 26 File Upload.
I can get a png image to save in the Uploads folder via the Gallery page.
On the documents page, I can load a file so that it displays "waiting" and I can get the subsequent message "uploaded".
I cannot get a document such as a PDF to save to the Uploads folder from the documents page.
I am not sure what the purpose of the other fields on the document page are ie
Name - is it in the format pic.jpg ? and
Hash - What is the hash field recording?
Do these fields need to be populated?
All files attempted are small 16 kb and are either pdf tps or csv.
I am unfamiliar with your question "is it set to save to disk?"
The aim of incorporating this example into my online apps is to be able to upload a bank statement as a csv file into a NT app and then manipulate it once there, as per a client request.
Cheers,
Richard NT 14.28
10
Web Server - Ask For Help / web26 example File Upload
« on: March 13, 2025, 07:08:14 PM »
When running the example" File Upload" ,The message box is telling me on "Start" that the nominated file is Uploaded and displays its size,
and for a larger file I can see the progress bar.
The file is not being uploaded to the webserver\uploads
In the webserver settings Scripts tab I have "File Upload" Ticked, ran Gzipall from here OK compiled and run
What am I missing please?
Thanks
Richard NT 14.28
and for a larger file I can see the progress bar.
The file is not being uploaded to the webserver\uploads
In the webserver settings Scripts tab I have "File Upload" Ticked, ran Gzipall from here OK compiled and run
What am I missing please?
Thanks
Richard NT 14.28
11
Web Server - Ask For Help / LetsEncrypt Certificate not auto renewing
« on: February 18, 2025, 03:23:05 PM »
Hi all,
While I can successfully, manually renew the Certificate from the template, the last auto renewal failed.
At the time the exe was running as a Service, so I stopped that and updated from the web serever.
The app is running from an Amazon Server.
I have checked the settings and the paths appear to be correct.
I attach a snip
Is there are reason?
Thanks
Richard
NT 14.28
While I can successfully, manually renew the Certificate from the template, the last auto renewal failed.
At the time the exe was running as a Service, so I stopped that and updated from the web serever.
The app is running from an Amazon Server.
I have checked the settings and the paths appear to be correct.
I attach a snip
Is there are reason?
Thanks
Richard
NT 14.28
12
Web Server - Ask For Help / Re: Filtering two fields in a Net Web Browse
« on: January 14, 2025, 10:45:59 PM »
Got it --
ThisView{prop:Filter} = 'Men:Date = ' & p_web.GSV('Din:date') & |
' and Men:Hall = ''' & p_web.GSV('Din:Hall') & ''' '
Note the spaces and the help of Bruce's book "Developing Web Applications with NetTalk"
Thanks Bruce !
Richard
ThisView{prop:Filter} = 'Men:Date = ' & p_web.GSV('Din:date') & |
' and Men:Hall = ''' & p_web.GSV('Din:Hall') & ''' '
Note the spaces and the help of Bruce's book "Developing Web Applications with NetTalk"
Thanks Bruce !
Richard
13
Web Server - Ask For Help / Filtering two fields in a Net Web Browse
« on: January 14, 2025, 09:40:44 PM »
Hi
I want to filter on two fields in a NW browse as in this expression, which is not working -
ThisView{prop:Filter} = 'Men:Date = ''' & p_web.GSV('Din:date') & |
'and Men:Hall = ''' & p_web.GSV('Din:Hall') &''' '
I can on either one but not both
The code is in 11 Set Filter
Thanks
Richard
NT 14.28
I want to filter on two fields in a NW browse as in this expression, which is not working -
ThisView{prop:Filter} = 'Men:Date = ''' & p_web.GSV('Din:date') & |
'and Men:Hall = ''' & p_web.GSV('Din:Hall') &''' '
I can on either one but not both
The code is in 11 Set Filter
Thanks
Richard
NT 14.28
14
Web Server - Ask For Help / Landscape Reports when running as a Service
« on: December 30, 2024, 06:31:26 PM »
Hello,
When my app is run as a Service, the Reports display and print in Landscape, which reverses to Portrait when the Service is stopped.
The Report Properties do not have the Landscape option selected.
How do I resolve this please?
Thanks
Richard
NT 14.28
SelfService 3.62
When my app is run as a Service, the Reports display and print in Landscape, which reverses to Portrait when the Service is stopped.
The Report Properties do not have the Landscape option selected.
How do I resolve this please?
Thanks
Richard
NT 14.28
SelfService 3.62
15
Web Server - Ask For Help / Re: Cannot load as a Service -wrong path to executable
« on: December 29, 2024, 05:36:46 PM »
thanks Jane
Cheers
Richard
Cheers
Richard