Ubuntu
shared-mime-info package

Add support for MS Access 2007 Format - Needed for OOo

Bug #208096 reported by Chris Cheney
10
Affects Status Importance Assigned to Milestone
shared-mime-info
Invalid
Medium
shared-mime-info (Ubuntu)
Triaged
Low
Unassigned
Hardy
Won't Fix
High
Unassigned

Bug Description

Binary package hint: shared-mime-info

I saved out test files for every format that MS Access 2007 supports saving and used gvfs-info to report what it thought about each file. It appears that the MS Access 2007 format itself is not supported yet. I will attach a zip file with all formats MS Access 2007 can save out to:

This one needs to be improved:

example - Microsoft Office Access 2007 Database.accdb : application/octet-stream - application/octet-stream

I will also have additional bugs for Excel/PowerPoint/Word file formats.

Thanks!

Chris Cheney

Revision history for this message
Chris Cheney (ccheney) wrote :
Changed in shared-mime-info:
importance: Undecided → High
milestone: none → ubuntu-8.04
Revision history for this message
ynamestnikov (ynamestnikov) wrote :

In new OO 2.4 was added support for Access 2007 (.accdb files)

Revision history for this message
Chris Cheney (ccheney) wrote :

This bug is about the fact that shared-mime-info doesn't know what type of file an Access 2007 file is, so when you click on it, it thinks it is a 'octet-stream' file instead of something more usable like 'vnd.openxmlformats-officedocument.database' or something along those lines...

Revision history for this message
berg (berg-foss) wrote :

@cris
I think that I understood your idea: the objective is "know" what file is. "Work" with the file or "open" this file is a openoffice's ( koffice, abiword etc) problem ( a big ooxml problem - ISO raped :)

http://avi.alkalay.net/2008/03/how-microsoft-raped-iso.html

linking bugs:
https://bugs.launchpad.net/ubuntu/+source/shared-mime-info/+bug/208062
https://bugs.launchpad.net/ubuntu/+source/shared-mime-info/+bug/208071
https://bugs.launchpad.net/ubuntu/+source/shared-mime-info/+bug/208092
https://bugs.launchpad.net/ubuntu/+source/shared-mime-info/+bug/208096

Chris Cheney (ccheney)
Changed in shared-mime-info:
milestone: ubuntu-8.04 → none
Dylan Taylor (dylanmtaylor)
Changed in shared-mime-info:
status: New → Confirmed
Chris Cheney (ccheney)
Changed in shared-mime-info:
milestone: none → ubuntu-8.10-beta
Revision history for this message
Andres Mujica (andres.mujica) wrote :

Hi, should we mark this linked bugs as duplicate off bug #138252 or viceversa? it seems that this set of bugs are being worked on??

Revision history for this message
Joe Smith (yasumoto7) wrote :

This is actually a different issue, #138252 is discussing a different filetype, and it looks like the fix has already been released.

Revision history for this message
Sebastien Bacher (seb128) wrote :

the mdb example are correctly detected as application/vnd.ms-access in jaunty

Changed in shared-mime-info:
importance: High → Low
milestone: ubuntu-8.10-beta → none
Revision history for this message
Sebastien Bacher (seb128) wrote :

the accdb is still not reconized, lowering the settings since that's not a high importance issue

Revision history for this message
Grzegorz G. (grzesiek1e5) wrote :

All but accdb recognised in Precise.

Revision history for this message
In , Sergey "Shnatsel" Davidoff (shnatsel) wrote :

Created attachment 67696
Example of Access 2007 file

MS Office Access 2007 files are not recognized.

example - Microsoft Office Access 2007 Database.accdb:
 name: application/octet-stream
 data: application/octet-stream
 file: application/octet-stream

This bug was originally reported at https://bugs.launchpad.net/ubuntu/+source/shared-mime-info/+bug/208096

Sergey "Shnatsel" Davidoff (shnatsel)
Changed in shared-mime-info:
importance: Undecided → Unknown
status: New → Unknown
Sebastien Bacher (seb128)
Changed in shared-mime-info (Ubuntu):
status: Confirmed → Triaged
Changed in shared-mime-info (Ubuntu Hardy):
status: Confirmed → Won't Fix
Bug Watch Updater (bug-watch-updater)
Changed in shared-mime-info:
importance: Unknown → Medium
status: Unknown → Confirmed
Revision history for this message
In , Bugzilla-x (bugzilla-x) wrote :

Caolan, does LO know how to open that?

Revision history for this message
In , Sergey "Shnatsel" Davidoff (shnatsel) wrote :

According to http://www.libreoffice.org/features/ it does.

Revision history for this message
In , Sergey "Shnatsel" Davidoff (shnatsel) wrote :

Oh wait, that doesn't mention 2007 explicitly, sorry.
http://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access does.

Revision history for this message
In , Caolanm (caolanm) wrote :

caolanm->dtardon: don't we only support msaccess under windows via ado or some such ?

Revision history for this message
In , Dtardon (dtardon) wrote :

(In reply to comment #3)
> Oh wait, that doesn't mention 2007 explicitly, sorry.
> http://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access does.

Have you actually _read_ the text? The first two sentences are: "These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system. For other systems the solutions are not yet finished." ("not yet finished" should better be replaced by "not even started")

http://www.libreoffice.org/features/ is misleading, unfortunately. It should state that MS Access DB driver is only available on Windows. (It should also not mention Adabas, because the code has been removed and it is not clear if it had ever been compiled anyway.)

Bug Watch Updater (bug-watch-updater)
Changed in shared-mime-info:
status: Confirmed → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.