...
P (Priority) 1=very important, an amazing time saver and error tracker, 2= it would be great, 3= it would be nice but we can do it manually.
| Phase | P | Tasks | Data fields in our checking tables | Query URL |
01.05 | Author's Registration | 3 | For a given set of email addresses (or names): Check who is not registered, who is registered with a misspelled or non-university email address, who has started a submission and if the submission type (poster vs. talk) is correct. Send reminders and correct issues. Other tasks before the 01.05:
| Author, email address, submission ID (& link), submission title, if the submission abstract text field is filled, and if they actually pressed the button to submit). Reminder: We would only be interested in the new submissions (i.e. between 01.05.2024-01.07.2024). List of the Submissions (similar to the tab "Submission" in the Excel) | |
10.05 | Submission of Abstracts | 2 | +who sent the submission. | ||
15.05 | Assignation of reviewers | 1 | Co-create a table of who reviews who given a set of rules (e.g. 1st year students from Vienna get as a teacher reviewer Elisabeth Zimmermann + 2nd year students Elisabet Delgado Mas + although group submissions are submitted by every member, a student can't review itself or someone from its own group etc.). Check all submissions have been assigned at least 3 or more reviewers (2 random students and 1 university designated teacher), with the exception of the group submissions. Check each author has been assigned to review two other authors. | submission ID (& link), submission title, author, number_assigned_reviewers, reviewer1_name, reviewer2_name, reviewer3_name (instead of name it can be an email address or user ID that allows to trace them), reviewer4_name (4th reviewer is not always applicable, for exceptions) Note: We can count on a separate table author, times_assigned_as_reviewer, by counting how many times do they appear as reviewers in the table above. | |
21.05 | Revision of reviews | 1 | Check which reviewers have sent their reviews, to (1) send reminders to those reviewers who have not submitted them and (2) assign 4th reviewers if needed be. Revise several times. Extra: Check if teachers have submitted all their reviews. | + r1_status, r2_status, r3_status, r4_status (submitted or not), r1_details, r2_details, r3_details, r4_details (“Recommendation: Revisions Required”, ”Recommendation: Accept Submission”) R=reviewer List similar to the tab "Data_review" in the Excel) | |
24.05 | Approved & forwarded reviews | 1 | Count how many reviews have been submitted overall and how many are left. | ||
31.05 | Submission of Final Abstracts | 2 | Check all abstracts are submitted and uniformize their content, assign them to an issue. | ||
The earlier the better | Conference Preparation (Schedule, badges) | 3 | To update the schedule: Extract list of submissions by type (poster vs. talk) and authors. To make the badges: Extract list of submission | Submission link, submission title, author surname Author name & surname, affiliation |
Deadlines and author guidelines for the Proceedings of the MEi:CogSci Conference.
...
- Most of these might be empty or merely not used.
- We highlight in bold the ones we have been using in successful queries.
- We highlight in italics the ones in which we have found data that we have not yet managed to explain, but which may become relevant.
- Authors
- access_keys
- announcement_settings
- announcement_type_settings
- announcement_types
- announcements
- auth_sources
- author_settings
- authors
- books_for_review
- books_for_review_authors
- books_for_review_settings
- captchas
- categories
- category_settings
- citation_settings
- citations
- comments
- completed_payments
- controlled_vocab_entries
- controlled_vocab_entry_settings
- controlled_vocabs
- custom_issue_orders
- custom_section_orders
- data_object_tombstone_oai_set_objects
- data_object_tombstone_settings
- data_object_tombstones
- dataverse_files
- dataverse_studies
- edit_assignments
- edit_decisions
- email_log
- email_log_users
- email_templates
- email_templates_default
- email_templates_default_data
- external_feeds
- external_feed_settings
- email_templates_settings
- event_log
- event_log_settings
- failed_jobs
- files
- filter_groups
- filter_settings
- filters
- genre_settings
- genres
- group_memberships
- group_settings
- groups
- institutional_subscription_ip
- institutional_subscriptions
- issue_files
- issue_galley_settings
- issue_galleys
- issue_settings
- issues
- item_views
- jobs
- journal_settings
- journals
- library_file_settings
- library_files
- metadata_description_settings
- metadata_descriptions
- metrics
- mutex
- navigation_menu_item_assignment_settings
- navigation_menu_item_assignments
- navigation_menu_item_settings
- navigation_menu_items
- navigation_menus
- notes
- notification_mail_list
- notification_settings
- notification_subscription_settings
- notifications
- oai_resumption_tokens
- object_for_review_assignments
- object_for_review_persons
- object_for_review_settings
- objects_for_review
- paypal_transactions
- pln_deposit_objects
- pln_deposits
- plugin_settings
- processes
- publication_categories
- publication_galley_settings
- publication_galleys
- publication_settings
- publications
- queries
- query_participants
- queued_payments
- referral_settings
- referrals
- review_assignments
- review_files
- review_form_element_settings
- referral_settings
- referrals
- review_assignments
- review_files
- review_form_element_settings
- review_form_elements
- review_form_responses
- review_form_settings
- review_forms
- review_object_metadata
- review_object_metadata_settings
- review_object_type_settings
- review_object_types
- review_round_files
- review_rounds
- roles
- rt_contexts
- rt_searches
- rt_versions
- scheduled_tasks
- section_settings
- sections
- sessions
- site
- site_settings
- stage_assignments
- static_page_settings
- static_pages
- subeditor_submission_group
- submission_artwork_files
- submission_comments
- submission_file_revisions
- submission_file_settings
- submission_files
- submission_search_keyword_list
- submission_search_object_keywords
- submission_search_objects
- submission_settings
- submission_supplementary_files
- submission_tombstones
- submission_xml_galleys
- submissions
- subscription_type_settings
- subscription_types
- subscriptions
- temporary_files
- theses
- usage_stats_temporary_records
- user_group_settings
- user_group_stage
- user_groups
- user_interests
- user_settings
- user_user_groups
- users
Backend - OJS Exports
We have prepared a sample of exports here, protected by password.
...
Change some of the design of the homepage, how the whole website looks and how to customize its design:
| What | Where |
|---|---|
| -Font. | SETTINGS: WEBSITE > APPEARANCE > THEME: "Typography". |
| -Logo. | SETTINGS: WEBSITE > APPEARANCE > SETUP: "Logo". |
| -Background color for the header(MEi:CogSci color). | SETTINGS: WEBSITE > APPEARANCE > THEME: "Colour". |
| -Content of the header. | (It's just the Logo) |
| -Content of the footer. | SETTINGS: WEBSITE > APPEARANCE > SETUP: "Page Footer". |
-Favicon (customized to MEi:CogSci, tiny image in the Internet browser tab)
| ... |
| ... | |
-Journal Style Sheet (which we have not tried, but may allow CSS?) | > APPEARANCE >> ADVANCES |
Menus & URLs
Change the structure/architecture/navigation (what page is inside of which and its URL) of the website:
-Main menu ("Primary Navigation Menu").
| SETTINGS: WEBSITE (on the left bar) > SETUP (upper tab) > NAVIGATION (left-central tab) |
-Secondary menu ("User Navigation Menu").
| |
| -Right Sidebar elements in the homepage (Language Toggle Block: "Deutsch, English", Information Block "For Readers, For Authors, For Librarians", Developed By Block "Open Journal Systems" and a Subscription Block that actually doesn't appear, right?) | SETTINGS: WEBSITE (on the left bar) > APPEARANCE (upper tab) > SETUP (left-central tab inside) > Scroll to the bottom. |
Eli's note:
Beware there are two sections called "Setup". In the picture we are in SETTINGS: WEBSITE (left bar) > APPEARANCE (tab in the upper part) > SETUP (tab inside appearance, on the lef-central part) > "Logo".
...
Permissions are divided in four categories or stages:
Submission | Review | Copyediting | Production |
|---|
All roles are a combination of these categories or stages (which for our purposes, is not most helpful).
...
Mostly relevant just before the last step for publishing the issue (June), to rearrange what you see here:
| What | Where (in the dashboard) |
|---|---|
Edit the configuration of an issue (name, date of publication, volume - formal number). Add a cover image and some text about this issue. | ISSUES > Back Issues or Future Issues tab, click on your issue > "Issue Data" tab |
Order the abstracts within each section in the right order. In 2024, by author surname, manually once an issue is created and after all submissions have been assigned. | ISSUES > Back Issues or Future Issues tab, click on your issue > "Table of Contents" tab > upper right button "Order" |
Order the sections. In 2024, the order set is:
| ISSUES > Back Issues or Future Issues tab, click on your issue > "Table of Contents" tab > upper right button "Order" |
Eli's note for team 2025:
...
15.07.2024
Elisabet Delgado Mas Evelyn Fischer
- General structure and order.Backend documentation on OJS web scrapping, and link to scripts.
- Backend documentation on OJS scripting, and upload of scripts.
09.07.2024
- Backend documentation on OJS exports.
02.07.2024
- Frontend documentation on OJS.
27.03.2024
...
- Create queries that:
- Given submission_id, provides the backend and frontend links of its submission.
- Given one of the user's author_id, show their email and both publications.
- Given one of the user's author_id, show their
...
- data (familyName, givenName, affiliation, country) for both publications
...
19.03.2024
Elisabet Delgado Mas Evelyn Fischer
- Goal: Start new scripts based on the Schedule.
- Homework:
- Evelyn Fischer Delete outdated tutorial.
- Elisabet Delgado Mas Create updated tutorial and follow-up content from our meeting.
- Arrange next meeting (any hour, Tue or Wed). https://univienna.zoom.us/j/66408236619?pwd=WFZEclF6bGNXUlJaellNbnYrTkMxUT09
Time: Mar 19, 2024 02:00 PM, Meeting ID: 664 0823 6619, Passcode: 444917 - Elisabet Delgado Mas Check DBeaver https://dbeaver.com/docs/dbeaver/Data-transfer/
12.03.2024
Elisabet Delgado Mas Evelyn Fischer
...
- .