make exporter for fabrik2.1 -> fabrik3

[pollen8]

I think we will need to make a small exporter component that will grab the database tables in question and alter them for fabrik3
We already have the start of the sql in the admin folder
Component would need to make a backup of the tables
It would need to alter the core db tables
See if there are any repeat groups and create the joined db talbes and split out the data in to those tables and update jos_fabrik_group record to set is_join = 1 and add join entry in jos_fabrik_joins
Any data using groupslitter would need to be json encoded instead

[pollen8]

dont think js events are imported - should be looking at the code though

[pollen8]

element - repalce with icons as this has changed need to check if folder selected in f2 and set to true for f3

[felixkat]

I've never used the 'icons' option but noticed after an upgrade that some of the upgraded elements set 'icons' as a default of yes.

Something maybe to consider.

[pollen8]

where they elements that had the icon option set in fabrik 2?

[felixkat]

Nope, I've never used the option before.

Now that I have my local server setup I'll re-run the test with before and after examples.

Watch this space! :)

[felixkat]

********** Placing comments per issues to keep it neat ***********

administrator / components / com_fabrik / models / upgrade.php

The array of mysql statements are running through the loop but nothing is executing them.

Inserting $db->setQuery($q); near line 132 resolves this.

[felixkat]

********** Placing comments per issues to keep it neat ***********

Around line 78 comment says //only do this if the attribs are not already in json format

So I think around line 83

if ($row->published == 0) {
$row->published = -2;
}

Should still be state because it's still in the old format?

if ($row->state == 0) {
$row->state = -2;
}

The SQL routine will change state -2 to published -2 if necessary later on..... I think... ;)

[felixkat]

Latest updates

http://fabrikar.com/forums/showpost.php?p=129369&postcount=27