Easy way to import metadata into Drupal 7?
-
We have to update the metadata for a drupal 7 website. We've already written them all out, and know exactly what URL they should go to. But I don't want to waste the client's money by spending any more time than is necessary on uploading the information to the site.
Is there a way to upload the information that isn't manual?
-
Thanks for the reply.
We ended up doing it manually, as we only had a few hundred pages to update. But I am going to keep this in my back pocket in case we run into the same issue with another client. Thanks again!
-
The only way that I am aware of would be to create a spreadsheet that matches the format of the metatag table in your database then creating a pattern using concatenation. The result would be an output to your data field that looked like - a:1:{s:11:"description";a:1:{s:5:"value";s:53:"This is a change for testing purpose in the database.";}}
I sure would not attempt this on a live site and if you dont have a sandbox set up for it already it might not be worth your time.
Another danger in uploading it would be how the cache_metatag table would be influenced.
Overall, unless you have thousands and thousands of entities I would do it the manual way.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Use H2 or H3 for Six Ways to Hip Thrust https://www.fitness-china.com/hip-thrust
Our article about Hip Thrust https://www.fitness-china.com/hip-thrust We have sex tips about how to hip thrust. that use h2. but Final Words use h3 or h2?
On-Page Optimization | | ahislop5740 -
Best Way to Handle Multi-Language Sites
In the last year we've made a few significant changes to the structure of our site - namely adding translations for a few languages. We have historically been gaining in organic search by about 10% each month, but in the last two months we've leveled out and seen a slight dip. I am wondering if this has something to do with the addition of the second language, and namely if there's a chance we've been penalized due to duplicate content. We have almost all pages / content on the site translated by a translator, but the way the development works the site will grab the english version if a translation hasn't been added - potentially adding some duplicate content? The URL structure remains the same, other than the addiion of the language - site.com/our-tour vs site.com/de/our-tour We also haven't translated the tour name itself, so that remains the same. Just wondering if anyone has any feedback on best practices here or things I should be looking out for. Thanks in Advance.
On-Page Optimization | | mkgreyound1 -
Best way to separate blogs, media coverage, and press releases on WordPress?
I'm curious what some of your thoughts are on the best way to handle the separation of blog posts, from press releases stories, from media coverage. With 1 WordPress installation, we're obviously utilizing the Posts for these types of content. It seems obvious to put press releases into a "press release" category and media coverage into a "media coverage" category.... but then what about blog posts? We could put blog posts into a "blog" category, but I hate that. And what about actual blog categories? I tried making sub-categories for the blog category which seemed like it was going to work, until the breadcrumbs looked all crazy. Example: Homepage > Blog > Blog > Sub-Category Homepage = http://www.example.com First 'Blog' = http://www.example.com/blog Second 'Blog' = http://www.example.com/category/blog Sub-Category = http://www.example.com/category/blog/sub-category This just doesn't seem very clean and I feel like there has to be a better solution to this. What about post types? I've never really worked with them. Is that the solution to my woes? All suggestions are welcome! EDIT: I should add that we would like the URL to contain /blog/ for blog posts /media-coverage/ for media coverage, and /press-releases/ for press releases. For blog posts, we don't want the sub-category to be in the URL.
On-Page Optimization | | Philip-DiPatrizio0 -
Is there a way to tell Google a site has duplicated content?
Hello, We are joining 4 of our sites, into 1 big portal, and the content from each site gonna be inside this portal and sold as a package. We don't wanna kill these sites we are joining at this moment, we just wanna import their content into the new site and in a few months we will be killing them. Is there a way to tell Google to not consider the content on these small sites, so the new site don't get penalised? Thanks,
On-Page Optimization | | darkmediagroup0 -
I'm ranking Position 7,8,11,12,13,14 &15 but would rather one page top three - are they competing?
For the search phrase "office design birmingham" in the uk. I have mutiple pages ranking in position 7,8,11,12,13,14 & 15! This is all very well but are they somehow competing? Am i better off doing something different to get one or two into the top 3 rather than 7 in the top 15?! Many thanks for your opinion and advice. James
On-Page Optimization | | bizint0 -
Am I cannabalizing my title tags or is there a better way?
I've read some info about title tags and meta, and I'm getting a little confused. If there is a previous discussion that I've missed, please redirect me. thank you. So I have a locksmith and one of his pages is on Auto Locksmith. For every car, I have a page. i.e Acura, Audi, BMW etc. Here is my title tag: Acura Car Keys| Ignition Switch Repair| Key Duplication BMW Car Keys| Ignition Switch Repair| Key Duplication Same for the rest of the different car models on the site. I previously asked a question on here about "What is Cannibalization", and after reading the answer, as well as a full article about it, I think I may be potentially cannibalizing my site with these title tags, though my SEO Moz has not indicated that I am. Should my title tags be instead... Acura car keys| Acura Ignition Switch Repair| Acura Key Duplication for each vehicle page? Additionally, all the Meta Descriptions on each vehicle page read the same as well. Is this correct? We duplicate Acura car keys, repair ignition switches, extract broken keys, replace remotes, reprogram transponder keys and provide emergency locksmith srvc. Lastly, this is for a city, yet I have not placed the city modifier in my tags nor content. Somehow it knows what city I'm in because some of my pages are ranking on Page 1, however other pages are ranking like #188, #257...So I'm just confused. Thanks for any help you can provide. Jaye
On-Page Optimization | | jayestovall0 -
Best Way To Host Images For Image Optimization
I need an image optimization expert to tell me whether or not we are hosting images properly for SEO. Currently, we upload all images to Picasa and then call them out with a webpart in our content management system. See example here - http://www.tennisnow.com/Photos/2011-BNP-Paribas-Open-Day-5.aspx Here's an example of the url that is attached to each image - http://lh5.ggpht.com/_1Oyc-Zgkrpk/TX5H-Pfyd7I/AAAAAAAARbc/nG3Cw-G5tsY/s400/1215548409_FU9xA-L.jpg We have a lot of images, and we've hosted them on Picasa for speed purposes based on a recommendation from our developer (makes the pages load faster). I've read that Google can now factor page load time into its ranking parameters. We are not seeing the images from each photo gallery being indexed on images.google.com. We are torn. What should we do to rank for these images?
On-Page Optimization | | tennisexpress0 -
Importance of Keyword density?
Short, Sweet and easy for you guys!! How important is keyword density??? Cheers
On-Page Optimization | | wazza19850