Table of Contents
maxLevel 3

Include Page
CP Script
CP Script

This process describes the steps to be performed by a beneficiary user in order to add mobility details using a .CSV file to the interface of Mobility Tool+.

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.

HTML
<div class="page-break-ruler"></div>

Basic info on .CSV file

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.

Image Removed CSV file in excel Image Added

HTML
<div class="page-break-ruler"></div>

Steps

Numbered Headings

start-numbering-at	h3

Open Excel and import the file via the "Data" tab

In order to use (read, modify) the file, you need to make some adjustments. Open a new worksheet.

In Excel, click the DATA tab in the title bar.
Select the option From Text.
Select the downloaded .CSV file and click the Import button.

HTML
<div class="page-break-ruler"></div>

Follow the "Text Import Wizard" Step 1

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.

Follow the "Text Import Wizard" Step 2

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.

Image Modified

HTML
<div class="page-break-ruler"></div>

Follow the "Text to Columns Wizard" Step 3

In the next step, check the following info:

In the Data preview, select all columns. Do this by selecting the first column, scrolling to the right and while holding down the shift key, select the last column.
Set the Column Data Format to Text
Check the Advanced options. Ensure that the Decimal separator is set as a point and the Thousands separator is set as a comma.
Click OK
Click Finish

Import Data

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.

HTML
<div class="page-break-ruler"></div>

Update the file

The *.csv file will now look like a standard excel file and information can easily be added, modified or deleted.

HTML
<div class="page-break-ruler"></div>

**Save the file as *.CSV in Unicode (UTF-8) format**

After adjustments have been made, you can save the file for re-import.

Select under Save as type: *.CSV
Under Tools, select Web Options...
In the Encoding tab of the newly opened window ensure the Save this document as: is set to Unicode (UTF-8)
Click OK
Save the file

Upon saving you might receive additional warning messages. Click OK and click YES.

HTML
<div class="page-break-ruler"></div>

Versions Compared

Old Version 10

New Version Current

Key

Table of Contents
maxLevel 3

Include Page
CP Script
CP Script

Basic info on .CSV file

Steps