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

[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

[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

[faglork]

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

[velden]

Extensions -> ListIt2 -> Module Help (top right)-> tab 'Upgrading'...

[faglork]

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?

[uniqu3]

For export/import all fields have to be created, including categories as categories are a field definition since 1.4.x as well.

[faglork]

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

[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.

[faglork]

If you are importing new entries, ignore ID field, like help text on right indicates.

Must have overlooked that one ...

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

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

[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.

[faglork]

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".

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?

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

[faglork]

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

[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.

[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

[Stikki]

Remove templates folders inside instances.