function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Abhishek Pal 33Abhishek Pal 33 

How to read data from folder in salesforce

I have a uploaded one csv file in folder called(New Data) in documents in salesforce. Now I want to read the contents of that csv file using apex code so that I can perform some logic and insert the data in salesforce standard object(user).

Anyone please help me in this.

Thanks in advance.
Best Answer chosen by Abhishek Pal 33
hitesh90hitesh90
Hello Abhishek,

This issue is because you have uploaded ".xlsx" file instead of ".csv" file in to your document.

Let me know if you have any question on this. Please mark this "Solved" if it helps.

Thank You,
Hitesh Patel
Email :- hiteshpatel.aspl@gmail.com
http://mrjavascript.blogspot.in/

All Answers

hitesh90hitesh90
Hello Abhishek,

Please check below piece of code for your requirement.

Apex Code: 
List<document> documentList = [select id, body from document where developername = 'Your_Document_Name'];
string strCsvBody = '';
string[] arrCsv;
for(document doc: documentList){
    strCsvBody = doc.body.toString();
    arrCsv = strCsvBody.split(',');
    for(String str: arrCsv){
        system.debug('CSV Data: ' + str);
        // Insert data here
    }
}

Let me know if you have any question on this. Please mark this best answer if it helps.

Thank You,
Hitesh Patel
Email :- hiteshpatel.aspl@gmail.com
http://mrjavascript.blogspot.in/
Abhishek Pal 33Abhishek Pal 33
Hi I have tried this code that you have mentioned above but it is giving me error.
"System.StringException: BLOB is not a valid UTF-8 string"
It is at line number 5 of above code i.e. strCsvBody = doc.body.toString();

Can you help?
Abhishek Pal 33Abhishek Pal 33
Hi Hitesh,

What is the role of blob here I have read so many posts related to blob but didnt understand how to use it?

As per my understandings it is not allowing to convert direcly(csv data into string) for the above error.

 
hitesh90hitesh90
Hello Abhishek,

This issue is because you have uploaded ".xlsx" file instead of ".csv" file in to your document.

Let me know if you have any question on this. Please mark this "Solved" if it helps.

Thank You,
Hitesh Patel
Email :- hiteshpatel.aspl@gmail.com
http://mrjavascript.blogspot.in/
This was selected as the best answer
Abhishek Pal 33Abhishek Pal 33
Hi Hitesh,

I have one more question cant we operate on excel instead of csv?

In csv I have columns which have some data , My requirement is to map those data to user object in salesforce.

I received data (22:57:38:009 USER_DEBUG [8]|DEBUG|CSV Data: QWxpYXMsQ29tbXVuaXR5Tmlja25hbWUsRW1haWwsRmlyc3ROYW1lLExhc3ROYW1lLFByb2ZpbGVJZCxVc2VybmFtZSxVc2VyUm9sZUlkLEVtYWlsRW5jb2RpbmdLZXksTGFuZ3VhZ2VMb2NhbGVLZXksTG9jYWxlU2lkS2V5LFRpbWVab25lU2lkS2V5DQpURERELFRlc3RpbmcsdGVzdGRhdGFoZXJzaGV5cy5jb21AZXhhbXBsZS5jb20sVGVzdCxEYXRhLDAwZUUwMDAwMDAwTkhBMElBTyx0ZXN0ZGF0YUBoZXJzaGV5cy5jb20ucGF0cm9zYngsLElTTy04ODU5LTEsZW5fVVMsZW5fVVMsQW1lcmljYS9OZXdfWW9yaw0K)

I guess its in encoded format. What is the way to proceed further?

If you suggest some documentation where something related to this is given then it would be more beneficial as it would clear my concept.

Thanks for all your help.
hitesh90hitesh90
Hello Abhishek,

If you try excel instead of csv in that case also there would be same situation to decode format.

See below link for Encode.
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_classes_restful_encodingUtil.htm

Thank You,
Hitesh Patel
Email :- hiteshpatel.aspl@gmail.com
http://mrjavascript.blogspot.in/
Abhishek Pal 33Abhishek Pal 33
Hi Hitesh,

I am stuck at one point where I am not able to put the data from csv into salesforce object.

Below is the code:

 arrCsv = strCsvBody.split('\n');
                arrCsv = strCsvBody.split(',');
                
                /* for(String str: arrCsv){
system.debug('CSV Data: ' + str);
} */
                for (Integer i=1;i<arrCsv.size();i++)
                {
                    String[] inputvalues = new String[]{};
                    inputvalues = arrCsv[i].split(',');
                    System.debug('input :'+inputvalues);
                    User test = new User();
                    test.Alias= inputvalues[0];
                    test.CommunityNickname=inputvalues[1];
                    userDetails.add(test);
                    System.debug('User details'+userDetails);
               
            }
        }

Now the data I am getting from debug is something like this i.e. first all header values then data of line 1 and so on.

Below image are the logs where yellow marked is header values and red marked are data. But last field(TimeZoneSidKey) is appending with the data.
User-added image


Please help in this. Thanks in advance.

 
Abhishek Pal 33Abhishek Pal 33
Hi Hitesh,

I am using .xlsx format file , I am trying to do the same procedure as above. Could you please help in this?

Code:

Document test=[select body from document where developerName='test'];
System.debug('Values :'+test);

String s= EncodingUtil.base64Encode(test.body);
System.debug('Blob value :'+s);

Result:12:29:29:009 USER_DEBUG [5]|DEBUG|Blob value :UEsDBBQABgAIAAAAIQBi7p1oXgEAAJAEAAATAAgCW0NvbnRlbnRfVHlwZXNdLnhtbCCiBAIooAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACslMtOwzAQRfdI/EPkLUrcskAINe2CxxIqUT7AxJPGqmNbnmlp/56J+xBCoRVqN7ESz9x7MvHNaLJubbaCiMa7UgyLgcjAVV4bNy/Fx+wlvxcZknJaWe+gFBtAMRlfX41mmwCYcbfDUjRE4UFKrBpoFRY+gOOd2sdWEd/GuQyqWqg5yNvB4E5W3hE4yqnTEOPRE9RqaSl7XvPjLUkEiyJ73BZ2XqVQIVhTKWJSuXL6l0u+cyi4M9VgYwLeMIaQvQ7dzt8Gu743Hk00GrKpivSqWsaQayu/fFx8er8ojov0UPq6NhVoXy1bnkCBIYLS2ABQa4u0Fq0ybs99xD8Vo0zL8MIg3fsl4RMcxN8bZLqej5BkThgibSzgpceeRE85NyqCfqfIybg4wE/tYxx8bqbRB+QERfj/FPYR6brzwEIQycAhJH2H7eDI6Tt77NDlW4Pu8ZbpfzL+BgAA//8DAFBLAwQUAAYACAAAACEAtVUwI/QAAABMAgAACwAIAl9yZWxzLy5yZWxzIKIEAiigAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKySTU/DMAyG70j8h8j31d2QEEJLd0FIuyFUfoBJ3A+1jaMkG92/JxwQVBqDA0d/vX78ytvdPI3qyCH24jSsixIUOyO2d62Gl/pxdQcqJnKWRnGs4cQRdtX11faZR0p5KHa9jyqruKihS8nfI0bT8USxEM8uVxoJE6UchhY9mYFaxk1Z3mL4rgHVQlPtrYawtzeg6pPPm3/XlqbpDT+IOUzs0pkVyHNiZ9mufMhsIfX5GlVTaDlpsGKecjoieV9kbMDzRJu/E/18LU6cyFIiNBL4Ms9HxyWg9X9atDTxy515xDcJw6vI8MmCix+o3gEAAP//AwBQSwMEFAAGAAgAAAAhAIE+lJfzAAAAugIAABoACAF4bC9fcmVscy93b3JrYm9vay54bWwucmVscyCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKxSTUvEMBC9C/6HMHebdhUR2XQvIuxV6w8IybQp2yYhM3703xsqul1Y1ksvA2+Gee/Nx3b3NQ7iAxP1wSuoihIEehNs7zsFb83zzQMIYu2tHoJHBRMS7Orrq+0LDppzE7k+ksgsnhQ45vgoJRmHo6YiRPS50oY0as4wdTJqc9Adyk1Z3su05ID6hFPsrYK0t7cgmilm5f+5Q9v2Bp+CeR/R8xkJSTwNeQDR6NQhK/jBRfYI8rz8Zk15zmvBo/oM5RyrSx6qNT18hnQgh8hHH38pknPlopm7Ve/hdEL7yim/2/Isy/TvZuTJx9XfAAAA//8DAFBLAwQUAAYACAAAACEA4OgZ8jcCAACRBAAADwAAAHhsL3dvcmtib29rLnhtbKxUTY/TMBC9I/EfLN/bfDTZtlGT1W63iEpotVr241IJTR2nserYwXZoK8R/Z5IQWOhlEVzisT15nvfe2IvLYyXJF26s0CqlwdinhCumc6F2KX18eDeaUWIdqBykVjylJ27pZfb2zeKgzX6r9Z4ggLIpLZ2rE8+zrOQV2LGuucKdQpsKHE7NzrO14ZDbknNXSS/0/QuvAqFoj5CY12DoohCM32jWVFy5HsRwCQ7Lt6Wo7YBWsdfAVWD2TT1iuqoRYiukcKcOlJKKJeud0ga2Emkfg3hAxvAMuhLMaKsLN0Yory/yjG/ge0HQU84WhZD8qZedQF3fQtWeIimRYN0qF47nKb3AqT7w3xZMU183QuJuEEWhT73spxV3huS8gEa6BzRhgMfEeBKGYZuJpK6k40aB40utHGr4Q/1/1avDXpYa3SH3/HMjDMemaGXLFvgFlsDW3oErSWNkSpfJ5tEi/Q1sS4Etsf9Ug/TDzeCs3byQG869/AvBgbXMPaTel9fHf8qQLdpmfhL8YH8J2k7J8VmoXB9Silfj9CI+dMvPIndlSkM/muN+v/aei13pUjqdxnF39gvorv3xiG4kqrP9Y3slArxn7bhunaXEJAIDs86DDmH4jYFkaHM7dIlxGAddBj+6D9ZlCxxRYZHSr0HkX039eTTyV5N4FM3m4WgWTcLRMroJV/F0dbO6jr/936ZGo5PhXWirLMG4BwNsj6/JPS+uwWKT94SwTjRiqNob/sq+AwAA//8DAFBLAwQUAAYACAAAACEAMEF1KhYBAAAVAgAAFAAAAHhsL3NoYXJlZFN0cmluZ3MueG1sbJHdSgMxEIXvBd8h5Eov3KxVRMru1uLaqyoi6wMM2bEJ5mfNTIt9e1MEC6m5y3fOSU4yzeLbO7HDRDaGVl5XtRQYdBxt2LTyfVhd3UtBDGEEFwO2co8kF935WUPEImcDtdIwT3OlSBv0QFWcMGTlIyYPnLdpo2hKCCMZRPZOzer6TnmwQQodt4HzvbdSbIP92uLjH+gasl3D3dJZoEZx16gD+IVPOe5KuLKJ+AU8lsIa/uWH/nOaQOd35YKEaYeye+sHUR7wCgkDiyyVynKanNXA+fsuhpi0Uc/A2hBb/Xl5UtDBpmR9XiVjJB6BoX8weTIG91Tp6EvXkF0n0f4QK531TT2brUt6LHpUVB5r9wMAAP//AwBQSwMEFAAGAAgAAAAhALC02zTXAAAASAEAACMAAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0MS54bWwucmVsc4TQvWoDMQwA4D3QdzDae750KCWcLxnSQoYuJX0AYevOJrZ12GrJvX29FBooZBSSPv0M+2uK6ptKDZwNbLseFGXLLuTZwOf57fEFVBXMDiNnMrBShf34sBk+KKK0purDUlVTcjXgRZad1tV6Slg7Xii3zMQlobSwzHpBe8GZ9FPfP+vy14DxxlQnZ6Cc3BbUeV3a5Ps2T1OwdGT7lSjLPyO0b1KJIV8aimUmMZAwROGdUBWHgseDb8/wtNbOcvote2fXNni9CpWMEfQ46Jv7xx8AAAD//wMAUEsDBBQABgAIAAAAIQCLgm5YkwYAAI4aAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbOxZz4sbNxS+F/o/DHN3/GtmbC/xBntsZ9vsJiHrpOSotWWPspqRGcm7MSFQkmOhUJqWXgq99VDaBhLoJf1rtk1pU8i/0CfN2COt5W6abiAtWcMyo/n09Om9N9+TNBcv3Y2pc4RTTljSdqsXKq6DkxEbk2Tadm8OB6Wm63CBkjGiLMFtd4G5e2n7/fcuoi0R4Rg70D/hW6jtRkLMtsplPoJmxC+wGU7g2YSlMRJwm07L4xQdg92YlmuVSlCOEUlcJ0ExmL02mZARdobSpLu9NN6ncJsILhtGNN2XprHRQ2HHh1WJ4Ase0tQ5QrTtwjhjdjzEd4XrUMQFPGi7FfXnlrcvltFW3omKDX21fgP1l/fLO4wPa2rMdHqwGtTzfC/orOwrABXruH6jH/SDlT0FQKMRzDTjotv0u61uz8+xGii7tNjuNXr1qoHX7NfXOHd8+TPwCpTZ99bwg0EIXjTwCpThfYtPGrXQM/AKlOGDNXyj0ul5DQOvQBElyeEauuIH9XA52xVkwuiOFd7yvUGjlhsvUJANq+ySQ0xYIjblWozusHQAAAmkSJDEEYsZnqARZHGIKDlIibNLphEk3gwljENzpVYZVOrwX/48daU8grYw0npLXsCErzVJPg4fpWQm2u6HYNXVIC+fff/y2RPn5bPHJw+enjz46eThw5MHP2a2jI47KJnqHV98+9mfX3/s/PHkmxePvrDjuY7/9YdPfvn5czsQJlt44fmXj397+vj5V5/+/t0jC7yTogMdPiQx5s5VfOzcYDHMTXnBZI4P0n/WYxghYvRAEdi2mO6LyABeXSBqw3Wx6bxbKQiMDXh5fsfguh+lc0EsI1+JYgO4xxjtstTqgCtyLM3Dw3kytQ+eznXcDYSObGOHKDFC25/PQFmJzWQYYYPmdYoSgaY4wcKRz9ghxpbZ3SbE8OseGaWMs4lwbhOni4jVJUNyYCRS0WmHxBCXhY0ghNrwzd4tp8uobdY9fGQi4YVA1EJ+iKnhxstoLlBsMzlEMdUdvotEZCO5v0hHOq7PBUR6iilz+mPMua3PtRTmqwX9CoiLPex7dBGbyFSQQ5vNXcSYjuyxwzBC8czKmSSRjv2AH0KKIuc6Ezb4HjPfEHkPcUDJxnDfItgI99lCcBN0VadUJIh8Mk8tsbyMmfk+LugEYaUyIPuGmsckOVPaT4m6/07Us6p0WtQ7KbG+WjunpHwT7j8o4D00T65jeGfWC9g7/X6n3+7/Xr83vcvnr9qFUIOGF6t1tXaPNy7dJ4TSfbGgeJer1TuH8jQeQKPaVqi95WorN4vgMt8oGLhpilQfJ2XiIyKi/QjNYIlfVRvRKc9NT7kzYxxW/qpZbYnxKdtq/zCP99g427FWq3J3mokHR6Jor/irdthtiAwdNIpd2Mq82tdO1W55SUD2/ScktMFMEnULicayEaLwdyTUzM6FRcvCoinNL0O1jOLKFUBtFRVYPzmw6mq7vpedBMCmClE8lnHKDgWW0ZXBOddIb3Im1TMAFhPLDCgi3ZJcN05Pzi5LtVeItEFCSzeThJaGERrjPDv1o5PzjHWrCKlBT7pi+TYUNBrNNxFrKSKntIEmulLQxDluu0Hdh9OxEZq13Qns/OEynkHucLnuRXQKx2cjkWYv/Osoyyzlood4lDlciU6mBjEROHUoiduunP4qG2iiNERxq9ZAEN5aci2QlbeNHATdDDKeTPBI6GHXWqSns1tQ+EwrrE9V99cHy55sDuHej8bHzgGdpzcQpJjfqEoHjgmHA6Bq5s0xgRPNlZAV+XeqMOWyqx8pqhzK2hGdRSivKLqYZ3Alois66m7lA+0unzM4dN2FB1NZYP911T27VEvPaaJZ1ExDVWTVtIvpmyvyGquiiBqsMulW2wZeaF1rqXWQqNYqcUbVfYWCoFErBjOoScbrMiw1O281qZ3jgkDzRLDBb6saYfXE61Z+6Hc6a2WBWK4rVeKrTx/61wl2cAfEowfnwHMquAolfHtIESz6spPkTDbgFbkr8jUiXDnzlLTdexW/44U1PyxVmn6/5NW9Sqnpd+qlju/Xq32/Wul1a/ehsIgorvrZZ5cBnEfRRf7xRbWvfYCJl0duF0YsLjP1gaWsiKsPMNXa5g8wDgHRuRfUBq16qxuUWvXOoOT1us1SKwy6pV4QNnqDXug3W4P7rnOkwF6nHnpBv1kKqmFY8oKKpN9slRperdbxGp1m3+vcz5cxMPNMPnJfgHsVr+2/AAAA//8DAFBLAwQUAAYACAAAACEAc1sI9ecCAAAgBwAADQAAAHhsL3N0eWxlcy54bWykVVtvmzAUfp+0/4D8Tg00ZEkEVE1TtEpdVSmdtFcHTGLVF2RMl2zaf9+xgYauWzctL4nP8bl837mY5GIvuPdEdcOUTFF4FiCPykKVTG5T9Pkh92fIawyRJeFK0hQdaIMusvfvksYcOF3vKDUehJBNinbG1AuMm2JHBWnOVE0l3FRKC2JA1Fvc1JqSsrFOguMoCKZYECZRF2Ehin8JIoh+bGu/UKImhm0YZ+bgYiFPFIubrVSabDhA3YcTUgyxnfAqvGCFVo2qzBmEw6qqWEFfo5zjOYZIWVIpaRqvUK00KYogtM2weJTqq8ztFRSwt8qS5pv3RDhoQoSzpFBcac9AZQCY00giaGdxRTjbaGbNKiIYP3TqyCpcMXs7wYCaVWKLo0OTJa21eiNXYD1OT+ZyNpCUcT4qQafIEmiFoVrmcOv154dDDVwlTE2HGa7+ar3V5BBG8cgBu4RZslG6hCkdim/r3KmyhNPKAEfNtjv7b1QNvxtlDLQ0S0pGtkoSbus2ePQHoFNQztd2kr9UL1jtK0+2IhfmpkwR7ISt+HAEIv2xi9cJEP9PTiH4/97JI3XND3et2FCdu0Vx2ZzW1vIoLR3/o3zJ2VYKagcR4DmHe60MLYxbZNd1PGbXcT2ZprevTuHbebsFcOgAz6gJL1rwDN6z05uijzBPmjP5CHvnMEBZNy3jhkmLaObWbGhn73Nna8oHByjUyOGXEgGOcn8cAndr7EPixuMZGcQoaUVabh6eL1N0PH+iJWsFvA291T17UsaFSNHxfGtnNZxayHRvbhvYZvj3Ws1S9P16+WG+us4jfxYsZ/7knMb+PF6u/HhytVyt8nkQBVc/Ru/aCa+ae31hcMPJouHw9umebA9+fdSlaCR08N2WAuwx9nk0DS7jMPDz8yD0J1My82fT89jP4zBaTSfL6ziPR9jj/8MeBjgMu0+HBR8vDBMURmPo1dChsRaaBOIbJPDQCXz8tGU/AQAA//8DAFBLAwQUAAYACAAAACEAAR/4YC8CAAAUBQAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbJRUTXObMBC9d6b/gdE9fDmOYwbIJHYc+5CZTr/uslhAYwlRSbbjf98Fagqkh/Qm8Xbf7r59In54k8I5gTZcVQkJXJ84UDGV8apIyI/vm5t74hhLq4wKVUFCLmDIQ/r5U3xW+mBKAOsgQ2USUlpbR55nWAmSGlfVUCGSKy2pxasuPFNroFmbJIUX+v6dJymvSMcQ6Y9wqDznDNaKHSVUtiPRIKjF/k3Ja3Nlk+wjdJLqw7G+YUrWSLHngttLS0ocyaJdUSlN9wLnfgtuKbtyt5d39JIzrYzKrYt0Xtfo+5mX3tJDpjTOOE7QyO5oyBPyGETbkHhp3Orzk8PZDM6OpftvIIBZyHBNxGnk3yt1aAJ3+MlHRtMGNIyUWX6CFQiRkFWAOzW/2iLNGUt4fY3h+Vpv067si3YyyOlR2K/qvAVelBYLz1GCRokou6zBMFwBlnbDed/4mlqaxlqdHVwn9mlq2pgjiNBH/85MY9bEPmIwkhmc45T6sXfC1tgf7GmIBWNsNcTCMbYeYrMx9jzEbsfYZojNx9jLELsbY9shtugxD+XoNQn/RxMM7jW5n2jSELUS9xHLiTLD7GAi6XoETjR9HoETUTdhu6KZH4YTzpdR2l+9u/k703X+KC81aMGrA3quP3fv4AlJdMTR0nqXBa1bh9E1LeCV6oJXxhGQt/ZbYEbnT9/Fs1V1Y8oFenWvrFXyeivx7wNoNd+dESdXyl4vzZPo/2fpbwAAAP//AwBQSwMEFAAGAAgAAAAhAPRCZ8iQAQAAGAMAABAACAFkb2NQcm9wcy9hcHAueG1sIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAnJJNb9swDIbvA/ofDN0bOd0HhkBWMaQdOqDDAiRtz6pMx0JlyRBZI+6vH20jqbPttBs/Xrx6SFFdHxqfdZDQxVCI5SIXGQQbSxf2hXjYfb/8KjIkE0rjY4BC9IDiWl98UJsUW0jkADO2CFiImqhdSYm2hsbggtuBO1VMjSFO017GqnIWbqJ9bSCQvMrzLxIOBKGE8rI9GYrJcdXR/5qW0Q58+LjrWwbW6lvbemcN8ZT6p7MpYqwouz1Y8ErOm4rptmBfk6Ne50rOU7W1xsOajXVlPIKS7wV1B2ZY2sa4hFp1tOrAUkwZujde25XIng3CgFOIziRnAjHWIJuSMfYtUtJPMb1gDUCoJAum4hjOtfPYfdLLUcDBuXAwmEC4cY64c+QBf1Ubk+gfxMs58cgw8U4424FvenPON47ML/3hvY5Na0Kvf4QqYs9jHQvq3oUXfGh38cYQHLd6XlTb2iQo+SNOWz8V1B0vNPnBZF2bsIfyqPm7MdzA43Toevl5kX/M+XtnNSXfT1r/BgAA//8DAFBLAwQUAAYACAAAACEAkRpz80UBAABtAgAAEQAIAWRvY1Byb3BzL2NvcmUueG1sIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlJJfT8MgFMXfTfwODe8tdM2mNm0X/2RPLlniFo1vCHcrWaEE0G7fXtputWa++Ajn3B/n3JDND7IKvsBYUascxRFBAShWc6F2OdqsF+EtCqyjitOqVpCjI1g0L66vMqZTVhtYmVqDcQJs4EnKpkznqHROpxhbVoKkNvIO5cVtbSR1/mh2WFO2pzvAE0JmWIKjnDqKW2CoByI6ITkbkPrTVB2AMwwVSFDO4jiK8Y/XgZH2z4FOGTmlcEftO53ijtmc9eLgPlgxGJumiZqki+Hzx/ht+fzSVQ2FanfFABUZZykzQF1tivuPUtgS9sGKVmSS4ZHUrrGi1i39xrcC+MPxwn3p8OyuSv8A8MCHS/sqZ+U1eXxaL1AxIfEsJDchma7JNJ3epYS8twF+zbdh+wt5ivEfYpKMiGdAkeGLD1J8AwAA//8DAFBLAQItABQABgAIAAAAIQBi7p1oXgEAAJAEAAATAAAAAAAAAAAAAAAAAAAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhALVVMCP0AAAATAIAAAsAAAAAAAAAAAAAAAAAlwMAAF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhAIE+lJfzAAAAugIAABoAAAAAAAAAAAAAAAAAvAYAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAODoGfI3AgAAkQQAAA8AAAAAAAAAAAAAAAAA7wgAAHhsL3dvcmtib29rLnhtbFBLAQItABQABgAIAAAAIQAwQXUqFgEAABUCAAAUAAAAAAAAAAAAAAAAAFMLAAB4bC9zaGFyZWRTdHJpbmdzLnhtbFBLAQItABQABgAIAAAAIQCwtNs01wAAAEgBAAAjAAAAAAAAAAAAAAAAAJsMAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0MS54bWwucmVsc1BLAQItABQABgAIAAAAIQCLgm5YkwYAAI4aAAATAAAAAAAAAAAAAAAAALMNAAB4bC90aGVtZS90aGVtZTEueG1sUEsBAi0AFAAGAAgAAAAhAHNbCPXnAgAAIAcAAA0AAAAAAAAAAAAAAAAAdxQAAHhsL3N0eWxlcy54bWxQSwECLQAUAAYACAAAACEAAR/4YC8CAAAUBQAAGAAAAAAAAAAAAAAAAACJFwAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAi0AFAAGAAgAAAAhAPRCZ8iQAQAAGAMAABAAAAAAAAAAAAAAAAAA7hkAAGRvY1Byb3BzL2FwcC54bWxQSwECLQAUAAYACAAAACEAkRpz80UBAABtAgAAEQAAAAAAAAAAAAAAAAC0HAAAZG9jUHJvcHMvY29yZS54bWxQSwUGAAAAAAsACwDRAgAAMB8AAAAA


Couldnt understand how to decode this?