19

I observe the same thing. It just hangs and I have to hit CTRL-C to leave get out of it and nothing happens. Also, CTRL-Z didn't work. You can create a file and you can actually just pass the name of the file as a parameter to the force apex command as that is one of the supported parameters. If you run force help apex you get the the usage: For ...


10

It hasn't been added to your path yet, so your terminal doesn't know where to find the application. See their fix, Fix path to source after running go get: Change line 49 to $ cd $GOPATH/src/github.com/heroku/force Other options: Ensure the file's permissions are set to be executable. Run ls -l in the folder to verify. If you are in your Terminal (or ...


5

The Apex Data Loader isn't particularly user-friendly (although it is getting better as time goes on). This is because it was originally designed as an internal tool for salesforce.com employees to move data (e.g. for Premier Support to move or import data). It started out that some Premier Support customers found out about it and wanted it themselves, with ...


5

On Unix systems - MacOSX and Ubuntu, etc - you need to make the file you downloaded executable (the file is the pre-compiled Go app for your operating system). In the directory where your downloaded file is, use the command: chmod a+x force Alternatively, you can run the command sh ./force without making the file executable, but that gets tiring after a ...


4

Yes, you should absolutely be making use of the config.properties file - it's best practice. You can then add all of your UN and PW to it and adjust the key's accordingly. project/config/config.properties sfdc.endpoint=https://login.salesforce.com sfdc.username=................ process.encryptionKeyFile=C:\\Users\\gazaino\\Projects\\DL\\key.txt sfdc....


4

You should be able to get the web auth working without installing Chrome in Ubuntu or an X-Window server in Windows. This is courtesy of Mike Bordon in the Salesforce DX community. I had to install xdg-utils to get it working on my side, so I have added that step. Install xdg-utils apt-get install xdg-utils Create a script referencing your browser path ...


4

I've got the same problem. I'am also using os x with ST3. The problem is caused by the fact, that ST3 is not using system PATH and it can't resolve force-cli executable. To solve that I installed plugin through Package Control called Fix Mac Path. There is a link to repo and description https://github.com/int3h/SublimeFixMacPath Hope it would help you.


3

You cannot do it directly from command-line, but neither from the Data Loader. There is some problem with the ExternalID you have to map. There a very simple workaround for this: Create a field on the Case Object named "commentCL" (with api name "commentCL__c) such that the field is Visible from all the profiles but on no page layouts (users in Salesforce ...


3

In the folder that contains the process-conf file, do you also have a file called log-conf.xml? Because if you don't, I know DataLoader starts logging everything, and creates a huge file... Do you also have a config file in the folder? If not specified in the bean, that will also set parameters... I have the command line setup on my machine for various ...


2

I guess you copy pasted command encrypt.bat -e "C:\temp\key.txt" from some website. It should be minus sign instead of dash, Can you try to type it and run it. You may find some helping steps here as well.


2

Are you trying to load data directly into the formula field? You can't do that. Instead, load data into the other fields and the platform will calculate the formula field values for you.


2

I guess you copy pasted command encrypt.bat -e "C:\temp\key.txt" from some website. It should be minus sign instead of dash, Can you try to type it and run it. You may find some helping steps here as well.


2

Your bean actually looks legit, but I know this is a pain to get it working alright. I can't tell why it's wrong, unfortunately. In fact, I felt so much pain I went through quite some hoops to create a tool around the data loader functionality to make it work from the command line each time. It highly simplified the scripting of the Data Loader. I hope you ...


2

Here is the root cause Caused by: java.io.IOException: Access is denied at java.io.WinNTFileSystem.createFileExclusively(Native Method) Below is a quote from another SO answer which covers your situation The problem is that a file can't be created unless the entire containing path already exists - its immediate parent directory and all ...


2

I have not tried this personally, but a Salesforce engineer gave me this info. Install google chrome into the ubuntu WSL. Also run xming, which is an X-Window server for Windows. I don't currently have access to my windows machine, so that is all the detail that I have just now.


2

I had a similar project for a client. I used DataLoader + Batch script file to automate extract / import data from/to Salesforce. Look a this amazing tutorial to Setting up Automated DataLoader. http://www.developerforce.com/media/Cheatsheet_Setting_Up_Automated_Data_Loader_9_0.pdf At the end you'll be able to launch a script (.bat file). Then you can ...


2

As you have correctly guessed the timezone is an issue. It is best to format date values in your CSV file such that they include both time and timezone, to make it independent of your computer timezone and SFDC Org default timezone. From the documentation: https://help.salesforce.com/articleView?id=000004680&language=en_US&type=1 Example ...


2

I know this almost a 2 years old thread but I want to improve the solution to above. First of all, thanks to kkorynta as his/her solution help me to fix my issue. My problem was that even I have enabled in my process-conf.xml <entry key="loader.csvOther" value="true"/> <entry key="loader.csvOtherValue" value="|"/> The command line process ...


2

On the utility's repository, I missed that you can alternatively launch a UI with this command: java -jar datasetutils-32.0.0.jar --server true Once I did, I discovered the listener option there. It's only available in the UI and the repository doesn't specify that.


2

I have seen the Windows command prompt get confused about colons in strings before, although running a quick test, it appears to work for me: Couple of things you can try: Update your SFDX CLI with sfdx update Start using Git Bash instead... Why Git bash? Well, it looks prettier for a start, and it is a closer match functionality-wise to what Mac and ...


1

You can authenticate via SOAP's login() command, which requires a username, password, and possibly a security token; a session Id is interchangeable with an access token (they are roughly synonymous). Or, you can use an User-Agent OAuth flow that authenticates via browser once, then uses a refresh token to stay logged in perpetually, even if the username or ...


1

I figured out what was wrong. Below is my code that worked in case anyone runs into the same issue. I had to add a mapping file as well as change the "extractionRequestSize" entry to "loadBatchSize" <bean id="csvExtractPartner" class="com.salesforce.dataloader.process.ProcessRunner" singleton="false"> <description>Extract Partner ...


1

Data Loader CLI can be affected by three timezones: SFDC timezone local machine timezone JDBC source database timezone We had the issue of it reverting to the local machine user timezone. This issue causes validation errors especially on date fields such as Lead.ConvertedDate falling over to a previous calendar day - in this case the sfdc.timezone ...


1

I see you are using the sfdc.useBulkAPIparameter, which is advisable given you are working with 2 million records. However, the sfdc.loadBatchSize parameter may not exceed 200: In a single insert, update, upsert, or delete operation, records moving to or from Salesforce are processed in increments of this size. The maximum value is 200. We recommend a ...


1

I just checked a process-conf.xml NoFrillsTransformation created, and the only four differences I could spot should not make a difference. I have the following three lines extra: <entry key="process.statusOutputDirectory" value="C:\Projects\ssm.migration\output\Dev\contacts" /> <entry key="dataAccess.readUTF8" value="true"/> <entry key="sfdc....


1

Data loader itself does not support incremental/delta backup/extract from SFDC, but there are various ways to achieve it with or without data loader. Option 1: add extra condition to your query in process-conf.xml <entry key="sfdc.extractionSOQL" value="Select Id, Name FROM Account where LastModifiedDate >= YESTERDAY"/> This works, but not very ...


1

You can check answer of this question. Basically it says , In the config file entry key="sfdc.externalIdField" value="Master__r.External_id__c" tells the dataloader what externalid to use to differentiate the child objects when creating them. To upsert a relationship in the dataloader you need to specify the mapping in the SDL file for example: Id=Id ...


1

Inside the object Case you can find the "Internal Comments" field, but if you use the corresponding API name ("Comments") you find out that you cannot use that field. The reason is simple: that is not a field. Internal Comments refers to an object called CaseComments. So, as Eric suggests, you should first insert the Cases and then adding the Comments.


1

Change to encrypt -e "C:\temp\key.txt" You may need to include the password and security token as you're not telling encrypt what to encrypt. e.g. encrypt -e myPasswordmySecurityToken "c:\temp\key.txt"


1

Yes your correct, the full path location of the CSV file has to be specified in the beans contained with the process-conf.xml file. And i assume your .Net code is receiving the uploaded CSV file from the user and placing it either in memory or in a temporary location on the web server. I've reviewed the documentation again since its been a while since i used,...


Only top voted, non community-wiki answers of a minimum length are eligible