Finance | Project Operations, Human Resources, ...

data management

(0) Share

Report

Posted on by Community Member

While import the data management .

showing:-

The file for entity Vendors V2 has 2 error(s)
Parallel tasks configured for Vendors V2: 0, Staging records: 0
'0' 'Vendors V2' record(s) inserted in staging.

how to find out error in excel sheet.

thanks in advance

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

It means you have errors in your file, it is hard to understand.

You need to see if any data is there in file and not in master

Was this reply helpful? Yes No
Suggested answer

Michal Krejza Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Could you share the vendor file with us ?

I would suggest following:

- Export Vendors from your system into Excel

- Delete all lines except one from Excel

- Import Excel back using the same data entity

Is this working properly ?

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

You can find an error in the execution details. If the data is not imported, you might have duplicate records, some mandatory fields are not filled or there might be some other invalid data in specific columns.

Was this reply helpful? Yes No
Suggested answer

Jinsan Son 5 on at

Like
a
(0)

Report
Copy link

Link copied!

In deed it was the format of the data. In my case, there were weird (some kind of ASCII code) character included in the data and some number has the comma(,) in it. Once I have rectified it, the data import was done successfully.

Was this reply helpful? Yes No