Cancelled

Data Parser for date and time old

I have about 29k database records with event times in plain text format. I need to parse the plain text into SQL to insert into an events table.

The data format would be: Day of week, start time, name, language

If a day of week is not provided assume it's Sunday.

Attached is some sample data. Each line represents a different type of text format. I can provide a full data export.

Here's the schema and some default values:

CREATE TABLE `Event` (

`id` int(10) unsigned NOT NULL auto_increment,

`name` varchar(75) NOT NULL,

`description` varchar(255) default NULL,

`dayofweek` int(10) unsigned NOT NULL,

`starttime` int(10) unsigned NOT NULL,

`length` int(10) unsigned NOT NULL,

`type` int(10) unsigned default NULL,

`status` int(10) unsigned NOT NULL,

`organizationid` int(10) unsigned NOT NULL,

`language` int(10) unsigned default NULL,

PRIMARY KEY (`id`)

);

name: default to "Worship Service" if no name is given

dayofweek: sunday = 1, saturday = 7 (default to sunday if no day of week is given)

type: worship service = 1, bible study = 2, youth group = 3, sunday school = 4 (default to '1' if no name is given)

starttime: military time 24 hour clock

length: default to 0100 (one hour)

organizationid: the first column in the csv file

status: set to '2'

language: default to null if a language is not specified. If a language other than English is specified then prepend the language in the name of the event. For example a spanish event would be "Spanish Worship Service"

Here's a language mapping:

English => 1

Spanish => 2

Korean => 3

Chinese => 4

Japanese => 5

Russian => 6

Portuguese => 7

French => 8

German => 9

Italian => 10

Indian => 11

Other => 12

Skills: Engineering, MySQL, PHP, Software Architecture, Software Testing

See more: primary data, php language study, one key data, c for int, time in korean, Korean to Spanish, korean to chinese, bible korean, type chinese, time table, Time study, spanish german and italian, sample data, russian korean, russian data, old school, name for chinese english, japanese portuguese, japanese italian, japanese full time

About the Employer:
( 12 reviews ) United States

Project ID: #2915302

14 freelancers are bidding on average $68 for this job

stephen85

See private message.

$42.5 USD in 14 days
(153 Reviews)
6.0
inadilemma

See private message.

$34 USD in 14 days
(41 Reviews)
5.1
edreamzinc

See private message.

$85 USD in 14 days
(24 Reviews)
5.1
vw7258315vw

See private message.

$25.5 USD in 14 days
(48 Reviews)
4.7
izharuislam

See private message.

$72.25 USD in 14 days
(27 Reviews)
4.5
SajidYousuf

See private message.

$63.75 USD in 14 days
(16 Reviews)
4.5
ilnlivw

See private message.

$55.25 USD in 14 days
(21 Reviews)
3.9
getitrightvw

See private message.

$25.5 USD in 14 days
(31 Reviews)
3.9
tatasthuinfotech

See private message.

$34 USD in 14 days
(13 Reviews)
3.3
AdamTurner34

See private message.

$255 USD in 14 days
(4 Reviews)
2.6
swecodervw

See private message.

$84.15 USD in 14 days
(3 Reviews)
1.4
competentwhiz

See private message.

$55.25 USD in 14 days
(2 Reviews)
1.3
keik1215

See private message.

$34 USD in 14 days
(1 Review)
0.0
gzaf

See private message.

$85 USD in 14 days
(0 Reviews)
0.0