import ISO_countries
from collections import OrderedDict
csv_2013_target = '../output/2013/extra/master_data_from_XL.csv'
xml_2013_target = '../output/2013/extra/master_data_from_XL.xml'
json_2013_target = '../output/2013/extra/master_data_from_XL.json'
csv_2014_target = '../output/2014/extra/master_data_from_XL.csv'
xml_2014_target = '../output/2014/extra/master_data_from_XL.xml'
json_2014_target = '../output/2014/extra/master_data_from_XL.json'
cur_year = 2014
regs = regions.build(cur_year)
csl = ISO_countries.build()
sp_chars = special_chars.build()
mappings = [
"Country_Name", "Assessment", "C_138_Ratified", "C_182_Ratified",
"Convention_on_the_Rights_of_the_Child_Ratified",
"CRC_Commercial_Sexual_Exploitation_of_Children_Ratified",
"CRC_Armed_Conflict_Ratified", "Palermo_Ratified",
"Minimum_Age_for_Work_Estabslished", "Minimum_Age_for_Work",
"Minimum_Age_for_Hazardous_Work_Estabslished",
"Minimum_Age_for_Hazardous_Work", "Compulsory_Education_Age_Established",
"Minimum_Age_for_Compulsory_Education",
"Free_Public_Education_Estabslished"
]
def get_cur_year():
import utility import special_chars json_2013_target = '../output/2013/extra/good_sector_mappings.json' csv_2013_target = '../output/2013/extra/good_sector_mappings.csv' xml_2013_target = '../output/2013/extra/good_sector_mappings.xml' json_2014_target = '../output/2014/extra/good_sector_mappings.json' csv_2014_target = '../output/2014/extra/good_sector_mappings.csv' xml_2014_target = '../output/2014/extra/good_sector_mappings.xml' mappings = ["Good_Sector", "Good_Name"] #The attributes to be extracted from the spreadsheet sp_chars = special_chars.build() # Function that returns the sector associated with a good name (otherwise it returns -1) def find_sector_from_name(goodname, slist): result = utility.get_default_error() ig = utility.canonical_good(goodname).upper().strip() for s in slist: cg = utility.canonical_good(s['Good_Name']).upper().strip() if (utility.goods_equal(ig, cg)): result = s['Good_Sector'] break return result # Function that returns a sorted list of the goods in a particular sector def find_goods_in_sector(sector, slist): result = utility.get_default_error() searchstring = sector.upper().strip()