Lottery Statistics Homepage
Forum Home Forum Home > LSA Forums > General LSA Support
  New Posts New Posts RSS Feed - Draw Data Imports v7
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Draw Data Imports v7

 Post Reply Post Reply
Author
Message
Administrator View Drop Down
Admin Group
Admin Group
Avatar
Admin

Joined: 04 Jun 2013
Status: Offline
Points: 162
Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Topic: Draw Data Imports v7
    Posted: 19 Apr 2018 at 9:23pm
Hi all

This week I have been working on draw imports for LSAv7, a feature I know many users will appreciate. This will enable a user to simply point LSA to a web link or a local file and it should (in theory)  take the data, parse out any unwanted data and append the current loaded database with missing draw data.

Currently I have LSA successfully importing CSV data from the UK lotto website, this is a file offered by the UK lotto containing only draw data.

I would like to step this feature up and allow a user to point to an actually webpage and have LSA strip out all none draw data and use the results.

Now I ask for some assistance.

I need links, so have you a favourite site you get data from or do you take it from a local file perhaps belonging to another lottery software, a RSS feed maybe, anything.

Please post below, I will then ensure the next release can handle importing from all the sources posted, the more you can provide the better this feature will be.

To note, I already know it will not be possible to grab data from a webpage that requires you to select a date range and click a button to display the results, way too much coding for millions of scenarios. The lottery text must be all on one page.

Back to Top
Technut View Drop Down
Moderator Group
Moderator Group
Avatar

Joined: 18 Jan 2014
Location: United States
Status: Offline
Points: 131
Post Options Post Options   Thanks (0) Thanks(0)   Quote Technut Quote  Post ReplyReply Direct Link To This Post Posted: 20 Apr 2018 at 2:31pm
i have already posted the links to texas lottery pages. I also have csv files I directly update myself. They are formatted like this : mm/dd/yyyy,#,#,#,# or mm/dd/yyyy,##,##,##,##,## etc. top line is most recent draw then descending order. the links are for downloading the data history for the games. The csv files they provide contain extra info not needed by the program so I have stripped the useless info from the data.

Texas CSV files updated thru 04/19/18 link below.

https://app.box.com/s/5do0a45ltrfdtmc8pqwaikfhi0thiyu1

Edited by Technut - 20 Apr 2018 at 2:42pm
Yesterday is History, Tomorrow is a Mystery, Today is a gift thats why its called the PRESENT! (c8
Back to Top
watchitt View Drop Down
Newbie
Newbie


Joined: 15 Jan 2015
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote watchitt Quote  Post ReplyReply Direct Link To This Post Posted: 23 Apr 2018 at 6:30pm
Try this website for Canadian lotteries

They are initially zip files but extract to full csv, and are up to date

http://lotto.bclc.com/winning-numbers/lotto-649-and-extra.html

http://lotto.bclc.com/winning-numbers/lotto-max-and-extra.html
Back to Top
Cozydog View Drop Down
Newbie
Newbie
Avatar

Joined: 12 Mar 2018
Location: Illinois
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote Cozydog Quote  Post ReplyReply Direct Link To This Post Posted: 23 Apr 2018 at 6:32pm
WI Badger 5:  https://www.wilottery.com/lottogames/badger5Allhistory.aspx
Back to Top
AlexD View Drop Down
Newbie
Newbie


Joined: 21 Apr 2018
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote AlexD Quote  Post ReplyReply Direct Link To This Post Posted: 24 Apr 2018 at 2:34am
Romania 6/49 http://www.loto49.ro/arhiva-loto49.php

everything is already on that page and it seems to be updated regularly.  dates are before numbers and on a different format but i think it's usable
Back to Top
Administrator View Drop Down
Admin Group
Admin Group
Avatar
Admin

Joined: 04 Jun 2013
Status: Offline
Points: 162
Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 02 May 2018 at 10:33pm
Thanks all, I am working on all these links.
Back to Top
JJJJJJ View Drop Down
Newbie
Newbie


Joined: 15 Oct 2018
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote JJJJJJ Quote  Post ReplyReply Direct Link To This Post Posted: 16 Oct 2018 at 6:43pm
https://www.wilottery.com/Zaxon550@gmail.com
Back to Top
timtam View Drop Down
Newbie
Newbie
Avatar

Joined: 10 Feb 2017
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote timtam Quote  Post ReplyReply Direct Link To This Post Posted: 19 Oct 2018 at 12:43pm
Hi there,
Here is a good website for the Australian Lotteries:
https://www.lotterywest.wa.gov.au/results/

and
www.thelott.com

When is the V7 going to be available?
I really appreciate the great effort on LSA again. :-)
timtam
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.078 seconds.