Skip to content

Column Expansion Procedure

Overview

In the Community Edition, you can use 26 columns for each of the following column types: "Class Column", "Numeric Value Column", "Date Column", "Description Column", "Check Column", and "Attachment Column" for a total of 156 columns. However, you can expand the number of columns in the Enterprise Edition.

DB Maximum number of columns available in the Enterprise Edition Notes
SQL Server Up to 900 columns in total for the six column types
PostgreSQL Up to 900 columns in total for the six column types
MySQL Up to 256 columns in total for the six column types MySQL is compatible with Pleasanter version 1.4.9.0 and later.

Expanded columns are created with consecutive numbers starting from "001" (Class 001, Class 002, etc.).
Follow these steps to expand columns or change the number of expanded columns.

Cautions

Expanding columns will change the table structure of the time-bound table (Issues table) and record table (Results table). In particular, when reducing the number of columns, the columns themselves are deleted from the table, so any data registered in the columns added through column expansion will be lost. Be sure to back up your data before expanding the column.

Prerequisites

This procedure assumes that you have upgraded Pleasanter to the Enterprise Edition.

Operation Procedure

  1. Back up your database
  2. Edit and save Issues.json and Results.json
  3. Run CodeDefiner
  4. Verify the column expansion

Operation Procedure

1. Back up your database

Back up your database according to your environment. Please also refer to our online manual.
Pleasanter User Manual - FAQ: Backup and Restore

2. Edit and save Issues.json and Results.json.

Edit Issues.json and Results.json in \App_Data\Parameters\ExtendedColumns under the Pleasanter installation folder (*).
- Issues.json: Time-bound table

{
   "TableName": "Issues",
   "ReferenceType": "Issues",
   "Class": 0,
   "Num": 0,
   "Date": 0,
   "Description": 0,
   "Check": 0,
   "Attachments": 0
}

- Results.json: Record table
{
   "TableName": "Results",
   "ReferenceType": "Results",
   "Class": 0,
   "Num": 0,
   "Date": 0,
   "Description": 0,
   "Check": 0,
   "Attachments": 0
}

- Settings

|Column|Content|
|:----|:----|
|Class|Number of columns to add to class column|
|Num|Number of columns to add to numeric value column|
|Date|Number of columns to add to date column|
|Description|Number of columns to add to the description section|
|Check|Number of columns to add to the check section|
|Attachments|Number of columns to add to the attachment section|

If you installed Pleasanter according to the instructions in our online manual, the installation folder is as follows. Please adjust accordingly depending on your environment.
1. Windows environment

C:\web\pleasanter\Implem.Pleasanter
1. Linux environment

/web/pleasanter/Implem.Pleasanter
1. Azure App Service environment

C:\home\site\wwwroot\

3. Running CodeDefiner

Please run CodeDefiner by referring to our online manual.
1. Windows environment
1. Open a command prompt (or PowerShell, or Terminal) and execute the following command:

cd C:\web\pleasanter\Implem.CodeDefiner
dotnet Implem.CodeDefiner.dll _rds

  1. Linux environment

  2. Execute the following command: refers to the user specified in the "Pleasanter service script". For details, please refer to our online manual.

    cd /web/pleasanter/Implem.CodeDefiner
sudo -u <Pleasanter startup user> /usr/local/bin/dotnet Implem.CodeDefiner.dll _rds

  3. Azure App Service Environment

  4. Select CodeDefiner from the Kudu directory list and confirm that the prompt is C:\home\site\CodeDefiner.
  5. Execute the following command:
    dotnet Implem.CodeDefiner.dll _rds /p C:\home\site\wwwroot

The above path is for installations following the instructions in our online manual. Please adjust accordingly for your environment.

4. Check Column Expansion

  1. Restart Pleasanter by referring to our online manual.
  2. Windows Environment
    1. Open Internet Information Services (IIS) Manager.
    2. In the left pane, select "Site" - "Default Web Site" and click "Restart" in the right pane.
  3. Linux Environment
    1. Execute the following command:
      sudo systemctl restart pleasanter

  4. Azure App Service Environment

    1. Open the App Service and click "Restart"

  5. Log in to Pleasanter, open any table, and from the navigation menu, select "Management" - "Manage Table" in the "Editor" tab, confirm that the expanded column (Class 001, Number 001, etc.) appear in the option list.