Re: [Lmappletserver-developers] Media columns in the MetaLogViewer

[Peter S. <co...@pe...>]

See comments below.

On Nov 8, 2007 12:19 AM, Roberto MIlev <rob...@gm...> wrote:

> Hi Peter,
>
> Here is a status on the progress so far:
>
>   1. What has been done so far.
>
>
>    * A new record in the metadata database teble is added with "mmx"
>      dataType value:
>
> insert  into
>
> `metadata`(`meta_id`,`name`,`context`,`priority`,`dataType`,`object_class_name`,`created`,`updated`,`searchProperty`,`numericValue`)
> values (1015,'Multimedia','',9,'mmx','
> com.lightminds.appletserver.examples.metalog.Vehicle','2006-02-27
> 11:42:30','2006-02-27 11:42:30','','\0');


This is good.


>
>    * The metadatalogentry gui table has the option when a column has a
>      "mmx" dataType to show button instead of label cell. That button
>      leads to downloading servlet (for now).


Sounds good.


>
>    * Streaming(download) and uploading servlets are created in new
>      project named lmappletserver_multimedia. The corresponding changes
>      are made in lmappletserver_build project to include the multimedia
>      project.
>
ok


>
>      2. What has not been done so far:
>
>    * The uploading servlet does not place the files in folders as we
>      discussed.
>    * There is no button or link to lead you to the upload servlet.

The idea is that one should use a e.g. mobile phone application to do this.
So you have to have this in mind, that the upload interface should be
reachable by third party apps. As a test case you can make a simple web
form.


>    * Configuration parameters are still hardcoded in MediaType class
>      (they will be in property file at the end as report_conf.properties)
>
>      3. Questions:
>
>    * We didn't finally agree on how to make the folder structure,
>      please tell me what approach to use?


I think your last suggestion was good. Just make it to log_id rather than
entry_id. So that if there are more than one multimedia file per log_entry
they will be in the same folder. does that sound ok?


>
>    * Is it good to use the dataType metadata field to represent
>      multimedia column, or we need to add another column?


Yes I think thats the best way.


>
>    * On the upload servlet now there is a field that gets entryId, for
>      that entryId the file is added in the database, is this OK?


use log_id rather than entry_id - I probably think is better?


regards,

Peter