CSV file data

[Joetooker95]

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]

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]

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]

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 https://github.com/platelet-app/platelet/issues/133#issuecomment-1445019300, 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]

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]

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 https://github.com/platelet-app/platelet/issues/133#issuecomment-1445033468, 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]

We can see if it suits them, and maybe add some extra controls if they need anything different.