Document Generator Tools 1.0. 2017

We are happy to announce the realise of Document Generator Tools 1.0

Document generator is a set of tools that serves to Erasmus Coordinators in order to:

1. Provide all the links to the Erasmus platforms: Mobility tool, OLS platform, Europass, National Agencies...
2. Support the registration process of participants
3. Manage electronic documentation of participants with privacy and eficiency  
4. Manage mobilities for students (dates,flights, insurances, language support, OLS)
5. Provide calculation of founding grants for HE and VET
6. Gader all the data from the companies/isntitutions
7. Create all documentation for National Agencies
8. Provide csv files to upload mobilities to mobilty tool

These tools have been developed by :

Roger Borrell (rborrell@elpuig.xeill.net,rogerborrell@gmail.com)

Pablo Jiménez (pjimenez@elpuig.xeill.net)

Daniel Perez (dperez@elpuig.xeill.net)

INSTALLATION

Document Generator Tools are a set of google drive files that serve several purposes. After you follow this process you will be able to have this tool set in your google drive account. If you don’t have one please create a google account.

1. Open the file called Create a new document generator

2. Create a new copy of this file in your google drive:  FILE-> MAKE A COPY

3. Select the function CreateNewDocumentGenerator on the combobox.

4. Run this function using the play button.  

5. The script will ask then for execution permissions

6. In the top of the page will appear a yellow box saying, “Running the function ……. CreateNewDocumentGenerator  ” This will take a long time (more than 5 minutes).

7. After it’s finish it run the other function called Establish_links

8. After it's finish it will appear a google drive folder called “KA1 Management” in your google drive.

1. In the Links tab, write the the coordinator email and a backup file ID where to send the bacuks (optional)

2. In the Document generator  file, in the Links tab, write the schools and the studies you will work with.

3. In the Document generator  file, in the Organizations tab fill the information of the schools and the intermediary organizations.

4. Create the Registration form clicking at the blue Q in the Document generator  file. You can send the link to the form to collect candidate data.

5. Create the  Foreign Company Form form clicking at the pink Q in the Document generator file. You can send the link to the form to collect foreign company data. 

6. In order to finish your installation you need to go into the following files and run the Initialize  function:

1. KA1 Management -> Forms -> Europass Form -> Europass_Form_Answers

1. Open this file

2. Tools -> Script Editor -> Select Initialize function

3. Run it with the play button

2. KA1 Management -> Forms -> Foreign Companies Collector Form -> Answers_Company

1. Open this file

2. Tools -> Script Editor -> Select Initialize function

3. Run it with the play button

3. KA1 Management -> Forms ->Local Companies Collector Form -> Local_Companies_Collector_Answers

1. Open this file

2. Tools -> Script Editor -> Select Initialize function

3. Run it with the play button

4. KA1 Management -> Forms ->Registration Form -> Registration_in_Erasmus_selection_process_Answers

1. Open this file

2. Tools -> Script Editor -> Select Initialize function

3. Run it with the play button

5. KA1 Management -> Forms ->Student Assessment->Final Assessment -> Final_Assessement_Answers

1. Open this file

2. Tools -> Script Editor -> Select Initialize function

3. Run it with the play button

6. KA1 Management -> Forms ->Student Assessment -> Middle Assessment -> Middle_Student_Assessment_Answers

1. Open this file

2. Tools -> Script Editor -> Select Initialize function

3. Run it with the play button

7. KA1 Management ->Document Generator

1. Open this file

2. Tools -> Script Editor ->backup-> Select Initialize function

3. Run it with the play button