Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

ER File Import From SharePoint broken?

Posted on by Microsoft Employee

Hi, 

I experience some difficulties importing files stored on SharePoint via ER as described on this docs site:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-configure-data-import-sharepoint

The log of the batch job says "There is no suitable file to import in the source."

It is not something special, just a simple Excel file with 2 data records that I want to import. 

Interestingly, if I manually import the file via ER without making use of the ER source and batch job configuration, the file import works fine. 

Any hints/tips welcome. 

Thanks, 

Ludwig

  • DianaRaileanu Profile Picture
    DianaRaileanu 4 on at
    ER File Import From SharePoint broken?
    Hello everyone, 

    Has anyone found a resolution for this issue?

    Thank you in advance.
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 12,059 Super User 2024 Season 2 on at
    ER File Import From SharePoint broken?
    Hi Dr. Ludwig Reinhard,
    Was the issue related to "Run ER import of manually uploaded documents in batch" feature?
  • BPS Profile Picture
    BPS 272 on at
    ER File Import From SharePoint broken?
    Hi Ludwig, 
    I am facing the same issue, could you please let me know if you got a solution of the issue.

    Thanks, 
    Pratap
     
  • VRD Profile Picture
    VRD 517 on at
    RE: ER File Import From SharePoint broken?

    Hi Ludwig,

    Sorry I cannot help you on your issue. But I need some help from you regarding this ER file import. But I need to implement similar ER file import like you. I have non-standard model to setup which I have done. This file comes from bank and need to mark payment journal transaction payment status as 'Rejected'. The files are text files (not CSV) format and will be placed at Sharepoint.

    Do you think we need to write a custom batch job to read this file and import through ER where i need to write whole code of how ER will be kicked in to convert the Bank file to appropriate format first and then do code to mark ledger transaction payment status to 'Rejected'.

    Your pointer can be of great help to me. Thanks.

    ~ Vikky

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans