502615 Extract info from textfiles / import into MySQL database.

Tamamlanmış İlan edilme: Jun 2, 2011 Teslim sırasında ödenir
Tamamlanmış 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)

****

Veri Tabanı Yönetimi MySQL Odd Jobs

Proje NO: #2248537

Proje hakkında

1 teklif Uzak proje Aktif Jul 11, 2012

Seçilen:

herpay

Hello, I can make it within several hours after you accept my bid. Regards, Tamas

%selectedBids___i_period_sub_7% gün içinde 20%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(127 Değerlendirme)
5.5