Hi, I've been searching the forums but haven't found any solutions. I'm stuck on the map application step. It's giving me an error. I've already checked the saved CVS file and it's fine. However, everything appears in one row. I've seen videos and others that show different properties like first name, etc., in different rows.
I attach a photo of where I am stuck,
and the error that appears when clicking next
The challenge is this one
https://trailhead.salesforce.com/content/learn/projects/import-and-export-with-data-management-tools/use-the-data-import-wizard?trailmix_creator_id=strailhead&trailmix_slug=prepare-for-your-salesforce-administrator-credential
#Trailhead #Trailhead Challenges #Salesforce Admin #Import Data Challenge
2 risposte
Yes i tried changing it but it doesnt work, i found this answer that help me to solve the problem.
I leave it here in case it helps someone.
https://trailhead.salesforce.com/es-MX/trailblazer-community/feed/0D5KX00000PZp2Z0AT
To resolve this issue:
- Go to your file and right click on it.
- Select Open with and select notepad
- Once the file open in notepad, click on the Edit Tab.
- Select replace
- On the "Find what" field enter the value (;) semi-colon
- On the "Replace with" field enter the value (,) comma
- Click on the Replace all button.
- Save the file and add the .CSV on the end of the file name. Once done with the last step, don't open again the save file on excel. This will ensure that the delimiter of the file is save as comma delimited. The file should be good for import.