What are the contents of the basic import file

Basic fields

• Activity Identifier - This is the element that defines the activity. In the CSV file if you leave any space in the cells below the activity identifier, it the information below will be counted for the above activity.
• Activity Title - The title for the activity. There can be only one title per activity.
• Activity Description (General) - There can only be one description per activity.
• Activity Description (Objectives) - There can be only one of these as as well, they can put together along with the other descriptions
• Activity Description (Target Groups) - There can be only one of these as as well, they can put together along with the other descriptions
• Activity Description (Others) - There can be only one of these as as well, they can put together along with the other descriptions
• Activity Status - There can be only one activity status in each activity (yy/mm/dd)
• Actual_Start_Date - Actual Start Date and Actual End Date must be Today or past days (yy/mm/dd)
• Actual_End_Date - Actual Start Date and Actual End Date must be Today or past days (yy/mm/dd)
• Planned_Start_Date - The planned start (yy/mm/dd)
• Planned_End_Date - The end date must not be before the start date
• Participating Organisation Role - Enter the role of the participating org. There can be multiple entries but role should not be repeated. Roles should be entered as 1,2,3 or 4 indicating the role. further
• Participating Organisation Type - This is the type of participating organization can be either entered as number or as the type ie: government, international NGO etc further
• Participating Organisation Name - The name of the participating org
• Participating Organisation Identifier - The identifier of the participating organization
• Recipient Country Code - the code for where the country in which the activity is being conducted. The codes are like for example TZ for Tanzania. There can be multiple countries for an activity. further
• Recipient Country Percentage - The percent generally is counted as 100, if there are more countries it should add up to 100.
• Recipient Region Code - There can be multiple regions to an activity, region percentage should be given further
• Recipient Region Percentage - If there are more than one recipient region's their percentage sum should add up to 100%. Sum of percentage of Recipient Country and Recipient Region must be equal to 100
• Sector Vocabulary - Sector vocabulary can be repeated but should not be the same further
• Sector Code - Sector code differ according to the vocabulary
• Sector Percentage - If there are multiple sectors, their percentage should add up to 100

Activity Defaults

• Activity Default Currency - the default currency that is being used eg USD,CAD,EUR further
• Activity Default Language - the default language that is being used eg en,fr,de further
• Humanitarian - Yes or no/ 1 or 0

Back to: How to use the mass import option for uploading activities