2.119 FAQ-1053 How to allow changing data when data connector is used?

Last Update: 4/23/2020

Data imported by Data Connector is protected by default:

  • Data imported via Text/CSV Connector is not editable, but sortable.
  • Data imported via Connector types other than Text/CSV, is neither editable nor sortable.

If you want to change the editing and/or sorting behaviors, please manipulate the value of system variable @IPDC BEFORE import data via Connector.,

To allow sorting data improted via Connector other than Text/CSV type, but still not editable,

  1. Select Preference: System Variables....
  2. In the Set System Variables dialog, type "IPDC" in Variable column and "1" in Value .
    Allow edit data by DC.png
  3. Import data by Data Connector.


To allow freely editing and sorting the data imported via any type of Connector, like othese imported by '''Data: Import from File''' menu,

  1. Select Preference: System Variables....
  2. In the Set System Variables dialog, type "IPDC" in Variable column and "0" in Value .
  3. Import data by Data Connector.

Keywords:import, connect data, CSV, TXT, DAT, Excel, Connector, sort column, sort worksheet