Batch Import Application

Help / Discuss
1

Hi,
I am using batch import application to populate my live table, which I have created through AWM. However during mapping I am getting to map only half of the columns. Only the alternate columns are being shown during mapping. Can you help me on it ? Where do I need to do changes so that all the columns are mapped.

Regards,

2

Hi,
Could you please provide more details? It would be interesting to see how the column names look like, maybe they have some special chars, or if all the data types are properly mapped. Also, make sure that all the notes from the “Column mapping” are carefully read.

Thanks,
Alex

4

In order to test your configuration, I created a new application using the AWM, with the same property names and pretty names without being able to reproducing your issue. I would suggest you to do some debugging to find out why there are class properties missing from the UI and the right place to start from is batchimport/xwiki-batchimport-application/src/main/resources/BatchImport/BatchImportMacros.xml at master · xwiki-contrib/batchimport · GitHub.

Hope this helps,
Alex

5

Now this is funny. I did some trial thing with my awm and csv and came to the conclusion that there is some problem with the csv file that I am trying to upload. If I try to map some another test csv, all the properties can be seen in the mapping UI. But when try to upload the actual csv in this awm or any other, the half the UI properties will go missing. :weary::open_mouth::sleepy::face_with_raised_eyebrow:
Can anyone explain this to me ?

Regards,
Nikhil

6

Well, this is not a Batch Import Application issue. Please use a valid csv or xls file in order to get the expected results.

Thanks,
Alex

7

Alex, just now found the actual problem. The csv I was uploading had one column with name Prob(%). It was causing problem. I just renamed it, and now it is working fine. :see_no_evil:
Don’t know why it happened that way, but now it is wokring.

Regards,
Nikhil

8

@nickhil Thanks for posting back. This looks like a bug in the batch import application. Would you mind reporting a jira issue at Loading... ? Thanks!

9

Ya sure, will do that. :slight_smile: