Automatically generate menu from existing page tree

[afdev82]

I'm upgrading AlchemyCMS from v4.2.4 to v4.6.2 and since I have a huge menu and many websites, I was searching a way to automatically generate the menu entries from my existing page tree, without having to add each node manually.

Is it already possible to do? I was searching documentation about the menu and I found that this link is broken.

If it's not possible to do it, could you point me in some direction to be able to write a script for that? I think AlchemyCMS should have a method to return the page tree used in the menu and from there maybe I could be able to generate the new nodes for the menus.

Thank you for your support!

[tvdeyen]

Yes, in v4.6 there is a rake task

bin/rake alchemy:convert:page_trees:to_menus

https://github.com/AlchemyCMS/alchemy_cms/blob/4.6-stable/lib/tasks/alchemy/convert.rake#L37

You can find available rake tasks with

bin/rake -T alchemy

[afdev82]

Thank you! I will try that ;)

[tvdeyen]

@afdev82 did it work? If yes, mind to mark the answer? This would help others having the same problem

[afdev82]

Hi @tvdeyen I still have to try that... I hope soon 😅

[afdev82]

It doesn't work...
I dumped my production database and then updated the alchemy gem to 4.6.2.
I run the following:

bin/rake alchemy:upgrade
bin/rake alchemy:convert:page_trees:to_menus

I get this error:

- Converting 12 page trees into menus.
rake aborted!
ActiveRecord::NotNullViolation: PG::NotNullViolation: ERRORE:  valori null nella colonna "site_id" violano il vincolo non-null
DETAIL:  La riga in errore contiene (1, Main Navigation, null, null, f, f, f, null, 1, 2, 0, null, 13, null, null, 2021-02-17 13:09:33.085654, 2021-02-17 13:09:33.085654, null).
: INSERT INTO "alchemy_nodes" ("name", "lft", "rgt", "language_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id"

Caused by:
PG::NotNullViolation: ERRORE:  valori null nella colonna "site_id" violano il vincolo non-null
DETAIL:  La riga in errore contiene (1, Main Navigation, null, null, f, f, f, null, 1, 2, 0, null, 13, null, null, 2021-02-17 13:09:33.085654, 2021-02-17 13:09:33.085654, null).

Tasks: TOP => alchemy:convert:page_trees:to_menus
(See full trace by running task with --trace)

Part of the error is in Italian, but it means that the column `site_id´ contains null values, it has a not null constraint.
I think because the site_id column was added with a later migration and after that the task was not re-checked?
I'll have a look if I'm able to fix the task.

[afdev82]

I managed to fix the task, I opened a PR: #2033