Skip to content

Extending and Reducing Columns During the Trial Period

Overview

These are the steps to change the number of columns during the trial period.

Reducing columns extended during the trial period

When you reduce the number of columns, the columns themselves are deleted from the table, so the data registered in the columns you added is lost.
Always take a backup of the database before you increase the number of columns.

Operation Steps

Editing and Saving Issues.json and Results.json

Edit and save the following two files in \App_Data\Parameters\ExtendedColumns under the Pleasanter installation folder.

  • Issues.json
  • Results.json

Tip

If you installed Pleasanter according to the steps in the user manual, the Pleasanter installation folder is as follows.

OS Installation Folder
Windows C:\web\pleasanter\Implem.Pleasanter
Linux /web/pleasanter/Implem.Pleasanter
Azure App Service C:\home\site\wwwroot\

Read them as appropriate for the environment you use.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
{
    "TableName": "Issues",
    "ReferenceType": "Issues",
    "Class": 0,
    "Num": 0,
    "Date": 0,
    "Description": 0,
    "Check": 0,
    "Attachments": 0
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
{
    "TableName": "Results",
    "ReferenceType": "Results",
    "Class": 0,
    "Num": 0,
    "Date": 0,
    "Description": 0,
    "Check": 0,
    "Attachments": 0
}

Settings

Column Description
Class The number of columns to add to Classification
Num The number of columns to add to Number
Date The number of columns to add to Date
Description The number of columns to add to Description
Check The number of columns to add to Check
Attachments The number of columns to add to Attachments

Running CodeDefiner

Move to the Pleasanter installation folder and run the CodeDefiner command with trial /e.

Example of running it on Windows
cd C:\web\pleasanter\Implem.CodeDefiner
dotnet Implem.CodeDefiner.dll trial /e