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