The scenario is based on the addition of mobilities for a higher education project KA103 and for activity type Student mobility for studies between programme countries.
Some fields are only relevant for KA103. Fields which are required for other action types or activity types, will be missing from this scenario.
The .CSV file downloaded from Mobility Tool+ uses the semi-colon as the list separator. If the same value is not set in the regional settings of your PC, on opening this file, the contents of each row is entered in the first cell.
This makes the content difficult to read and update. If you just open the file, it will not work.
The file cannot be imported back into Mobility Tool+ in this format. You would receive an error message for only the first mobility stating Not enough elements. This is the standard message received if the number of columns is not correct.
In order to use (read, modify) the file, you need to make some adjustments. Open a new worksheet.
The Text Import Wizard will open and consists of three steps.
In Step 1, in the Original data type section make sure the Delimited radio button is clicked and the File origin drop-down menu is set to 65001: Unicode (UTF-8).
Click on Next.
In Step 2 under Delimiters uncheck the box Tab and check the Semicolon option. In the Data Preview you will notice now several columns instead of just one.
The Text Qualifier should be set as a " quotation mark.
Click on Next.
In the next step, check the following info:
Set the Column Data Format to Text
A new window will pop up. You can select to import the information to the existing worksheet or a new worksheet.
Click OK after you selected the option most suitable for you.
The *.csv file will now look like a standard excel file and information can easily be added, modified or deleted.
After adjustments have been made, you can save the file for re-import.
Upon saving you might receive additional warning messages. Click OK and click YES.