Can't see media files in back office following FTP upload to Azure
I'm running Umbraco 7.2.5 on an Azure Web App, I've transferred some existing media files to the media folder via FTP (these are from on premise server that's being migrated to Azure) having already moved the content as package.
I've done this many times before on Umbraco 6 and the files would show up, is 7 different?
What I've tried so far:
Republished the entire site
Rebuilt the examine indexes from the Developer tab
Deleted the contents of the app_data folder to force a clean rebuild of the cache
Any ideas on what else can be done to get them to show up?
Update
Just dawned on me that as I've done a clean install and added the content as a package that the references to the media don't exist in the database which is why they are not showing. Normally when I copy from one to another the references already exist.
New Question
What's the best way of migrating the media from one installation to another whilst keeping the references intact. Initial thoughts are to script the references via SQL so I retain the media id's.
Any suggestions?
Update 2
I've gotten all the media file references as a csv from the db using the following SQL
select *
FROM cmsPropertyData
INNER JOIN cmsPropertyType ON cmsPropertyData.propertytypeid = cmsPropertyType.id
WHERE cmsPropertyType.dataTypeId = -90
And I was planning to build a Insert script along the lines of
The INSERT statement conflicted with the FOREIGN KEY constraint "FKcmsPropertyDataumbracoNode_id". The conflict occurred in database "test-db", table "dbo.umbracoNode", column 'id'.
So clearly just inserting into the one table isn't going to work, anyone able to point me in the right direction to get round this.
Can't see media files in back office following FTP upload to Azure
I'm running Umbraco 7.2.5 on an Azure Web App, I've transferred some existing media files to the media folder via FTP (these are from on premise server that's being migrated to Azure) having already moved the content as package.
I've done this many times before on Umbraco 6 and the files would show up, is 7 different? What I've tried so far:
Any ideas on what else can be done to get them to show up?
Update
Just dawned on me that as I've done a clean install and added the content as a package that the references to the media don't exist in the database which is why they are not showing. Normally when I copy from one to another the references already exist.
New Question
What's the best way of migrating the media from one installation to another whilst keeping the references intact. Initial thoughts are to script the references via SQL so I retain the media id's.
Any suggestions?
Update 2
I've gotten all the media file references as a csv from the db using the following SQL
And I was planning to build a Insert script along the lines of
The INSERT statement conflicted with the FOREIGN KEY constraint "FKcmsPropertyDataumbracoNode_id". The conflict occurred in database "test-db", table "dbo.umbracoNode", column 'id'.
So clearly just inserting into the one table isn't going to work, anyone able to point me in the right direction to get round this.
is working on a reply...