Hi,
I've downloaded XMLSpy and MapForce.
I've had to create an XML Schema using the 'Generate Schema' function
in XMLSpy because MapForce doesn't allow you to import an XML file
without a Schema or DTD.
However, when I import the XML file into MapForce, not all the values
in XML file appear to allow me to map them to files in the database.
Now this is probably due to the way the XML tags have been named.
Would anyone have any ideas on how I can get all the tags to show.
Just to say my XML knowledge is very limited. I did try to create my
own schema, but with no luck.
Regards
David Bradley
Senior Web Programmer
Globe Media
Brookfields Way
Manvers
Wath-upon-Dearne
Rotherham
S63 5DL
Tel: 01709 768231
Fax: 01709 768011
www.globe-media.com
On 7 Jun 2007, at 00:30, Stephen Green wrote:
> Hi David
>
> Thanks :-)
> Personally I use Stylus Studio. I use a version which
> deosn't have XML to database mapping but it works quite
> nicely for XSLT if you are new to it. I learnt XSLT
> with it using its mapping facilities to map between
> schemas so I'd be confident it would suit me to map
> to a database / SQL.
>
> I also use XML Spy which in certain versions has tools
> I think which could be useful for this. If you don't
> mind the expense then there's Altova's Map Force too
> which looked cool when I tried an evaluation copy. In
> fact, just looking at XML Spy Pro 2007 I see it lets
> you do what Access does but to map to an existing
> Database (which is what you seem to need to do having
> designed your database manually perhaps) it asks you
> to buy MapForce.
>
> All of these have evaluation copies and they really
> should be tried before being bought as they are quite
> costly (by my standards/means anyway).
>
> Still I love them and find them solidly useful if you
> have a fair bit of this sort of work to do. Map Force
> probably comes closest but a version of Stylus Studio
> with the functions you need (I think there is one -
> you'd have to check it out) might be more user friendly
> (at least I thought so when starting to do mappings
> though at that time Map Force wasn't around). Really
> it's a matter of choice between these two main players
> but both can probably do what you need, happily, and
> give you some fun in doing it too :-) But cost you a
> bit for the easy ride - until you get the hang of
> XSLT so much you don't need them perhaps :-) If you
> don't have Windows you might need to check out whether
> a version of Oxygen does the same thing (but I've
> never used it).
>
> Happy mapping
>
> Steve
>
>
>>>> David Bradley <> 06/06/07 13:17 PM >>>
> Hi Stephen,
>
> You've ht the point bang on. Although my XML knowledge was limited,
> I was able to quickly see that the elements and attributes were named
> in a confusing manner.
> Also you've explained it in a great way.
>
> My next question is, can anyone point me in the direction of a
> complex mapping tool that is good and fairly easy to use.
>
> Regards
> David Bradley
> Senior Web Programmer
> Globe Media
> Brookfields Way
> Manvers
> Wath-upon-Dearne
> Rotherham
> S63 5DL
>
> Tel: 01709 768231
> Fax: 01709 768011
>
> www.globe-media.com
>
>
> On 6 Jun 2007, at 12:47, Stephen Green wrote:
>
>> Hi David
>>
>> Could it be to do with the fact that certain elements like those
>> named
>> (confusingly, but no matter) 'attributes' may appear in several
>> different
>> contexts (within 'country' and within 'region', etc)? I think this
>> may cause
>> problems for a simple xml to database mapping tool like Access has.
>> What you probably need is a more sophisticated one that allows you
>> more control. Then you can apply sufficiently complex criteria. Or,
>> more
>> to the point, rather than let a wizard in the tool determine your
>> database
>> structure (which due to the reuses above could cause a simple such
>> tool
>> problems), what you need is to design your own database with some
>> way to distinguish an 'attributes' table related to 'country' from an
>> 'attributes' table related to 'region', etc and then use a more
>> complex
>> mapping which decides which 'attributes' table the given XML
>> belongs to
>> based on the parent element name. Maybe I've missed the point of your
>> question - then we'd need more details on what you are doing.
>>
>> Best regards
>>
>> Stephen Green
>>
>>
>> ------------------------------------------------------------
>> Stephen Green
>>
>> Senior IT Officer
>> Bristol City Council
>> Room G34, Romney House
>> Romney Avenue
>> Bristol BS99 3HB
>> Tel: 0117 922 3794
>> Fax: 0117 922 4877
>> Email:
>>
>>
>>
>>>>> David Bradley <> 6/06/07 09:28:44 >>>
>> Hi,
>>
>> I'm quite certain that this is not a fault with Access. It is more to
>> do with how the XML file has been constructed.
>> The XML file did have a reference to a DTD but the source that I got
>> the XML file from will not allow me access to the DTD file.
>>
>> So is there anywhere to map certain XML tags to fields in the
>> database?
>>
>>
>>
>> _____________________________________________________________________
>> _
>> Please note the new simpler name for our website: http://
>> www.bristol.gov.uk
>>
>> Our email addresses have also changed - visit http://
>> www.bristol.gov.uk/bigchange for further details.
>>
>> Sign-up for our email bulletin giving news, have-your-say and
>> event information at: http://www.bristol.gov.uk/newsdirect
>>
>>
>>
>>
>> _____________________________________________________________________
>> _
>> _
>>
>> XML-DEV is a publicly archived, unmoderated list hosted by OASIS
>> to support XML implementation and development. To minimize
>> spam in the archives, you must subscribe before posting.
>>
>> [Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
>> Or unsubscribe:
>> subscribe:
>> List archive: http://lists.xml.org/archives/xml-dev/
>> List Guidelines: http://www.oasis-open.org/maillists/guidelines.php
>>
>>
>
>
> ______________________________________________________________________
> Please note the new simpler name for our website: http://
> www.bristol.gov.uk
>
> Our email addresses have also changed - visit http://
> www.bristol.gov.uk/bigchange for further details.
>
> Sign-up for our email bulletin giving news, have-your-say and
> event information at: http://www.bristol.gov.uk/newsdirect
>
>
>
>
