OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Exporting Abstracts for paper publication

Are you a Director, Presenter, Reviewer or Conference Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael

Forum rules
This forum is meant for general questions about the usability of OCS from an everyday user's perspective: conference managers, presenters, and directors are welcome to post questions here, as are librarians and other support staff. We welcome general questions about the role of OCS and how the workflow works, as well as specific function- or user-related questions.

What to do if you have general, workflow or usability questions about OCS:

1. Read the documentation. We've written documentation to cover from OCS basics to system administration and code development, and we encourage you to read it.

2. take a look at the tutorials. We will continue to add tutorials covering OCS basics as time goes on.

3. Post a question. Questions are always welcome here, but if it's a technical question you should probably post to the OCS Technical Support subforum; if you have a development question, try the OCS Development subforum.

Exporting Abstracts for paper publication

Postby jimsick » Sun May 04, 2008 6:02 pm

Now that we have finalized abstract review and acceptance, I would like to turn the online data (abstract, author, affiliation) into a printable conference program file. It seems the only export option is xml, which I'm not very familiar with. I can open this as an Excel list and work from there, but was wondering if there is a better way. (Lemon8-XML?, some other page layout program that can work from the xml database?). I'd appreciate it if anyone who has done this could point me in a good direction before I invest time needlessly in cutting and pasting.

regards,

Jim Sick
jimsick
 
Posts: 14
Joined: Sat Sep 15, 2007 6:17 am

Re: Exporting Abstracts for paper publication

Postby mj » Tue May 13, 2008 1:01 pm

Hi Jim,

What version of OCS are you using? The upcoming release of OCS 2.1 will, I believe, provide a number of report plugins in CSV format that can be easily imported into Excel and manipulated from there. The only XML export plugins at present are the NLM XML plugin, which exports indexing metadata, and the Users XML plugin, which exports user account data -- neither of these seem to be suited to what you're looking for. If you can let us know a little more about your OCS setup, we might be able to offer some better advice.

Regards,
MJ
mj
Site Admin
 
Posts: 304
Joined: Fri Mar 26, 2004 9:32 am
Location: Toronto, Canada

Re: Exporting Abstracts for paper publication

Postby jimsick » Sat May 17, 2008 12:07 am

I am using OCS 2.0, installed at a SiteGround personal hosting site. I'm technically inclined, but am not a web designer or network specialist. I've used phpMyAdmin to backup the database, but not much else. For the moment, I downloaded the NLM xml file, opened it in Excel, and hand edited. Tedious, but it worked. There have since been many revisions to the data however, and it would be useful to know a better way. Is there some way to work off the mysql db, for example?

TIA,

Jim Sick
jimsick
 
Posts: 14
Joined: Sat Sep 15, 2007 6:17 am

Re: Exporting Abstracts for paper publication

Postby mj » Wed May 21, 2008 8:04 am

Hi Jim,

As I mention, OCS 2.1 will include a CSV export, which is probably the easiest way to work with the data if you're using something that natively handles CSV like Excel. If you want to get the data directly out of the database, your hosting provider might be able to set up an application like phpMyAdmin, which should allow you to export the raw data as SQL, CSV, or XML. Definitely faster and easier than hand-editing.

Hope this helps,
MJ
mj
Site Admin
 
Posts: 304
Joined: Fri Mar 26, 2004 9:32 am
Location: Toronto, Canada

Re: Exporting Abstracts for paper publication

Postby jimsick » Wed May 21, 2008 11:46 pm

Hi John,

Thanks for pointing me in the right direction. I've worked with phpMyAdmin and managed to get the data out in a format flexible enough to meet my current needs.

Jim
jimsick
 
Posts: 14
Joined: Sat Sep 15, 2007 6:17 am

Re: Exporting Abstracts for paper publication

Postby spatialguru » Fri May 30, 2008 10:40 am

mj wrote:As I mention, OCS 2.1 will include a CSV export


Hi MJ,
Is this feature already in the 2.1 release. I can't seem to find it.

Tyler
spatialguru
 
Posts: 112
Joined: Mon Jun 25, 2007 1:23 pm
Location: British Columbia, Canada

Re: Exporting Abstracts for paper publication

Postby spatialguru » Fri May 30, 2008 10:47 am

spatialguru wrote:Is this feature already in the 2.1 release. I can't seem to find it.


Nevermind, I think found it :) for thoe who want to see it, there is a cool Stats & Reports option under your event. Takes you to: manager/statistics -> Reports are at the bottom. Very cool!

I have several without a title and abstract though - not sure what that means.

Thanks developers - I'm just starting to dig into the improved functions of 2.1 and already this has helped!
Tyler
spatialguru
 
Posts: 112
Joined: Mon Jun 25, 2007 1:23 pm
Location: British Columbia, Canada

Re: Exporting Abstracts for paper publication

Postby mj » Fri May 30, 2008 10:53 am

Hi Tyler,

You beat me by 5 minutes. :-) Glad you found it and are happy with the new features in OCS 2.1!

MJ
mj
Site Admin
 
Posts: 304
Joined: Fri Mar 26, 2004 9:32 am
Location: Toronto, Canada


Return to OCS Conference Support and Discussion

Who is online

Users browsing this forum: Exabot [Bot] and 2 guests