Welcome to the help system for the generic tables systems. This system is described as:
This help system has system specific information regarding how to use Generic Tables. See also readme.html and devnotes.txt for developer and administrator specific information. Don't bother reading those if you are just entering or viewing data.
Only three types of URLs are accepted. Any URL must start with one of, "HTTP://", "HTTPS://" or "FTP://". If the URL does not start with one of these three, "HTTP://" will be prepended (added to the front of) it.
Options in the select fields are the only ones that you may choose. This is enforced at the server (backend). It maybe the case that you get a strange error message in certain cases. The most likely reason for this is, the provided options (in the settings file) have been changed after you entered a record, and selected option was removed. You should tell the person who administers the system to not change the options after installation, and then you will have to choose another option.
If the date is unknown, you can set the year, month and day to all zeros. However, if only one, or two of these are unknown, you must set the unknown to "01". (This is the same as in WinEvsys.)
The legal range for the years for each of the date fields is as follows:
It is possible to select a date in the past.
To add an image to the system (where enabled), click the browse button and select the file from your file system. The file name can not be changed once it is uploaded, and there is no way to delete uploaded images (only to disassociate them from a particular record). The alt text and title text for the image when it is displayed is the file name.
When editing, you can see the image that is part of the record (if any), and have the option to upload a new image to replace it. If there is currently an image, you must un-check the check box.
To see all the images that have been uploaded, two things must be the case. The first is the upload directory must be visible from the web, and secondly, indexing or similar must be enabled in that folder. Assuming that both of these things are true (and they are normally), see Uploads. Finally, images must be one of the following types, JPEG, GIF or PNG, and have a file name extension of either gif, jpeg, jpg or png.
The form you see has a number of fields (obviously). Each of those fields has a preset limit on the number of characters (letters, numbers and symbols) that can be entered in it. This is enforced both in the browser, and (if you get around the browser side restriction), at the server (back end).
The following character limits apply for the fields.
The export format is CSV. That is, each record (row, unit, item, resource), is printed on one line. Each part of the record (e.g. title, author etc.) are surrounded by quote marks (") and separated by commas (,). Any quote marks in the part of the record (e.g. title, author etc.) are 'escaped' by other quote marks. That is: Something like "this". Will be: Something like ""this"".
"International human rights instruments","Report on indicators for monitoring compliance with international human rights instruments","","HRI/MC/2008/3","","Human Rights Instrument (HRI)","Who did ""what to whom""."
The export date format is Y-m-d.
Images aren't exported, instead, just the unique identifier that is stored in the database is. This is the sha1 hash (40 chars long) and then the file name. As such, the uploads folder should be copied directly as well. If you want to export all the items right now, go to export.php. If you want to download all uploaded files in a zip archive, go to archivefolder.php.
It is possible to import data into the system. However, at the moment, there is no simple, easy to use, web interface. Make sure all your data is in CSV format, with the correct number of records in each row, save it in the folder with the rest of the program files, read the import.php file, and go from there. It is always possible to import the files exported by the system. Please note, the import function is rather simplistic at the moment, and does not do any real sanity checking. It will enforce size/length/character limits. Import requires authentication. If you are messing around, check out the authent.php file to see how to change the password (I think the username is admin and the password admin).
One thing, should make sure the QUOTE, COMMA and DATE_FORMAT constants are the same on the import and export systems.
Potential big issue:
"Q\"" \' Q","","Q\"" GG \"" Q",will be returned as:
Q\" \' Q" Q\" GG \"" Q"The quotes are being messed up big time hey.
Q" \' Q Q" GG " Q
"Q"" \' Q","","Q"" GG "" Q",The backslashes are escaping things, or something strange. Not realy sure what is going on.
It is assumed by default that the data has headings (data that is exported has headings). These are ignored.
Images aren't imported, images aren't stored in the database. If you are importing something that has been exported from the system, and it has images, make sure that you place the uploads folder with all the images in the correct location in the new system.
To force admin links to be included in the table (e.g. edit, verify and delete), add "?displayadminlinks=true" to the end of the URL in the address bar. These still require you to be logged in to work though.
There isn't really much to say about the single view. Forcing the URLs to link of the items is a work in progress that doesn't affect the working of the system at all. Yeah.