Issue with importing the maintenance file csv

[Esraa_k]

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 said : “The source data is not in the required format” , what dose this mean? and how to solve it

[Nirav237 · Accepted solution]

Hi @Esraa_k 

Try this before importing the file -

1) Create record on the Service Area as Building Work and save it.

2) Now change the date format settings from > Personalization setting - Click on cog wheel than select Personalization setting, go to the tab name formats and change to English (United States).

If I was able to solve the issue, like the post and please click accept as solution 😊

Regards,
Nirav J Raval

[BCBuizer]

Hi @Esraa_k ,

As suggested in this topic (https://powerusers.microsoft.com/t5/Building-model-driven-apps-with/Problem-with-Excel-upload/m-p/27...), try changing the file type to .csv

[Pavan_Mani_Deep]

Hi @Esraa_k 

Firstly, try downloading the import template for Maintenance logs table. 

Once downloaded, fill in the data in the template and then try to upload.

If I have answered your question, please mark your post as Solved.

If you like my response or got a direction forward to proceed, please give it a Thumbs Up. Appreciate your Kudos. You can accept more than one post as a solution.

If you were still facing any issue or challenge, please do let me know so that I can try to check for you. Happy to help you further.

Blog:https://ecellorscrm.com

Cheers,

PMDY

[BenClistBC2]

Kia ora @Pavan_Mani_Deep,

Downloading import templates is not something that is covered in the Power Up Program and is not a requirement for this scenario. The import file is provided as part of the course materials.

This post could be confusing for other learners.

Ngā mihi,

Ben