Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved exportJson - UpperCase in column names

  1. How-to
0
Votes
Undo
  1. Andres Slachevsky
    Andres Slachevsky
  2. PowerBuilder
  3. Thursday, 21 March 2019 14:18 PM UTC

Hello All,

I have a DW with column names like :
Column1, FirstName,LastName

when i create the json file using exportJson

the Json is generated with names in lowercase 

column1,firstname,lastname

and that cause a problem when i try to import it in the targer application (non PB)

if i edit the names to keep the UpperCase then it import works.

any way i can solve it or i must use the JsonParser object?

  1. JSON
PB2017R3 Orca SCC Refresh Target not working
month control powerbuilder
Responses (2)
Robert Purser
Robert Purser Accepted Answer Pending Moderation
  1. Thursday, 16 January 2020 17:20 PM UTC
  2. PowerBuilder
  3. # 1

I'm having the same problem but for what I want to do I would have dozens of Datawindows and hundreds of column names. Is there no way to have mixed-case column names in a Datawindow?

Comment
There are no comments made yet.
Kevin Ridley
Kevin Ridley Accepted Answer Pending Moderation
  1. Thursday, 21 March 2019 17:04 PM UTC
  2. PowerBuilder
  3. # 2

Not ideal but if it's only 1 dw and you know the column names, you can just write a find/replace utility to replace the lowercase for each column, since JSON is really just a string.

Comment
Kevin Ridley
  1. Kevin Ridley
  2. Thursday, 21 March 2019 17:30 PM UTC
FYI the pfc has a great string replace function. Check out pfc_n_cst_string.of_globalreplacenew it should have everything you need. You can put "old" and "new" values into arrays and loop through calling the replace function. Also looks like you can just copy the function right from the pfc without all the usual pfc "hooks".
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.