Spreadsheet import module

Module for importing spreadsheet as collection entries in Cockpit CMS

Features

• Import from CSV files or JSON files (generated by Cockpit collection export functionality)
• Localization
• Auto-assign fields based on header (Column names must match collection field names)
• Filters
  • Text
  • Select
  • Boolean
  • Lookup entry matching Name (for field type link-collection, useful for setting up categories) For multiple collection links, use Vertical bar | as a separator. Collection must have field named name
  • Location (Geolocate addresses)

Requirements

• Cockpit v0.13
• for CSV files IE10+/ Safari 6+ (see Papaparse browser compatibility)

Installation

Manual

1. Download latest release and place in [cockpit-path]/modules/addons/Import or

   cd [cockpit-path]/modules/addons
   git clone https://github.com/piotr-cz/cockpit-import Import

2. Open cockpit backend.

3. In top-right corner you'll see Import button.

Using composer

1. In composer.json add path where cockpit modules are located:

   "extra": {
       "installer-paths": {
           "cockpit/modules/addons/{$name}": ["type:cockpit-module"]
       }
   },

2. Install module using command

   composer require piotr-cz/cockpit-import

Usage

1. Select collection and file

   

2. Map collection fields to spreadsheet columns

   

3. Tune up processing options and click Import

   

Authors

• piotr_cz

3p libraries

• Papaparse (MIT)

Issues/ Feature requirements

Submit issue or feature requirement here

Latest development version

Licensed under MIT License