getAllStatuses(); $renderer = get_active_status_renderer(); echo ''; } function topic_icons_css() { echo "\n"; } function topic_icons_label( $label ) { global $topic; if (bb_is_front() || bb_is_forum() || bb_is_view() || bb_is_tag()) { $icon_set_name = topic_icons_get_active_icon_set(); $icon_set_url = ICON_SET_URL_BASE . $icon_set_name; $status = get_active_status_interpreter()->getStatus(bb_get_location(), $topic); $renderer = get_active_status_renderer(); $image = $renderer->renderStatus($status); $tooltip = $renderer->renderStatusTooltip($status); $exists = file_exists(dirname(__FILE__).'/icon-sets/'.$icon_set_name.'/'.$image); if (!$exists) { return sprintf(__('
%s
%s'), get_topic_link($topic->topic_id), ICON_SET_URL_BASE.'/empty.png', ICON_WIDTH, ICON_HEIGHT, $tooltip, $label); } else if (strlen($tooltip) > 0) { return sprintf(__('
%s%s
%s'), get_topic_link($topic->topic_id), $icon_set_url.'/'.$image, ICON_WIDTH, ICON_HEIGHT, $tooltip, $tooltip, $label); } else { return sprintf(__('
%s
%s'), get_topic_link($topic->topic_id), $icon_set_url.'/'.$image, ICON_WIDTH, ICON_HEIGHT, $tooltip, $label); } } return $label; } function topic_icons_init( ) { remove_filter('bb_topic_labels', 'bb_closed_label', 10); remove_filter('bb_topic_labels', 'bb_sticky_label', 20); add_filter('bb_topic_labels', 'topic_icons_label', 11); add_action('bb_head', 'topic_icons_css'); add_action('bb_admin_menu_generator', 'topic_icons_admin_page_add'); add_action('bb_admin-header.php', 'topic_icons_admin_page_process'); topic_icons_register_status_interpreter('default', new DefaultStatusInterpreter(BUSY_THRESHOLD)); topic_icons_register_status_renderer('default', new DefaultStatusRenderer()); } topic_icons_init(); ?> Digital Humanities Questions & Answers » Topic: Microsoft access on sharepoint to create database ultimately destined 4 website? http://digitalhumanities.org/answers/topic/microsoft-access-on-sharepoint-to-create-database-ultimately-destined-4-website Digital Humanities Questions & Answers » Topic: Microsoft access on sharepoint to create database ultimately destined 4 website? en-US Sun, 24 Mar 2019 04:55:34 +0000 http://bbpress.org/?v=1.0.2 <![CDATA[Search]]> q http://digitalhumanities.org/answers/search.php Wally Grotophorst on "Microsoft access on sharepoint to create database ultimately destined 4 website?" http://digitalhumanities.org/answers/topic/microsoft-access-on-sharepoint-to-create-database-ultimately-destined-4-website#post-1414 Thu, 13 Oct 2011 19:57:05 +0000 Wally Grotophorst 1414@http://digitalhumanities.org/answers/ <p>If you're willing to spend between $79-$99 you'll find that Navicat for MySQL makes it trivial to import an Excel spreadsheet or CSV into a MySQL databse. As an added bonus, it's a great tool for working with the data as well: exporting, reporting, querying, etc. $79 for Mac and Linux, $99 for Windows. <a href="http://navicat.com" rel="nofollow">http://navicat.com</a> </p> georginalgreen@gmail.com on "Microsoft access on sharepoint to create database ultimately destined 4 website?" http://digitalhumanities.org/answers/topic/microsoft-access-on-sharepoint-to-create-database-ultimately-destined-4-website#post-1411 Wed, 12 Oct 2011 20:45:54 +0000 georginalgreen@gmail.com 1411@http://digitalhumanities.org/answers/ <p>Thanks everyone! The relational nature of the database is key to the research -we are trying to uncover complex, unforeseen patterns of membership, publication, etc. I am looking into MySql and ways to remotely access the MySql server or perhaps enter data offline to be synced once network access is available.<br /> Thanks for your input it reassured me that I might be right to doubt the access / sharepoint solution. I'll look into all your suggestions and let you know how we get on. </p> Stéfan Sinclair on "Microsoft access on sharepoint to create database ultimately destined 4 website?" http://digitalhumanities.org/answers/topic/microsoft-access-on-sharepoint-to-create-database-ultimately-destined-4-website#post-1409 Tue, 11 Oct 2011 00:11:46 +0000 Stéfan Sinclair 1409@http://digitalhumanities.org/answers/ <p>Depending on the complexity of your database you might want to consider using Google Spreadsheets with <a href="http://www.google.com/google-d-s/forms/">Google Forms</a>. You wouldn't have the possibility of establishing relationships between tables, but you could do field validation and constraints (through pull-down menus, etc.).</p> <p>I suspect ultimately you'll need to build a custom web-based interface for the database anyway, and that could be query Spreadsheets through the API or you can migrate all the data into something like MySQL or SQLite. The real strength of Google Forms would be a free, collaborative platform for data entry.</p> <p>Alternatively, you might want to try something like <a href="http://www.zoho.com/creator/create-online-database.html">Zoho</a> (I haven't tried it for databases). </p> georginalgreen@gmail.com on "Microsoft access on sharepoint to create database ultimately destined 4 website?" http://digitalhumanities.org/answers/topic/microsoft-access-on-sharepoint-to-create-database-ultimately-destined-4-website#post-1408 Mon, 10 Oct 2011 19:17:54 +0000 georginalgreen@gmail.com 1408@http://digitalhumanities.org/answers/ <p><em>Replying to @Patrick Murray-John's <a href="http://digitalhumanities.org/answers/topic/microsoft-access-on-sharepoint-to-create-database-ultimately-destined-4-website#post-1407">post</a>:</em></p> <p>Hello,<br /> Thanks for the suggestions so far. I will look into them. Sharepoint was a suggestion as it is being used by another (pretty different) project at the uni. My concerns are the same as yours!<br /> There would be a lot of manual entry -taken from a lot of handwritten sources, for example. I think we are committed to a conventional relational database, but I will look into the wiki idea. I was thinking of using MySql via a GUI (none of us are up to it without a GUI for inserts). I am uncertain how to access the database from a variety of locations. I also think we maybe should have data collection databases which we then merge somehow into a master database ultimately.<br /> What do you think? Any tips appreciated.<br /> Thank you! </p> Patrick Murray-John on "Microsoft access on sharepoint to create database ultimately destined 4 website?" http://digitalhumanities.org/answers/topic/microsoft-access-on-sharepoint-to-create-database-ultimately-destined-4-website#post-1407 Mon, 10 Oct 2011 14:50:46 +0000 Patrick Murray-John 1407@http://digitalhumanities.org/answers/ <p>One specific question I have (after agreeing that Sharepoint doesn't sound like the ticket) is how the information would be coming in from the various archives? That is, are you looking at a lot of manual entry, or importing via OAI-PMH, or some other mechanism. My hunch is that that will be very big factor in what tool or platform will work best, perhaps even more important than the factors of displaying and sharing the information once it has been populated. </p> Arno Bosse on "Microsoft access on sharepoint to create database ultimately destined 4 website?" http://digitalhumanities.org/answers/topic/microsoft-access-on-sharepoint-to-create-database-ultimately-destined-4-website#post-1406 Mon, 10 Oct 2011 08:12:02 +0000 Arno Bosse 1406@http://digitalhumanities.org/answers/ <p>I concur that Access is not a good choice. At Chicago my group former Humanities Computing group hosted a similar sounding project developed by the university library: Libraries and Archives in South Asia (LASA): <a href="https://coral.uchicago.edu:8443/display/lasa/Home" rel="nofollow">https://coral.uchicago.edu:8443/display/lasa/Home</a> </p> <p>As you can see LASA is built around a wiki. It is a database, certainly, but a database whose content is exposed in a format that allows others to (optionally) contribute their own data, easily share results, search through the contents by keywords or browse it by facets, subscribe to an RSS feed of recent changes and so on. As you can see, by putting the content in a wiki you get a lot of very useful, user directed features 'for free'. The LASA wiki is built on Atlassian Confluence (<a href="http://www.atlassian.com/software/confluence/" rel="nofollow">http://www.atlassian.com/software/confluence/</a>) which is a commercial wiki. I feel Confluence is by far the most feature rich and easiest to use wiki solution available today but it's not free (or even cheap..) and setting it up requires a fair amount of hardware resources.</p> <p>My advice is still to build your resource as a wiki but to do this with a free and technically less demanding solution such as Dokuwiki (<a href="http://www.dokuwiki.org/dokuwiki)" rel="nofollow">http://www.dokuwiki.org/dokuwiki)</a>. I personally don't recommend MediaWiki (even though it is far better known) since to me, at least, it is cryptic and unfriendly to use, difficult to extend and maintain and hasn't (to my knowledge) seen any significant updates in some time. </p> <p>One potentially significant downside of a wiki-as-a-database approach to your task is that just as a wiki excels in helping you organize and share relatively unstructured data you will have a harder time of it than with a traditional database in exporting this data into a structured context afterwards. So, for example, while it should not be too difficult to move from eg. DokuWiki to another wiki, much more manual intervention will likely be required to move your content from DokuWiki to say another database. Without more background on your specific task and audience I can't properly say more to this but my gut instinct is that this won't actually matter. </p> Dorothea Salo on "Microsoft access on sharepoint to create database ultimately destined 4 website?" http://digitalhumanities.org/answers/topic/microsoft-access-on-sharepoint-to-create-database-ultimately-destined-4-website#post-1405 Sun, 09 Oct 2011 22:19:48 +0000 Dorothea Salo 1405@http://digitalhumanities.org/answers/ <p>Almost certainly not. Access is well-known for falling over dead given any significant load (either via size of database or number of simultaneous accesses), and it doesn't play nicely with non-Microsoft technology (such as what runs most of the Web).</p> <p>What were you thinking Sharepoint/Access would do for you? Perhaps the DH hivemind can suggest a stabler, opener alternative. </p> georginalgreen@gmail.com on "Microsoft access on sharepoint to create database ultimately destined 4 website?" http://digitalhumanities.org/answers/topic/microsoft-access-on-sharepoint-to-create-database-ultimately-destined-4-website#post-1404 Sun, 09 Oct 2011 17:04:21 +0000 georginalgreen@gmail.com 1404@http://digitalhumanities.org/answers/ <p>We are at the very start of a project which will populate a relational database with information from archives across the world. There will be three people working on the database and ultimately we want it to be openly available and searchable as an online research tool. Would Microsoft access on sharepoint be a good way of facilitating the collaborative research? </p>