New on BenMap, Struggling to validate the excel files for the self pace exercises


(Kaukurauee Ismael Kangueehi) #1

Hello guys, Thank you for making BenMap free available, it is very useful.
I am however currently struggling to validate the excel files for PM2.5 for South africa and China. BenMap is not accepting this files, there are errors, I have been trying to fix this errors with no success so far. Please help.


(Neal) #2

Hi Ismael–sorry to hear that you’ve had trouble importing the air quality data. Can you tell me what validation error you’re receiving?


(Kaukurauee Ismael Kangueehi) #3

Hi Neal_Fann, thank you for your reply. most of the errors are with the columns and rows, meaning its not in the right format. I expected the data in the self paced exercise to be in the right format. Validation%20error


(Neal) #4

Hi Ismael–I’m going to attempt to replicate the issue you’re experiencing. Can you tell me what version of the program you’re using?


(Kaukurauee Ismael Kangueehi) #5

Hi Neal, thank you for your reply.
I think the problem is that the excel files that are given for the self paced exercises are not in the right format.
I am not using any programming, I simply just installed the BenMap on my windows pc, downloaded the provided excel/csv files for the training exercises and they are not working. How can they be fixed, I attempted with no success. Please help. Capture


(Ali) #6

Ismael,

I’m sorry to hear that you are having issues, so this morning I tested both the South Africa and China datasets that are provided online and was able to load them into BenMAP without any issues.

In the screenshot you sent, it seems as though the formatting was changed when the file was opened. I’m not quite sure why the formatting would change, but when I opened it on my computer, the data remained in columns.Can you try downloading the file again, but this time do not open it ahead of time, and try to load it into BenMAP?

I hope this allows you to move forward. Best, Ali

image


(Ali) #7

Ismael, I’ve taken the data you’ve sent to Neal and it was able to load without an issue on my computer and I was able to successfully generate BenMAP results. Again, I really think that the file is being corrupted when it is opened, can you try loading it again? Otherwise, you may have to reformat the .csv in Excel by using the “text to columns” tool. Best, Ali