Help import users -- converting Excel to XML

Hello everyone!

I volunteer for a non-profit in Argentina and I’m developing an OJS (version site for one of their magazines.

They asked me to create +3.000 users from an Excel Sheet (which includes first name, last name and email address).

Could anyone assess me about:

  1. How to convert so many users into an XML file, only with reading access (I checked the Import and export users but I cannot find something to help me insert the data I have in Excel to the XML sample they provide).

I’m really grateful for your time and any help you can provide! :slight_smile:

Hi @upupepops,

There is this external tool, from the University of Alberta libraries, that may be able to help out with this process: GitHub - ualbertalib/ojsxml: converts a csv file to ojs native import xml

I haven’t personally used it, but have anecdotally heard that others have found success with it for doing imports.

PKP Team

Hi @rcgillis and @upupepops,

The ojsxml plugin linked above is intended for published content (articles and issues), not users, which uses a different XML schema. Let me check with someone on our hosting team, as it’s likely they’ve done a conversion like this.

Alec Smecher
Public Knowledge Project Team

Hi @asmecher,

This is confusing, from the Github README, there does appear to be a utility specifically for users, in addition to the Issues one…


Hi all,

Ah! My apologies, you’re absolutely right, Roger. The plugin above does support users.

Alec Smecher
Public Knowledge Project Team

Thank you all! I’ll try that !!