SergioFeitoza

Dear Fred Please read this and thanks for the help

Dear Ingsoft Please read this and thanks

Dear Peter Please read this and thanks

Below are links for FREE access to 2 codes. The test period (*) will go up to June 30th. My goal is to help engineering teams from undeveloped countries. Maybe, after the test period , I will keep it FREE, I will wait for the reactions to decide. The user need only to register an e-mail and create a password. I even removed the e-mail confirmation. Comments on errors and bugs are very welcome. Remember , this is an experimental period and bugs will come Comments and suggestions are welcome Thanks again to all and regards. Sergio Feitoza Costa The link https://www.cognitor.com.br/instructions.html _________________________________________ ( * ) The technical part is unique and reasonably tested. The Delphi + (free) GLScene VCL version is used by companies for more than 10 years. The only difference is that the rare 3D results visualization is not in the Unigui version. I am trying to create 3D components for Unigui based on GLscene. My concern is the “easy” login system. In my case, security is not an issue.

Thanks, Abaksoft. In my case, doing everything directly in the Remote Area, where will deploy, avoids doing things twice. The issue is if the Remote Area is “slow” to work with Delphi + Unigui. Here with the current provider is worse than my home localhost. I am changing provider and will know soon if others are better. With the help of Unigui team and some other colleagues in the forum I succeeded to develop and deploy my code. Thanks to all. I will not mention names to avoid forgetting someone. Below are links to FREE access to 2 codes. The test period will go up to June 30th. As my goal is to help engineering teams from undeveloped countries, maybe, after, I will keep it FREE, I will wait for the reactions to decide. The technical part is unique and reasonably tested. The Delphi + (free) GLScene VCL version is used by companies for more than 10 years. The only difference is that the rare 3D results visualization is not in the Unigui version. I am trying to create 3D components for Unigui based on GLscene. My concern is the “easy” login system. In my case, security is not an issue. The user need only to register an e-mail and create a password. I even removed the e-mail confirmation. Let´s see how it will work. Without the help of this forum, it would not be possible to conclude. Comments on errors and bugs are very welcome. Thanks again to all and regards. Sergio Feitoza Costa The link https://www.cognitor.com.br/instructions.html

Hi Peter. You have quite good activities. I made many friends in the Netherlands in the last 40 years (I am 66 and took the vaccine yesterday). For some time, I was a kind of agent of Kema in Brazil.. Great to read about your music festival www.bospop.nl. After becoming a recognized engineer in the “energy area”, in the last years I am changing my focus to music production and books writer. I am a songs composer, guitar player, sing a little bit and I have now 5 CD’s / DVDs produced. That´s why I am putting this software free in the web to finally remove the bonds that still hold me in R&D engineering. This week I will be making also available a pdf reader made with Unigui with my last book “ The Cosmic Engineers in the Country of Amazonia … “ Links in http://www.cognitor.com.br Cheers Sergio

I am used to prepare my code in the home localhost, I test everything, adjust ISS and deploy the code in C:\MyDLLDirectory into the localhost. Then I click http://localhost/MyCode and can see running in the browser After I copy the C:\MyDirectory, with the DLL, to the Remote Area VPS, adjust again the IIS there and run the code via browser typing http://XXX.YY.ZZ.WW/MyCode Seems to be easier to install Delphi + Unigui in the localhost of the Remote Area VPS, to prepare the DLL there and, at the end, the only difference is the address which you will type in the browser. Is this last one the more common practice? or Remote Areas use to be “more slow” to develop the code and to arrive to the DLL?

Dear Mierlp. Thank you very much for your great help. Your text is excellent and gave me all the information I needed to decide. It was the first time that I saw a text that explains well, for humans, these concepts. I imagine you apply training as it is very didactic. I am going to hire a plan today. I was curious and visited his website http://www.eventsoft.nl . Congratulations, the product and the site are great. I saw that you are from WEERT (Netherlands). I used to go to Arnhem a lot at the KEMA labs. They have the most important testing laboratories for large electrical equipment in the world. These are very expensive tests. I also worked and managed laboratories of this type. There are few in the world. My SwitchgearDesign software is perhaps the only one in the world that simulates these tests. In 1 or 2 days you will be able to see the release of the free web version at this link https://www.cognitor.com.br/SwitchgearDesign.html The Delphi VCL version has been in use for more than 10 years but the web version completely new. I would not have been able to complete the WEB / Unigui version without the help of some 10 people from this forum who help me as you did. I will not mention the names to avoid forgetting someone. Thanks to all Sergio Feitoza

Thanks This is what I am checking just now

Thanks .. I will check again this morning . The code qorks well in the Remote Area except for the outgoing e-mail. However I installed Outlook in the Reote Area and created the same gmail account and workd. I will check what is written PORT in my code. I will inform

Hi Mierlp This is great. I did not know it exists . Tomorrow I will read in details. Thank you very much. Great help Actually I passed some hours this afternoon checking Contabo. that I think I will contract. I am studying more to buy the right initial plan, possibly tomorrow The doubts I am trying to clarify to select the proper minimum plan are: Question 1 - How does the provider VPS work?: In my current provider I access the Windows Remote Area that they have made available, I place the program's DLL in the 😄 /MyDLLDirectory , adjust the ISS and then just enter the address in the browser. Everything equal to what I do here at home on localhost. Before, I installed MySql in the remote area. My doubt is if In CONTABO and other VPS providers the procedure is the same Question 2 - which plan to choose: I will put 1 or 2 “calculators” with a 32MB DLL that uses a small MySql database. These are specific calculations and I think should never have more than 2 to 3 simultaneous users. Most likely to have only one user at a time and from time to time. Do the plan that you listed meet my needs. I think YES Question 3 : If it is a Remote Area the common thing is to have available a MySql and ISS operating or do I need to install? Question 4: If I want to put in the same remote area - in another directory - besides the DLL one - a very little html PHP site does this work?

Hi Peter. Thank you very much for your time exposing the points of view. Especially useful and didactic. The reason for using gmail is as just because is simpler. After many experiences I rely more in my sergiofeitozacosta@gmail.com than in my sergiofeitoza@cognitor.com.br ( from www.cognitor.com.br my consultancy company ). The idea here is to send very few e-mails. Only automatic confirmation messages for (few) people which is registering to use my software. I am almost stopped sending e-mails. People do not like them anymore whichever is sender. Anyway, for sending bulk e-mail divulging the engineering trainings I was used to apply I have a service from Leadlovers. I intend to stop with it this year. People now do not like anymore to receive e-mails. I checked the 3 options which you detailed very well. They are professional ways of doing the thing. However, my objective is just to put my rare engineering software SwitchgearDesign working in the web (free in the first 3 months – almost free after) and to forget it after. I am dedicating most of my time to other activities and the software will remain there as a kind of heritage for younger people. I will put the link for access here next days. So, I will try to discover what is missing in the Remote Area that makes to fail instead of working perfectly as in my home localhost. Maybe the reason is just a DLL missing in the SysWoww64 as above. Or something in my provider ( I am changing this week) Regards and thanks again

Thanks and Good idea I will check. Anyway I am going today or tomorrow to put my dll in a new provider and will able to see if works there. The fact is that in my localHost everything works perfectly. In the Remote Area of the provider only the Email is not been receiving (although no error message) Unfortunately, the REMOTE AREA is not working for doing the test. Something tells me that in a better provider it will work as well as in my localhost

Thank you very much Andyhill . I understood and will implement this also , in addition to the above. My provider Remote Area is Windows Server 2012 As I wrote in another post of yesterday I am looking for a new provider which works better than my current one. I hope to conclude this today

I am looking for a provider to host my Unigui DLL My program made with Unigui now runs right in the Remote Area on my provider using IIS. However, the support does not answer my doubts well and, for example today, the Remote Area stopped working. As I cannot trust in just one service, I am looking for an additional provider just to host the DLL. I intend to leave the other website and email services at the current provider as they work, and I do not depend on them so much. Can any of you suggest providers for this service at reasonable prices? If it is not proper to write here, please write the contact information to my email sergiofeitozacosta@gmail.com The relevant thing is that it is used for the same purpose by some of you and that the provider has a support that at least answer the questions.

Hi friends I deployed my code and is working well in my home localhost and also in the Windows Remote Area where I deployed with IIS It uses a data base MySql I did a login system which requests e-mail confirmation when registering. The classical Indy code is below. Someone which is registering clicks the button REGISTER and an e-mail is sent asking for clicking the token for e-mail confirmation. It works nice in the localhost. The user clicks the confirmation e-mail and the program becomes accessible (mainmodule.before login). MY PROBLEM: When I put the dll in the remote area and access it I arrive properly to the login page. When I click the REGISTER button I see the message “ Email was sent … click the link to confirm” and do not receive any error message . However the e-mail do not arrive in the box – to br clicked Is it necessary to do any adjustment in the code bellow? For example something like IdSMTP.Host := ' 158.XX.YY.ZZ/smtp.gmail.com'; Thanks in advance ---------------------------------------------------------- function TEmail.Send: boolean; // Indy var IdSSLIOHandlerSocket: TIdSSLIOHandlerSocketOpenSSL; IdSMTP: TIdSMTP; IdMessage: TIdMessage; begin IdSSLIOHandlerSocket := TIdSSLIOHandlerSocketOpenSSL.Create(Nil); IdSMTP := TIdSMTP.Create(Nil); IdMessage := TIdMessage.Create(Nil); try IdSSLIOHandlerSocket.SSLOptions.Method := sslvSSLv23; IdSSLIOHandlerSocket.SSLOptions.Mode := sslmClient; IdSSLIOHandlerSocket.SSLOptions.SSLVersions := [sslvTLSv1, sslvTLSv1_1, sslvTLSv1_2]; IdSMTP.IOHandler := IdSSLIOHandlerSocket; IdSMTP.UseTLS := utUseImplicitTLS; IdSMTP.AuthType := satDefault; // Using gmail Server (do not modify this) IdSMTP.Host := 'smtp.gmail.com'; IdSMTP.Port := 465; IdSMTP.Username :='myEmail@gmail.com'; // (1) IdSMTP.Password :='xxxxxxxxxxxxx'; // From IdMessage.From.Address :='MyEmail@gmail.com'; IdMessage.From.Name := 'From Me'; IdMessage.Recipients.Add.Text := fToEmailAdresse; IdMessage.Subject := fObject; IdMessage.ContentTransferEncoding := '8bit'; IdMessage.ContentType := 'text/plain'; IdMessage.CharSet := 'UTF-8'; IdMessage.Body.Clear; IdMessage.Body.Text:=fMessage; ferror:=False; fmes:='E-mail sent succesfully.'; try IdSMTP.Connect; IdSMTP.Authenticate; except on E: Exception do begin ferror:=True; fmes:=E.Message; end; end; if not ferror then begin try IdSMTP.Send(IdMessage); except On E: Exception do begin ferror:=True; fmes:=E.Message; end; end; end; finally IdSMTP.Disconnect; UnLoadOpenSSLLibrary; FreeAndNil(IdMessage); FreeAndNil(IdSSLIOHandlerSocket); FreeAndNil(IdSMTP); end; result:=not ferror; end;

Thank you very much Mohammed. You are right. Yesterday I checked again and corrected a mistake I was doing . It is now working well as before and Mydac components are working correctly

Thanks for your comments. L will try to identificate what is not working well here in the update of the MySql table. The test I will do is the following .MyDac.bmp I use the code below in the VCL version of my code to duplicate a line of the “MyDacQuery” associated with a table in the MySql. I just click the button with the code below and a new line is created duplicating an existing. It works perfectly and the MySql table is updated doing only this In my Unigui version I use exactly the same thing and components. In your opinion this should work well in the Unigui version (from the point of view of the MySql being updated) ? procedure TF0D.DuplicateLineofTableClick(Sender: TObject); var i: integer; begin with MyDacConnection do begin for i := 0 to DataSetCount - 1 do DataSets[i].DisableControls; end; try DuplicateCurrentRecordJ(MyDacQuery); except ShowMessage ('Error duplicating a line of MyQuery'); end; with MyDacConnection do begin for i := 0 to DataSetCount - 1 do DataSets[i].EnableControls; end; end; procedure TF0D.DuplicateCurrentRecord (aDataSet: TMyQuery); var Data: array of variant; aRecord: array of TVarRec; i: integer; max: integer; begin max := aDataSet.fields.count - 1; // set the lenghth of the arecord array to be the same as the number of elements in the data array SetLength(aRecord, max + 1); SetLength(Data, max + 1); // set the variant type pointers to the data array for i := 0 to max do begin aRecord[i].VType := vtVariant; aRecord[i].VVariant := @Data[i]; end; // Copy the Record to the Array for i := 0 to max do begin if i <> 1 then Data[i] := aDataSet.fields[i].value else Data[i] := aDataSet.fields[i].value + '_bis'; // change only the title of the new record end; // finally append the record in one go aDataSet.AppendRecord(aRecord); end;

Thank you Mohammed My problem to send a test case is that my code is a very big one and it is almost impossible to separate a part representative of the problem (see the figure) I constructed the program exactly as you describe your case . I use MySql and I think that - from the point of view of saving the data in MySql tables - the version Unigui was working correctly before. That is, when I changed the boxes in my code (figure) the MySql table was updated. Now what happens is that when I am running the code everything seems to be OK . I change values and they are changed but the changes do not aarive to the MySql table. It is like opening MySql workbench , open a table, change a valure BUT do not click the APPLY button. I do not know the reason. It iss like being protected Let me put the question in another way: Do you know any small demo usinh Unigui + MySql + any database component ? Maybe Unidac.

I use the same database components to connect – as well - the VCL Delphi version and the Unigui version. In the VCL version, when I change a value in my screen the change is automatically done in the MySql tables. I suppose that this is the main function of the database components. To do this in the VCL version it is sufficient to use the “Delphi” statements like try SQL.Text := 'SELECT * FROM t_lastcalc'; Open; Append; FieldByName('Fuel').AsString := tipo_projetoSTR; FieldByName('TypeOfPlant').AsString := tipo_plantaSTR; Post; finally Free; end; However, when doing the final tests of my Unigui code, to deploy in the web, I noticed that for the Unigui version the phases above work when the code is running but they are not sufficient to save the changes automatically in the MySql database. I do not know if I did some undue modification to provoke this. In my Unigui version, to succeed in updating the MySql data base I need to use the classical MySql queries like: AddNewUser := TMyQuery.Create(nil); try AddNewUser.Connection := uniMainModule.MyConnection; AddNewUser.SQL.Clear; AddNewUser.SQL.Add('INSERT INTO hpl.USERS (LOGIN,DATEREGISTER) VALUES (:LOGIN,:DATEREGISTER);'); AddNewUser.ParamByName('LOGIN').AsString := LOGIN; AddNewUser.ParamByName('DATEREGISTER').AsDateTime := now; AddNewUser.Execute; finally AddNewUser.Free; end. As I work with a table with some 80 columns it is hard to update the tables using MySql queries. I think I am missing something. Otherwise, what would be the reason for not using only Delphi native components? Could you please clarify if, in my Unigui code, I am obliged to use the MySql statements instead of – only - the components language that I use in the VCL version ? Thanks, in advance.

Hi Fred This demo you posted is really very good I will implement it in my code Thank you very much again

Thank you very much Fred. Months ago I tried a lot to deploy with Apache, Xamp.. The best lesson was to deploy with IIS . When I followed step by step the instructions in this forum (as in some posts I did) I succeeded with IIS which is - for the purposes of Unigui - sufficiently documented . Regards and thanks again

Caro Fred Muiito Obrigado Resposta muito útil, completa e bem explicada . Vou trabalhar nela agora Dear Fred Thank you Very useful, complete and well explained answer. I will work on it now

Caro Fred Muiito Obrigado Resposta muito útil, completa e bem explicada . Vou trabalhar nela agora Dear Fred Thank you Very useful, complete and well explained answer. I will work on it now

If I am in my computer and want to save a printscreen on my C:/sergiodirectory I do: a) Click the keyboard key PrintScreen b) Open my old Paint c) Click Control+V putting the myimage in Paint d) SaveAs myImage in the directory C:/sergiodirectory e) What is the Unigui code (and where to insrt it step by step) that I have to write in my Unigui code to do exactly this ?