close

oseberg

innovation. exploration. vision.

search

atla - Advanced CSV Import Tutorial

  • How do I name each column of data in my CSV?

The csv headers are automatically used to label each data attribute. So a csv header named "source" becomes "Source" in the grid.

OR

Add [label=MyLabelName] to your csv header to override the above behavior. source[label=DataSource] labels "source" as "DataSource".

  • How do I map my data?

Your geographic data must be in geojson format. The data can be either a GeoJSON FeatureCollection or a GeoJSON Geometry.

The csv header must either

  1. Have "geojson" in the header name
  2. Include "[type=geojson]" in the header.

For example, the application will recognize both "drilling_tract_geojson" or "drilling_tract[type=geojson]" as mappable geojson fields.

  • How do I add a map date to my data so that it works with the map timeslider?

Create a csv header titled "map_date" and add the date at which you want your data to appear on the map. When that date lies between the beginning and end dates of the timeslider handles, your data will map provided it has a valid geojson geometry field.
 

  • How do I create a hyperlink for a data cell in the grid?

Create a column in the csv that contains the url you want the hyperlink to link to. In the header for the data you want the link to be created for, add [linkMapping=(name of header with url)] where (name of header with url) is either the explicit field name you have set for that column, i.e.: urlColumn[name=SOME_URL_COLUMN] or the lowercase column name if the name field has not been explicitly set.

For example, the csv below creates a link around "OCC" that links to the url in the source_url column.

source[lnkMapping=source-url],source-url

OCC, https://data.oseberg.io/service/attachment/occ-apporder/201602075

  • How do I create types for my CSV data so that the application treats them as a "date", "number", or "text"

Add a mapping to the cell with the correct type. For example, "expiration_date[type=date]" converts the data in that column to a date, while "section[type=number]" converts the data to a number.

  • What other configurations are available for my CSV data?

Here is a non-comprehensive list of mappings available to configure your data. Create these mappings by adding them to the respective header like "headerName[mapping_key=value][mapping_key=value]" These are all optional and only used for advanced configuration of your data.

  1. name - Key used to reference the respective key in your csv. Unnecessary in most cases. The csv header is used by default as the name.
  2. label - The display value used for the data field. For example "Source", "Section", etc
  3. type - "date", "number", or "text" 
  4. visible - Whether this field is hidden in the grid by default. Can be toggled in the column manager.
  5. linkMapping - Looks for a url in this data field. If one exists and creates a link around the labeled field in the grid. See the example above.
  6. layer-name - Only valid for geojson data. This geojson data will be mapped to its own map layer of the same name. If multiple fields contain the same layer name, then they will all be mapped to the same layer.