Re: Parsing XML and storing attributes in MySQL using Perl

On 12 Jun 2006 13:53:04 -0700, "jkugler" <jkugler@xxxxxxx> wrote:

Hello,

I am trying to store huge amounts of data from xml files and put them
into a MySQL database. The xml files all are in this format:

[xml snipped]

Hi James.

If you want you could use RXParse.pm (ver .91) posted on this group.
It would send the same attribute info to a tag handler.
Should be the same as the one you used.
From there you could check the "name" for the "value" data.

If you could hang on a while, I'm writing filter interfaces for
tags, namespace, attributes, content, etc.. The filters can be
either regexp or dos style. Each filter is specific, set by the
user who provides the handler to recieve that specific info.

Whats nice is that the regexp provided by the user is applied to
just the sub-parsed global data, the category is guaranteed.
Tag is tag, attrib is attrib, content is content.

Its almost there. Yours is a basic search but the intent is to
provide search/replace as well as multiple filter capability.
At my stage of development with this its really pretty easy.
The hold up is a base compliant parser, which is almost done.

Anyway, just some info for you. No need to use RXParse. The difference
between my module and all thats out there is its whole purpose is meant
to be interactive. Funny how the simple things you would expect from
high power software just aint there, and its so easy to do!

robic0
(god of porn)
.

Relevant Pages

  • Re: OpenForm Filtering too much
    ... The filter text is built up in a text box in the form SearchBuilder as ... ShowResults is a form built on a table, ... The weird part is that for some searches, the NULLS that matter seem to be ... another tag field for with options roots, ...
    (microsoft.public.access.macros)
  • Re: XML parsing: no EndElement for combined start/end tags
    ... Personally, I don't see it as an issue, as the infoset has no ... concept of what an end tag is. ... small example to show to exactly what the XML files are like. ... them correctly, according to the standard, but the .NET framework does ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: rcb - begin post this way??
    ... In another group someone suggested a tag like that and the ... next day all the posts had that tag, which made them easier to filter ... If they want to use Xnews, sylpheed-claws, ... they could install slrn and have a lot more free time to ...
    (rec.crafts.brewing)
  • Re: XML parsing: no EndElement for combined start/end tags
    ... that BOTH start tag and end tag exists, ... small example to show to exactly what the XML files are like. ... them correctly, according to the standard, but the .NET framework does ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Form Filter... "Enter Parameter Value" ??
    ... I am new to creating form filters, and I was unaware of the "Tag" option ... > Hi Brook ... > Are you sure that each of your FilterX comboboxes has its Tag property set ... >>> the name of the corresponding field to filter. ...
    (microsoft.public.access.formscoding)