Date: Fri, 29 Mar 2024 00:17:57 +0100 (CET) Message-ID: <1055458009.31853.1711667877786@ip-172-34-0-25> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_31852_288791617.1711667877782" ------=_Part_31852_288791617.1711667877782 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The scenario is based on the addition= of mobilities for a higher education project KA103 and fo= r activity type Student mobility for studies between programme coun= tries.
Some fields are only relevant for KA1= 03. Fields which are required for other action types or activity types, wil= l be missing from this scenario.
The .CSV file downloaded from Mobility Tool+ uses the s= emi-colon as the list separator. If the same value is not set in the region= al settings of your PC, on opening this file, the contents of each row is e= ntered in the first cell.
This makes the content difficult to read and update. If you just open th= e 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 adjustmen= ts. Open a new worksheet.
=
The Text Import Wizard will open and consists of t= hree steps.
In Step 1, in the Original data type s=
ection 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 unchec=
k the box Tab and check the Semicolon option. In the
The Text Qualifier should be set as a " quotation mar= k.
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 th= e existing worksheet or a new worksheet.
Click OK after you selected the option most suitable fo= r 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.= p>
Upon saving you might receive additional warning messages. Click OK and click YES.