Import and Export with Data Management Tools > Use Dataloader.io to Update Data


+ [Import and Export with Data Management Tools > Use Dataloader.io to Update Data](https://trailhead.salesforce.com/content/learn/projects/import-and-export-with-data-management-tools/use-data-loader-to-import-data)

# 区切り文字が違っている

+ [Update in Dataloader.io](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000FWq03SAD)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/03bf36dd-8408-dd3e-4183-215bfde9c664.png)

:::note
It seems your data is separated by ';' . Could you please convert your data into Comma Separated  and try.
:::

# 11件のエラー

+ [Use Dataloader.io to update data.](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000HEY3lSAH)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/bf467eeb-ed60-2caa-a6d5-08dc0e626ef4.png)

:::note
Go to field accessibility settings for the object and remove required checkbox for the field . This makes field optional . 

Check if any validation rule is setup for the object which make the field Support_Plan_Start_Date__c  required . 
:::

+ [Does anyone know why I keep getting errors when trying to upload my saved document into dataloader.io?](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000PedCK)

+ [  The error is "invalid cross reference id" ](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007OuMcg)

:::note
I just manually updated the account site field for the 11 records for this project. Wouldn’t be the way to do it for 1,100 records but got me through to the next.
:::


# エラー

+ [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)

+ [Error in SOQL Query in the "Use Dataloader.io to Export Data"](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007JBdmj)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/c7960e08-1816-ab0f-3800-939d14cc0573.png)

:::note
I found the solution to the problem mentioned above. The 'Account type' field was not available, even though it was not mentioned in the steps. It wasn't related to a security issue; I had already checked that. I searched for many videos on YouTube, and I even tried to solve it by creating a different User Id, but I kept encountering the same error. Finally, my cousin suggested me to do in Incognito window. I completed the challenge in the Incognito window with the same User ID, and the 'Type' field was available. After selecting the 'Type' field, there was no error, and I was finally happy.

上記の問題の解決策を見つけました。手順には記載されていませんが、「アカウントの種類」フィールドは使用できませんでした。それはセキュリティ問題とは関係ありませんでした。私はすでにそれを確認していました。 YouTube で多くのビデオを検索し、別のユーザー ID を作成して解決しようとしましたが、同じエラーが繰り返し発生しました。最後に、いとこがシークレット ウィンドウで行うことを提案してくれました。同じユーザー ID を使用してシークレット ウィンドウでチャレンジを完了すると、「タイプ」フィールドが使用可能になりました。 「タイプ」フィールドを選択した後、エラーは発生せず、最終的に満足しました。
:::


# Export Dataでのエラー

+ [Use Dataloader.io to Export Data: the download in excel does not look lik it is supposed to . I have tried many ways to change the file i just can't seem to figure it out.](https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000KBrOX)
+ [Using Dataloader.io to Export Data module -- cannot proceed, Account Site missing](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007BJ070SAD)

-----------
+ [【未解決】Running export with dataloader.io returns 0 results](https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000TjATR)