see LDIF parsing.
Derek Sivers wrote:
I've got a quickie project here, that's over my head, that I could pay a little
something for:
Can you set up a script that will take flat text files, (one file per record, many
files per directory) - and do some sed/regex conditional replace, and turn it into
MySQL statements?
I've done one, below, but don't know how to automate the process.
TIMELINE: by this weekend, January 27
PAYPOINT: $100 (done as a perl, shell, or PHP script that can scan a set directory
for incoming text files, run your process on each one, then feed each one into MySQL.)
- INCOMING FILE:
name=John Jacob Schmidt
addr=1313 Willamena Way
username=asdfhjkl
artistname=The Beatles
albumname=Can't Get Enough
description:
One of the best albums they ever made.
Really one of the finest.
Oh yes i mean it truly.
@END@END@
price=15
songs:
track=1
title=Michelle
track=2
title=Taxman
track=3
title=Tomorrow Never Knows
@END@END@
- OUTGOING FILE:
insert into clientinfo (
name='John Jacob Schmidt',
addr='1313 Willamena Way',
username='asdfhjkl');
insert into albuminfo (
albumcode=concat('username', now()),
artistname='The Beatles',
albumname='Can\'t Get Enough',
description='One of the best albums they ever made.
Really one of the finest.
Oh yes i mean it truly.',
price='15');
insert into songs (
albumcode='$albumcode', // the auto-generated one we used in the previous table
track='1',
title='Michelle')
insert into songs (
albumcode='$albumcode',
track='2',
title='Taxman');
insert into songs (
albumcode='$albumcode',
track='3',
title='Tomorrow Never Knows');
NOTE: Most fields are only one line, so the carriage return is the stopping point.
But as you see there are just a few that have carriage returns, so on those we do
"fieldname:" instead of "fieldname=" - then end it with "@END@END@"
More details if you're interested, but that's about it. The actual file is twice as
big, but with no other surprises. (That's an actual example, above, just with some
lines taken out.).
Please reply by email, not to the whole list.
Thanks!
--
Derek Sivers
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
