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

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?

Hi @arharis,

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

-Roger
PKP Team

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

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

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

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