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

[stevemac]

It would probably assist to post value / images of

· JDBC job definition

· Import set table — showing # rows & sys ID

· The ECC records (1 each of output and input — specifically the payload contents). They output payload will detail the query passed to the MID Server, the input payload the number of records returned and the # payload records (chunks) passed back to the instance

Regards,

Steve

[Boobalan]

Hi Guys,

The issue was with the data which is having a different symbol () in the file coming from MFT at random locations.

If the above symbol is replaced in the csv file then the load is working without any issues.

Regards

Boo

[enojardi]

Hi All, just wanted to give you a quick update that I've started working on the migration (and potentially little enhancements) to a scoped app in my spare time.

If you have any ideas or anything to share, please do so here or in this community post.

Also, if you don't mind sharing which customers/instances you're using this app, that would be great (here or via email). Also, trying to persuade product management to (finally) incorporate this capability Out of the box 🙂

Cheers!

Jonatan 'Jonny' Jardi | ISV Solution Architect – Technology Partners
ServiceNow | Work at Lightspeed

[User656714]

Hi Jon,

I am not able to find this app on the store.

Could you send me the link please?

Thanks

Abhishek

[Herman3]

Hi,

Can this be used to get an xml file that is placed in a directory on the midserver?

if yes, what do i have to modify? getting:

java.sql.SQLException: Wrong number of columns in line: 224 Columns read: 2 Columns expected: 1