Facing Issue in data import from old journal site to new site

Software Support
, , ,
1

i am trying to import data from my old journal site to new using OJS native XML import export tool i Have attached export file that i supposed to upload on new site but unfortunately when I try to import this file an error occurred that says "The process failed. Check below for errors/warnings.
Errors occured:
Generic Items

Filter (Native XML submission import) supports input schema(plugins/importexport/native/native.xsd) - string given
Generic Items Id: 1

Line 29 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 88 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 218 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 393 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 533 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 653 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 775 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 879 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 979 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 1143 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 1290 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Line 1404 Column 0: Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Validation errors:
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.
Element ‘{http://pkp.sfu.ca}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed."

Then I remove “locale=“en_US”” from the whole xml file. Now these errors are resolved but a new error starts that shows "SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (frontier_ojs718.submission_files, CONSTRAINT submission_files_source_submission_file_id_foreign FOREIGN KEY (source_submission_file_id) REFERENCES submission_files (submission_file_) (SQL: insert into submission_files (created_at, file_id, file_stage, genre_id, source_submission_file_id, submission_id, updated_at, uploader_user_id) values (2024-07-08 07:41:26, 5, 6, 1, 3041, 3, 2024-07-08 07:41:26, 1))"

Now please guide me on how can I fix this issue?

2

Hi @arharis,

Can you please indicate which specific version (e.g. 3.3.0-17) you’re migrating to and from?

-Roger
PKP Team

3

Hi @rcgillis
I am using OJS 3.3.0.10 previously from where I am trying to export data and import in OJS 3.4.0.5

4

Hi @rcgillis, @OJS-novice @OJS_Darryl @ojs_univie @ojspkpuser @ojs_pacitan @ojsbsb
Can you help me?

5

Hi @arharis,

Please be patient. Support on the PKP Community Forum is provided for free by PKP staff and community members. PKP staff are a small team and need to balance our time spent answering questions here on the Forum with our other work developing and maintaining our free and open source software and other services. We try our best but do not guarantee that every question will be answered or that every issue is resolved.

-Roger
PKP Team

6

Hi @arharis,

due to schema differences, you can’t import XML files that you exported from a lower major version (e.g. 3.3) to a higher version (e.g. 3.4).

The usual way is to carry out an upgrade of the older site first.

1 Like
7

Hi @arharis,

Thank you for tagging me about this error log.

I encountered this error about a month ago, but I was able to resolve it on my own. Being patient and reading through related error messages can be very helpful.

In my case, I did not jump straight to the latest version because my version was several updates behind. I upgraded from OJS 3.3.0.13 to OJS 3.3.4.0.5.

Here’s the process I followed, which you might find useful. However, I recommend reading up on related errors encountered during the upgrade, as it can be challenging:

  1. Upgrade from OJS 3.3.0.13 to OJS 3.3.0.18
  2. Upgrade from OJS 3.3.0.18 to OJS 3.4.0.0
  3. Upgrade from OJS 3.4.0.0 to OJS 3.4.0.1
  4. Upgrade from OJS 3.4.0.1 to OJS 3.4.0.2
  5. Upgrade from OJS 3.4.0.2 to OJS 3.4.0.3
  6. Upgrade from OJS 3.4.0.3 to OJS 3.4.0.4
  7. Upgrade from OJS 3.4.0.4 to OJS 3.4.0.5
  8. Upgrade from OJS 3.4.0.5 to OJS 3.4.0.6
  9. I believe the latest version now is OJS 3.4.0.6.

Throughout this process, I faced many challenges, but it was also quite enjoyable.

Best regards,
Darryl