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

[Gaetano De Mitr]

Can I use Network logic Path(for example a NAS) as Path name on JDBC File Loeader?

Info:

on MID Server I mounted network logic path with word (E:\\).

This path point to NAS.

But when I execute JDBC File Loader, I receive: "Directory Not found"

[giuseppem]

In path refer to NAS server/directory no map drive E:

Also note doble the backslash. Just a sample "\\\\\\\\servername\\\\directory". Obviusly map to your path

[cswaroop]

Hi,

Was anyone able to successfully retrieve excel file from Mid server ?

I am getting the below error when i try to retrieve data from xlsx file. However, works fine for CSV file.

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

Thanks.

[stevemac]

have not tried xlsx files.  if we get time will attempt and let you know 

I looked at the notes for csvjdbc (the jar file that is used to read the csv) & could not find any mention of it supporting xlsx files

[gokul arumugam]

what is the column separator symbol or value to import data from notepad(txt format)