Sync Sage 100

By Fahad Mahmood

0+ active installationsVersion 1.0.3

A user friendly plugin to synchronize Sage 100 data into WordPress with API endpoints and manual import.

Description

Sync Sage 100 helps you bring data exported from Sage 100 into WordPress. After activation a Sync Sage menu appears in your dashboard. Open it to browse the folders on your server, pick the export file you want to work with (.xlsx, .xml or .csv files are listed), and load the file to see its columns.

Free features

  • Server folder browser with valid / writable status for every folder.
  • One click file selection.
  • Reads .xlsx exports and lists all columns so you can choose the relevant fields.

Pro features (plug and play)

The Pro version is a single pro folder inside the plugin directory. When the folder exists, these features switch on automatically. Remove it and the free features keep working.

  • Import tab: map Sage columns to WordPress user fields (email, username, first and last name, display name, website, bio, role and a Sage ID).
  • Dry run first, then batch import with a progress bar and a log of skipped rows and errors.
  • CSV and XML files besides XLSX.
  • Secure REST API endpoint so Sage or a script can push rows to WordPress (off by default, key shown once, only a hash is stored).
  • Safe by design: administrators are never changed by an import, roles that can manage users are never offered, passwords are never changed.

Security

Settings are saved only for administrators, requests are protected by nonces, the file picker accepts only files from the folders it displays, and all output is escaped.

Tags

wordpress, users, import, sage 100, xlsx

Trademark notice

Sage and Sage 100 are trademarks of The Sage Group plc. This plugin is an independent project and is not affiliated with, endorsed by or sponsored by Sage.

License

This WordPress plugin is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 2 of the License, or any later version. This WordPress plugin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this WordPress plugin. If not, see http://www.gnu.org/licenses/gpl-2.0.html.

Installation

  1. Upload the plugin files to the /wp-content/plugins/sync-sage-100 directory, or install the plugin through the WordPress plugins screen directly.
  2. Activate the plugin through the ‘Plugins’ screen in WordPress.
  3. Open Sync Sage in the dashboard menu, pick a file from the folder list and click the button to load its data.

To enable Pro, copy the pro folder into /wp-content/plugins/sync-sage-100/.

FAQ

Which file types can I use?

The free version reads .xlsx files. Pro adds .csv and .xml.

How do I switch Pro on or off?

Pro is plug and play. Copy the pro folder into the plugin directory to switch it on, delete the folder to switch it off.

Why does the file picker show several parent folders?

It shows every folder from the root of your upload path down to the upload folder, so you can pick an export stored anywhere along that path. Only files in those folders can be selected.

Changelog

1.0.3

  • Security: settings can be saved by administrators only and only for known keys.
  • Security: a selected file must be a .xlsx, .xml or .csv file inside the folders shown by the picker (blocks arbitrary path selection).
  • Security: nonce added to the “load file data” action; output escaping reviewed.
  • Fix: fatal error on PHP 8 when no settings were saved yet.
  • Fix: front-end fatal risk and unneeded plugin scan on every request.
  • Fix: the Users tab now opens by default instead of showing an empty screen.
  • Fix: script and style handles are prefixed to avoid conflicts, and assets are versioned instead of re-downloaded on every load.
  • New: plug and play Pro support (import, field mapping, CSV/XML, REST API).
  • Tested up to WordPress 7.1.

1.0.2

  • Maintenance release.

1.0

  • First release.