One of my users writes long notes for individuals.
He used to write them using the imbedded notes (1 NOTE
and 2 CONT/CONC)
The system does not allow him to add another word.
The solution that I have suggested is to use external
notes (1 NOTE @Nxx@ and 0 NOTE @Nxx@ 1 CONT/CONC ...).
PhpGedView should support this format without a need to
use raw editing in initiating the creation of the
external note.
It should
* show a list of existing external notes and where they
are used and enable the user to see the text of the note.
* enable users to create new external notes and
automatically create the next Note ID when a user wants
to add a new external note.
* enable linking of an existing note to individuals,
families, sources, media and even to another note
* show a specific note and enable raw editing etc.
* enable searching also on the external note text
* sort the external notes by the Note ID when the
gedcom is downloaded or a part of it is exported using
the clipping cart.
* include the total number of the external notes in the
GEDCOM Statistics block.
* etc.
It has to be possible to include a submitter text, a
user reference number and type, a RIN and a source
citation.
CONC and CONT tabs are to work as defined in the standards.
Should we create a notes DB table instead of using the
others table for the external notes?
Logged In: YES
user_id=300048
We can solve your original problem by changing the Field
size from TEXT to MEDIUMTEXT or LONGTEXT.
TEXT has a limit of 2^16 or 64KB
MEDIUMTEXT has a limit of 2^24 or 16MB
LONGTEXT has a limit of 2^32 or 4GB
Wouldn't it be better if linked notes were more transparent
to the user. Most of the time the user will not care where
a note is or how it is implemented. And I don't see much
value in having a "Note List" or a special page for notes.
My proposal would be:
1. Notes longer than X number of characters should
automatically be made into external notes. (Good values for
X might be 10000 or 20000.)
2. Users should have the option to mark a note as a "Shared
Note" which will automatically make it available to link to
other people.
3. Users should have the option to link to an existing
"Shared note" any place where they can add a note
4. Search option should be added to search in Shared Note
records.
Beyond that, shared notes can be treated like any other
record in the system.
--John
Logged In: YES
user_id=959928
John,
Your suggestion sounds good.
We need also to sort the Notes records while we download the
Gedcom or extract parts of it. As far as I know this is not
done currently.
Meliza