Skip to main content

Notifications

Power Up Program - Building model-driven apps w...
Unanswered

Unable to import CSV file

Posted on 22 Apr 2024 08:43:56 by 8

Hello,

I am on module 16 of the Microsoft Power Up program to build a model-driven up and cannot import .csv files. When I select the option Import .csv the window for importing files does not open. Anyone encountering the same issue and/or ideas to solve it?

Thanks and regards,

Fabiana 

Categories:
  • priscilacso Profile Picture
    priscilacso 3 on 14 Nov 2024 at 12:59:21
    Unable to import CSV file
    I am in the same situation. Any help regarding this?
  • CU19081538-0 Profile Picture
    CU19081538-0 2 on 19 Aug 2024 at 15:19:40
    Unable to import CSV file
    Yes it did work, thank you!
  • BCBuizer Profile Picture
    BCBuizer 21,956 on 29 Apr 2024 at 11:13:39
    Re: Unable to import CSV file

    Hi @TechPrince ,

     

    Simply add the mentioned rows to the Service Areas table, for instance by navigating to the table in the Solution explorer and clicking the +New button at the top ribbon to add any missing rows:

    BCBuizer_0-1714389181761.png

     

  • TechPrince Profile Picture
    TechPrince 36 on 27 Apr 2024 at 22:51:20
    Re: Unable to import CSV file

    How do i achieve the below

     

    To prevent this, make sure the following areas are in your Service Areas table: Plumbing, Electrical, Cleaning, Building, Carpentry.

  • BCBuizer Profile Picture
    BCBuizer 21,956 on 27 Apr 2024 at 21:53:15
    Re: Unable to import CSV file

    Hi All,

     

    Just a few things to look after when doing this exercise:

     

    1. Import method: As mentioned in the video, there are multiple ways to import data. The one that is being demonstrated is when playing the app. When trying to import via the solutino explorer I ran into an issue where the MaintenanceLogName column gave an error since it is a required field, but it is an autonumber field, meaning a value can´t be provided. Also the mapping had to be done mostly manually. These are all not an issue when importing via the app.

     

    2. File extension: With the course resources there are two similar files available MaintenanceLogs.csv and MaintenanceLogs.xlsx. Use the first one. Although the data looks the same, the files are structured differently which may cause issues.

     

    3. Date formatting: The data in the file is formatted as mm/dd/yyyy, which is the data formatting for English (United States). During and earlier video you may have changed the language settings to English (United Kingdom), which means you have to change this back or else the values are not recognised as valid.

     

    4. LookUp values: Some of the values for the Service Area column may not exist in your Service Areas table which will make the LookUp fail. To prevent this, make sure the following areas are in your Service Areas table: Plumbing, Electrical, Cleaning, Building, Carpentry.

  • TechPrince Profile Picture
    TechPrince 36 on 27 Apr 2024 at 18:44:36
    Re: Unable to import CSV file

    Hi, were you able to resolve this error after the import?

  • Javiavan2 Profile Picture
    Javiavan2 70 on 25 Apr 2024 at 09:27:25
    Re: Unable to import CSV file

    I am encountering the same problem. 7 errors. Attached image.

    Javiavan2_0-1714037234121.png

     

  • FabianaRR Profile Picture
    FabianaRR 8 on 23 Apr 2024 at 12:54:42
    Re: Unable to import CSV file

    Hi,

    The issue is solved. I forgot to actually Play (click the button) the app...

    Now the issue is that all 7 records give error...

    Thanks for your support.

    Regards,

    Fabiana

  • Nirav28 Profile Picture
    Nirav28 169 on 22 Apr 2024 at 16:57:37
    Re: Unable to import CSV file

    Hi @FabianaRR 

    Can you please share some screen shot of the error or issue which you are facing, It will be very helpful.



    Regards,
    Nirav J Raval

  • FabianaRR Profile Picture
    FabianaRR 8 on 22 Apr 2024 at 13:35:02
    Re: Unable to import CSV file

    Thank you for the suggestion, but I am in English (US) already... The problem I face is that the window for importing does not even pop up; I click Import .csv from the menu but no window opens, so I do not even have the option to search for the file. The same happens when I try to import excel...

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard

Featured topics