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

All responses (4)

Answers (0)

Suggested answer

Jinsan Son 5 on at

Like (0)

Report

RE: data management

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.
Suggested answer

André Arnaud de Cal... 294,120 Super User 2025 Season 1 on at

Like (0)

Report

RE: data management

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.
Suggested answer

Michal Krejza on at

Like (0)

Report

RE: data management

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 ?
Suggested answer

Ramit Paul 22,473 Most Valuable Professional on at

Like (0)

Report

RE: data management

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