Page 1 of 1

j2xml ... cannot read Access XML

Posted: Tue Mar 01, 2011 10:00 am
by romolo
Hey All,

I tried to import content into Joomla 1.5. I am trying only a single record as a test as I got problems.

When I try to import it says:

File format unknown. Impossible to import file.

I have exported this file from Access 2010 using XML export.

Does anyone know if I have to set special options or do more once the file is out of Access before I import using J2XML.

Thanks in advance

R

Re: j2xml ... cannot read Access XML

Posted: Tue Mar 01, 2011 7:44 pm
by kenmcd
.
J2XML is designed to import XML files that have been exported with J2XML.
The idea is to facilitate transferring content, users, etc. between Joomla websites.
The error you are getting is because J2XML does not recognize the format of the XML file you are importing.

It is possible you could format the XML file properly so J2XML could import it.
You can download the J2XML XML file specification here (at the bottom of the menu):
http://www.eshiol.it/en/joomla/j2xml/j2xml-1503.html
This is the direct download link:
http://www.eshiol.it/j2xml/1505/j2xml.dtd
.

Re: j2xml ... cannot read Access XML

Posted: Thu Jun 23, 2011 6:12 pm
by Greycat
romolo wrote:Hey All,

I tried to import content into Joomla 1.5. I am trying only a single record as a test as I got problems.

When I try to import it says:

File format unknown. Impossible to import file.

I have exported this file from Access 2010 using XML export.

Does anyone know if I have to set special options or do more once the file is out of Access before I import using J2XML.

Thanks in advance

R
If it still actual.

You need to change php.ini settings, like that:

post_max_size = 8M
upload_max_filesize = 8M

Re: j2xml ... cannot read Access XML

Posted: Wed Aug 14, 2013 1:08 pm
by pyeager
Thanks, Greycat!

I was trying to import into 2.5.15 from 1.5.x, and was getting the invalid file format error on one of the files. Sure enough, the file was over 2 MB, which was the upload limit in php.ini.

I upped it to 8 MB, restarted Apache, and the import worked!

Re: j2xml ... cannot read Access XML

Posted: Thu Feb 06, 2014 11:05 am
by Alex53
I am getting the same error.

My php.ini allwos files up to 40mb.

I exported with J2XML, the file was 22mb.

I tried importing into Joomla 3, got;

Code: Select all

1 - internal error at line 12764
5 - Extra content at the end of the document at line 12765
File format unknown. Impossible to import file.
I tried into Joomla 2.5, same error.

I tried redoing the export and tried again. Same error.

In both cases the 1.5 importer plug-in is installed and enabled.

EDIT: I have tried re-exporting with block size 2000 instead of the default 1000 and with compression ON. Same result.

Re: j2xml ... cannot read Access XML

Posted: Thu Feb 06, 2014 8:26 pm
by dpacadmin
You should check with your Host to see if there is another setting limiting the file size on your site.