Easy way to import metadata into Drupal 7?

[ZephSnapp]

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?

[ZephSnapp]

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!

[mikeusry]

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.