Jun 19 2023 19:15:59 |
Dexter Merquita (bc) |
Time Spent: 1h 15m Design |
RESEARCH
Was able to quickly generate an RST table by copy-pasting a csv file and feeding into our jobjar
QA Note
Convert xlsx file into CSV
Open the file in notepad++
Select entire file and indent once
Copy the entire file (and keep in the clipboard)
In the jobjar, use 'csv-table' directive and use ":delim: ,"
.. csv-table::
:widths: 1,1,1,1,1,1,1,1,1,1,1
:delim: ,
:header-rows: 1
File (data excerpt) was taken from JJ#466888
merchant_id |
merch_name |
outlet_id |
store_name |
training |
host_mode |
verified_offline |
olo_site |
hma |
twin_setup |
cloud_print |
3136 |
Milestones |
3197 |
MIL #5204 - Victoria BC |
f |
f |
f |
f |
f |
t |
f |
3136 |
Milestones |
3196 |
MIL #5207 - Park Royal BC |
f |
f |
f |
f |
f |
t |
f |
3136 |
Milestones |
3208 |
MIL #5208 - Langley BC |
f |
f |
f |
f |
f |
t |
f |
3136 |
Milestones |
3205 |
MIL #5213 - Coquitlam BC |
f |
f |
f |
f |
f |
t |
f |
3136 |
Milestones |
3216 |
MIL #5217 - Dixon Road - Etobicoke ON |
f |
f |
f |
f |
f |
t |
f |
3136 |
Milestones |
3221 |
MIL #5218 - Mississauga West - Mississauga ON |
f |
f |
f |
f |
f |
t |
f |
DESIGN CONCEPT
- We create a new section under "Summary Note" that will allow user to create a table within jobjar using various data input methods (see below).
- Provide basic UI controls for adding table/rows and columns right from within this new section.
- User clicks "Preview Table" and then "Confirm" to build the table as a jobjar note
- User clicks the regular "Update Job" or "Preview" buttons, as need be.
Data input methods
method 1: file upload - Upload a xlsx or csv file. Then, we identify and count the number of headers. We use this data to build the table structure using RST or whatever engine we want to use for rendering content.
method 2: editor view - this is the main feature for defining table dimension, adding content
method 3: default view -- our regular JobJar note data entry window
|