Re: [Gnumed-devel] Document parts display

[Jim Busser]

On 2011-06-26, at 10:35 AM, Karsten Hilbert wrote:

>> 2. in the case of the documents which had been
>> bootstrapped (the Vietnam 2003 reports) I cannot seem to
>> open them and wonder if it is in GNUmed impossible to do so
>> absent an entry in the "filename" field from which to
>> trigger any document viewer?
> 
> The filename is not required.
> 
> The log may be able to tell us more.

Searching on my hard drive within the downloaded gnumed-server directory, it 
seems from

        
/Users/djb/Downloads/gnumed-server.15.5/server/sql/test-data/test_data-James_Kirk.sql

that no actual blob was ever imported (see 'missing' in script lines below) …

… perhaps Vietnam has export restrictions which do not permit aging space 
travelers like Kirk to take away with them photos of Vietnamese children <grin>

:-)

-- Jim
******************************************************************

-- need to run the insert on data separately !
insert into blobs.doc_obj (
        doc_id,
        seq_idx,
        comment,
        fk_intended_reviewer,
        data
) values (
        currval('blobs.doc_med_pk_seq'),
        1,
        'Happy schoolgirls enjoying the afternoon sun catching the smile of
         passers-by at an ancient bridge in the paddy fields near Hue.',
         (select pk_staff from dem.v_staff where firstnames='Leonard Horatio' 
and lastnames='McCoy' and dob='1920-1-20+2:00'),
         'missing'
);

insert into blobs.doc_obj (
        doc_id,
        seq_idx,
        comment,
        fk_intended_reviewer,
        data
) values (
        currval('blobs.doc_med_pk_seq'),
        2,
        'Mekong River Delta Schoolgirls making their way home.',
        (select pk_staff from dem.v_staff where firstnames='Leonard Horatio' 
and lastnames='McCoy' and dob='1920-1-20+2:00'),
         'missing'
);