CSV file data
Joetooker95 opened this issue · 6 comments
Joetooker95 commented
Can we modify what data is pulled through to the export file and can each bit of data be modified to display in a particular order without having to do much modifying once the file opens? So that the data can easily be interpreted? If so i am happy to draw up a draft of what i think it should look like.
duckbytes commented
offline_COORDINATOR_Wed Feb 22 2023 00 26 29 GMT+0000_to_Sat Feb 25 2023 00 26 29 GMT+0000.csv
This is an example of what the output looks like at the moment (except createdAt will also be populated on live).
Let me know if there's anything you'd like adjusted.
Joetooker95 commented
Hi Theo,
I downloaded the last 2 weeks worth of data last night into an excel spreadsheet and i have pruned out unnecessary information and reordered the columns in a way that now reads exactly how we are going to want to see them, if we do not do this before hand then it is going to make the job stats officers job very laborious. It will also make it difficult for him to see if he is missing data.
Please let me know what you think to this layout and if it is possible? I have attached the spreadsheet.
Kind Regards
Joe Tooker
… On 25 Feb 2023, at 00:28, Theo ***@***.***> wrote:
offline_COORDINATOR_Wed Feb 22 2023 00 26 29 GMT+0000_to_Sat Feb 25 2023 00 26 29 GMT+0000.csv
This is an example of what the output looks like at the moment (except createdAt will also be populated on live).
Let me know if there's anything you'd like adjusted.
—
Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you authored the thread.
RezTy-BBW commented
Have you thought about using a Google sheets Query for the time being to
get the information set up in the format you need? The Ideal solution
would be that its sorted at source, but there is a query as an option in
the interim?
*Regards*
*Tyron*
*Technical Analyst*
*Blood Bikes Wales*
*07535651292*
*www.bloodbikes.wales*
…On Sat, 25 Feb 2023 at 07:19, Joe Tooker ***@***.***> wrote:
Hi Theo,
I downloaded the last 2 weeks worth of data last night into an excel
spreadsheet and i have pruned out unnecessary information and reordered the
columns in a way that now reads exactly how we are going to want to see
them, if we do not do this before hand then it is going to make the job
stats officers job very laborious. It will also make it difficult for him
to see if he is missing data.
Please let me know what you think to this layout and if it is possible? I
have attached the spreadsheet.
Kind Regards
Joe Tooker
> On 25 Feb 2023, at 00:28, Theo ***@***.***> wrote:
>
>
> offline_COORDINATOR_Wed Feb 22 2023 00 26 29 GMT+0000_to_Sat Feb 25 2023
00 26 29 GMT+0000.csv
>
> This is an example of what the output looks like at the moment (except
createdAt will also be populated on live).
>
> Let me know if there's anything you'd like adjusted.
>
> —
> Reply to this email directly, view it on GitHub, or unsubscribe.
> You are receiving this because you authored the thread.
—
Reply to this email directly, view it on GitHub
<#133 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AQASZJDHEHW2H2WVJCHZJS3WZGXBJANCNFSM6AAAAAAVHOFI6E>
.
You are receiving this because you are subscribed to this thread.Message
ID: ***@***.***>
--
100% Volunteers, £0 Charge
*
*
*DISCLAIMER
We welcome
correspondence in Welsh and English, and we will ensure that we communicate
with you in the language of your choice, whether that’s English, Welsh or
both if you let us know which you prefer.
E-mails to and from Blood Bikes
Wales are scanned by automated security systems. This message was scanned
for viruses before transmission, but you should also satisfy yourself that
the message, and all attachments, are virus-free before use. We can accept
no responsibility for any loss or damage that might arise from opening the
message or any attachments. This message and any files transmitted with it
may contain confidential information intended only for the recipient. If
you receive the message by mistake please inform us and delete it. The
views expressed in this message are the personal views of the author and
may not necessarily represent those of Blood Bikes Wales. We accept no
liability for any errors, corruption or omissions that might arise in
transmission of this message.*
*Blood Bikes Wales is registered with the
UK Charity Commission, charity number 1143352.*
* *
*YMWADIAD
Rydym yn
croesawu gohebiaeth yn Gymraeg a Saesneg, ac yn sicrhau y byddwn yn
cyfathrebu â chi yn eich iaith ddewisol, boed yn Gymraeg, Saesneg neu’r
ddwy, dim ond i chi ein hysbysu.
Mae pob neges e-bost a anfonir at neu gan
Beiciau Gwaed Cymru yn cael ei sganio gan systemau diogelwch awtomatig.
Sganiwyd y neges hon am firysau cyn ei hanfon, ond dylech hefyd wirio bod y
neges, a phob atodiad ynddi, yn rhydd o firysau cyn ei defnyddio. Nid ydym
yn derbyn cyfrifoldeb am unrhyw golled neu ddifrod o ganlyniad i agor y
neges neu unrhyw atodiadau. Gall y neges hon ac unrhyw ffeiliau a atodir
ynddi gynnwys gwybodaeth gyfrinachol a fwriadwyd ar gyfer y derbynnydd yn
unig. Os ydych chi wedi derbyn y neges trwy gamgymeriad, hysbyswch ni a
dileu’r neges. Safbwyntiau personol yr awdur a fynegir yn y neges hon, ac
nid ydynt o reidrwydd yn cynrychioli safbwyntiau Beiciau Gwaed Cymru. Nid
ydym yn derbyn cyfrifoldeb am unrhyw wallau, llygredd neu esgeulustod a
allai godi wrth drosglwyddo'r neges hon.**Mae Beiciau Gwaed Cymru wedi
cofrestru gyda’r Comisiwn Elusen y Ddeyrnas Unedig, rhif elusen 1143352. *
duckbytes commented
I can't see your attachment @Joetooker95 . I think GitHub strips attachments from comments written by email. You'll need to attach it using the GitHub webpage.
If you can get back to me with a description of exactly what stats Bill needs, it might be better for me to implement some function that gathers them straight from the database. Then he won't need to do anything except log in and look them up when he needs to.
RezTy-BBW commented
If you build the database to download in the Freewheelers format, would
that then become the standard for other blood bike charities?
Regards
Ty Stevenson
Technical Analyst
Blood Bikes Wales
Tel :- 07535651292
…On Sat, 25 Feb 2023, 08:53 Theo, ***@***.***> wrote:
I can't see your attachment @Joetooker95 <https://github.com/Joetooker95>
. I think GitHub strips attachments from comments written by email. You'll
need to attach it using the GitHub webpage.
If you can get back to me with a description of exactly what stats Bill
needs, it might be better for me to implement some function that gathers
them straight from the database. Then he won't need to do anything except
log in and look them up when he needs to.
—
Reply to this email directly, view it on GitHub
<#133 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AQASZJFLXGERSS2EEACZ5RLWZHCAHANCNFSM6AAAAAAVHOFI6E>
.
You are receiving this because you commented.Message ID:
***@***.***>
--
100% Volunteers, £0 Charge
*
*
*DISCLAIMER
We welcome
correspondence in Welsh and English, and we will ensure that we communicate
with you in the language of your choice, whether that’s English, Welsh or
both if you let us know which you prefer.
E-mails to and from Blood Bikes
Wales are scanned by automated security systems. This message was scanned
for viruses before transmission, but you should also satisfy yourself that
the message, and all attachments, are virus-free before use. We can accept
no responsibility for any loss or damage that might arise from opening the
message or any attachments. This message and any files transmitted with it
may contain confidential information intended only for the recipient. If
you receive the message by mistake please inform us and delete it. The
views expressed in this message are the personal views of the author and
may not necessarily represent those of Blood Bikes Wales. We accept no
liability for any errors, corruption or omissions that might arise in
transmission of this message.*
*Blood Bikes Wales is registered with the
UK Charity Commission, charity number 1143352.*
* *
*YMWADIAD
Rydym yn
croesawu gohebiaeth yn Gymraeg a Saesneg, ac yn sicrhau y byddwn yn
cyfathrebu â chi yn eich iaith ddewisol, boed yn Gymraeg, Saesneg neu’r
ddwy, dim ond i chi ein hysbysu.
Mae pob neges e-bost a anfonir at neu gan
Beiciau Gwaed Cymru yn cael ei sganio gan systemau diogelwch awtomatig.
Sganiwyd y neges hon am firysau cyn ei hanfon, ond dylech hefyd wirio bod y
neges, a phob atodiad ynddi, yn rhydd o firysau cyn ei defnyddio. Nid ydym
yn derbyn cyfrifoldeb am unrhyw golled neu ddifrod o ganlyniad i agor y
neges neu unrhyw atodiadau. Gall y neges hon ac unrhyw ffeiliau a atodir
ynddi gynnwys gwybodaeth gyfrinachol a fwriadwyd ar gyfer y derbynnydd yn
unig. Os ydych chi wedi derbyn y neges trwy gamgymeriad, hysbyswch ni a
dileu’r neges. Safbwyntiau personol yr awdur a fynegir yn y neges hon, ac
nid ydynt o reidrwydd yn cynrychioli safbwyntiau Beiciau Gwaed Cymru. Nid
ydym yn derbyn cyfrifoldeb am unrhyw wallau, llygredd neu esgeulustod a
allai godi wrth drosglwyddo'r neges hon.**Mae Beiciau Gwaed Cymru wedi
cofrestru gyda’r Comisiwn Elusen y Ddeyrnas Unedig, rhif elusen 1143352. *
duckbytes commented
We can see if it suits them, and maybe add some extra controls if they need anything different.