Question

2
Replies
152
Views
 Chunzhi Hong (Chunzhi_Hong)
PEGA
Consulting Manager
Pegasystems Inc.
JP
Chunzhi_Hong Member since 2013 141 posts
PEGA
Posted: December 26, 2016
Last activity: December 27, 2016
Posted: 26 Dec 2016 0:39 EST
Last activity: 27 Dec 2016 0:50 EST
Closed

7.2.1 Data table exported column order differs from which displays on the screen

We have delegated a Data table to the end user, so end user can export / import data from the OOTB data table edit screen.

The exported CSV file contains  all record displays on the screen with different column order as attached image shows.

Can anyone explain why does this happen and how can I make sure the exported CSV has the same column order as the screen display ?

 

Many thanks!

***Updated by moderator: Lochan to update Categories***

Low-Code App Development Case Management Data Integration Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 26 Dec 2016 10:13 EST
Veera Gangababu Gollapalli (Gangababu)
PEGA
Principal Technical Solutions Engineer
PEG
IN

Hi chunchi,


I did try to export the data type column information in 7.2.1 local instance. However I did observe that after exporting all the columns are in alphabatical order(ie. from A to Z).


If you can try running the Data Type export in data explorer and observe the behavior.


FYI, pzDownloadDataRecordsAsCSV  OOB activity is responsible for exporting the records.


P.S: I haven't tried delegating option.
Posted: 4 years ago
Posted: 27 Dec 2016 0:50 EST
Chunzhi Hong (Chunzhi_Hong)
PEGA
Consulting Manager
Pegasystems Inc.
JP

You can reproduce the issue by creating a new Pega Express application. 


There will be a Data type called Product created by default and you can see that the column order is different between CSV and Screen display as belwo screen shot show.