Issues after importing the maintenanceLog.csv file

[Nuel21]

I’ve started my power up training and I’ve ran into an issue. I'm on Video 16 where I need to import the file : MaintenanceLogs.csv into the Maintenance logs table and on the video the trainer gets 1 error and 6 success row imports but when I do it all 7 rows fail to import. The error description says : “The lookup reference could not be resolved” which means nothing to me. I have seen previous solution to change my location to US which i did and my service area from building to building block and still having errors. 

[BenClistBC2 · Accepted solution]

Kia ora @Nuel21,

The error message is telling you it can't find a record in your Location table with these names:

Have you called your locations something else?

Ngā mihi,

Ben

Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

[Nirav237 · Accepted solution]

Hi @Nuel21 ,

There might be two condition which is creating error during import -
1) Recheck all the record of Location, if it is have Case senstive record value that might cause an error.
2) The Value for service area where record name Building is created might cause error because on CSV file there is Building work.

Just recheck all the Location values of record and create one new record on the table > Service area with Building work.

It will work,


Regards,
Nirav J Raval

[Nuel21]

Thanks so much, i checked my locations where i made a an alphabetical error BO1 instead of B01 and so on

[Nuel21]

Exactly it was an an alphabetical error, Thank you so much

[KMPowerUp]

I had the same problem and I am complete newbie.

(I am based in the UK) - I opened the CSV data in an Excel sheet so it was delimited to the columns (looking like a normal spreadsheet), and then formatted the date columns to English UK.

For some reason, this didn't work on all dates as some visibly remained in US format.

So, I simply retyped those dates in the cell they are in, which then reformatted them to a UK date.

Imported it again, it worked.