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)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

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 on at

Like (0)

Report

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... 301,171 Super User 2025 Season 2 on at

Like (0)

Report

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 (0)

Report

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