OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



SOLVED: Users.xml export issues

Are you responsible for making OCS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, michael, John

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

SOLVED: Users.xml export issues

Postby johnkperks » Mon Jan 16, 2012 3:01 pm

We have OCS 2.3.4 and we are able to export the users.xml for each role. However, when trying to open them in excel it always gives and error stating:

Error code: -1072896636
URL: <not-supplied>
Reason: DTD is prohibited.
Line: 2
Column: 11
File Offset: 49

Can someone help please?
Last edited by johnkperks on Mon Jan 23, 2012 4:34 am, edited 1 time in total.
johnkperks
 
Posts: 14
Joined: Wed Nov 02, 2011 3:10 am

Re: Users.xml export issues

Postby asmecher » Mon Jan 16, 2012 3:38 pm

Hi John,

As far as I know, Excel expects XML to be supplied according to a particular DTD and this is not the same format that the user import/export plugin uses. Basically, the file formats are incompatible. You'll have to use an intermediate tool to get the exported XML document into a form that Excel can use -- e.g. something to convert that XML format into a CSV file.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Re: Users.xml export issues

Postby johnkperks » Mon Jan 23, 2012 4:34 am

asmecher wrote:Hi John,

As far as I know, Excel expects XML to be supplied according to a particular DTD and this is not the same format that the user import/export plugin uses. Basically, the file formats are incompatible. You'll have to use an intermediate tool to get the exported XML document into a form that Excel can use -- e.g. something to convert that XML format into a CSV file.

Regards,
Alec Smecher
Public Knowledge Project Team


Thanks Alec, It worked.
johnkperks
 
Posts: 14
Joined: Wed Nov 02, 2011 3:10 am

Re: SOLVED: Users.xml export issues

Postby cccosw » Tue Oct 09, 2012 2:48 pm

I downloaded a converter from http://xmltocsv.codeplex.com/, imported the downloaded xml users file (actually from a OJS file for now, we don't have OCS up and running fully), and was able to export to a csv file. It was a bit confusing as it created multiple csv files, but the one called users.csv had all data in it. Imported to Access fine. - Mike
cccosw
 
Posts: 1
Joined: Tue Oct 09, 2012 1:26 pm


Return to OCS Technical Support

Who is online

Users browsing this forum: No registered users and 2 guests