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?
SOLVED: Users.xml export issues
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.
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.
4 posts
• Page 1 of 1
SOLVED: Users.xml export issues
by johnkperks » Mon Jan 16, 2012 3:01 pm
Last edited by johnkperks on Mon Jan 23, 2012 4:34 am, edited 1 time in total.
- johnkperks
- Posts: 10
- Joined: Wed Nov 02, 2011 3:10 am
Re: Users.xml export issues
by 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
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: 5768
- Joined: Wed Aug 10, 2005 12:56 pm
Re: Users.xml export issues
by 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: 10
- Joined: Wed Nov 02, 2011 3:10 am
Re: SOLVED: Users.xml export issues
by 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
4 posts
• Page 1 of 1
Return to OCS Technical Support
Who is online
Users browsing this forum: Bing [Bot] and 1 guest