You need to sign in to do that
Don't have an account?
Nikhil Jaitly 8
Superbadge - Reports and Dashboards - Configure reports and dashboards security
Hi All,
I am getting this error again and again -
Challenge Not yet complete... here's what's wrong:
The 'Contact by Hobby' report does not appear to be in the 'General Reports' folder. Whereas I have created the 'Contacts By Hobby' report and saved it in the General Reports folder quite a few number of times, but still getting the same error.
Thanks
Nikhil
I am getting this error again and again -
Challenge Not yet complete... here's what's wrong:
The 'Contact by Hobby' report does not appear to be in the 'General Reports' folder. Whereas I have created the 'Contacts By Hobby' report and saved it in the General Reports folder quite a few number of times, but still getting the same error.
Thanks
Nikhil
All Answers
I have errr while downloading the data into Data Import wizard. I have saved the excel sheet three sheets into three CSv files namely, people, Opportunities and hobbies. Tried to import first people's sheet and matched the column Hoobies with custom field Contact Hobby taht was created... I am not able to download data... Secodnly, I have downloaded the Hobbies file into cusotm objects and was succesful... Pls help...
1. Hobbies
2. Accounts
3. Contacts
4. Contact Hobbies
Thanks
NIkhil
I've Imported the Hobbies and Account/Contacts. struggling with Hobby Contacts.
I'm getting
REQUIRED_FIELD_MISSING:Required fields are missing: [Hobby__c]:Hobby__c --
My Mapping look like this:
It fails with the message above. Any pointers ?
Thanks.
I am importing only 2 columns: Name and Hobbies. I import as Custom Objects > Contact Hobbies. I choose Add new records. I don't select anything from the dropdowns (selecting either one seems to cause other errors). I have the same exact mapping as in your screenshot. When I import I get the same error as stated above.
Getting confused here. Any help would be appreciated.
The way I did that was Export Contacts and Hobbies using the Data Loader to get the ID's in a file. I then mapped them in Excel to get this:
If anyone needs more details or has a better/easier way of doing this let me know.
Hey ive been stuck on this part for two days now. looking at the screen shot above I see you only aasigned them one hobby and the first hobby in their list of three. Do we need to have all three ID numbers or just the first one. Igor- Im trying to understand creating 3 files for each hobby? if you can shine anymore light on that I would greatly appreciate it.
let me try it, and get back to you guys.
thanks
FYI- v look ups will save you a ton of time, and allow you to easily map the ID's to the apporpriate contact/hobby
I am not quite sure how to utilize the vlookups because I don't understand exactly what we are looking up and when... so here is my process starting from Challenge 1... since i'm still on it a full day later...
I have a new DE account.
Map your fields. Current field mapping * File Column Header | NameI Installed the unmanaged package.
I changed the DE account settings like it recommended.
So I start with the excel file and Dataloader.
WIthin the excel file there are four tabs : (Contacts & accounts, Opportunties, Hobbies, and Contact hobbies)
This is where I created a new spreadsheet, because I assumed the vlookup will be utilized here... yet I do not understand exactly what it is asking.
It wants three reports, so I am assuming that I need three spreadsheets but I would like to get through the first one for a start...
Right so, In Dataloader,
step1 step2
Insert > Hobby(Hobbies__C) > choose CSV file > select "Sanditas_Import_File.csv" > initialization succeded, containing 240 records
Step 3
* Contact Name | (This is left blank)
*Hobby | (This is left blank)
####Note: I have tried to "create or edit a map" which results in errors upon finish.
#######Note : Tried it with the blanks as above in step three - RESULT 240 successful inserts
Map your fields. Current field mapping * File Column Header | NameNow I move onto dataloader for accounts!
step1 step2
Insert > Account(Accounts) > choose CSV file > select "Sanditas_Import_File.csv" > initialization succeded, containing 240 records
Step 3
* Contact Name | (This is left blank)
*Hobby | (This is left blank)
####Note: I have tried to "create or edit a map" which results in errors upon finish. For this option I am using the (Name & Type... I know these are probably incorrect but regardless of my choices from the choicelist I am getting this result - RESULT 240 successful inserts
#######Note : Tried it with the blanks as above in step three - RESULT 240 erroneous inserts
Now I move onto dataloader for Contacts!
Map your fields. Current field mapping * File Column Header | Namestep1 step2
Insert > Contacts(Contacts) > choose CSV file > select "Sanditas_Import_File.csv" > initialization succeded, containing 240 records
Step 3
* Contact Name | (This is left blank)
*Hobby | (This is left blank)
####Note: I have tried to "create or edit a map" which results in errors upon finish. For this option I am using the (AccountID & Description)... I know these are probably incorrect but regardless of my choices from the choicelist I am getting this result - RESULT 240 erroneous inserts
#######Note : Tried it with the blanks as above in step three - RESULT 240 erroneous inserts
What am I missing? I feel like there is a bit of key information that I have just blown past and can't recover from.... even though I am on the begining step.
Should I be creating three new excel files and then utilize the vlookup somehow?
I am terribly confused...
The V-look is so you dont have to spend a ton of time matching the contact hobby to the prospective ID's. If you do this manually youll forusre spend hours matching the info, and the v-look up reduces the chances of ernouniously entering the wrong ID number. Also I made a few mistakes in the very begining and strated from scratch about 3 or 4 times lol Honestly it helped me to start over and really think things through, hopefully I gave you some insight on macthing the ID's and contacts.
Ive got the vlookups down as of an hour ago. The only problem is now that I've tried it a few times I have realized I am completely looking up the wrong ID's from previous attempts and essentially screwing myself over there.
I'm on another attempt, but I appreciate the clarification!
so the next step would be to use a vlookup to combine them?
I'm not able to visualize the next step
I did the vlookup thing. However this is not serious. I mean in real life with TB of data using vlookup or export and map in external DB is not very handy. Is there a way to use the Data Loader in more inteligent way in order it to check the refernces? Or is the correct way creating before insert triggers for the intial load? I am just interested in the correct salesforce way. The challenge is 240 rows and is easy to tweak using vlookup (just remeber that the values in the first column should be sorted :-) ).