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
What to do if you have a technical problem with OCS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved. Please note that this FAQ is OJS-centric, but most issues are applicable to both platforms.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OCS Conference Support and Discussion subforum; if you have a development question, try the OCS Development subforum.

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: 7696
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 1 guest