gera3d

I am also looking for the answer to this. Please let me know if you make any progress please post about it here so we can benefit.

• This reply was modified 7 years, 2 months ago by gera3d.

Most of the time we would want to add menu when we import everything else. We can do it after though.

We currently use
https://www.ads-software.com/plugins/really-simple-csv-importer/

This imports all our content other then menus.

Thanks for getting back to me on this and helping me explore this idea.

We have a fairly complex set of menus we put together for each of our clients. Currently, we put all the menu items in a spreadsheet and them Manually build them based on what’s laid out.

Most of the site is built in the spreadsheet then we have to build out menus manually and that just takes allot of time each week.

Here is how we lay them out currently:
https://cl.ly/43400f2V1A0u

They we just do copy paste. We want to lay them out like you see in the link I posted first.
https://u340520947.dl.dropboxusercontent.com/u/340520947/BILL%20Billings%20Oral%20Surgery%20%26%20Dental%20Implant%20Center%20-%20Content.csv

being able to build the menu in a spreadsheet ahead of time would be awesome. As you can see in the link above we already know what all the page names and URLs are going to be ahead of time because we are importing it all together.

If this is something you are are interested in developing we would be really interested in buying it.

We don’t export. We build all the data manually and then import it into the site.

Sample:
https://u340520947.dl.dropboxusercontent.com/u/340520947/BILL%20Billings%20Oral%20Surgery%20%26%20Dental%20Implant%20Center%20-%20Content.csv

The problem with menus is that it links into the database in a bunch of different ways.

Can you give me any leads I can follow? Do you know of anything that does menu importing from a spreadsheet?

I also have this issue. A solution would be greatly appreciated.

You got it. Thanks for getting on it so fast. 5 stars coming your way.

Ok you are awesome! that fixed it.

It seems like it stopped working at the start of the month and just started working again about a week ago.

Currently I just updated all the plugs+Core+ theme and hope that just fixed it. I was just wondering if any know issues existed.

ok I have been at it for a bit and here is what I got. What am I missing?

Sample:
https://dl.dropboxusercontent.com/u/340520947/import_menu_sample_v8.csv

Any help would be greatly appreciated.

Ok I think I found all the row names but I am not sure how to first create a menu then add the items to it.

Would one of the rows have this
post_title –> News
post_status –> publish
post_type — > nav_menu_item

Now a new row with the menu items?
How do the menu items know they are part of the menu above?

// Insert new nav_menu_item
$nav_item = wp_insert_post(array(‘post_title’ => ‘News’,
‘post_content’ => ”,
‘post_status’ => ‘publish’,
‘post_type’ => ‘nav_menu_item’));

add_post_meta($nav_item, ‘_menu_item_type’, ‘post_type’);
add_post_meta($nav_item, ‘_menu_item_menu_item_parent’, ‘0’);
add_post_meta($nav_item, ‘_menu_item_object_id’, $page);
add_post_meta($nav_item, ‘_menu_item_object’, ‘page’);
add_post_meta($nav_item, ‘_menu_item_target’, ”);
add_post_meta($nav_item, ‘_menu_item_classes’, ‘a:1:{i:0;s:0:””;}’);
add_post_meta($nav_item, ‘_menu_item_xfn’, ”);
add_post_meta($nav_item, ‘_menu_item_url’, ”);

Here is a sample I am working on. What am I doing wrong?
https://dl.dropboxusercontent.com/u/340520947/import_menu_sample.csv

Thanks for the reply.

Here is what I found:
https://dl.dropboxusercontent.com/u/340520947/Screen%20Shot%202016-09-08%20at%201.05.35%20PM.png

It seems like you need the post_id ahead of time. Is there a way to just give it the path you want it to use?

Example:
/New-Page

We know what all the post names are going to be so creating the link in the spreadsheet level would be awesome.

Your the man. Thanks for the quick reply.

It worked for me. I am not sure if it created any other issues but I can tell you this for sure.

I was on older version –> Worked
I updated –> Links disappeared
I install this your new version –> Saw the links again.

I hope that helps. We are pushing new code to like 15 sites and your plug is core to how we sort our content. Any timeline on making the new version live?

Thanks for what you do your work is greatly appreciated! Your doing a great job.