WebClientAPI
-
- New in Town / Le Ptit Nouveau
- Posts: 29
- Joined: Wed Apr 17, 2019 1:09 am
WebClientAPI
Hi Simon,
I'm reading the code from the WebClientAPI and see that the code is to update the .DB file
I want to understand how we can ask the Simulator to use the .DB files for loading the Roster & the Lines?
Thanks a lot
I'm reading the code from the WebClientAPI and see that the code is to update the .DB file
I want to understand how we can ask the Simulator to use the .DB files for loading the Roster & the Lines?
Thanks a lot
-
- STHS Owner / Propriétaire du STHS
- Posts: 14804
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: WebClientAPI
There.
You either do it manually by download the .DB file in your input folder OR you do it automatically by selecting the "Load SQLite Database from Website before Loading Lines Files" option and making sure your Website URL is correct in the output option.
You either do it manually by download the .DB file in your input folder OR you do it automatically by selecting the "Load SQLite Database from Website before Loading Lines Files" option and making sure your Website URL is correct in the output option.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
-
- New in Town / Le Ptit Nouveau
- Posts: 29
- Joined: Wed Apr 17, 2019 1:09 am
Re: WebClientAPI
Hi Simon,
Let me rephrase if I understand it’s correctly or not.
1. After simulation the DB at the Output folder
2. Assume that copy .DB file to the Input folder & point point the API to this .DB
3. When I simulate, the lines change will be effected after I simulate & we repeat the step 1.
Thanks Simon
Let me rephrase if I understand it’s correctly or not.
1. After simulation the DB at the Output folder
2. Assume that copy .DB file to the Input folder & point point the API to this .DB
3. When I simulate, the lines change will be effected after I simulate & we repeat the step 1.
Thanks Simon
-
- STHS Owner / Propriétaire du STHS
- Posts: 14804
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: WebClientAPI
1. After simulation the DB at the Output folder, upload on your web server
2. Before your next simulation, download an copy of .DB from your web server to the Input folder.
3. When the Load Lines function will run, either manually using the Run the "Auto Load Lines" from the menu or right before simulation if you have the option selected in the STHS, the change in the DB will be process.
2. Before your next simulation, download an copy of .DB from your web server to the Input folder.
3. When the Load Lines function will run, either manually using the Run the "Auto Load Lines" from the menu or right before simulation if you have the option selected in the STHS, the change in the DB will be process.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
-
- New in Town / Le Ptit Nouveau
- Posts: 29
- Joined: Wed Apr 17, 2019 1:09 am
Re: WebClientAPI
Hi Simon,
Thank you so much
Thank you so much
-
- New in Town / Le Ptit Nouveau
- Posts: 29
- Joined: Wed Apr 17, 2019 1:09 am
Re: WebClientAPI
Hi Simon,
I did try to follow the steps.
1. I change lines and save to .DB file (I use sql to check again and see data updated correctly in TeamFarmLines, TeamFarmLinesNumberOnly
2. I put the this file in the Input Folder, and run the "Auto Load Lines" - > The notification = Load & Process League DB File
3. However, when I open the Team Lines I use to test. There is no updated at all
Can I check with you if I missed any step.
TQ
I did try to follow the steps.
1. I change lines and save to .DB file (I use sql to check again and see data updated correctly in TeamFarmLines, TeamFarmLinesNumberOnly
2. I put the this file in the Input Folder, and run the "Auto Load Lines" - > The notification = Load & Process League DB File
3. However, when I open the Team Lines I use to test. There is no updated at all
Can I check with you if I missed any step.
TQ
-
- STHS Owner / Propriétaire du STHS
- Posts: 14804
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: WebClientAPI
You modify the .DB how? If you modify directly, you need to a change the value WebClientModify to True also for the STHS to process it.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
-
- New in Town / Le Ptit Nouveau
- Posts: 29
- Joined: Wed Apr 17, 2019 1:09 am
Re: WebClientAPI
Hi Simon,
Thanks for the instruction.
I did modify the code to update WebClientModify to True in TeamFarmLinesNumberOnly & TeamProLinesNumberOnly.
For TeamFarmLines & TeamProLines. There is no field of WebClientModify.
I did double check in .DB file and it was updated. When I do the Auto Load Lines. The function is not working.
Seeking for your support.
Thanks
Thanks for the instruction.
I did modify the code to update WebClientModify to True in TeamFarmLinesNumberOnly & TeamProLinesNumberOnly.
For TeamFarmLines & TeamProLines. There is no field of WebClientModify.
I did double check in .DB file and it was updated. When I do the Auto Load Lines. The function is not working.
Seeking for your support.
Thanks
-
- STHS Owner / Propriétaire du STHS
- Posts: 14804
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: WebClientAPI
Well, are you sure you are loading the DB correctly? Can you try it with the manuel command "Process Database".
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
-
- New in Town / Le Ptit Nouveau
- Posts: 29
- Joined: Wed Apr 17, 2019 1:09 am
Re: WebClientAPI
Hi Simon,
Thanks a lot for your response but still even I run that command, they said processed successfully but still I can not see the change when I try to open the file again.
I will put the details to see if I missing anything.
1. CEO simulate & output the .DB file
2. I use this .DB file and upload the location to point the WebClient to:
3. I use WebClient to update the Line15vs5ForwardTime from 35 to 33 (new value) and increase Line2 by 2 so make sure it's 100
4. I click save, I get a copy of this .DB and run the SQL to see if data updated correct or not (It's correct & the Flag WebClientUpdate is True)
5. I put this new updated .DB file in the Input folder which is config in the Simulator
6. I cluck Simulate > Auto Load Lines (or run the command) --> Its success
7. I go back to the Tean Line and see, the Line15vs5ForwardTime value still 35.
So the DB was updated correctly but by some reason the loading is not effective.
Is there anything I'm missing here
Best Regards
Thanks a lot for your response but still even I run that command, they said processed successfully but still I can not see the change when I try to open the file again.
I will put the details to see if I missing anything.
1. CEO simulate & output the .DB file
2. I use this .DB file and upload the location to point the WebClient to:
3. I use WebClient to update the Line15vs5ForwardTime from 35 to 33 (new value) and increase Line2 by 2 so make sure it's 100
4. I click save, I get a copy of this .DB and run the SQL to see if data updated correct or not (It's correct & the Flag WebClientUpdate is True)
5. I put this new updated .DB file in the Input folder which is config in the Simulator
6. I cluck Simulate > Auto Load Lines (or run the command) --> Its success
7. I go back to the Tean Line and see, the Line15vs5ForwardTime value still 35.
So the DB was updated correctly but by some reason the loading is not effective.
Is there anything I'm missing here
Best Regards
-
- STHS Owner / Propriétaire du STHS
- Posts: 14804
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: WebClientAPI
Give me your website URL please.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
-
- New in Town / Le Ptit Nouveau
- Posts: 29
- Joined: Wed Apr 17, 2019 1:09 am
Re: WebClientAPI
Hi Simon,
Please find below for the link that we are testing now, I remove the password verification step so that the change can be made directly to the DB
WebClient Link:
http://www.lhdgv.ca/WebClientIndex.php
DB Link:
http://www.lhdgv.ca/STHS.db
--> This is the DB file after change I use to put into Input Folder.
Thank you for your help.
BR
Please find below for the link that we are testing now, I remove the password verification step so that the change can be made directly to the DB
WebClient Link:
http://www.lhdgv.ca/WebClientIndex.php
DB Link:
http://www.lhdgv.ca/STHS.db
--> This is the DB file after change I use to put into Input Folder.
Thank you for your help.
BR
-
- STHS Owner / Propriétaire du STHS
- Posts: 14804
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: WebClientAPI
Why are you changing the DB file name? You shouldn't change it's name. That probably why it doesn't work when loading, it doesn't load because it doesn't look for the correct name.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
-
- New in Town / Le Ptit Nouveau
- Posts: 29
- Joined: Wed Apr 17, 2019 1:09 am
Re: WebClientAPI
Hi Simon,
I changed the name to test.
I did keep the name as the output as: LHDGV2020-SEASON.DB now but still not working (even the data insides the DB updated correctly through the client with flag WebClientModified = True
Can you help to look into this?
Is there any option in the client I need to change?
Thanks Simon
I changed the name to test.
I did keep the name as the output as: LHDGV2020-SEASON.DB now but still not working (even the data insides the DB updated correctly through the client with flag WebClientModified = True
Can you help to look into this?
Is there any option in the client I need to change?
Thanks Simon
-
- STHS Owner / Propriétaire du STHS
- Posts: 14804
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: WebClientAPI
The file should be "LHDGV2020-STHS.db". Did you keep changing the name around?
When you "click Simulate > Auto Load Lines (or run the command)". Do should see the message "Load and Process SQLite Database complete." when the DB is load correctly in the STHS.
When you "click Simulate > Auto Load Lines (or run the command)". Do should see the message "Load and Process SQLite Database complete." when the DB is load correctly in the STHS.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français