JDBC File Loader (via MID Server)

[enojardi]

How many times have you thought? I wish I could use JDBC to connect and extract data from a flat file instead of a database.

Well… This application (first release / beta version) does exactly that… and more:

* Connect using JDBC to a file via the MID Server

* Support for any flat file (CSV, TXT, etc)

* Support for zipped (.zip) files (containing a flat file)

* Choose any column separator you like

* Choose header row number or no header row at all

* Support for wildcard (*) and dynamic (scripted) file names

* Support for processing multiple files at once (using * wildcard)

* Load all rows from the file or execute your own "SELECT" SQL statement

* Select Import Set mode: Load only or Load & Transform (if a map is available)

* Bonus (experimental): onComplete file action: Copy, Move, Rename or Delete the file!

Link to App in Share: ServiceNow Share

[chalverson1971]

It does make sense.   I've tried it but am still having issues. The load into the import set table is running indefinitely.   Have you encountered this issue before?   Are there any manual steps that should be done for your solution after a MID server upgrade?

[enojardi]

Hi Chris

Not really, it worked for me fine. Could you describe a little bit more in detail what you're experiencing?

- Check the ECC queue, do you see the output and inputs coming in?

- Is the MID Server available?

- Are there any errors/warning in the log?

Cheers,

Jonatan Jardi

[chalverson1971]

1) I don't see anything going into the ECC queue.

2) The MID server is available

3) The only entries in the log are the dbc_file_loader.load_started entries.

[enojardi]

Mmmm then that tells me that perhaps the data source doesnt have the updated code in the "script". So it's not even executing. Try this in   a background script: var sourceRec = new GlideRecord('u_jdbc_file_source'); sourceRec.get('INSERT_SYS_ID_OF_DATA_SOURCE'); if(sourceRec.next()){     new global.JDBCFileLoader(sourceRec).execute() } Run this and check if you see anything in the ECC queue then.

[chalverson1971]

Successfully ran, but nothing in the queue.