[RESOLVED] Generic DB importer service

[wakawaka]

Hello again!

I am looking into make a generic DB importing tool. As of now it is only targeting CSV's.

Now I don't have much experience on this front but to make it useable with multiple files, I have pretty much set it up so it is reliant on a XML configuration file. I don't have any actual VB code as I am working on the XML format, but I just want to know what you guys think and if there is a better way to go about it.

<?xml version=1.0?>
<Configuration>
	<Service interval="15" newThread="Yes" />
	
	<Database connectionString="" invariantName="System.Data.Sql" />
	<ImportSettings>
		<File name="TEST 1" fetchPath="" dumpPath="" errorPath="" verificationKey="" />
	</ImportSettings>
</Configuration>

This really is banking on the "verificationKey" attribute being set correctly. The point of it is to verify that the record being imported is in-alignment with what is expected.

Example: [0=NULL|1=NOT NULL][s=String|I=Int|DA=Date|etc...]

So if the record to be import was suppose to be a entry date, name, and Food prefrence it would look like this: 1DA, 1S, 0S. This means there has to be a value other than null or a null string and then it would verify that it can be converted to a date, and so on and so forth.

Sound like a horrible idea?