Search

Vlad Polonskiy added a comment - 16/Feb/2024 3:06 PM - edited This is the Confluence On-Prem DB SQL that Atlassian asks clients to run in order to help them to map page IDs. Then Atlassian asks to attach resulting CSV. Knowledge is from current migration effort.  SELECT c.title, 2 c.contentid, 3 s.spacekey 4FROM content c 5JOIN spaces s ON s.spaceid=c.spaceid 6WHERE c.contenttype= 'PAGE' 7 AND c.prevver IS NULL 8 AND c.content_status= 'current' 9 AND c.title !='' 10 AND c.title IS NOT NULL 11ORDER BY s.spacekey, c.title;

Bhavana V added a comment - 08/Nov/2023 12:16 PM https://getsupport.atlassian.com/browse/MOVE-146416

Daniel Serkowski added a comment - 17/Oct/2023 11:04 AM Hey a5da1a1190d2 , 1. If you finished the links migration process (post-migration task) recently, our support team can assist you in exporting audit logs in CSV format ( as this feature is not yet public ). The exported CSV files will contain all changes made from old to new links. Here's a small sample of such a file:  "Link update ID" , "Date" , "Author" , "Changed object" , "Operation details" , "Data" "951ae2f3-0243-49d0-8651-c32d365fbe05" , "2023-09-19T01:59:11Z" , "admin@example.com" , "Comment" , "Updated link from 'instenv-127401-t5no.instenv.internal.atlassian.com/browse/PFG1-25' to 'atl-fbl-e2e-test-1.jira-dev.com/browse/PFG1-25' " , " Object ID: 49905665" "951ae2f3-0243-49d0-8651-c32d365fbe05" , "2023-09-19T01:59:11Z" , "admin@example.com" , "Comment" , "Updated link from 'instenv-127401-t5no.instenv.internal.atlassian.com/browse/PFG1-24' to 'atl-fbl-e2e-test-1.jira-dev.com/browse/PFG1-24' " , " Object ID: 49905665" "52899e2a-6b59-4162-9a56-79632a0f5503" , "2023-09-19T02:02:10Z" , "admin@example.com" , "Page" , "Updated link from 'instenv-115260-kqga.instenv.internal.atlassian.com/pages/viewpage.action?pageId=1638697' to 'atl-fbl-e2e-test-1.jira-dev.com/wiki/pages/viewpage.action?pageId=33292689' " , " Object ID: 49873149" "52899e2a-6b59-4162-9a56-79632a0f5503" , "2023-09-19T02:02:10Z" , "admin@example.com" , "Page" , "Updated link from 'instenv-115260-kqga.instenv.internal.atlassian.com/pages/viewpage.action?pageId=1638667' to 'atl-fbl-e2e-test-1.jira-dev.com/wiki/pages/viewpage.action?pageId=33292643' " , " Object ID: 49873149" "52899e2a-6b59-4162-9a56-79632a0f5503" , "2023-09-19T02:02:10Z" , "admin@example.com" , "Page" , "Updated link from 'instenv-115260-kqga.instenv.internal.atlassian.com/x/SgIZ' to 'atl-fbl-e2e-test-1.jira-dev.com/wiki/x/e4AAAg' " , " Object ID: 49873149" "52899e2a-6b59-4162-9a56-79632a0f5503" , "2023-09-19T02:02:10Z" , "admin@example.com" , "Page" , "Updated link from 'instenv-115260-kqga.instenv.internal.atlassian.com/x/1wEZ' to 'atl-fbl-e2e-test-1.jira-dev.com/wiki/x/ZIAAAg' " , " Object ID: 49873149" However, please be aware of the following limitations: We can only store this data for 29 days. Only links that have been migrated will be included.   if it does not meet your requirements (for instance, if the link migration process was carried out a while ago), the support team can offer an alternative method of exporting mappings (focused on pageId/tinyurl values). The method is based on database queries, so will require extra consent from you, etc. The format for this is as follows: "server_page_id" , "cloud_page_id" , "server_page_type" , "cloud_page_type" , "server_page_title" , "cloud_page_title" , "server_space_key" , "cloud_space_key" , "server_url" , "cloud_url" , "tiny_server_url" , "tiny_cloud_url" "2624364" , "100001" , "PAGE" , "PAGE" , "AAA1" , "AAA1" , "AAA" , "AAA" , "https: //wiki.rtakata.com/pages/viewpage.action?pageId=2624364" , "https://rtakata.atlassian.net/wiki/pages/viewpage.action?pageId=100001" , "https://wiki.rtakata.com/x/bAso" , "https://rtakata.atlassian.net/wiki/x/oYYB" "4260608" , "100002" , "PAGE" , "PAGE" , "AAA2" , "AAA2" , "AAA" , "AAA" , "https: //wiki.rtakata.com/pages/viewpage.action?pageId=4260608" , "https://rtakata.atlassian.net/wiki/pages/viewpage.action?pageId=100002" , "https://wiki.rtakata.com/x/AANB" , "https://rtakata.atlassian.net/wiki/x/ooYB"     2. Currently, we don't have a specific workflow for this. However, to expedite the process, you could refer to this ticket ( https://jira.atlassian.com/browse/MIG-507 ) or link my comment there in the description of your support ticket.

oliver.wihler added a comment - 11/Oct/2023 11:09 AM Hello, I have two questions. 1. can you publish the format of the mapping file? 2. is there a special request type or keyword we need to mention when requesting this from the cloud migration support team? Thanks, Oliver

Łukasz Halicki added a comment - 02/Oct/2023 1:45 PM fad83336f6ed yes and such mapping can now be requested after fixing links (in Atlassian products) via our support so that relevant redirection could be added outside of Atlassian tooling.

Cormang added a comment - 02/Oct/2023 1:35 PM What does the resolution have to do with the Problem Definition? I thought we were simply looking for a mappings file. 

Łukasz Halicki added a comment - 02/Oct/2023 1:20 PM URL mappings before and after migration to cloud, including pageId changes can now be requested via Atlassian support as part of post migraiton link fixing: https://confluence.atlassian.com/confkb/after-a-successful-server-to-cloud-migration-url-links-are-broken-in-the-new-cloud-instance-1077781093.html Closing this issue as resolved.

Mark Lennon (Inactive) added a comment - 11/Aug/2023 4:04 PM https://getsupport.atlassian.com/browse/MOVE-83188

Arun Parameswaran added a comment - 28/Jul/2022 8:15 AM https://getsupport.atlassian.com/browse/MOVE-90456

Aurélien Joga added a comment - 22/Jul/2021 10:02 AM It would be great to have a snippet of configuration for apache or haproxy for us to put the http redirect. Ideally Atlassian would host these redirections on the cloud instance