How to avoid header record from an excel using it create Bulk cases

[VenkateshC17599704 (Venkatesh C)]

Problem : I have requirement where i need to create bulk cases through upload of an Excel file (.xlsx).
Aprraoch i followed is : Created separate casetype for bulk upload and in post processing of flow action i am doing the parsing of file and case creation logic (with the help of Data flow).

So the issue here, When i am trying to upload the file with More than 1000 records (actually this is one of the AC: that user shouldn’t be allowed to upload the file with more than 1000 records) It is allowing with header as taking the count. But i have added in the logic to check count of of records should be greater than 1000 then exit the activity but it’s not working .

Could anyone please help me with this issue to resolve

Thanks,

Venkat Ch

[RameshSangili]

Could you please confirm whether the PageList includes the header row after the pxParseExcel step is executed when uploading files with 5 or 10 records?

We have a similar requirement for bulk case creation and, in our experience, the header has never been included as part of the PageList.

[JayachandraSiddipeta]

@VenkateshC17599704 When you call pxParseExcelFile activity, you have an option to select whether your uploaded excel has header or not as shown below

Check this option and then the output pagelist should contain the list of records without the header. Then your count validation would work fine.

Regards

JC