Import excel during the dataentry

0
Hi All,   I have 2 tables / entity. Master and Transaction. The Transaction contains multiple records. User can input these transaction one by one.    I have created a "Excel Import" and calling the same thru a button in my page. The excel is importing successfully but not reflecting the dataview.    Question is, How list the data in dataview once import is success ?   Regards Sudhir
asked
8 answers
3

Hello Sudhir,

You can achieve this 

1.Give import button option.

2.Call  MF to import data .

3,After import you can refresh the page and data should be visible there.

answered
2

Hello Sudhir,

You can add debugger in your IVK_ImportTemplateDocument microflow and check template and other things are correct.

Also at the last of this microflow you can call show page activity and can display the data.

image.png

answered
0

Hi Raju,

 

Actually I am in data entry screen. Where few rows then provision is made to add button and create the details. If it is bulk user can utilize the import option. 

 

So in the page itself data has to popup

 

Regards

Sudhir

answered
0

Hi Raju,

In the MF IVK_ImportTemplateDocument added Change Object with refresh. But it is not listing the item but it is adding a blank row.

image.png

 

Regards

Sudhir

answered
0

Hi All, 

 

The refresh has been set properly. Imported records are displaying on the screen. 

 

I am using list view with Edit enabled. Now, if I import 50 records then it will list all records. Is there anyway to bring the scrolling by enabling the list view length of 10 records ?

 

Regards

Sudhir

answered
0

Hi Sudhir,

 

You can show only 10 records initially by defining the page size of 10 inside the list view general settings.

 

Thanks

answered
0

Hi Amit,

 

If the ListView is editable then you cannot set the number of rows. 

 

image.png

 

Regards

Sudhir

answered
0

Hi All,

 

I have made it using style sheet.

 

Thanks for your support.

 

Regards

Sudhir

answered