hpcc-systems / Visualization

HPCC JavaScript Framework
https://hpcc-systems.github.io/Visualization/
Other
93 stars 62 forks source link

Table export as CSV undefined #3081

Closed jchambers-ln closed 5 years ago

jchambers-ln commented 5 years ago

Certain datasets that show blanks in the table widget export with the value of undefined in the column.

Possible bug or opportunity to add "treat as blank" option in the dermatology.

databaser1 commented 5 years ago

When a blank value shows in a table cell, it'll be initialized as empty string or anything defined in missingDataString setting in marshaller_HTML section in Layout Designer (for exemple: MISSING); but all those blank values that haven't got chance to be displayed in the table (like in page 2 and above) will be a literal string "undefined" in the downloaded CSV.

GordonSmith commented 5 years ago

@databaser1 - what version are you using (2.x or 1.x)?

databaser1 commented 5 years ago

@GordonSmith - It's DSP-CERT: DSP Version :1.11.0.4 HIPIE Version :1.11.2.1 VIZ Version :1.20.0 Salt Version :SALT32 Minimum HPCC Version :5.6.4-1 KEL Version : Dermatology Version :1.3.1

GordonSmith commented 5 years ago

Can we double check the viz version as it looks like this fix made it into v1.20.0-rc6: https://github.com/hpcc-systems/Visualization/commit/3ccecabe13673c1069f79a69856ce8dd8f5c267b

GordonSmith commented 5 years ago

@jchambers-ln can you email me a link to the offending dash?

databaser1 commented 5 years ago

Https://dsp-cert.risk.regn.net

Login and find dashboard SASearchV4. Then search for a first name such as John then click on a record in search result, and the specialty summary widget will be populated, whose font needs to be adjusted.

On Jan 18, 2019, at 11:35 AM, Gordon Smith notifications@github.com<mailto:notifications@github.com> wrote:

@jchambers-lnhttps://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fjchambers-ln&data=02%7C01%7C%7C50ceffebfa0f4c78e77808d67d62f741%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636834261341134152&sdata=SVjLaHnTRpaenliPLX6US9suhFUPbuRmTu5F%2BlY%2BS%2Bo%3D&reserved=0 can you email me a link to the offending dash?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fhpcc-systems%2FVisualization%2Fissues%2F3081%23issuecomment-455607997&data=02%7C01%7C%7C50ceffebfa0f4c78e77808d67d62f741%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636834261341290408&sdata=bGUgorqBIC%2FZ9UNX545v93AoKC7Rv1P0SOVwt85mN1Y%3D&reserved=0, or mute the threadhttps://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAWR85ewpA0liGzppCdZuCJiCvUGdIGrfks5vEffSgaJpZM4aBb0a&data=02%7C01%7C%7C50ceffebfa0f4c78e77808d67d62f741%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636834261341290408&sdata=zuO9FKsUhuxGmXLuO9HMkXCHNehaESSikR7b73c90nY%3D&reserved=0.

stale[bot] commented 5 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

jchambers-ln commented 5 years ago

This still needs to be resolved.