Devam Ediyor

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

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)

****

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

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

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

Proje NO: #2248537

Seçilen:

herpay

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

0 gün içinde 20$ USD
(127 Değerlendirme)
5.5