Error DIXF : 0 Vendor records inserted in staging

(0) Share

Report

Posted on by Community Member

Hi all,

So it's my first time experience with Data Import Export Framework. My businees requirement is to create new legal entity and move some data like vendor and customer from legal entity A to B. From information that i get, i need to use DIXF and based from some guide i have found, here's what i've done (DAX 2012 R3):

- I have created the DIXF parameters, source data format (for this case delimited).

- Using target entities : vendor.

- Create a processing group (leave both check box empty, generate source file and save it, select default column, and manually mapping it to the source and generate source mapping).

- Get staging data, and run the job and got this info :

Someone please explain why i get zero row inserted to staging and what is the solution? Thanks.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (3)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Anisa,

You can look at the processing history to find out about possible errors. You have not mentioned any details about how you did fill the source file, how many records you have and which columns are included. Can you confirm you have at least all mandatory fields provided?

PS. The title of the post is mentioning Asset records while the post is about Vendor records. Can you update this?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The execution history just showing Staging Status : Error & Target Status : Didn't run.

Here is how i fill the source file :

I was using only default records i assume that's the mandatory fields, then i generate the .txt files So, yes i have all mandatory fields. Yes i have changed the title, thanks.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Anisa,

When you are on the form Execution history, you can indeed see the status for staging and target like you provided now. Have you also looked into the details of the form Error log? This usually provides the details about the error. Eventually from this form you can drill down further into Staging log details.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have checked the history and error log, it doesn't really giving me useful details. Also, staging log details button is disabled. The info log still showing me same message.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Pl. go to that particular Processing Group > Execution History > Error Log > Log text field. You should be able to get the exact reason of the above mentioned issue.

Regards,

Vishal Salot

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Anisa,

How many vendors do you have in this file? can you also check the codepage being used for this file and the one you have setup on the processing group? If this does not match, it could also give errors.

What delimiters are setup on the processing group? Are these correct?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Vishal,

You can see my "Log text" information on above screenshot. It says "'0' 'Vendor' record(s) inserted in staging".

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Andre,

You mean how many vendors i have in current legal entity? Well, from what i see from vendor form, i have about 30 vendors.

My code page on source data format setup is 1252, i can't find code page on my processing group where i can find it?

I'm using delimited on my processing group, yes.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Anisa,

Sorry my fault.... The codepage is on the Source data format setting. Also the settings for the delimiters are on the Source data format.

I was not asking about how many vendors are in AX, but in the source file.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

OK, yes it's different, my code page for source data format is 1252 but my .txt is ANSI. I have tried to change it into match type, but still doesn't work.

I just tried excel as source format, then my processing group generate an excel file, but only header. Then i tried to "Preview Source File", it tell me something about 0 rows or something and show me no data below it. SO i open this excel file and manually added a dummy data save it, and clicked button "Preview Source File" again, it's shows me some data i have entered before below it.Then i go back to processing group and do the job "Get Staging Data", now 1 row has inserted. It's working. So i think it won't give me anything (show me same result as my screen shot) if the file has 0 data, it at least need something.

Well, the problem is it's impossible for me to add manually one by one each my vendor data into this file. I thought that when i clicked something in Processing group then they will generate my vendor data into file. I'm so frustrated, ho can i generate this vendors data into excel so i can migrate vendor into other company?

Was this reply helpful? Yes No