Inforiver
EDITable
EDITable
  • Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
      • Admin consent for EDITable's Entra ID
        • Basic consent
        • Full admin consent
    • Install EDITable
    • Add EDITable visual
  • Getting Data into EDITable
    • Connect to Data
      • Get data
      • Assign fields
      • Configuration Steps
        • Configure source
        • Configure Columns
        • Configure Type 2 SCDs (Optional)
    • Create a Table
      • Create From Scratch
      • Use Existing Table
      • Import Data
  • Working with EDITable
    • EDITable interface
    • Manage Columns
      • General
      • Constraints
      • Lookup and Relation
      • Display
      • Import/Export Configuration
      • Add Database Column
      • Insert Column
    • Column Access Control
    • Row Identification
    • Table Operations (Insert/Update/Delete)
      • Edit data
      • Bulk Edit
      • Find and Replace
      • Insert rows
      • Insert Column
      • Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
      • Reset Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Group Rows By
      • Summarize Column
    • Basic formatting
    • Conditional Formatting
  • Row Access Control
  • Approval Workflow
    • Review Changes - Workflow process
  • Type 2 SCDs
    • Configuring Type 2 SCDs in EDITable
  • Audit logs
  • Webhook
  • Display Settings
  • Commenting and Collaboration
    • Assign users & task status
    • View all comments & track changes
    • Comment Settings
  • Admin Portal & EDITable Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • Utility
      • Download Report
      • Pipeline
        • Power BI & EDITable deployment pipelines
        • Deployment in different destinations
        • Trigger deployment pipeline from external applications
        • Logs & other pipeline options
    • Manage Profile
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • EDITable managed DB
        • API token
    • Onboarding Actions
  • Formula and Functions
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEIF
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • LOG
      • MAX
      • MIN
      • PCT
      • POWER
    • Text formatting functions
    • Date functions
      • DATE
      • DATE.FORMAT
    • Other operators
  • Keyboard Shortcuts
  • Release Notes
    • EDITable - v1.7.5
    • EDITable - v1.7
    • EDITable - v1.6.5
    • EDITable - v1.6
Powered by GitBook
On this page
  • Export
  • Import
  1. Working with EDITable
  2. Manage Columns

Import/Export Configuration

PreviousDisplayNextAdd Database Column

Last updated 5 months ago

While you can configure the columns manually, if you want to replicate an existing configuration in a similar table, the Import and Export options let you complete the process in just a few seconds.

This is accomplished by exporting the existing configurations to a text file (using 'Export') and then reusing it later for a similar table (using 'Import').

Generally, when you connect to a source database and configure an editable visual, the configuration settings remain intact. So, if you create a new visual that connects to the same database, the configurations persist without the need for an export.

Import and export options are helpful when you have to reset a visual to its initial configuration or replicate the same setup in a table with similar fields.

Export

  1. To export, click on Export.

Please ensure that you export saved configurations. If not, click Save to save the existing configuration and then export.

In the above example, notice the configuration details of the highlighted fields.

  1. In the confirmation pop-up, click Download to download the file to your local system.

  1. Click Save to save the config file. This will export the column properties in a .txt format.

Import

To restore a visual to its original setup, including any added columns and configurations, use the Import option to bring in the saved config file. Here’s how to do it:

  1. After loading your table into EDITable, click Import to import the previously downloaded text file.

  1. Select Click to Upload. In the file explorer, select the text file you downloaded earlier.

  1. Click Upload.

  1. If conflicting properties exist, a pop-up will appear asking for confirmation to overwrite the existing column configuration. You'll also be prompted about additional columns such as formula or multi-select columns (if present) to confirm if you want to add them. You can check the required columns to select them and apply the configurations.

  1. Click Import to proceed.

  2. The columns will be configured and saved automatically with the imported configurations.

Export
Download
Save export config
Import
Click to upload
Upload
Select columns and Import
Imported configuration