502615 Extract info from textfiles / import into MySQL database.
N/A
Teslim sırasında ödenir
Can you import information from several textfiles into a mysql database? IMPORTANT: Please read the part under "NOTE"
The information that needs to extract from those text files are:
- username
- sex
- signup date
- emailadres
- password
The information must imported in 2 tables
table 1 (name: login)
- ID
- username
- Password
table 2 (name: userdata)
- ID
- username
- reg. date
- website (if available)
- other fields set to some default or leave emtpy
NOTE!
The most important thing in this project is TO CREATE a routine that EXTRACTS the info from the textfile so that it can be imported. The textfile was originally an EML (=email) message. (sample included)
We lost our userdatabase and we hope to restore it with these signup messages (2200 signups). A sample text files is added so you can see where its needs to be extracted from.
In the text file this is the important stuff:
*****
Date .... (=signup date new member)
*****
and
*****
Hi Webmaster
There is a new registration :
Username : Taylor57
Passwordd: 04tarr
E-Mail : rr *[url removed, login to view]
Profile Owner : m (=male)
****
Proje NO: #2248537