Results 1 to 6 of 6
  1. #1
    Join Date
    May 2008

    Exclamation need software / tool recomendations

    Here's the issue:

    I've got two gig of short html files where the code is comparable to the following:
    4 eggs<br>
    2 c. sugar<br>
    3 small jars strained carrots<br>
    (baby food)<br>
    1 small jar strained pineapple<br>
    (baby food)<br>
    1 c. chopped nuts<br>
    1 c. raisins<br>
    1 1/2 c. oil<br>
    2 c. flour<br>
    2 tsp. baking soda<br>
    1 tsp. salt<br>
    2 tsp. cinnamon<br>
    1 tsp. vanilla<br>
    <br>Beat the eggs, sugar, strained carrots, strained pineap-                 <br>
    ple  (mashed),  nuts,  raisins and oil.  After which add flour,<br>
    baking  soda,  salt,  cinnamon  and vanilla.  Mix all together.<br>
    Place in pan.  Bake for 50 to 60 minutes at 350 degrees.<br>
    Now, I am looking for an application or tool that will assist with migrating all of this into a database - or xml -- any particular database is fine --- I'll be adding custom fields to the database after the data is in place.

    any suggestions to aid in a rapid deployment are appreciated.

    current system is in asp index server on a windows box ---

    Any help / guidance is appreciated

  2. #2
    Join Date
    Nov 2004
    out on a limb
    any language will do that
    you could try PHP (Id go PHP-command line/exe rather than web server)

    the main issue I can see would be how you insert the data into the DB and maintain data integrity
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2008
    see, the data is currently searched by full text indexing -- I'm looking to capture the title as one field and the rest of the recipe as the next field while stipping all html except the br tags

    any ideas on a good automated tool that will do this? or an easy script --- php is not an option

    please help

  4. #4
    Join Date
    Feb 2004
    In front of the computer
    How about Perl then? You wouldn't need to install either PHP or Perl on the server itself if that is the problem, either of them could be installed on any client machine that could read the files.


  5. #5
    Join Date
    Jun 2007
    Php is not an option
    PHP and PERL would both work well and they're not difficult to learn - is there a reason they aren't an option? Gawk would also work but you're less likely to know that. Are there any languages you can program in? Will your PC be the web server or are you going to move to a dedicated UNIX server?

    any particular database is fine
    If you're happy with any database then you could just have one table with one field and then just insert each recipe - it wouldn't be pretty but you could then use SQL to extract the data into a more normalised form - that's assuming you know SQL. Of course if you're serious about any database then you're welcome to have the one I currently have to work with - it does risk assessment for banks but you might be able to adjust it somehow.

    Do you have a recipe web site? can we see it? I love food.


  6. #6
    Join Date
    May 2008

    Automatic wrappers publishing XML

    try to play with is a semi-automatic wrapper generator, which can be used to isolate the various portions of a web-page and to output XML or other formats.

    I did something similar wrapping descriptions of WINEs and it worked fine.

    good luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts