finos / finos/tracdap

Model output schemas with £ signs have incorrect encoding

Open
#355 0 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Java
Stars
55
Forks
18
Avg merge
6h 29m
Merged PRs (30d)
16

Description

## Bug Report

### Steps to Reproduce:
1. create a model that uses the csv schema importer to set the out dataset's schema
2. in the format_code entry of the schema set it as ",|.|0|£||1" for any float or integer field (this is interpreted as an amount in GBP by the UI)
3. run the model via the TRAC UI
4. get the output dataset via the TRAC API.

### Expected Result:
The schema will be returned via the API as defined in the CSV

### Actual Result:
The schema is returned with the wrong encoding to the £ sign. e.g. £

### Environment:
TRAC UI : 0.5.24",
local TRAC sandbox TRAC: 0.5.24

Defined output schema:

![image](https://user-images.githubusercontent.com/80156020/226357351-011c02e5-1602-4492-a3c3-c49ea5d1a041.png)

Formatted table using schema from API:

![image](https://user-images.githubusercontent.com/80156020/226357628-56aa5d76-25c0-4992-b7b6-84e0960d4f09.png)

Contributor guide

Open the contributing guide

Research direction

Start with the CSV schema importer and follow the output dataset schema through the TRAC UI execution path to the TRAC API response. Reproduce the issue using the format_code value ",|.|0|£||1" for a numeric field, then compare the API schema with the CSV definition. Done means the £ sign is returned with the correct encoding.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
api, data
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.