GivePanel data import for Blender Preamble This process is how to export data from GivePanel and import it into Blender. GivePanel is a fundraising platform for Facebook and allows us to reach a larger community. We need to export this data once a month at the end of every month to ensure the data is up to date. Blender allows us to process the data without inputting the data manually. Requirements Access to GivePanel Access and understanding of processing loads in blender Access to the blender auto folder in the server Steps Go to GivePanel (ensuring you have a login and correct access to perform the following). Click on "Account Settings" under the drop-down in the top right where the user icon is: Click the small drop-down under edit for ctq_fundraisers_allFields_for_DUK This is how you export the reports to be downloaded. The email bar at the bottom is to ensure you get an email notification when it is ready to be downloaded.MAKE SURE the date range is current for you, if it becomes historical end it at a date in the future. The report will be made available if you scroll down with to the bottom where old reports are. Click export report- an email will be sent when it is ready to download on this page. It will download with a very long and complicated name as below. Rename is as follows: GP_upto_DDMMYYYY.csv Go to this file location in another file explorer (you will need to copy the file to a location here):\\gs1dukfilv01\shared$\CIS_Support\Development_Tasks\DevOps-271 Give Panel Facebook Data-in Copy your renamed file into GP_datafilesOpen the z_GP_Cleanup_preimport.ps1 file WITH Visual Studio Code When you open it you may see the same 'restricted mode' alert, click trust and then exit that tab back to the code tab. The ONLY thing you change is where it says 'afile'You will replace it with the name of the file you copied into GP_datafiles (hence why we renamed it)When done a small play button will appear in the top right in the same row as the three dots. That is to execute the job- click it. It will created the highlighted file below which is ready for import- as in the name. Go to this file location in a new file explorer\\blender.diabetes.org.uk\AUTO\Facebook Give Panel Paste in the file and it should disappear- this is the blender load where is picks up files. In blender go to:Manage>Chinh Quan>[TEST] Give PanelThe file should have been imported into here. Process as usual DONE