MaxLab 2b: When uploading file for first time, step 17 indicated 6 mapped, 1 not. I did steps 7-17 again and got 7 mapped. Did import through steps 28, Step 29 just shows three records. I tried the import again and get 3 records.
I have attached screen capture of step 29. I also captured the import report which does show 10 of 10 records failed.
Ok, Mary, well it looks like Address never got added as a field into Meeting Attendances. That's supposed to happen in Steps 104 to 116. Is it possible you missed those? Or maybe you did them all except forgot to do the Next, Next, Save at the end in the last step?
Go to the Object Manager and open up the Meeting Attendances object and click Fields & Relationships and see if Address is there and if it's not, then click New and then follow 104-116. If it is, then I think it may be that the field got Hidden. That can happen if you click thru the Next, Next & Save quickly, before SF has a chance to fully load the pages in between that set the Visibility for the field.
Let me know if you can confirm that it is there in the object already. If so, then I'll tell you how to check & fix the visibility. If it's not there, then add it as described above, ok?
I am now having another problem with step 140 Add filter: there is no address on drop down. Not sure how / where to fix
your guess is correct! thanks for help!
Ok so your list of 3 Meeting records is showing the 3 that you created in Lab 2a. So none of the records imported, even tho you got all the fields mapped, which is good.
My guess is that you had some trouble importing Pitches back in Lab 1b so that your Pitch records are not numbered 000 thru 009. If so, that's the problem because the Meeting records coming in the import, have to each find a matching Pitch record. The Meeting data records in the import file, each contain the Pitch ID of the Pitch record they go with. So if you look at that Meeting data file, it has a column with Pitch ID and they are numbered 000 thru 009.
So if that is your problem, all you need to do is to edit the Meeting data file in Excel, changing the Pitch IDs of the Meetings to match to your Pitch record IDs. Like if the Pitch records are numbered 010 thru 019, then change the values in those cells to 010 to 019. (Both files are in the same order from top to bottom, so both ID sequences will align.)
BUT MAKE SURE, WHEN YOU SAVE the file in Excel, that you SAVE AS and choose the CSV file format because Salesforce can't import from an .xls file. It has to be a .csv file.
If the Pitch IDs aren't your problem, then post back and we'll find a different solution.
here is screen capture of step 29