Skip to content

Asset Map

Sumeet Grewal edited this page Feb 22, 2020 · 14 revisions

Asset Map Coming Soon

Importing Data

The Data that is displayed on the Asset Map is stored in Wordpress. Each item (project, group, individual, etc.) is stored as a post with the respective post type. The available custom post types are:

  • cities
  • communities
  • groups
  • individuals
  • projects
  • tags
  • tag_types

To import data for a custom post type:

  1. Save the file containing the data in a CSV format. Only CSV files can be processed.
  2. From the Wordpress admin page menu, select the 'Asset Map' page.
  3. Attach the file to the appropriate field. Alternatively, select a file from the Wordpress Media Library.
  4. After all the files are attached, select the update button. Depending on the amount of data, this may take up to a couple of minutes.

Note: If a file is attached to the field for a post type, selecting Update will delete all the existing posts for that post type and create a new post for every row in the data file.

Note: When uploading a file to Wordpress, it is best to ensure the file has a unique name. Ex. "Projects-[today's date]"

Import File Format

The import file must be in a CSV format.
The first row of the file is ignored.
The second row of the file should contain the column (field) names. Please refer to the below table to see the complete list of available column names for each post type. The available column names are also listed on the 'Asset Map' page on the Wordpress admin panel.

Available Fields

  • cities: CITY_ID, NAME, LOCATION
  • communities: COMMUNITY_ID, NAME, CODE, LOCATION, CITY
  • groups: GROUP_ID, NAME, DESCRIPTION, WEBSITE, TAGS, COMMUNITY, PARENT_GROUP, PROJECTS, INDIVIDUALS
  • individuals: INDIVIDUAL_ID, NAME, DESCRIPTION, WEBSITE, POSITION, EMAIL, PHONE, SURVEY_INFO, TAGS
  • projects: PROJECT_ID, NAME, DESCRIPTION, WEBSITE, BLOG_POST, TAGS, DIRECTOR
  • tags: NAME, TYPE
  • tag_types: TYPE_ID, NAME, COLOUR
Clone this wiki locally