for

Welcome to the help page for the Project Bread Hungermap

Question: How do I upload a spreadsheet of sites?

Answer: Creating many sites at once is done using an Excel spreadsheet that has been saved in comma-separated-value (CSV) format. The format of the CSV file is the following:

The first line contains the following column labels in this exact order

  1. Sponsor - Agency supporting this site, if any.
  2. SiteName
  3. SiteAddress
  4. City
  5. State
  6. ZipCode
  7. DaysOperated - When the site provides service.
  8. Breakfaststart
  9. Breakfastend
  10. amSnackStart
  11. amSnackEnd
  12. LunchStart
  13. LunchEnd
  14. pmSnackStart
  15. pmSnackEnd
  16. SupperStart
  17. SupperEnd
  18. StartDate
  19. EndDate
  20. Notes
  21. Status

To upload your spreadsheet of sites do the following:

  1. Create your spreadsheet, with column labels
  2. Fill in details about one site per row of the spreadsheet
  3. Save the spreadsheet in CSV format (Mac users will need to save the file in "CSV (Windows)" format)
  4. Go to the application and click "Login" at the top right
  5. Go to Add a new Site
  6. On the "Add New Site" page, locate the "Add multiple sites" box
  7. Browse to find your CSV file
  8. Click save changes
  9. Wait roughly one second per site in your spreadsheet
  10. When upload completes you'll be presented with the site list where you can review your sites

Notes:

Question: How do I add an individual site?

Adding an individual site is done in the following way:

  1. Go to the application and click "Login" at the top right
  2. Go to Add a new Site
  3. On the "Add New Site" page, locate the "Add a single site" box
  4. Fill in the details of the site, and then click the "Save Changes" button at the bottom of the page

Question: How do I create a map?

Answer: Creating a map is done by giving it a name, assigning sites to place on the map and then saving the changes:

  1. Go to the application and click "Login" at the top right
  2. Go to Create a new map
  3. Enter a name and optionally a description
  4. You may also specify whether you want this map to be public to the internet or private to only Project Bread personnel
  5. Assuming sites have been added, you can use the dropdowns to add sites to your map
  6. When you are done, click "Save Changes" and you will be brought to your new map

Question: How do I assign sites to the map?

Answer: Sites can be assigned to a map in two ways - at creation or when editing the map later. There is no limit on the number of sites a map may have.

  1. To edit a map, first view that map
  2. Click the large "Edit" link near the name of the map
  3. You will be presented with a form that allows you to add and remove sites from the map
  4. Click "Save Changes" and the new sites will now be on your map

Question: How do I edit a site

Answer: To edit a site, you go to the site list and then click the "Edit" link. Changes made to the details of a site are reflected in the info bubbles of every single map where the site appears. This means that editing a site in this one location will benefit every place it appears on a map.

  1. To edit a site, go to the site list
  2. Click "Edit"
  3. Make your changes in the form presented and then click "Save Changes"
  4. You will be shown a detail view of the site, with changes included

Question: How do I remove a site from a map

Answer: Go to the map list while logged in. Click the 'edit' link next to the map containing the site you would like to remove. This brings to to the edit page for that map. To remove a site, check the checkbox on that page under 'Remove Sites.' When you are done click the 'Save Changes' button and the site will be removed.

Question: How do I bulkupdate all sites in the application?

Synopsis:

The Hungermaps application has advanced features by which it allows hundreds of sites to be uploaded with new information such that the new sites are recognized as entirely new sites, sites already in the application or sites that partially match information associated with sites in the database.

This answer is about how to take advantage of these features.

Answer:

  1. Login
  2. Click the 'Manage' link on the top right
  3. Click 'Bulkupdate all sites'
  4. Create an Excel spreadsheet that the application will understand. Do this by following step 1 to download a spreadsheet that lists all sites in the application currently along with all the associated fields for each of them.
  5. You are now free to edit the spreadsheet. You can change rows, delete rows or add new rows.
  6. When your changes are ready return to the bulkupdate page and select the spreadsheet you have modified and then click the 'Upload Bulkupdate file' button.

At this point you will be presented with a page with up to three sections

Matching between rows in the spreadsheet and sites in the application is done exclusively with the site name and street fields, nothing else. This means that 'identical', 'loose', and 'new' sites are all relative to what we can match between the spreadsheet and the application by those two fields.

In the case of identical matches, the exact name and street for a row in the spreadsheet was found in on a site in the application. Similarly, for new sites, it means that nothing in the name and street of a row in the spreadsheet can be found in the application. In the middle-ground are so-called 'loose' matches. A loose match is one where by slightly modifying the name or street, we can find similar sites in the application to a row in the spreadsheet. You will note there may well be several loose matches for a row in the spreadsheet.

You need to take action on this page in order for sites to appear in the application. Each section, identical, loose and new have different capabilities.

Identical matches: For each identical match you are presented with a box that summarizes differences between what is in the application and what was read from the spreadsheet. These are located in the 'existing' and 'new' columns respectively. The link at the top of each identical match section will bring you to that site in the application. If you would like to replace the field values for the site in the application with those listed in the identical match section from the spreadsheet just click the 'Merge this site.'

If you would like to accept ALL the identical match changes click the 'Update all identical matches' button below all the identical match listings.

Loose matches: For each loose match you see a headline that represents the name taken from a row in the spreadsheet. You can immediately add this to the application as a new site by clicking the 'Save as New Site' button. Alternatively you can survey a list of possible matches to this spreadsheet row, found in the application. As in the identical match scenario, field differences are listed in 'existing' and 'new' columns corresponding to how the loosely matched site in the application differs from the spreadsheet row.

There is no merge all button for Loose matches since that would be ambiguous for those loose matches with multiple options.

New sites: These are rows in the spreadsheet that could not be matched to any site in the application and so are assumed to be new to the application. To add them simply click the 'Add all new sites' button.

Notes on use: