2015-01-05 07:49 AM
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.
Any ideas please?
Solved! SEE THE SOLUTION
2015-01-06 12:04 AM
@ The csv file is delimited with TABs and starting with "/N" just like the example file in the video.
It should be \N and not /N at the begnning of a row in CSV files. So make this change, reset the scheme if you want and try to acquire again.
2015-01-06 09:04 AM
It was a typo, the CSV file starts with "\N".
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 appreciate your help.
2015-01-06 10:24 AM
Alternatively, I would like to drop this DB from the MySQL WFA server, but when i'm trying to drop the table I'm getting "access denied" message.
I am using TOAD for mysql explorer, and connected to "localhost" using wfa\Wfa123.
Is there a root user for the mysql WFA Server which can drop my custom made DB?
2015-01-07 02:37 AM - edited 2015-01-07 02:39 AM
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.
2015-01-07 03:07 AM
This user wfa\Wfa123 doesn't have permission to drop a database.
So if you want to drop this database/schema , you need to delete the dictionary from WFA UI.
2015-01-08 12:42 AM
You can create CSV files using powershell too without the need to convert the result file into UTF-8 without BOM. You need to use -Encoding Byte option. Somthing like this below code example.
$UserFile = "./Users2.csv"
New-Item -Path $UserFile -type file -Force
Add-Content $UserFile ([Byte][Char] "`\N`tabhi`tsinhaa`n") -Encoding Byte
Add-Content $UserFile ([Byte][Char] "`\N`t$first_name`t$last_name`n") -Encoding Byte