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.
121
Web Server - Ask For Help / Export XML / Xfiles date format Libre Office.
« on: April 04, 2015, 01:32:34 AM »
Bruce thanks for your help at Thursday's webinar.
Problem with date format when export to Libre Office rather then Excel.
Export works OK except the date format.
Solution
Add 'T0' to the end of the date field.
XML field type is set to 'DateTime' but the time part is not set in the export. So adding 'T0' sets the time to zero. Date now works OK.
Added to xCell.SetCell Procedure in xFiles.clw
If self.workbook.WorksheetQueue.Table.RowQueue.Cells.type = 'DateTime' and p_Data<>''
self.workbook.WorksheetQueue.Table.RowQueue.Cells.data = left(p_Data)&'T0'
End
Problem with date format when export to Libre Office rather then Excel.
Export works OK except the date format.
Solution
Add 'T0' to the end of the date field.
XML field type is set to 'DateTime' but the time part is not set in the export. So adding 'T0' sets the time to zero. Date now works OK.
Added to xCell.SetCell Procedure in xFiles.clw
If self.workbook.WorksheetQueue.Table.RowQueue.Cells.type = 'DateTime' and p_Data<>''
self.workbook.WorksheetQueue.Table.RowQueue.Cells.data = left(p_Data)&'T0'
End
122
Web Server - Ask For Help / Re: Clarion 10
« on: March 09, 2015, 11:05:59 PM »
Thanks Terry and Bruce.
I assumed it was Clarion 10 but I thought I would just check.
Thanks for your help. I am not is a rush to use Clarion 10 so I will wait until it is fixed.
Cheers
Vinnie
I assumed it was Clarion 10 but I thought I would just check.
Thanks for your help. I am not is a rush to use Clarion 10 so I will wait until it is fixed.
Cheers
Vinnie
123
Web Server - Ask For Help / Clarion 10
« on: March 09, 2015, 03:05:04 AM »
I am sure this not a NetTalk problem but thought I would ask for help.
I am using the MultiSite app which works great in Clarion 9.1 but the DLL apps do not compile using Clarion 10.
Error is :
Error(3): cif$fileopen systemstring.inc
This seems to be every clw
Any help welcome
Cheers
Vinnie
I am using the MultiSite app which works great in Clarion 9.1 but the DLL apps do not compile using Clarion 10.
Error is :
Error(3): cif$fileopen systemstring.inc
This seems to be every clw
Any help welcome
Cheers
Vinnie
124
Web Server - Ask For Help / Re: Safari 7.04 Browser and Login Form .
« on: February 12, 2015, 10:20:15 AM »
Sorry Brian I did not explain.
Yes clear the password on the MAC browser.
Cheers
Yes clear the password on the MAC browser.
Cheers
125
Web Server - Ask For Help / Re: Safari 7.04 Browser and Login Form .
« on: February 12, 2015, 08:46:02 AM »
Just to share information.
I had a problem with a client trying to login to my we app using a MAC.
The problem turn out to be that the client saved to password in the browser.
The main difference to example login and my app login is that I also have three fields on my login form.
User and password (which are standard and being saved by the browser save)
but also an ACCOUNT CODE (which is not being saved by the browser)
The main problem other then the client being unable to login is if the client left the login page open the server log would continuously report login request from the client which would look as if client was attacking the server.
I got the client to remove the save password and that client has never had that problem again.
Hope this helps
Cheers
Vinnie
I had a problem with a client trying to login to my we app using a MAC.
The problem turn out to be that the client saved to password in the browser.
The main difference to example login and my app login is that I also have three fields on my login form.
User and password (which are standard and being saved by the browser save)
but also an ACCOUNT CODE (which is not being saved by the browser)
The main problem other then the client being unable to login is if the client left the login page open the server log would continuously report login request from the client which would look as if client was attacking the server.
I got the client to remove the save password and that client has never had that problem again.
Hope this helps
Cheers
Vinnie
126
Web Server - Ask For Help / Re: SSV and GSV
« on: October 20, 2014, 01:02:05 PM »stop('1 Loc:Login = '&Loc:Login)
p_web.SSV('Loc:Login','Loc:Login')
stop('2 Loc:Login = '&Loc:Login)
p_web.SSV('loc:savedlogin','Loc:Login')
stop('3 loc:savedlogin = '&loc:savedlogin)
p_web.SSV('loc:savedlogin', p_web.GSV('Loc:Login'))
stop('4 loc:savedlogin ='&loc:savedlogin)
stop('1 Loc:Login = '&Loc:Login)
p_web.SSV('Loc:Login','Loc:Login')
stop('2 Loc:Login = '&Loc:Login)
p_web.SSV('loc:savedlogin','Loc:Login')
stop('3 p_web.GSV('loc:savedlogin') = '&loc:savedlogin)
p_web.SSV('loc:savedlogin', p_web.GSV('Loc:Login'))
stop('4 p_web.GSV('loc:savedlogin') ='&loc:savedlogin)
127
Web Server - Ask For Help / Re: Help Please (59) Multi site app - I give up
« on: October 18, 2014, 07:56:50 AM »
Hi Kevin
Sorry that did not work out for you.
The zip file does not have any files in it on my system please can you repost the file.
Cheers
Vinnie
Sorry that did not work out for you.
The zip file does not have any files in it on my system please can you repost the file.
Cheers
Vinnie
128
Web Server - Ask For Help / Re: Help Please (59) Multi site app - I give up
« on: October 17, 2014, 10:57:57 AM »
Hi Kevin
Just found another two issues.
Check Surppress Error Messages in Webserver Extension.
claCLA.dll not copied into working folder
Cheers
Vinnie
Just found another two issues.
Check Surppress Error Messages in Webserver Extension.
claCLA.dll not copied into working folder
Cheers
Vinnie
129
Web Server - Ask For Help / Re: Help Please (59) Multi site app - I give up
« on: October 17, 2014, 07:18:06 AM »
Hi Kevin.
I do use the Multsite and it works great.
I did try to compile the Multsite6(59) which is shipped with NT8.28 and this one I had problems with.
My solution was to install NT8.27 and Make a copy of the Multisite6 and compile that version. Only a couple of small errors which is due to me not having insight Graphing but just comment out the three errors and the app compiles great.
I do change the listen port to port 80 rather then sg:ListenOnPort (I think setting do not load correctly)
I reinstalled NT8.28 and now the the copied version still work OK.
Hope this helps your issue.
Cheers
Vinnie
I do use the Multsite and it works great.
I did try to compile the Multsite6(59) which is shipped with NT8.28 and this one I had problems with.
My solution was to install NT8.27 and Make a copy of the Multisite6 and compile that version. Only a couple of small errors which is due to me not having insight Graphing but just comment out the three errors and the app compiles great.
I do change the listen port to port 80 rather then sg:ListenOnPort (I think setting do not load correctly)
I reinstalled NT8.28 and now the the copied version still work OK.
Hope this helps your issue.
Cheers
Vinnie
130
Web Server - Ask For Help / Re: Multi-Host, and mixed SSL \ Non SSL sites
« on: October 16, 2014, 07:05:29 AM »
Yes I am running on a machine in my office which is just a stand PC running Windows 7
I have not used Rackspace so can not help with this but I am not sure that you have to use IIS.
I assume you can just copy the correct files from your local pc onto the virtual pc and run the app.
Cheers
Vinnie
I have not used Rackspace so can not help with this but I am not sure that you have to use IIS.
I assume you can just copy the correct files from your local pc onto the virtual pc and run the app.
Cheers
Vinnie
131
Web Server - Ask For Help / Re: Multi-Host, and mixed SSL \ Non SSL sites
« on: October 15, 2014, 11:38:46 AM »
Hi Ashley,
Yes you are right on both points.
The Multisite exe is running three sites all DLL's. One of which is a cut down version of the main Secure site running onport 443 which the user has to login to to get access to.
Yes you are right on both points.
The Multisite exe is running three sites all DLL's. One of which is a cut down version of the main Secure site running onport 443 which the user has to login to to get access to.
132
Web Server - Ask For Help / Re: Multi-Host, and mixed SSL \ Non SSL sites
« on: October 15, 2014, 09:35:27 AM »
Hi Ashley.
The non secure site is port 80. This is a multisite NetTalk host. This enable the single IP address to check the http://www.sitenames and conect to the correct web server.
The Secure site is on port 443. This site can only be called from https://www.sitename. I can only have one secure site on the single IP address.
If the user enters the http://www.sitename address then this is directed to the port 80 address non secure site. On this site I have a 'Login' on themenu . this has an url to https://ww.sitename which switches to the secure site login page. The user does not see too much change except the secure padlock.
The Certifacte and key (which I created five years ago so I remeber it being easy) I created using the Nettalk tools which creat the Certificate and the key.
I now have two files in \web\certificates folder cpslive.crt and cpslive*.key (cpslive being my webite name)
The Certificate is autorised by Symantecs (Verisign) then .
When I say web server this of course does not use Microsoft IIS server stuff. Server is Windows 7 with NetTalk and Clarion DLL's and my EXE's and DLL's andof course my crt and key files loaded.
If you want to see it work then website is http://www.cpslive.co.uk
secure site http://www.cpslive.co.uk (you will not be able to login)
Hope some of this helps
Cheers
Vinnie
The non secure site is port 80. This is a multisite NetTalk host. This enable the single IP address to check the http://www.sitenames and conect to the correct web server.
The Secure site is on port 443. This site can only be called from https://www.sitename. I can only have one secure site on the single IP address.
If the user enters the http://www.sitename address then this is directed to the port 80 address non secure site. On this site I have a 'Login' on themenu . this has an url to https://ww.sitename which switches to the secure site login page. The user does not see too much change except the secure padlock.
The Certifacte and key (which I created five years ago so I remeber it being easy) I created using the Nettalk tools which creat the Certificate and the key.
I now have two files in \web\certificates folder cpslive.crt and cpslive*.key (cpslive being my webite name)
The Certificate is autorised by Symantecs (Verisign) then .
When I say web server this of course does not use Microsoft IIS server stuff. Server is Windows 7 with NetTalk and Clarion DLL's and my EXE's and DLL's andof course my crt and key files loaded.
If you want to see it work then website is http://www.cpslive.co.uk
secure site http://www.cpslive.co.uk (you will not be able to login)
Hope some of this helps
Cheers
Vinnie
133
Web Server - Ask For Help / Re: Multi-Host, and mixed SSL \ Non SSL sites
« on: October 15, 2014, 06:48:06 AM »
Hi Debra
No this can not be done.
I do have a Multi Site host but only on port 80 non secure.
I also have a secure site on port 443 but that runs on a separate exe.
On the non secure site when the user presses the login button I redirect them to the secure site.
This will only work for one secure site port 443 and multi sites non secure sites on port 80.
I think the main problem is still that the www.sitename is encrypted for the secure site. There may be an option in the future the sort this but not now.
Cheers
Vince
No this can not be done.
I do have a Multi Site host but only on port 80 non secure.
I also have a secure site on port 443 but that runs on a separate exe.
On the non secure site when the user presses the login button I redirect them to the secure site.
This will only work for one secure site port 443 and multi sites non secure sites on port 80.
I think the main problem is still that the www.sitename is encrypted for the secure site. There may be an option in the future the sort this but not now.
Cheers
Vince
134
Web Server - Ask For Help / Re: SSL question
« on: October 14, 2014, 08:38:13 AM »
Hi Ashley.
Not sure why you are using IIS's I think this is a much harder way of creating a certificate.
You can create a certificate using the NetTalk options
Instructions here
http://capesoft.com/docs/NetTalk8/NetTalkWebSecure.htm#CreatingACertificate
Which port NetTalk uses can then be set in your app. The Certificate does not need to know the port. Or which machine is is being run on.
After you have your certificate working on your machine then you need to have the certificate authenticated.
Bruce did a Webinar on this a couple of weeks ago. www.capesoft.com/ftp/public/webinars/UG_NT037_20140925_NetTalkUserGroupMeeting37.wmv
This will help
.
Hope I am helping but you may of course already done this process.
Any way
Cheers
Vinnie
Not sure why you are using IIS's I think this is a much harder way of creating a certificate.
You can create a certificate using the NetTalk options
Instructions here
http://capesoft.com/docs/NetTalk8/NetTalkWebSecure.htm#CreatingACertificate
Which port NetTalk uses can then be set in your app. The Certificate does not need to know the port. Or which machine is is being run on.
After you have your certificate working on your machine then you need to have the certificate authenticated.
Bruce did a Webinar on this a couple of weeks ago. www.capesoft.com/ftp/public/webinars/UG_NT037_20140925_NetTalkUserGroupMeeting37.wmv
This will help
.
Hope I am helping but you may of course already done this process.
Any way
Cheers
Vinnie
135
Web Server - Ask For Help / Re: SSL question
« on: October 13, 2014, 08:36:26 AM »
'' Firefox wanted to know if I still wanted to turn the exception on for my program.
This is normal. If you have purchased a SSL Cert then this would normally be for https://www.
If you test https://127??? then the cert is only for the https://www. so Browser will ask for exception.
If browser is asking for exception then SSL is working.
Hope I am understanding your problem correctly.
Cheers
Vince
This is normal. If you have purchased a SSL Cert then this would normally be for https://www.
If you test https://127??? then the cert is only for the https://www. so Browser will ask for exception.
If browser is asking for exception then SSL is working.
Hope I am understanding your problem correctly.
Cheers
Vince