Hello,
when i tried with below header CSV file, got the error.
Is there any trick about it?
HOSTNAME;Owner SicilNo;Username;OwnerDisplayName;Local Grup
Hello,
when i tried with below header CSV file, got the error.
Is there any trick about it?
HOSTNAME;Owner SicilNo;Username;OwnerDisplayName;Local Grup
Can you provide the error you are seeing?
We have spaces in some of our CSV files. We surround the column header in " " when defining the collector. For example, our header is:
application,accountname,Group,Account Status
When we write the query for the collector we select "Account Status" from the CSV file.
Your example users semicolons instead of commas in the CSV. Do you have semicolons in your CSV file? I wouldn't be surprised if that's your problem instead of the space.
The solution to the problem is to define the CSV Separator in the connection string.
Since semicolon (;) is a reserved character in the JDBC connection string, you can use the Unicode equivalent of semicolon to work around the problem.
jdbc:csv:////home/oracle/datafeeds/application/?_CSV_Header=true;_CSV_Separator=\u003B |
Hi,
There is no problem with URL, i have already use separator as you said.
"jdbc:csv:////home/oracle/ftp/Windowslocal/Windows_Os_Local.csv?_CSV_Header=true;_CSV_Separator=\u003b;csvfileExtension=csv"
When i remove blanks from header i can collect the datas, then revert it original condition got error.
You can find the sample of my csv file:
HOSTNAME;OwnerSicilNo;Username;Owner DisplayName;Local Grup
x.y.z;aa bb;cc;dd ee;ff
You can find the error below:
Did you try surrounding the column name you are selecting in " " like i suggested above(in collector, not CSV)? You can have spaces in the CSV header but the collector needs the " " when specifying the column you are selecting.