Modifying the Default Image Storage Location

By default, when you upload images the system stores them in the PTRTDB table. The default URL ID is PT_RTE_IMG_DB_LOC. To create a different storage location and URL ID, follow these steps:

  1. Create a new record definition.

  2. Insert the FILE_ATTDET_SBR subrecord.

  3. Save and then build the record definition.

  4. Clone these record definitions:

    • PTRTDB_BMP

    • PTRTDB_GIF

    • PTRTDB_JPG

  5. Save the record definitions, name them like this: <myrecord>_BMP, <myrecord>_GIF, and <myrecord>_JPG.

    The following image types are supported: JPG, BMP, GIF, PNG, and SVG.

  6. For each record, open the SQL Editor and change the FROM statement in the SQL to this: 

    FROM PS_<your record name from step 3>

  7. Save and build each view.

Note:

FTP storage is not supported.

Note:

It often will require end users to refresh a page or access it twice in order to display an image in a rich text editor field after the following events: browser cache has been cleared, web server cache has been cleared, the posting using the rich text editor field (such as a job posting) is new.