j2xml ... cannot read Access XML

This forum is for general questions about extensions for Joomla! version 1.5.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
romolo
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Mar 01, 2011 9:45 am

j2xml ... cannot read Access XML

Post by romolo » Tue Mar 01, 2011 10:00 am

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

 
User avatar
kenmcd
Joomla! Champion
Joomla! Champion
Posts: 5672
Joined: Thu Aug 18, 2005 2:09 am
Location: California
Contact:

Re: j2xml ... cannot read Access XML

Post by kenmcd » Tue Mar 01, 2011 7:44 pm

.
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
.
██ LibreTraining

User avatar
Greycat
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Jan 07, 2008 3:47 pm
Location: Russia
Contact:

Re: j2xml ... cannot read Access XML

Post by Greycat » Thu Jun 23, 2011 6:12 pm

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
Russian Joomla! support site: http://www.joomlaportal.ru/
Russian Joomla! forum: http://www.joomlaforum.ru/

pyeager
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Aug 14, 2013 12:59 pm

Re: j2xml ... cannot read Access XML

Post by pyeager » Wed Aug 14, 2013 1:08 pm

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!

Alex53
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 236
Joined: Mon Aug 22, 2005 11:25 am

Re: j2xml ... cannot read Access XML

Post by Alex53 » Thu Feb 06, 2014 11:05 am

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.

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6029
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: j2xml ... cannot read Access XML

Post by dpacadmin » Thu Feb 06, 2014 8:26 pm

You should check with your Host to see if there is another setting limiting the file size on your site.

 

Locked

Return to “Extensions for Joomla! 1.5”