Dataloader.ioのまとめ

[まとめページに戻る](https://qiita.com/Keiji_otsubo/items/60afc2a8d211b6f7d89f)
[まとめA～M](https://qiita.com/Keiji_otsubo/items/f3ddedee6793bf1576f8)

+ [Dataloader.io Errors Explained - Time for an Alternative?](https://www.integrate.io/blog/dataloaderio-errors-explained-time-for-an-alternative/)

----------------

+ [Monitor Bulk Data Load Jobs](https://help.salesforce.com/s/articleView?id=sf.monitoring_async_api_jobs.htm&type=5)
+ [Importing Tasks with Dataloader.io](https://help.salesforce.com/s/articleView?id=000390206&type=1)

+ [Import and Export with Data Management Tools >Use Dataloader.io to Export Data & Use Dataloader.io to Update Data](https://qiita.com/Keiji_otsubo/items/9518f6b650550d0e7642)

+ [Use the Dataloader.io to Extract Data](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000Jy9kR)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/19327a14-e82d-bd9f-f175-0a893e70aaa5.png)

:::note
I had this exact issue and I spent 2 hours trying different strategies to find a fix and finally found a simple fix that worked for me and hopefully will work for you too.

1) When you are prompted to login to salesforce through the dataloader.io website, click the checkbox "I have a custom salesforce domain".

2) replace ONLY the 'yourdomain' part of the username with your active playground URL (ex: fancy-bear-ffsedj-dev-ed.trailblaze) so that the username looks like this example : fancy-bear-ffsedj-dev-ed.trailblaze.my.salesforce.com
:::

+ [Trailhead playground log in](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000Jejee)
+ [Issue with launch dataloader.io when logging in with salesforce on playground](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000PfBHs)

dataloader または dataloaderIO を使用しているときに、trailhead plyground へのログインに問題がある

:::note
Although the content is different, there is a workaround for the error when you can not log in successfully.

I had this exact issue and I spent 2 hours trying different strategies to find a fix and finally found a simple fix that worked for me and hopefully will work for you too.

1) When you are prompted to login to salesforce through the dataloader.io website, click the checkbox "I have a custom salesforce domain".

2) replace ONLY the 'yourdomain' part of the username with your active playground URL (ex: fancy-bear-ffsedj-dev-ed.trailblaze) so that the username looks like this example : fancy-bear-ffsedj-dev-ed.trailblaze.my.salesforce.com

https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000Jy9kR
:::

+ [While uploading a csv file through Dataloader.io , facing this problem. Can anyone tell me why is it so and how to overcome.](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007XIMWvSAP)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/090c14b5-b2ab-5ca1-8d5e-73a64cdb80c6.png)

:::note
How many columns are you attempting to import? Blank columns in the document you convert to CSV can cause problems.
:::

+ [Why does Dataloader.io not recognize my Trailhead userid and password?](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007ig1aT)

:::note
Please check this article.

https://trailhead.salesforce.com/ja/trailblazer-community/feed/0D54S00000FxW8XSAV
:::


# The following required fields are not mapped:

+ [I have to add 20 users in sandbox via Dataloader.io getting erro](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007LScq5)

バグみたい。upsertなら問題ないらしい

:::note
1. Take one of the users from your list of 100 and manually create a user record for them in Sf.
2. Add a new column to the spreadsheet and give it a header "UserID"
3. Copy the Sf ID of the one user you created in Sf and paste into the UserID column in the spreadsheet in the appropriate row (where that user's info is)
4. Start an upsert task in dataloader.io and map the UserID column in the spreadsheet to the UserID field in Sf. Make sure all the normally required fields are present (the list can be found here: https://help.salesforce.com/HTViewSol..., except I discovered currency code isn't actually required)
5. Run the task

Since Upsert is an update and an insert in the same operation, the one user you create manually will be the "update" portion, and the rest will be the "insert."


https://dataloader.zendesk.com/hc/en-us/community/posts/211166927-Insert-User-records-requires-wrong-set-of-fields-in-map-
:::

# Use Dataloader.io to Export Data

+ [Dataloader.io launch issue](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000MjlTqSAJ)

起動しないらしい
after this point the data loader doesn't launch. 

:::note
I had this exact issue and I spent 2 hours trying different strategies to find a fix and finally found a simple fix that worked for me and hopefully will work for you too.

1. When you are prompted to login to salesforce through the dataloader.io website, click the checkbox "I have a custom salesforce domain".
2. replace ONLY the 'yourdomain' part of the username with your active playground URL (ex: fancy-bear-ffsedj-dev-ed.trailblaze) so that the username looks like this example : fancy-bear-ffsedj-dev-ed.trailblaze.my.salesforce.com

https://dataloader.zendesk.com/hc/en-us/articles/224214348-Having-trouble-logging-in-to-dataloader-io
:::

+ [Excelがうまく開かない？](https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000KBrOX)



# トレイルヘッド

+ [Import and Export with Data Management Tools > Use Dataloader.io to Update Data](https://qiita.com/Keiji_otsubo/items/d7d74485b7faf578ec14)
+ [Using Dataloader.io to Export Data module -- cannot proceed, Account Site missing](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007BJ070SAD)
+ [指示によると、「ログイン」ボタンをクリックすることになっています。ただし、そのようなボタンはありません。](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007X8GJe)

ログイン画面が出てこないようです。本番環境のセッションが残っているかららしい

:::note
Please check this article.

https://dataloader.zendesk.com/hc/en-us/articles/5679490477075-dataloader-io-logs-you-in-to-an-active-session-and-you-are-not-able-to-log-in-to-a-different-account
:::



# 参考になるサイト

+ [Having trouble logging in to dataloader.io](https://dataloader.zendesk.com/hc/en-us/articles/224214348-Having-trouble-logging-in-to-dataloader-io)

# エラー

+ [I am having an issue using DataLoader](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007cm9ug)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/b8674043-461a-e188-4077-3fa11a592a15.png)

:::note
Please check to use Bulk API
:::

# 未解決

+ [Pulling batch record size on import wizard](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007UrDv0)
+ [Dataloader.ioでのデータ削除で処理結果のリンクが表示されない](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007UsX9i)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/ae9960b5-0912-6946-0305-08a2b7a7fa53.png)

以下は正常
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/6b895537-3737-cb7c-9bf9-98d44d16a50b.png)


+ [Unable to login on dataloader.io](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007erIK5SAM)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/49705874-f394-09f8-0d1d-3d4e0f27e9b8.png)

+ [Dataloader.io can't fetch sandbox objects](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007ervxj
)