Issues to load file with JDBC file loader

[Nick12]

Hi, I'm experiencing in some problems to load csv file with JDBC file loader. I'm using JDBC file loader to load a file from mid server folder to servicenow tables.

1. Is it possible to configure as column separator the TAB key? The corresponding cell to configure it doesn't accept the TAB, and \t doesn't work. According documentation should be possible to configure any column separator.

2. When I try to load a csv file separated by an accepted separator (pipe (|) or semicolon (;)) the JDBC file loader loads only some columns, other columns remain blank. If I load the same file with a standard Data Source to load attachment, it works perfectly. Which could be the reason?

Thanks 

[Sukraj Raikhraj]

They are 3 options OOB for  CSV delimiter, can you access the CSV delimiter on the data source?

They are some syntax that will split up the columns if part of the data during the import. 

[Nick12]

Hi, to clarify better my previous question, I was referring to JDBC file loader:

https://community.servicenow.com/community?id=community_question&sys_id=abe153eddbdcdbc01dcaf3231f96...

I'm using JDBC file loader to load data from a file placed in folder of Midserver

According documentation is possible to configure any column separator

I configured as column separator pipe (|) and then i tried with semicolon (;) but JDBC file loader loaded all the rows of the file but only some columns of the file. Some columns remained blank also if had a value in the file.

If I use the same file as attachment in the Data source the file is loaded correctly with all the columns.

I need to use the JDBC file loader to load data from a file placed in a MIdserver folder, it is not possible to use Data source (Data source works with attachment already loaded in Servicenow, it doesn't load file placed in folders of Midserver)

Thanks

[antonio1989]

Are there news? I have a similar problem, i import the same file manually through data source and all columns are loaded, with JDBC Loader instead one column is always blank, the problem affects only one column