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

Rich output formatting #3

Open
sfhkaplan opened this issue Aug 13, 2014 · 1 comment
Open

Rich output formatting #3

sfhkaplan opened this issue Aug 13, 2014 · 1 comment

Comments

@sfhkaplan
Copy link
Member

The current output is a text table of paired student/preceptor names. While this information is critical, the user may want more information about the matching, as well as multiple views of the data.

First, the output should be in CSV format, since we want the results to be importable to a spreadsheet.

Second, the output should contain not just names. Rather, there should be the following fields:

  1. Student name
  2. Preceptor name
  3. Preceptor location
  4. Practice type
  5. Day of the week

The program should also create multiple sheets, each ordered by one of these fields. This multiple-view, reordered output should be generated by a script that simply uses awk, sort, etc. Or perhaps Python would be especially good at this task.

@sfhkaplan
Copy link
Member Author

A preliminary version of this has been implemented. Output type is now a command-line choice, and in addition to a cleaned-up human-readable format, there is a CSV, comma-delimited output type.

Currently, it is simply emitted and sorted by student last-name. However, that's not all that was requested. We should emit the output in a semicolon-delimited form so that awk can more easily parse the fields. Then, we need a script that parses, resorts, and re-emits with a separate CSV, sorted by a different field.

However, an alternative -- likely a better approach for producing a final product that end-users want -- is to emit one CSV, import it into a template spreadsheet, and to program the spreadsheet to generate the many-sorted views. Yeah, that's the ticket. Working on it. That said, producing both approaches would not be difficult.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant