# Xml import error

**URL:** <https://forum.pkp.sfu.ca/t/xml-import-error/89421>\
**Category:** Software Support\
**Tags:** ojs3, xml, import, export, locale\
**Created:** [July 9, 2024, 3:27pm UTC](https://forum.pkp.sfu.ca/t/xml-import-error/89421 "2024-07-09T15:27:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![arharis](https://forum.pkp.sfu.ca/user_avatar/forum.pkp.sfu.ca/arharis/32/33403_2.png) [@arharis](https://forum.pkp.sfu.ca/u/arharis)\
**Post date:** [July 9, 2024, 3:27pm UTC](https://forum.pkp.sfu.ca/t/xml-import-error/89421/1 "2024-07-09T15:27:43Z")

</div>

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

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](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 88 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 218 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 393 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 533 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 653 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 775 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 879 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 979 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 1143 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 1290 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Line 1404 Column 0: Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Validation errors:  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](http://pkp.sfu.ca/)}publication’, attribute ‘locale’: The attribute ‘locale’ is not allowed.  
Element ‘{[http://pkp.sfu.ca](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?

---

<div class="post-metadata">

**Author:** ![rcgillis](https://forum.pkp.sfu.ca/letter_avatar/rcgillis/32/5_5575768a8748004e209b776fc1b2916d.png) [@rcgillis](https://forum.pkp.sfu.ca/u/rcgillis)\
**Post date:** [July 9, 2024, 5:19pm UTC](https://forum.pkp.sfu.ca/t/xml-import-error/89421/2 "2024-07-09T17:19:08Z")

</div>

Hi @arharis,

You’ve already posted about this here:

> [@Facing Issue in data import from old journal site to new site](https://forum.pkp.sfu.ca/t/facing-issue-in-data-import-from-old-journal-site-to-new-site/89392):
>
> 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:/…](http://pkp.sfu.ca)

Do not post duplicate posts on the forum as it clutters the forum (this goes against our guidelines).

I will close down this post - but please continue to post to the other thread if you have updates.

-Roger  
PKP Team

---

<div class="post-metadata">

**Author:** ![rcgillis](https://forum.pkp.sfu.ca/letter_avatar/rcgillis/32/5_5575768a8748004e209b776fc1b2916d.png) [@rcgillis](https://forum.pkp.sfu.ca/u/rcgillis)\
**Post date:** [July 9, 2024, 5:19pm UTC](https://forum.pkp.sfu.ca/t/xml-import-error/89421/3 "2024-07-09T17:19:16Z")

</div>


