Encerrado

Create xml file from DB Access, using a xsd file

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.

Project goal:

• Take xml structure from xsd file.

• Values are stored in Access DB from three tables in join.

• Xml elements name are different from fields name of Access tables.

• Some xml elements datatype are different from DB fields datatype (example form numeric 0/1 to Boolean, or parsing a string to recover two values etc. etc.).

• Project a Transduction Element to match xml element name and datatype to Fields of DB.

• Take values for xml elements from DB using the Transduction Element.

• Create xml destination file.

• Validate xml file with sorce xsd, return True it’s all ok.

Development Language: VB6, .net

Name Project: XSD2XML

Type Project: DLL for VB6

INPUT DATA:

• 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).

• Flag Append, if true file exist it append otherwise ask to replace.

• 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

Habilidades: Arquitetura de software, VB.NET, Visual Basic, XML

Veja mais: file n ict prom activity 203 website startbootstrap freelancer 1.0 5 startbootstrap freelancer 1.0 5 index html, create front end access using sharepoint, create table access using xml schema, script create multiple accounts using excel file, create email using mhtml file body, databasehow create database using cvs file, excel export xml xsd file, create wordpress template using psd file, create table access using, create crystal report web using access, modify xml files using flash file, create xml feed access database, xml access using, print access report pdf file using vba, create html web design using access

Acerca do Empregador:
( 2 comentários ) Perugia, Italy

ID do Projeto: #15376087

13 freelancers estão ofertando em média €200 para esse trabalho

hawkscodeaus

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills Mais

€155 EUR in 3 dias
(54 Comentários)
6.8
liangjongai

Hi! I'm interesting your project very well. i mastering VB.NET and MS ACCESS. And also I have many experience and good skill about web and android development. Let's go ahead with me

€155 EUR in 3 dias
(159 Comentários)
6.8
MrtDolphin

HI. I am new here but i am a programmer with over 8 years experience. I am programming king. Please check my profile and the following links to see about me. [login to view URL] [login to view URL] [login to view URL] http Mais

€250 EUR in 2 dias
(9 Comentários)
6.0
urmate

Dear Sir/Madam I've excellent VB, VBA, VB.NET programming skills and knowledge. I can provide an efficient, perfect, well documented development of your VB, VB.NET project according to 100% accuracy and requireme Mais

€250 EUR in 3 dias
(169 Comentários)
6.2
€250 EUR in 10 dias
(13 Comentários)
5.6
€155 EUR in 3 dias
(29 Comentários)
5.3
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo Mais

€388 EUR in 10 dias
(22 Comentários)
4.2
angnut

hi, i am an italian developer. i used vb 6 to create a software like this. i can do it in vb.net or c#

€222 EUR in 10 dias
(11 Comentários)
4.3
stillart

Salve, vi propongo di realizzare il progetto interamente in vb6, potreste così integrarlo facilmente nel vostro software. Se siete interessati alla mia proposta vi chiedo di inviarmi un esempio di file XSD per verifica Mais

€250 EUR in 5 dias
(11 Comentários)
4.0
€244 EUR in 3 dias
(6 Comentários)
4.3
€30 EUR em 1 dia
(0 Comentários)
0.0
Gilles9

I once wrote a plugin for visual studio using the built-in visual studio XML Parser. I suppose I can give this a try as well.

€222 EUR in 5 dias
(0 Comentários)
0.0
€34 EUR em 1 dia
(0 Comentários)
0.0