search

rejkpp / fxs

0 stars 0 forks source link

improve data entry workflow to make use of database or csv file #3

Open rejkpp opened 2 years ago

rejkpp commented 2 years ago

current workflow:

get rates from tg bot or just from source websites. manual entry into spreadsheet. then convert table from spreadsheet into markdown table. add table to new markdown file.

this is not efficient. plus point is that data gets stored into spreadsheet right away. but from spreadsheet to website could be automated.

a more efficient way is to enter data straight into markdown file which already has the table formatting. downside is that the data doesn't get collected in spreadsheet right away.

rejkpp commented 2 years ago

idea for solution:

use data folder built into hugo.

  1. have the manual data entry be done into data file spreadsheet.
  2. have hugo read the data and automatically publish in a new posts/page.
rejkpp commented 2 years ago

note: keep in mind to have data for each bank/exchange to be entered into a seperate file. this way, if banks/exchanges get access to enter their rates, they will not be able to edit for others.

rejkpp commented 2 years ago

for 2 months workflow was:

  1. run tg-bot
  2. copy new md file for new day
  3. edit date and rates
rejkpp commented 2 years ago

changed workflow. started using json data files.

cambios are added. each bank/cambio has own json file.

workflow:

  1. check rates (tg/website, fb)
  2. copy new entry in json file
  3. edit date and rates