Data Management

Posts under the "Data Management" category

Import CSV & SQL files

Import CSV file Import SQL or ZIP file from Data Explorer main page Import SQL from Data Explorer table page Import CSV file Upload CSV file Perform column mapping Import CSV file Use reload to import an updated CSV file and prevent the need to remap table...

Run SQL script files

Button Import data/Execute script(s) can be used to execute SQL script files. It allows DCL (grant or revoke access), DDL (e.g. create table, drop table) and DML (select, insert, update, delete) statements, presuming the connected user has the proper privileges (works...

Data Backup

Backup Navigate to WP Data Access > Data Explorer > Data Backup Select the tables you want to backup Define a unique backup id Select your backup location (backup to local or dropbox folder) Define a backup interval or select Run once Define the number of backup...