**XML Import/Export Schema Module**
The purpose of this module is to allow the client, a background investigation company to be able to quickly and easily transmit data to and from various county, state, federal, and private firms which collect background information. The background investigation company needs to be able to send data to various agencies requesting information, and also receive it back. Because there are over 3000 reporting counties, states, federal agencies, and companies, it is important that this system allow them to easily create a new import/export without the need for a programmer to do the work.
The client’s application is developed in VB6, an upgrade is not practical at this time, and thus a hybrid application may be needed as many of the vendors are using .NET Web Services.
See attached file for additional details
EXTENDED INFORMATION:
I have added the following information to answer several questions asked by potential bidders.
Client Layout:
The client is using a developed Visual Basic 6.0 system with a SQL Server 2000 back end. This system already exists and will contain all data that needs to be sent out, and tables are in place for all data that needs to be returned.
Purpose of this project:
Client sends search requests to thousands of different locations for them to pull county records and such, currently this is done by e-mail, fax, and csv files. Many records locations are now accepting XML files via e-mail and .NET web services. We need to give the EXISTING Visual Basic 6.0 application the ability to send these locations XML data via e-mail, ftp, or .NET Web Services.
***_PLEASE READ THE ATTACHED INFORMATION!_***
## Deliverables
**Q. How much will the output XML Schema change?
**A. Unknown, although all XML data will relate to background checks, so they should be similar.
**Q. If the underlying database changes, do you expect to have the program automatically change?**
A. Database changes should be very minor if any, we can probably leave this to coding only. I would like it to be able to at least load a list of tables from a table and a list of fields in those tables from another table.
**Q. On average how many data elements are we talking about for the XML? Are there 10-50 elements that need to be mapped or would there be a lot bigger number?**
A. I attached a sample of both incoming and outgoing XML Schemas to the bid request, please review it. This is probably the most complicated one we will work with.
**Q. Would this progam accept the XML files dynamically or would there be a person manually executing the program?**
A. It can be a manual process as long as they don't have to do anything more than select a source and click send/recieve button, sending should be automateable.
**Q. Do you want the program to remember mappings?**
A. Yes there is a "contractors" table, each contractor can have a mapping to send and to receive. These will need to be saved as data needs to be sent and received every few minutes.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
4) See attached Project [login to view URL] file for additional requirements.
* * *This broadcast message was sent to all bidders on Thursday Jan 12, 2006 2:27:24 PM:
Q. How much will the output XML Schema change?
A. Unknown, although all XML data will relate to background checks, so they should be similar.
Q. If the underlying database changes, do you expect to have the program automatically change?
A. Database changes should be very minor if any, we can probably leave this to coding only. I would like it to be able to at least load a list of tables from a table and a list of fields in those tables from another table.
Q. On average how many data elements are we talking about for the XML? Are there 10-50 elements that need to be mapped or would there be a lot bigger number?
A. I attached a sample of both incoming and outgoing XML Schemas to the bid request, please review it. This is probably the most complicated one we will work with.
Q. Would this progam accept the XML files dynamically or would there be a person m anually executing the program?
A. It can be a manual process as long as they don't have to do anything more than select a source and click send/recieve button, sending should be automateable.
Q. Do you want the program to remember mappings?
A. Yes there is a "contractors" table, each contractor can have a mapping to send and to receive. These will need to be saved as data needs to be sent and received every few minutes.
## Platform
Visual Basic 6.0
SQL Server
.NET Web Services
XML