function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jörn Flath 15Jörn Flath 15 

SFDX force:data:bulk:upsert does not recognize opening quote

Hi all,
during record export and import I'm running basically into two problems:
1. "sfdx force:data:soql:query -r csv" is creating an empty line at the end of the output-csv. And "data:tree:export" is not an option, because there are a lot more records than 200 to be exported. Of course this error I can handle with a script. So that's no fatal issue.
2. "sfdx force:data:bulk:upsert" (the exact (except the empty line, which I removed) csv exported via the above command) does not recognize "" as opening quote:
 
ERROR running force:data:bulk:upsert: Invalid opening quote at line 11
false,"Cache entry time to live for the anonymous account cache, in seconds. Min 300.",cache,,anonacctttl,Anonymous Account Cache TTL
Anyone else with this problem, or even a possible workaround?
Thanks a bunch!