I was following the How-To Video for creating a custom data source type using csv file, and it was working fine, until I've deleted manually al data from the table, and now i'm getting the following error:
Incorrect Integer Value:'??' for column 'id' at row 1
The csv file is delimited with TABs and starting with "/N" just like the example file in the video.
I've also tried to reset the sceme but it aint worked.
Here is the content of my csv file (called "vsm_issues.csv"):
\N fas3070-1.ps.lab court1 fas3070-2 court1 destination volume too small; it must be equal to or larger than the source volume 144.22:06:56
\N fas3070-1.ps.lab court2 fas3070-2 court2 destination volume too small; it must be equal to or larger than the source volume 144.22:06:56
\N 10.68.65.14 vol4 fas3070-2 vol4 destination volume too small; it must be equal to or larger than the source volume 7.23:55:45
I was able to use data contents you provided and acquistion worked for me. So nothing wrong with the data in the csv file. You said you manually deleted/edited the CSV files, right? What was the editor you used? What is the Encoding setting for it? I think that is what has caused this. Looks like your editor uses Encoding : UCS-2 Big Endian or Little Endian or something else.
The error like: Incorrect Integer Value:'??' for column 'id' at row 1 or Incorrect integer value: 'ï»¿N' for column 'id' at row 1 etc. indicate that the CSV file has incorrect Encoding. The correct encoding required is : UTF-8 without BOM ( Byte Order Mark ) or ANSI.
Now to fix it, You can use a text editor like Notepad++ open this CSV file and From Tab button Encoding-> Convert to UTF-8 without BOM. Save the file and acquire again. I think this will work. You can use other editors too, but you need to do the same thing i.e. change the Encoding type. Or send me the file by email and I'll return u with the fix.
If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.
How can I actually import UTF8 characters into the database using this technique? I'm trying to build a data source for active directory. We have a lots of users and groups having scandinavian characters in their names and I have yet to find a way how to import those.
If I use -Encoding Byte it obviously fails and if I try to use -Encoding UTF-8 I get all sorts of errors like "Incorrect integer value: 'N' for column 'id' at row 1" or "Incorrect integer value: '500' for column 'id' at row 1" depending if I have \N or a numeric id in the first field of the file.