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 Transduction 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.
Development Language: VB6
Name Project: XSD2XML
Type Project: DLL
• DB_Name (DB Access name with full path).
• Transduction 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
7 freelancere byder i gennemsnit €192 på dette job
Dear Employer, I will automate the process for you using VBAs and MAcros. Please find my previous work samples. Please let me know if we can discuss further on this. Thanks and Regards, Ashish Singhal