Migrating Cloud to Server - Organisation values

[Tom Lister]

Hi

I'm migrating a Cloud JSD to a hosted server.

I'm using a staging server to import the cloud project, clean up some user values and then export/import to our target server. The staging system has all the Organization values intact.

When i import into the target I get the message

Unable to import custom field 'Organizations'. The custom field type does not support project imports.

In order to expedite this I intend to proceed and rebuild our Organisation data over a few days after importing.

My actual question is where in the database are the organisation values stored?

I can see numeric values but not text values

SELECT jiraissue.id, jiraissue.pkey, issuenum, jiraissue.project, pname, project.pkey, cf.cfname, cv.numbervalue
FROM jiraissue, project, customfieldvalue cv, customfield cf
WHERE jiraissue.project = project.id
AND project.pkey = 'CSD'
AND cv.issue = jiraissue.id
and cv.customfield = cf.id
and cv.customfield = 10004 

[Tom Lister]

Looks like they're in active object tables

AO_54307E_ORGANIZATION

[Tom Lister]

FYI

This is what I needed to know...

To get Organisation names

SELECT "DOMAIN", "ID", "LOWER_NAME", "NAME", "SEARCH_NAME"  FROM "AO_54307E_ORGANIZATION";

To get Organisation Issue values

SELECT  concat(project.pkey , '-',issuenum ) as key, "AO_54307E_ORGANIZATION"."NAME",  pname,  cf.cfname, cv.numbervalue  FROM jiraissue, project, customfieldvalue cv, customfield cf, "AO_54307E_ORGANIZATION"  WHERE jiraissue.project = project.id  AND project.pkey = 'CSD'  AND cv.issue = jiraissue.id  AND "AO_54307E_ORGANIZATION"."ID" = cv.numbervalue  and cv.customfield = cf.id  and cv.customfield = 10004

To get Organisation members

SELECT "DEFAULT_ORGANIZATION", "AO_54307E_ORGANIZATION_MEMBER"."ID", "ORGANIZATION_ID", "USER_KEY","AO_54307E_ORGANIZATION"."NAME"  FROM "AO_54307E_ORGANIZATION_MEMBER", "AO_54307E_ORGANIZATION"  WHERE "AO_54307E_ORGANIZATION_MEMBER"."ORGANIZATION_ID" = "AO_54307E_ORGANIZATION"."ID"