Page 1 of 2

[solved]Listit2 Update 1.3.2-1.4.1: lost category tabs /cats

Posted: Mon Jun 16, 2014 3:46 pm
by faglork
Hi!

I just updated a Listit2 1.3.2 module to 1.4.1

Now I am missing the category tabs in all instances. The database still holds all categories.

Any ideas? Do I have to explicitely "switch on" the categories somewhere?

Cheers,
Alex

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

Posted: Mon Jun 16, 2014 3:58 pm
by Jo Morg
Not sure if it solves but:
  1. clear cache;
  2. I believe there is a scan fields, or rescan fields on the main module, that should be used after an upgrade (confirm in module help);
HTH

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

Posted: Mon Jun 16, 2014 4:07 pm
by faglork
Jo Morg wrote:Not sure if it solves but:
  1. clear cache;
  2. I believe there is a scan fields, or rescan fields on the main module, that should be used after an upgrade (confirm in module help);
HTH
Did both. No change.

I looked at the database, and in the "cms_module_listit2myinstance_category" table all categories had a NULL in the "active" column, so I set it manually to "1". Didn't help.

Also, in the "cms_module_listit2myinstance_category" table the 1.3.2 database had no fields for create_date and modified_date, so these are NULL. Do I need to populate them?

Cheers,
Alex

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

Posted: Mon Jun 16, 2014 7:18 pm
by velden
Extensions -> ListIt2 -> Module Help (top right)-> tab 'Upgrading'...

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

Posted: Mon Jun 16, 2014 7:45 pm
by faglork
velden wrote:Extensions -> ListIt2 -> Module Help (top right)-> tab 'Upgrading'...
Aaah ... I misunderstood the sentence.

I re-created the "Category" field definition and there they are!

Sometimes you don't see it when it is right before your eyes ...

Thank you!
Alex

PS: When I export/import 1.4.1 databases, do the category field definitions get created? Or do I have to do it manually?

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

Posted: Tue Jun 17, 2014 9:50 am
by uniqu3
For export/import all fields have to be created, including categories as categories are a field definition since 1.4.x as well.

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

Posted: Tue Jun 17, 2014 3:24 pm
by faglork
uniqu3 wrote:For export/import all fields have to be created, including categories as categories are a field definition since 1.4.x as well.
Thanks for clarification.

Well, I created all fields and all categories, same as in original instance.

Tried to import the database from CSV ... failed.

I can match all fields in the import dialog, with the exception of "modified_date". This does not show in the list of fields to match (in the list of fields to match_to it shows).

I guess thats the reason nothing gets imported. I checked the CSV file: the "modified_date" field is there.

Any ideas?

Cheers,
Alex

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

Posted: Tue Jun 17, 2014 5:00 pm
by Stikki
If you are importing new entries, ignore ID field, like help text on right indicates.

Created and Modified are created up on import, so you don't even have change to affect these. If you think this should be there, please fill feature requests, i'll consider it if i think it's necessary.

IIRC only ISO8895-1 encoded file is accepted in import, might lack memory tho.

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

Posted: Tue Jun 17, 2014 5:27 pm
by faglork
Stikki wrote:If you are importing new entries, ignore ID field, like help text on right indicates.
Must have overlooked that one ...
Stikki wrote:Created and Modified are created up on import, so you don't even have change to affect these. If you think this should be there, please fill feature requests, i'll consider it if i think it's necessary.
No, it is ok as it is ...
Stikki wrote:IIRC only ISO8895-1 encoded file is accepted in import, might lack memory tho.
I exported the CSV from a Listit2 1.4.1 instance. I did not see any options for encoding. Where do I set encoding in Listit2 1.4.1 export?

Best regards,
Alex

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

Posted: Tue Jun 17, 2014 5:29 pm
by Stikki
Are we talking about item export/import or module export/import?

You don't set it on export or import, you save it with certain encoding.

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

Posted: Wed Jun 18, 2014 3:26 pm
by faglork
Stikki wrote:Are we talking about item export/import
In every 1.4.1 instance, there is a link at the bottom "export items". I use this to export as CSV.
Likewise, in every 1.4.1 instance, there is a link at the bottom "import items". I use this to import the CSV I just exported (see above).

So I guess it is "item export/import".
Stikki wrote:or module export/import?
Module export? my listit2 1.4.1 module under "Extensions" does not offer export/import. Is it incorrectly installed?

EDIT: Just ckecked all my other 1.4.1 installs - none offers "module export". Do I have to activate this somewhere? The module help does not mention "module export/import".

Where would I find "module export/import"? What exactly does that mean? i.e. what gets exported?
Stikki wrote: You don't set it on export or import, you save it with certain encoding.
In the Windows "Save" dialogue, there is no option to chose encoding ...
How can I set encoding? Do I have to open the CSV with an editor and explicitely save as ISO before I can import it? This should be mentioned in the module help ...

I am a bit confused now ... is there a documentation on exporting / importing? I did not find it in the module help.

Cheers,
Alex

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

Posted: Wed Jun 18, 2014 3:36 pm
by faglork
Stikki wrote:If you are importing new entries, ignore ID field, like help text on right indicates.
Well, this did it. Import seems to have worked.
Will check database and compare with original database.

Cheers,
Alex

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

Posted: Wed Jun 18, 2014 3:47 pm
by faglork
Well, did'nt really work.

There are fields with HTML code containing double quotes (textarea with wysiwyg), so this breaks the import when you use the standard enclosing character, which happens to be double quotes. For future versions of ListIt2: May I suggest using a different default enclosing character? I think wysiwyg areas are quite common.

What enclosing character would you suggest? Would the pipe symbol "|" work?

Cheers,
Alex

PS: I suggest adding a tab "Import/Export" to the module help, as this is obviously not that easy. I will gladly help with the wording, if you want.

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

Posted: Wed Jun 18, 2014 3:58 pm
by faglork
Just noticed that the "delete marked items" button is missing. This means that I have to delete all items one by one ... :-(

I checked three other 1.4.1 installs - none shows the "delete marked items" button. Does this have to be activated somewhere? It is not a permissions question, as I am admin user.

Cheers,
Alex

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

Posted: Wed Jun 18, 2014 4:46 pm
by Stikki
Remove templates folders inside instances.