Skip to the products
LCPanelLicence Center Panel
Data Export & Import Addons
About this addon

Data Export & Import Addons

Take any list out of the panel as CSV for Excel or as JSON: dealers, products, serial numbers, invoices, warranty cards, claims, tickets, users, settings, and the lists of the Accounts, Coupons and Dealer Customers addons when they are on. Filter by creation date, or tick several lists and get them in one file. Passwords never leave.

Bringing data in is careful by design. Upload a CSV or JSON file, match each column to a field (columns with the same name are matched for you), choose whether existing rows are updated, left alone or added again, and run it first as a dry run. The dry run changes nothing and tells you how many rows would be added, updated or skipped, with the row number of every problem.

Rows are matched on their natural key (a dealer's code, a product's SKU, a serial number), never on database numbers, so a file from another installation or from Excel lands in the right place. Free with every licence.

What it does

  • CSV and Excel
  • Column mapping
  • Validation before import
  • Export any list
Screenshots

See it before you buy

screenshots - click a picture to see it full size.

Data Export & Import Addons - Export import
Export import
Data Export & Import Addons - Match columns
Match columns
Data Export & Import Addons - Dry run
Dry run
Changelog

What's new

v1.0.0 — First release
  • AddedFirst release of the addon: Get data in at the start, and out whenever you want it.
  • AddedCSV and Excel
  • AddedColumn mapping
  • AddedValidation before import
  • AddedExport any list
Addons

More for Dealer Management System

Community

Reviews & comments

Rate it, ask a question or tell others how you use it. Everyone here is a signed-in LCPanel member - verified buyers are marked and come first.

–
★★★★★★★★★★
No reviews yet
5 ★0
4 ★0
3 ★0
2 ★0
1 ★0
Write a review

Add stars to your comment and it becomes a review.

Loading reviews and comments…