B4nanaF1sh / dataloadercliq

Automatically exported from code.google.com/p/dataloadercliq
0 stars 0 forks source link

Unknown Exception while performing Insert Operation #83

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
Hi,

I have to perform a batch operation which uploads Non-English chars in to 
salesforce system. I have slightly modified the batch script which does the 
following as mentioned in the below blog
http://mysalesforceblog.blogspot.sg/2013/11/mass-uploadinsert-non-english.html

Further I have followed steps mentioned as per the below blog
http://stackoverflow.com/questions/940045/how-to-suppress-the-file-corrupt-warni
ng-at-excel-download

Now the BatchFile looks like the one below
----------------------------------------
SET XLSXFILEPATH="C:\Users\kareddy\Documents\MGM_Process"
SET TXTFILEPATH="C:\Users\kareddy\Documents\TXT_Folder"
SET DLSRCFILEPATH="C:\Program Files (x86)\salesforce.com\Data 
Loader\cliq_process\MGM\read"

pushd %XLSXFILEPATH%
for /f "tokens=*" %%a in ('dir /b') do set newest=%%a
popd

copy /b/v/y C:\Users\kareddy\Documents\MGM_Process\%newest% 
C:\Users\kareddy\Documents\TXT_Folder\MGM.txt

CScript “C:PathToReplaceText.vbs” //B 
C:\Users\kareddy\Documents\TXT_Folder\MGM.txt "\t" "," [/I]

copy /b/v/y C:\Users\kareddy\Documents\TXT_Folder\MGM.txt  
%DLSRCFILEPATH%\MGM.csv

SET DLPATH="C:\Program Files (x86)\salesforce.com\Data Loader"
SET DLCONF="C:\Program Files (x86)\salesforce.com\Data 
Loader\cliq_process\MGM\config"
SET DLDATA="C:\Program Files (x86)\salesforce.com\Data 
Loader\cliq_process\MGM\write"
call %DLPATH%\Java\bin\java.exe -cp %DLPATH%\* -Dsalesforce.config.dir=%DLCONF% 
com.salesforce.dataloader.process.ProcessRunner process.name=MGM
REM To rotate your export files, uncomment the line below
REM copy %DLDATA%\MGM.csv 
%DLDATA%\%date:~10,4%%date:~7,2%%date:~4,2%-%time:~0,2%-MGM.csv

But the problem here is, I see an exception being generated while processing 
the file. Could you please suggest on how to fix this up.

Version of MS Office: Excel 2010

Operating System: Win 7 Enterprise Service Pack 1 Build 7601

Thanks in advance!

Regards,
Karthik

Original issue reported on code.google.com by karthik1...@gmail.com on 30 Mar 2014 at 5:54

Attachments:

GoogleCodeExporter commented 8 years ago
This probably means something is not being read correctly in the file:

Exception occured during loading
java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
        at java.util.ArrayList.RangeCheck(Unknown Source)
        at java.util.ArrayList.get(Unknown Source)
        at com.salesforce.dataloader.dao.csv.CSVFileReader.readRow(CSVFileReader.java:191)

Can you run this Insert from the GUI in Data Loader?  If that does not work, 
then this probably won't either.
I am also not familiar with the methods shown in those blogs.

Original comment by vijay.swamidass@gmail.com on 2 Apr 2014 at 5:05

GoogleCodeExporter commented 8 years ago
To my strange even GUI version of data loader is unable to recognize the file. 
Do u have any idea on how to upload the chinese chars into salesforce through 
GUI?

Thanks for the update.

Original comment by karthik1...@gmail.com on 2 Apr 2014 at 8:08

GoogleCodeExporter commented 8 years ago
That makes sense.  I do not have any experience with Chinese chars in 
Salesforce.  You might search on developer.force.com for more info.

Original comment by vijay.swamidass@gmail.com on 2 Apr 2014 at 5:38

GoogleCodeExporter commented 8 years ago
Thanks for the prompt reply!

Original comment by karthik1...@gmail.com on 3 Apr 2014 at 1:52