Sync Sage 100

• Author: Fahad Mahmood
• Project URI: http://androidbubble.com/blog/wordpress/plugins/sync-sage-100
• Demo URI: http://demo.androidbubble.com/sync-sage-100

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.

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/.

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.