acdigital

worked for me as well. But I cannot add fields to new created groups, why?

This was easy.
In case someone needs, go to line 1738 of main script and change this:

$pid = ‘MU-‘;

Be aware the maximum chars is 6, so if you use MU- you have only 3 combination chars left.

Thank you xnau, I will replace the question as a new topic.
Cheers,
Paulo

Hello xnau,

Great plugin, fits perfect my needs.
Congrats!

I would like to insert two leters MU- before the five characters random combination such as: MU-M4JTT to be included in the private ID link, where “MU-” is a fixed character set that will be the same for all the IDs. Which file do I have to work on to have it running?

Cheers,
Paulo Lopes

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
— https://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.

Hi, I just addressed the same question a few days ago and this solution worked for me.

In your page place this:

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

In your Admin/Tablepress/plugin options/custom css place this:

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

This will also align the search box.

I hope it works for you.
Cheers,
Paulo

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

Thank you Tobias, I will try your advice. brilliant.

I am closing the topic. ??

Thanks Tobias for the super fast answer.
I will try to figure it out by my own, there might be a way to do this.
Cheers,
Paulo