Apex Code Development You need to sign in to do that
Don't have an account?
Rahul Goyal Command line interpreter error while runnind command to load the data
Hi All,
I am trying to import some account record to load the data in SFDC from the CLI, but i am getting below error. can some one pls help on this...
the file i am placing is : -
Name,AccountNumber,SLA__c,SLASerialNumber__c
Rahu,"123456","Gold",bb
Error::_-
com.salesforce.dataloader.exception.DataAccessObjectException: com.sforce.async.CSVReader$CSVParseException: Found unescaped quote. A value with quote should be within a quote
at com.salesforce.dataloader.dao.csv.CSVFileReader.readRow(CSVFileReader.java:174)
at com.salesforce.dataloader.util.DAORowUtil.calculateTotalRows(DAORowUtil.java:67)
at com.salesforce.dataloader.dao.csv.CSVFileReader.getTotalRows(CSVFileReader.java:218)
at com.salesforce.dataloader.action.AbstractLoadAction.initOperation(AbstractLoadAction.java:100)
at com.salesforce.dataloader.action.AbstractAction.execute(AbstractAction.java:122)
at com.salesforce.dataloader.controller.Controller.executeAction(Controller.java:121)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:149)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: com.sforce.async.CSVReader$CSVParseException: Found unescaped quote. A value with quote should be within a quote
at com.sforce.async.CSVReader.nextRecordLocal(CSVReader.java:209)
at com.sforce.async.CSVReader.nextRecord(CSVReader.java:142)
at com.salesforce.dataloader.dao.csv.CSVFileReader.readRow(CSVFileReader.java:172)
what exactly i am missing... Please help ..
I am trying to import some account record to load the data in SFDC from the CLI, but i am getting below error. can some one pls help on this...
the file i am placing is : -
Name,AccountNumber,SLA__c,SLASerialNumber__c
Rahu,"123456","Gold",bb
Error::_-
com.salesforce.dataloader.exception.DataAccessObjectException: com.sforce.async.CSVReader$CSVParseException: Found unescaped quote. A value with quote should be within a quote
at com.salesforce.dataloader.dao.csv.CSVFileReader.readRow(CSVFileReader.java:174)
at com.salesforce.dataloader.util.DAORowUtil.calculateTotalRows(DAORowUtil.java:67)
at com.salesforce.dataloader.dao.csv.CSVFileReader.getTotalRows(CSVFileReader.java:218)
at com.salesforce.dataloader.action.AbstractLoadAction.initOperation(AbstractLoadAction.java:100)
at com.salesforce.dataloader.action.AbstractAction.execute(AbstractAction.java:122)
at com.salesforce.dataloader.controller.Controller.executeAction(Controller.java:121)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:149)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: com.sforce.async.CSVReader$CSVParseException: Found unescaped quote. A value with quote should be within a quote
at com.sforce.async.CSVReader.nextRecordLocal(CSVReader.java:209)
at com.sforce.async.CSVReader.nextRecord(CSVReader.java:142)
at com.salesforce.dataloader.dao.csv.CSVFileReader.readRow(CSVFileReader.java:172)
what exactly i am missing... Please help ..
All Answers
Thanks for your response, I am just putting this data in the notepad and saving it as .csv, is it somethng i am missing ??