joomfish import problem

Welcome, Guest
Please Login or Register. Lost Password?

Jolomea

Bugs and issues

Miscellaneous

(1 viewing) (1) Guest

Page: 12

TOPIC: joomfish import problem

Forum Tools

joomfish import problem 1 Year, 12 Months ago Karma: 1

Hi,

first of all thanks for your component. I think this is very usefull.

I just try to use it in combination with joomfish to export xliff data of the content, because I want to hand it over to an 3rd party translation office.

So I test the export and it works fine (at least as far as I can see).
Then I try to make some changes and re-import it via jolomea ->joomfish ->Translation group content import (I try both target languages de-DE and EN-GB).

but I always got this error Message:

Code:

Warning: Invalid argument supplied for foreach() in /is/htdocs/wp1032249_Y0KZT22LN7/www/neu/en/administrator/components/com_jolomea/handlers/jolomeaJoomfish.php on line 202

File access error

This error also appears if I just export it and re-import it right away.

Do you have any Idea what´s going wrong?

Regards
Nico

nico

Fresh Boarder

Posts: 1

The administrator has disabled public write access.

#10

Re:joomfish import problem 1 Year, 8 Months ago	Karma: -1
Hi, I think i fixed this bug in the 0.0.6 release. Can you confirm it is ok for you now ? Thx in advance Regards Antoine

antoine.tissier

Admin

Posts: 9

The administrator has disabled public write access.

#14

Re:joomfish import problem 1 Year, 8 Months ago Karma: 1

This error is still present in 0.0.6 and occurs if no translations exist in the target language.

I did a quick fix by changing the code from line 202 to 231 from:

Code:

		foreach($existing_list as $e){

									

			$update_array[$e] = $value;

									

			$reference_id = intval($e); 

			

			$keys = explode('_',$e);

			unset ($keys[0]);

			

			

			$reference_field = implode('_',$keys);

			

			if (!empty($query)){

				$query.=',';

			}

			

			$query .="(".$reference_id.",".$database->Quote($reference_field).",".$database->Quote($array[$e]).")";					

		}

									

		$query = 'INSERT INTO #__jf_content_jolomea VALUES '.$query;

				

		$database->setQuery($query);

		$database->query();



		$database->setQuery('UPDATE #__jf_content, #__jf_content_jolomea set modified_by='.$modified_by.' ,modified=now()
,#__jf_content.`value`=#__jf_content_jolomea.`value` where #__jf_content_jolomea.reference_id=#__jf_content.reference_id and #__jf_content_jolomea.reference_field=#__jf_content.reference_field and #__jf_content.reference_table='.$database-
>Quote($reference_table)." and #__jf_content.language_id=".$language_id );

		$database->query();

Code:

if(count($existing_list) > 0)

		{

			foreach($existing_list as $e)

			{

										

				$update_array[$e] = $value;

										

				$reference_id = intval($e); 

				

				$keys = explode('_',$e);

				unset ($keys[0]);

				

				

				$reference_field = implode('_',$keys);

				

				if (!empty($query)){

					$query.=',';

				}

				

				$query .="(".$reference_id.",".$database->Quote($reference_field).",".$database->Quote($array[$e]).")";					

			}

										

			$query = 'INSERT INTO #__jf_content_jolomea VALUES '.$query;

					

			$database->setQuery($query);

			$database->query();

	

			$database->setQuery('UPDATE #__jf_content, #__jf_content_jolomea set modified_by='.$modified_by.' ,modified=now()
,#__jf_content.`value`=#__jf_content_jolomea.`value` where #__jf_content_jolomea.reference_id=#__jf_content.reference_id and #__jf_content_jolomea.reference_field=#__jf_content.reference_field and #__jf_content.reference_table='.$database-
>Quote($reference_table)." and #__jf_content.language_id=".$language_id );

			$database->query();

		}

There is another misbehavior (I think). If you import content in to a target language where translations exist. The existing translations get not modified in the Db but the importer add's new rows to the jfcontent database table. The result is a messed up jfcontent table with double translations. If you - for example - delete one of the double translations of an article within the Joom!Fish admin you will lose all translations of that article because all translations have the same id.

carsten

Fresh Boarder

Posts: 4

The administrator has disabled public write access.

#15