acdigital

This also didn’t work for my case.

<?php $this->record->get_value(‘private_id’); ?>

I resolved, installing elsewhere and copying the tables to my multi-site installation. Everything seems well now. In case someone needs this info, here is the default dump from a fresh installation:

— phpMyAdmin SQL Dump
— version 3.3.7deb8
— http://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Nov 14, 2014 at 04:37 PM
— Server version: 5.1.73
— PHP Version: 5.3.3-7+squeeze22

SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

—
— Database: pydio
—

— ——————————————————–

—
— Table structure for table wp_23_participants_database
—

CREATE TABLE IF NOT EXISTS wp_23_participants_database (
id int(6) NOT NULL AUTO_INCREMENT,
private_id varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
first_name tinytext COLLATE utf8_unicode_ci,
last_name tinytext COLLATE utf8_unicode_ci,
address tinytext COLLATE utf8_unicode_ci,
city tinytext COLLATE utf8_unicode_ci,
state tinytext COLLATE utf8_unicode_ci,
country tinytext COLLATE utf8_unicode_ci,
zip tinytext COLLATE utf8_unicode_ci,
phone tinytext COLLATE utf8_unicode_ci,
email tinytext COLLATE utf8_unicode_ci,
mailing_list text COLLATE utf8_unicode_ci,
photo text COLLATE utf8_unicode_ci,
website text COLLATE utf8_unicode_ci,
interests text COLLATE utf8_unicode_ci,
approved text COLLATE utf8_unicode_ci,
date_recorded timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
date_updated timestamp NULL DEFAULT NULL,
last_accessed timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

—
— Dumping data for table wp_23_participants_database
—

— ——————————————————–

—
— Table structure for table wp_23_participants_database_fields
—

CREATE TABLE IF NOT EXISTS wp_23_participants_database_fields (
id int(3) NOT NULL AUTO_INCREMENT,
order int(3) NOT NULL DEFAULT ‘0’,
name varchar(64) COLLATE utf8_unicode_ci NOT NULL,
title tinytext COLLATE utf8_unicode_ci NOT NULL,
default tinytext COLLATE utf8_unicode_ci,
group varchar(64) COLLATE utf8_unicode_ci NOT NULL,
help_text text COLLATE utf8_unicode_ci,
form_element tinytext COLLATE utf8_unicode_ci,
values longtext COLLATE utf8_unicode_ci,
validation tinytext COLLATE utf8_unicode_ci,
display_column int(3) DEFAULT ‘0’,
admin_column int(3) DEFAULT ‘0’,
sortable tinyint(1) DEFAULT ‘0’,
CSV tinyint(1) DEFAULT ‘0’,
persistent tinyint(1) DEFAULT ‘0’,
signup tinyint(1) DEFAULT ‘0’,
readonly tinyint(1) DEFAULT ‘0’,
PRIMARY KEY (id),
UNIQUE KEY name (name),
KEY order (order),
KEY group (group)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;

—
— Dumping data for table wp_23_participants_database_fields
—

INSERT INTO wp_23_participants_database_fields (id, order, name, title, default, group, help_text, form_element, values, validation, display_column, admin_column, sortable, CSV, persistent, signup, readonly) VALUES
(1, 0, ‘first_name’, ‘First Name’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘yes’, 1, 2, 1, 1, 0, 1, 0),
(2, 1, ‘last_name’, ‘Last Name’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘yes’, 2, 3, 1, 1, 0, 1, 0),
(3, 2, ‘address’, ‘Address’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘no’, 0, 0, 0, 1, 0, 0, 0),
(4, 3, ‘city’, ‘City’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘no’, 3, 0, 1, 1, 1, 0, 0),
(5, 4, ‘state’, ‘State’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘no’, 4, 0, 1, 1, 1, 0, 0),
(6, 5, ‘country’, ‘Country’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘no’, 0, 0, 1, 1, 1, 0, 0),
(7, 6, ‘zip’, ‘Zip Code’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘no’, 0, 0, 1, 1, 1, 0, 0),
(8, 7, ‘phone’, ‘Phone’, NULL, ‘main’, ‘Your primary contact number’, ‘text-line’, NULL, ‘no’, 0, 0, 0, 1, 0, 0, 0),
(9, 8, ’email’, ‘Email’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘#^[A-Z0-9._%+-]+@[A-Z0-9.-]+\\.[A-Z]{2,4}$#i’, 0, 4, 0, 1, 0, 1, 0),
(10, 9, ‘mailing_list’, ‘Mailing List’, ‘Yes’, ‘main’, ‘do you want to receive our newsletter and occasional announcements?’, ‘checkbox’, ‘a:2:{i:0;s:3:”Yes”;i:1;s:2:”No”;}’, ‘no’, 0, 0, 1, 1, 0, 1, 0),
(11, 10, ‘photo’, ‘Photo’, NULL, ‘personal’, ‘Upload a photo of yourself. 300 pixels maximum width or height.’, ‘image-upload’, NULL, ‘no’, 0, 0, 0, 0, 0, 0, 0),
(12, 11, ‘website’, ‘Website, Blog or Social Media Link’, NULL, ‘personal’, ‘Put the URL in the left box and the link text that will be shown on the right’, ‘link’, NULL, ‘no’, 0, 0, 0, 0, 0, 0, 0),
(13, 12, ‘interests’, ‘Interests or Hobbies’, NULL, ‘personal’, NULL, ‘multi-select-other’, ‘a:7:{s:6:”Sports”;s:6:”sports”;s:11:”Photography”;s:11:”photography”;s:10:”Art/Crafts”;s:6:”crafts”;s:8:”Outdoors”;s:8:”outdoors”;s:4:”Yoga”;s:4:”yoga”;s:5:”Music”;s:5:”music”;s:7:”Cuisine”;s:7:”cuisine”;}’, ‘no’, 0, 0, 0, 0, 0, 0, 0),
(14, 13, ‘approved’, ‘Approved’, ‘no’, ‘admin’, NULL, ‘checkbox’, ‘a:2:{i:0;s:3:”yes”;i:1;s:2:”no”;}’, ‘no’, 0, 0, 1, 0, 0, 0, 0),
(15, 14, ‘id’, ‘Record ID’, NULL, ‘internal’, NULL, ‘text-line’, NULL, ‘no’, 0, 0, 0, 1, 0, 1, 1),
(16, 15, ‘private_id’, ‘Private ID’, ‘RPNE2’, ‘internal’, NULL, ‘text’, NULL, ‘no’, 0, 90, 0, 0, 0, 1, 1),
(17, 16, ‘date_recorded’, ‘Date Recorded’, NULL, ‘internal’, NULL, ‘timestamp’, NULL, ‘no’, 0, 100, 1, 0, 0, 0, 1),
(18, 17, ‘date_updated’, ‘Date Updated’, NULL, ‘internal’, NULL, ‘timestamp’, NULL, ‘no’, 0, 0, 1, 0, 0, 0, 1),
(19, 18, ‘last_accessed’, ‘Last Accessed’, NULL, ‘internal’, NULL, ‘timestamp’, NULL, ‘no’, 0, 0, 1, 0, 0, 0, 1);

— ——————————————————–

—
— Table structure for table wp_23_participants_database_groups
—

CREATE TABLE IF NOT EXISTS wp_23_participants_database_groups (
id int(3) NOT NULL AUTO_INCREMENT,
order int(3) NOT NULL DEFAULT ‘0’,
display tinyint(1) DEFAULT ‘1’,
admin tinyint(1) NOT NULL DEFAULT ‘0’,
title tinytext COLLATE utf8_unicode_ci NOT NULL,
name varchar(64) COLLATE utf8_unicode_ci NOT NULL,
description text COLLATE utf8_unicode_ci,
PRIMARY KEY (id),
UNIQUE KEY name (name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

—
— Dumping data for table wp_23_participants_database_groups
—

INSERT INTO wp_23_participants_database_groups (id, order, display, admin, title, name, description) VALUES
(1, 1, 1, 0, ‘Participant Info’, ‘main’, NULL),
(2, 2, 1, 0, ‘Personal Info’, ‘personal’, NULL),
(3, 3, 0, 0, ‘Administrative Info’, ‘admin’, NULL),
(4, 4, 0, 0, ‘Record Info’, ‘internal’, NULL);

Thanks to all.

Hello Tobias, it worked like a charm.

I will paste the code for someone with limited knowledge like me to get it.

Insert this in your admin/plugin options/custom css.
Replace 123 for the id of your table

 div#tablepress-123_wrapper {
  width: 800px;
  margin-left: auto;
  margin-right: auto;
}

Place this around your table in the page/post or wherever you decide to display your table.

<div id=tablepress-123_wrapper>
[table id=123  /]</div>

Cheers,
Paulo

I am closing the topic. 🙂