Page 2 of 2

Re: Listit2 Update 1.3.2->1.4.1: lost category tabs

Posted: Wed Jun 18, 2014 4:55 pm
by faglork
Stikki wrote:Remove templates folders inside instances.
This is a clean install of 1.4.1 ... there are no templates folders inside the instances folder. Just
/images
nothing else.

/templates folders exist in my old 1.2 installs.

Cheers,
Alex

Re: Listit2 Update 1.3.2->1.4.1: lost category tabs

Posted: Wed Jun 18, 2014 4:57 pm
by Stikki
It's in dropdown?

Blind or something?

Re: Listit2 Update 1.3.2->1.4.1: lost category tabs

Posted: Fri Jun 20, 2014 10:34 am
by faglork
Stikki wrote:It's in dropdown?

Blind or something?
I know the option "delete" is in the dropdown. I did not talk about the dropdown. There is NO BUTTON to start the action.

There is a button "save order" which does nothing when I select "delete".

Here is a screenshot:

Image

This is the case in all my 1.4.1 installs.

Cheers,
Alex

Re: Listit2 Update 1.3.2->1.4.1: lost category tabs

Posted: Fri Jun 20, 2014 10:42 am
by uniqu3
When you choose "Delete" from dropdown, a confirmation dialog will appear, asking if you are sure you want to delete selected items.
If dialog doesn't appear then please open JS console in Developer Tools (whatever browser you are using, in example usually F12 key) and check if there is some JS error.

Re: Listit2 Update 1.3.2->1.4.1: lost category tabs

Posted: Fri Jun 20, 2014 7:18 pm
by faglork
uniqu3 wrote:When you choose "Delete" from dropdown, a confirmation dialog will appear, asking if you are sure you want to delete selected items.
If dialog doesn't appear then please open JS console in Developer Tools (whatever browser you are using, in example usually F12 key) and check if there is some JS error.
Aaah ... switching from Firefox to Chrome did it. Thank you very much!

I then exported the original Listit2 Clone database again, this time using the "|" as enclosing character (in order to avoid conflicts with HTML code from wysiwyg text areas), imported with same setting, and lo and behold - the import worked ... at least for the items.

Sadly, the categories were not imported. The categories exist in the new instance, same names, same aliases. But all items have set category to "none" :-(

Any ideas how to fix that? This is the LAST obstacle, everythiong else works now, there must me a solution ...

EDIT: Just checked the CSV - Categories get exported as IDs, not as names or aliases. Is this correct?

This CANNOT work, since the IDs are different.

Is there a way to match IDs? Would it work if I maually matched the IDs in the CSV file?

Cheers,
Alex

Re: Listit2 Update 1.3.2->1.4.1: lost category tabs

Posted: Tue Jun 24, 2014 9:06 am
by faglork
faglork wrote:
Sadly, the categories were not imported. The categories exist in the new instance, same names, same aliases. But all items have set category to "none" :-(

Any ideas how to fix that? This is the LAST obstacle, everythiong else works now, there must me a solution ...

EDIT: Just checked the CSV - Categories get exported as IDs, not as names or aliases. Is this correct?

This CANNOT work, since the IDs are different.

Is there a way to match IDs? Would it work if I maually matched the IDs in the CSV file?
Well, here is the answer: It works.

I manually matched the category IDs in the CSV file to the new category IDs in the target Listit2 instance.

So here is the solution to export / import listit2 1.4.1 databases:

1) if you are using wysiwyg fields, on export, you MUST change the "enclosing" character to something else than the default double quotes ("). I suggest the pipe symbol "|".
Tipp for the developers of listit2: Make that the default. Or at least explain it in the module help. If you want, I write the text for you.

2) In the target system, create an identical instance. Same name, same fields, same categories. Same aliases.

3) if you are using categories, you MUST match the "old" category IDs in the CSV file to the "new" category IDs in the target system (You see the IDs when you hover the mouse over the category link in the "Categories" tab). You need an editor to do that, and it is a bit tricky, because you can't just search/replace ID numbers. The trick is to s/r the ID numbers including the enclosing characters AND the character for "new line", since the category field is at the end of the line. This ensures that only the values in the category field get replaced.
EDIT: be careful, you can't just make a simple s/r ... eg.:
id 2-->5
id 3-->7
id 5-->8 <-- see? now you change all former 2 to 8

4) import the corrected CSV using the "|" symbol as enclosing character. Match all fields with the exeption of the ID field.


(BTW: Export/Import with 1.3.2->1.3.2 is possible, too, but you need to do it in SQL and it is somewhat complicated.)

Cheers,
Alex