Help import users -- converting Excel to XML

Software Support
, , , ,
1

Hello everyone!

I volunteer for a non-profit in Argentina and I’m developing an OJS (version 3.3.0.15.) 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:

2

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.

-Roger
PKP Team

4

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.

Thanks,
Alec Smecher
Public Knowledge Project Team

5

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…

-Roger

6

Hi all,

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

Regards,
Alec Smecher
Public Knowledge Project Team

7

Thank you all! I’ll try that !!