This is part one of three guides:

Preparing your data

Please read the directions on this page carefully. Then, download the OS Hub Data Template (see buttons below) to prepare your data. The facility data points you are able to upload are:

• country (required)
• name (required)
• address (required)
• sector/product type(s) (highly recommended)
• facility/processing type
• number of workers (raw values or ranges accepted)
• parent company

Deluxe Embedded Map Users: If you have signed up for a Deluxe Embedded Map, you will receive a custom template with any additional data points you may have requested. Please use that template and follow the accompanying instructions to prepare your data for upload.

Detailed Directions:

When you upload your list to Open Supply Hub, our team will run a quality check on it before accepting it into the system. We are constantly working to maintain a balance between making it easy to share data, and preserving a high level of data quality, so that the data in the tool is as useful as possible.

Follow the tips below to help us collectively raise the quality of supply chain data available for anyone who needs it:

General Tips:

• Please include cities and zip/postal codes in the address cell, if you have them.

• OS Hub accepts facilities throughout all tiers of the supply chain, but does not accept home addresses. If you have a facility you believe is also a person's home, please do not submit it to Open Supply Hub.

• Do not change the column heading titles in the first row. The wording must be exact for our system to process them.

• If you don't have data for a particular data point, please leave the column or cell blank. Do not enter N/A or other filler text.
  

• All fields in your list must be in English.

• Country names must be translated into English in order to be recognized by the system. OS Hub uses ISO country names for geocoding and processing.

• Please deduplicate your list. The OS Hub algorithm will check whether the facilities in your list already exist in OS Hub and match them accordingly. However, the algorithm will not remove duplicates within your list. Therefore, we ask that you remove duplicate facilities from your list before uploading.

• Ensure your facility names and addresses have fewer than 200 characters in a cell.

• File size limit: 5MB

• Save your file as an Excel file (.xlsx) or as a CSV UTF-8 (.csv). Excel is preferred, if accessible to you.

Formatting Instructions:

• If you are uploading multiple entries in one cell (like multiple product types), those entries must be separated by a comma OR vertical bar. For example: if entering pants and socks as product types for a facility, enter them as: “pants, socks” or “pants|socks.”
  
  For sector, facility type, and processing type, there is a set taxonomy that OS Hub uses to process data. Some of the values in these taxonomies contain commas. For example, “Printing, Product Dyeing and Laundering” is both a facility type and a processing type in the OS Hub taxonomy. For these values, the data will be treated as one value and will not be separated based on commas.

• Separate your plots/units/buildings. Please only upload one plot/unit/building per line in your upload. This way, our algorithm and moderation team can easily match entries unit by unit.

• Please do not use quotation marks and em dashes (—) in your file.

• Remove P.O. Box and Police Station Data: Some facility addresses will include details about a P.O. Box (PO) or local police station (PS). These details may disrupt the geocoding process and it is best practice to remove them from your address field. This will primarily affect facilities located in India.

• If you used Excel formulas while preparing your data, consider copying your final dataset into a new sheet and pasting [only values] to avoid formula errors affecting your data.

Additional notes on two data points:

Sector/Product Type:

• Values for sector are grouped with values for product type (e.g. in the upload template you’ll notice that the column name is sector_product_type).
• Open Supply Hub has a set list of supported sector values; any values uploaded in the sector_product_type field that match values on the OS Hub sector list will be listed under the sector heading on facility profile pages. All other values uploaded in the sector_product_type field will be listed as product type values. There can be multiple sector values and multiple product type values uploaded for each facility. Remember that you must use a comma or the vertical bar character (“|”) to separate discrete values when uploading. In the case where multiple values are uploaded without proper formatting, our team may reject your list and ask that you re-upload with correctly formatted fields.
• All facilities without a value matching one of the identified sector values will be assigned the value of ‘Unspecified’ for sector. These are the sector values that are currently programmed to be supported in Open Supply Hub. Note that our team will be routinely updating the list of sector values and the logic for this field as new data is uploaded. As OS Hub expands, and the system’s understanding of sector and product type relationships improves, new versions of the algorithm and underlying display logic will be released to better reflect this understanding.

Facility Type/Processing Type:

• For apparel facilities: You will note that facility and processing type are merged into one column in the upload template (if you have questions about what constitutes a processing and/or facility type, please consult our Facility Type Taxonomy). In this column, you may upload all processing activities that you have confirmed occur at a particular facility, which will appear as the Processing Types for each facility in OS Hub. OS Hub then sorts those values into searchable Facility Type categories, which will appear as the Facility Type in OS Hub.
• For non-apparel facilities: In the initial release of OS Hub, there are no defined values for processing type and facility type for facilities outside of the apparel sector. As more data is collected for non-apparel sectors, the logic for these fields will be built out to behave as they do for apparel facilities. You are welcome to submit any processing type data you have for your facilities.

Example Data: Before and After

Want an example to follow? Here's a quick sample of how to resolve some of the most common formatting issues submitted to OS Hub.

Uploading your data

Once you have prepared your file(s), according to the above instructions. Move on to uploading your data.

Have questions?

First, check out our FAQs page - we may have already answered your question! If you can't find what you need there, please reach out to info@opensupplyhub.org and we are happy to assist you. We look forward to seeing your data in Open Supply Hub!