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
