{"action":"created","issue":{"url":"https://api.github.com/repos/idno/Known/issues/734","labels_url":"https://api.github.com/repos/idno/Known/issues/734/labels{/name}","comments_url":"https://api.github.com/repos/idno/Known/issues/734/comments","events_url":"https://api.github.com/repos/idno/Known/issues/734/events","html_url":"https://github.com/idno/Known/issues/734","id":55616532,"number":734,"title":"imported entities not displaying","user":{"login":"michielbdejong","id":408412,"avatar_url":"https://avatars.githubusercontent.com/u/408412?v=3","gravatar_id":"","url":"https://api.github.com/users/michielbdejong","html_url":"https://github.com/michielbdejong","followers_url":"https://api.github.com/users/michielbdejong/followers","following_url":"https://api.github.com/users/michielbdejong/following{/other_user}","gists_url":"https://api.github.com/users/michielbdejong/gists{/gist_id}","starred_url":"https://api.github.com/users/michielbdejong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michielbdejong/subscriptions","organizations_url":"https://api.github.com/users/michielbdejong/orgs","repos_url":"https://api.github.com/users/michielbdejong/repos","events_url":"https://api.github.com/users/michielbdejong/events{/privacy}","received_events_url":"https://api.github.com/users/michielbdejong/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-01-27T13:20:03Z","updated_at":"2015-02-15T12:21:55Z","closed_at":null,"body":"First of all, thanks for creating the export format with the entities.sql file, that's a great step!\r\n\r\nI imported the entities table for a customer, but the imported posts are not displaying. I updated their URLs and owner URLs using search-and-replace (I had to do an import-and-dump first to get the hexadecimal blobs to turn into text which I can search-and-replace in with a text editor), but that was not helping. I analyzed the MySQL queries, and found out that it is trying to go to metadata for the `access: 'PUBLIC'` part. Looking at [the code](https://github.com/idno/known/blob/master/Idno/Data/MySQL.php#L499), maybe I should just create one entry in the metadata table for each imported entity?"},"comment":{"url":"https://api.github.com/repos/idno/Known/issues/comments/74415304","html_url":"https://github.com/idno/Known/issues/734#issuecomment-74415304","issue_url":"https://api.github.com/repos/idno/Known/issues/734","id":74415304,"user":{"login":"michielbdejong","id":408412,"avatar_url":"https://avatars.githubusercontent.com/u/408412?v=3","gravatar_id":"","url":"https://api.github.com/users/michielbdejong","html_url":"https://github.com/michielbdejong","followers_url":"https://api.github.com/users/michielbdejong/followers","following_url":"https://api.github.com/users/michielbdejong/following{/other_user}","gists_url":"https://api.github.com/users/michielbdejong/gists{/gist_id}","starred_url":"https://api.github.com/users/michielbdejong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michielbdejong/subscriptions","organizations_url":"https://api.github.com/users/michielbdejong/orgs","repos_url":"https://api.github.com/users/michielbdejong/repos","events_url":"https://api.github.com/users/michielbdejong/events{/privacy}","received_events_url":"https://api.github.com/users/michielbdejong/received_events","type":"User","site_admin":false},"created_at":"2015-02-15T12:21:55Z","updated_at":"2015-02-15T12:21:55Z","body":"Do also take care to also run `:%s/http.......oldname.withknown.com/https:\\\\\\/\\\\\\/newname.com/g` (with triple backslashes in that case) on the 'exported_data' file containing the sql statements for adding the entities, then this import method works.\r\n\r\n@pierreozoux @timmmmyboy you may find these commands helpful when doing an import from a customer who came from *.withknown.com or elsewhere. Have you done any successful migrations yet? I just completed my first and second one! :)"}}