org_cdata is a temporary table and you should not be writing to it. the data will get dropped and regenerated.
phone and address is not stored in either of these tables.
So say I wanted to find Organization 1. (by default this is osTicket unless you deleted it)
Look in your ost_organization table and see before you try this. In my installation it is id=1.
I would run a query like this:
SELECT id FROM ost_form_entry WHERE object_id=1 AND object_type='O';
In this query the object_id is the id number of the Org you want to look up, and object_type is type O (O as in Organization). For this example it is 7802 (which it is on this instance)
Using the returned id I would then do
SELECT * FROM ost_form_entry_values WHERE entry_id=7802;
This will result in a listing of all the data points for that Organization.
Hypothetically this information would look like this:
entry_id,field_id,value,value_id
7802,45,420 Desoto,null
7802,46,,null
7802,47,https://osticket.com.null
7802,48,note,null
You can also look up what field that is for each one with a query like this:
SELECT label FROM ost_form_field WHERE id='ID';
where ID in the query is the field_id that you want to look up. Of course you could go look at the table and see that information.
So now that you know how the tables relate you will need to insert the data into the tables to make the Organization forms populate for each Organization.
Make sense?
