Soholaunch User Manual

Managing Table Data

Viewing Database Tables
You may view the record data contained within a particular table by clicking on the “View / Edit Records” link next to its name.

dBTableManager_ViewEdit.png

Download

Select this link to download the database table as a CSV file.

dBTableManager_Download.png

Import
You may view the record data contained within a particular table by clicking on the “View / Edit Records” link next to its name.

dBTableManager_Import.png

Empty
This link will empty the database table of all record data contained within a particular table by clicking on the “Empty” link next to its name.

dBTableManager_Empty.png

Modify
This link allows modification of the database table. Use this feature to add additional fields to the table by clicking on the “Modify” link.

dBTableManager_Modify.png


Find Record
Enter terms to be searched in the provided field. Click the "within field" link to select specific fields to search for the entered terms. This allows the search to be drilled down to a specific area of the database table.

dBTableManager_ViewEdit2.png

Add New Record
This feature allows for new records to be added to the database table one at a time. Simply click the Add New Record button and the table fields will be presented for submission of information. It is not necessary to insert a Prikey as that will be assigned automatically upon saving the new record. Save when finished.

dBTableManager_NewRecord.png


Show Collapsed Options
Clicking this will show extra options such as hiding fields and collapsing data columns.

dBTableManager_ShowCollapseOptions.png

Run Custom Query
If you are familiar with MySQL databases, you can pull up a custom query.

dBTableManager_CustomQuery.png

Format Timestamps
This feature allows the timestamps to be formatted as human date strings. Select timestamp field(s) to format as dates. Note that this will not actually alter the data. This allows timestamp values to display as meaningful date/time strings which are more easily read.

dBTableManager_FormatTimestamps.png

Format Serialized Data
This feature allows php programmers/developers to format serialized array data for display.

  • Select field(s) containing serialized array data. Note that this will not actually alter the data. It's just meant to display serialized array data in a more concised, readable format.

dBTableManager_FormatSerializedData.png

Decode Data
This feature allows php programmers/developers to decode encoded data for display.

  • Select field(s) containing encoded data. Note that this will not actually alter the data. It's just meant to display the encoded data in a readable format.
  • Note: Some field may store encoded data. This tool decodes those fields.

dBTableManager_DecodeData.png