scripts that can parse the data from the text files and import them into a normalized database

sanjid has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: scripts that can parse the data from the text files and import them into a normalized database by marto (Cardinal) on Oct 21, 2010 at 09:24 UTC
You seem to have (or have been given by someone else) a fair specification, this isn't a code writing service, we're not here to do this for you. If you're new to perl see: http://learn.perl.org http://perldoc.perl.org The Tutorials section of this site. Once you have some actual perl problems, feel free to ask for help.	[reply]
Re: scripts that can parse the data from the text files and import them into a normalized database by BrowserUk (Patriarch) on Oct 21, 2010 at 05:32 UTC
Am looking for a script which can ... You have a pretty comprehensive spec--which is about 1/4 of the battle. So what is stopping you from writing it? Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice. RIP an inspiration; A true Folk's Guy	[reply]
Re^2: scripts that can parse the data from the text files and import them into a normalized database by ambrus (Abbot) on Oct 21, 2010 at 10:22 UTC
That doesn't look like a comprehensive specification to me, but rather a list of buzzwords.	[reply]
Re^3: scripts that can parse the data from the text files and import them into a normalized database by BrowserUk (Patriarch) on Oct 21, 2010 at 11:03 UTC
That doesn't look like a comprehensive specification to me ... Perhaps he was trying to avoid putting off would-be responders by seeming to be too demanding?	[reply]
Re^4: scripts that can parse the data from the text files and import them into a normalized database by raybies (Chaplain) on Oct 21, 2010 at 14:36 UTC
Re: scripts that can parse the data from the text files and import them into a normalized database by Utilitarian (Vicar) on Oct 21, 2010 at 10:59 UTC
If I understand you correctly you need to: Do MySQL db inserts which will require the DBI module After you've determined the format of the file (Perl's regular expressions should help provide an indication of the file format unless it's just a different sort order within CSV files) and parsed the file using the appropriate parser eg. XML::Simple, Text::CSV As to the other spec elements, buy a copy of Perl Best Practices and apply its wisdom. Or to put it another way, that is not a question, it's a job spec - write some code, tell us what's going wrong if you are having problems otherwise try offering to pay someone to resolve the issue. `print "Good ",qw(night morning afternoon evening)[(localtime)[2]/6]," fellow monks."`	[reply] [d/l]