I’ve tried to add the Source Name and Source URL by importing straight from old site into my new site on MySQL Azure server. They did not appear on the posts. On investigation as to why I note that when manually adding the URL name and URL Url that it has the codes “s:3” or “s:7” before the Source Name, and “s:20” or “s:43″ before the URL. See below samples.
Post 29000: –
a:2:{s:9:”td_source”;s:3:”Official Site”;s:13:”td_source_url”;s:20:”http://www.starwars.com/news/6-reasons-we-still-love-the-star-wars-shadows-of-the-empire-game”;}
Post 29191:-
a:2:{s:9:”td_source”;s:7:”YouTube”;s:13:”td_source_url”;s:43:”https://www.youtube.com/watch?v=8ogmQUxWegk”;}
Post 29188: –
a:2:{s:9:”td_source”;s:3:”Official Site”;s:13:”td_source_url”;s:20:”http://www.starwars.com/news/6-reasons-we-still-love-the-star-wars-shadows-of-the-empire-game”;}
Is their a convention I need to follow to have the theme recognise my Source Names and URLs? i.e. certain names must have s:3 before them.?
Hello brianjcameron,
It seems that your Source Name&Source URL are serialized from your database and if you want to add them in the new database you will have to unserialize. Please notice that is not an easy way to do and if you are not aware of the steps which you needed to take in this regard, please consider hiring a freelancer/developer to help you because we cannot provide customization services at the moment and this type of task is not covered by our support -> no theme related, sorry! For more references in this regard, you can check the following links, like this -> http://php.net/manual/en/function.unserialize.php and here -> http://stackoverflow.com/questions/6819487/unserialize-data-of-database
Hope this helps!
Thanks for your understanding!
Thanks for your response, based off of it i found a plugin called AllImport that allows import with serialisation.
I could import to the td_post_theme_settings field, then serialise map the key td_source to my Source Name and td_source_url to my Source URL.
Leaving this details here for anyone else who may encounter similar issue.
Hello brianjcameron,
Thank you for your message and this could be more useful for our clients.
