Realization of a DLL (VB6)
INPUT: database name to collect the data, name of the output file, the XSD file name containing the schema, database name for the transduction of data, Collection of elements indexes for export.
OUTPUT: creates or inserts in APPEND data in XML format from a specific XSD files.
PROCESSING: take data from an archive ACCESS (97) and produces an XML file, formatted according to a schema XSD file.
A further special ACCESS database will contain information on where to get the node data in the XSD file, in the form of Node Name, Table Name, Field Name (Archive transduction).
If the data will come from different tables it will be indicated the key indexes which allow the correlation.
Some data must be encoded and encoding information is inserted into Excel spreadsheets, which may belong to the same file. So you need to specify the archive transduction if that node must be coded or not and if you where to take the encoding.
Update of the appropriate field for the state of export with recording the date has been exported.
This request is the synthetic scheme, at the contractor will be given the detttagliate technical specifications