Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upload binary version of Mintos XLSX into database #1

Open
mark-stopka opened this issue Feb 15, 2020 · 0 comments
Open

Upload binary version of Mintos XLSX into database #1

mark-stopka opened this issue Feb 15, 2020 · 0 comments
Labels
enhancement New feature or request

Comments

@mark-stopka
Copy link
Contributor

mark-stopka commented Feb 15, 2020

Upload passed XLSX statement into database, in addition to XLSX blob, also store following information:

  • Statement ID
  • ID of account associated with the statement as foreign key
  • Upload date and time in UTC
  • SHA256 hash of the uploaded file
  • Total amount of transaction in the statement
  • Timestamp of first transaction in the statement
  • Timestamp of last transaction in the statement
  • State of processing as ENUM (new, processing, processed, processing failed)
  • Timestamp of processing start in UTC (can be NULL)
  • Timestamp of processing finish in UTC (can be NULL)
@mark-stopka mark-stopka added the enhancement New feature or request label Feb 15, 2020
@mark-stopka mark-stopka changed the title Import binary version of Mintos XLSX into database Upload binary version of Mintos XLSX into database Feb 16, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant