502615 Extract info from textfiles / import into MySQL database.

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


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)




Hi Webmaster

There is a new registration :

Username : Taylor57

Passwordd: 04tarr

E-Mail : rr *[url removed, login to view]

Profile Owner : m (=male)


Beceriler: Her şey Kabul, Veri Tabanı Yönetimi, MySQL

Daha fazlasını gör: sample eml files, rr profile, rr mail, rr login in, rr login, login rr email, eml file sample, email rr login, mysql data files, rr, info, extracts, extract tables, eml file, data extract from website, file email extract, mysql read files, mysql database import, mysql login password, mysql stuff, website database extract, messages lost, mysql create table data, mysql signup, mysql create table fields

İşveren Hakkında:
( 32 değerlendirme ) Tongeren, Belgium

Proje NO: #2248537



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)