We provide you with:

(a) several hundred JPEGs of maps of different areas (Example: Europe, Asia, United States, etc)
each map is either an old map or a map about a subject regarding the area (transportation, demographics, etc.)
these maps are grouped right now only by area (Europe, Asia, United States, etc.)
(b) an excel spreadsheet (example of what we need)
it is formatted to organize the maps into categories by theme and date

You:

within each area,
(a) ORGANIZE the maps into categories
– 5-10 categories BY YEAR
Example: Years 1801-1900, Years 1901-2000
– 5-10 categories BY THEME
examples of CATEGORIES are Languages, Commerce, Demographics, Religion, Humor, Cultural, Ethnic, Geography, Military
YOU decide on the categories based on the Maps
no category can have less than 5 maps in it. If you need to group 2 categories to have enough Maps thats ok
ideally balance of maps across all the categories
it is OK if a map is in a BY DATE category and a BY THEME category
(b) ORDER them inside the categories
– for example within years from oldest to newest
(b) SAVE the maps jpeg files INTO FOLDERS by category, one subfolder per category created
(c) RENAME the filenames to ADD A NUMBER at the front in order to reflect the ORDER you created inside the categories
and RENAME the filenames with the SUBJECT of the map (no spaces)
Example: From xyz.jpg —> 02-europe-languages-spoken.jpg
(d) ENTER the information about the organization into the EXCEL spreadsheet
– Subject of the Map
– File Name

DELIVER to us
for each area
(a) One excel Spreadsheet per AREA formatted as described (example provided)
(b) Folder with subfolders of images organized by category with map image jpegs in each subfolder

We are looking for someone who will do this on an ongoing basis

To start with
3 areas (United Kingdom, World, France)
about 100 Maps each area areas
France is already 1/2 done to give you an example to follow/learn from

Tags: area, categories, category, change read folders excel, convert php files jpeg images, copy folders excel spreadsheet, couldnt create table adtrackz_campaigns error sql syntax check manual corresponds mysql server version right syntax use near rep, example, Excel, extract names folders excel sheet, javascript organize images, map, maps, mysql drag drop organize images, pull data outlook folders excel, save images sql server 2005 database table, script create folders excel