[eml-dev] Bug in import MS Access to morpho

[Jing Tao]

Hi, devs:

I am working on the bug 
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=4537

This bug is about generating invalid eml output when user imports a MS 
Access db to morpho.

I took a look and found there are two problems there:

1. Generating an empty objectName element - <objectName/>
2. Generating an empty offline element - <offline/>

They are not hard to be fixed. But I have to make sure I am going to add 
correct value there.

For objectName, in our morpho practice, we usually put physical file name 
there. In MS Access module, each table in MS Access db will be generated 
a dataTable in eml. And each dataTable will have an objectName. If we put 
a physical file name, i.e. database file name, as objectName, so different 
dataTable will have same objectName. For example, text.adp has two 
tables table-one and table-two. In the EML, it will have two dataTable 
elemnts table-one and table-two. Both of them will have a same objectName - 
test.adp.

I am not sure if this is a good idea since eml specification says:
The name of the data object. This is possibly distinct from the entity 
name in that one physical object can contain multiple entities, even 
though that is not a recommended practice.

For offline element, I will put some hard code such as "Hard Drive" as 
mediumName since Import MS Access Module doesn't have any user input 
interface there.

Any suggestion and comment will be appreciated.

Jing

Jing Tao
National Center for Ecological
Analysis and Synthesis (NCEAS)
735 State St. Suite 204
Santa Barbara, CA 93101