Add more info to Excel export

Add more info to Excel export

by Miguel Ramos -
Number of replies: 2

Hi Everyone,

I just want to know if we can modify the data we can get from the feedback in the exported Excel file

We wish to have the :

  1. Date of submission of entry
  2. City/Town of user
  3. Country of User
  4. e-mail address
  5. Responses to the feedback
Please let me know if you have an idea. Thank you very much!
Average of ratings: -
In reply to Miguel Ramos

Re: Add more info to Excel export

by Andreas Grabs -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Translators

Hi Miguel,

you can do that in two ways.

  1. You modifiy the feedback/analyse_to_excel.php
  2. You develop a new item class that can be used like a question but only give the needed information from the system.
    A good starting point could be feedback/item/info/*

Best regards
Andreas

Average of ratings: -
In reply to Andreas Grabs

Re: Add more info to Excel export

by Miguel Ramos -

Hi Andreas,

Thank you. I tried editing the analysis_to_excel.php file and it worked. I'm not really good at reading and editing PHP files.

The email and city worked but are misaligned. Do you know the variables to get the strings for Country + Date of Submission?

I have attached the file I edited. Thank you very much!


Regards,

Miguel

Average of ratings: -