We have an important and consolidated VB6 software, it using a DB Access. Data are inside some tables relationship between them.
We need to export an particular record query about an specify ID: Query is very similar to for example a table “Anagrafic Data” relation with one2many table “Addresses”, and also relation with another one etc. etc.
Export format is XML, and this XML have a specified XSD Schema.
XSD Schema can be change and so XML change.
XML element name or xml tag are different from field name, and can be different also data type , for example in DB Access we have a Boolean filed and in the XSD Schema have a Text value like Y/N… or a particular XML data tape is a list of element so DB field value need one of those.
We think to resolve mapping problem from xml tag and field of record with a "Transducer Element", which is for example an Access DB with a Table, table have like fileds: Name Tag XML, Table Name DB, Field name DB, Request (Boolean) and so on with a filed for number order and number section. This is our solution but you can suggest another solution.
Scope one: Project best solution for "Transducer Element"
Scope two: VB6 DDL
Development Language: VB6
Name Project: XSD2XML
Type Project: DLL
• DB_Name (DB Access name with full path).
• Transducer Element.
• XSD_Name (XSD Schema file with full path).
• XML_Name (XML destination file with full path, if exist it append in the file).
• ID_Element (Long value to identity record in proper way ……..WHERE ID = ID_Element).
OUTPUT DATA: Export MS Access data to XML file validated with passed XSD Schema.
Specify data: MS Access DB is version 97
14 freelancers are bidding on average €286 for this job
hello i have done this work before i can do this and available i have read your complete requirements and understood thank you regards tuba [url removed, login to view]