473,396 Members | 2,052 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

PEGA relief map - data table exported to CSV using JSON

New job, new platform: Pega. So Pega is being used to host a relief map of ranchers and farmers for a conservation project. A data table can be generated with about 20-22 columns. The developer told me that the export to CSV uses a function exposed by Pega to convert a JSON payload to a .CSV file

the problem is, empty cells in the data table on the browser have a "-" (the dash symbol) because our client doesn't want empty data cells. The dashes are not carried over to the .CSV export

the second problem is that a column that displays that data in quotations is being exported to .CSV with double quotations.

I have been going over to the code in developer view trying to figure out where and how that data is being exported that particular way but I can't find the exact string.

Does anyone else have experience with Pega using a JSON command to export a .CSV file?
Nov 24 '20 #1
0 2185

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Steve | last post by:
Hi; Can a table.....with all of its data be exported into a SQL script that will restor the table with all of its data? Thanks in advance Steve
1
by: John | last post by:
Hi When using Table Adapter Configuration Wizard if 'Use SQL Statements' is selected as Command Type, the data table's name in dataset is retained and only its data adapter's select statements...
1
by: Andrew Poulos | last post by:
There's an object: foo = new Object(); and a property called 'bar' with a value of 1 is to be added to it using JSON. If I try the following it only demonstrates my ignorance: var str =...
2
by: Daz | last post by:
Hi everyone. Sorry for the confusing subject, I couldn't think how best to word it. What I would like to know, is if there is an equivilant to this code, in using JSON. <script...
1
by: laredotornado | last post by:
Hi, I have a data table on my page (buried amidst other images and extraneous text). I would like to spawn a new window that automatically prints the content of my data table, and only that...
4
semanticnotion
by: semanticnotion | last post by:
hi i have 3 tables in mysql i retrieved the data in xml using php now i want to retrieved the same data in json format but i have some problem in queries. i retrieved data from one table in json but...
0
by: ghjk | last post by:
I want to add form data and images using one form in php. I'm using php,ajax and mysql.When I run images insert code and data insert code seperately ; they worked. But when I put in the same php form...
1
by: salmansohail | last post by:
I got few odbc connections, where I can import tables from in Access, However, I'm trying to create a vb Script, which uses the exisitng odbc DSN connection and import or read a table and save...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.