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.

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.