Example Mapping of file upload dirs and sql queries for EE1 ngen to EE2 file fields

gistfile1.txt

UPLOAD DIRECTORIES

id	label
------------------------------
10	Career Uploads
11	Consumer Line
5	Content Resources
13	Form Uploads
9	Hero Images
12	Home Page Banner Uploads
1	Main Upload Directory
8	News Images



MATRIX COLS

col_id	field_id	upload_dir	label
------------------------------------------------------------									
1	31		5		File upload
4	32		5		File upload
7	33		5		File upload
10	36		8		Image Upload
12	37		9		Left image upload, text only
14	37		9		Right image upload. (photograph)
16	51		10		Image Upload
18	53		10		File Upload
20	60		11		PDF Upload



REGULAR FIELDS

field_id		label
------------------------------------------------------------
61			Banner Upload



SQL QUERIES
------------------------------------------------------------

UPDATE exp_channel_data
SET field_id_61 = CONCAT('{filedir_12}', field_id_61)
WHERE field_id_61 != ''
AND field_id_61 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_1 = CONCAT('{filedir_5}', col_id_1)
WHERE col_id_1 != ''
AND col_id_1 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_4 = CONCAT('{filedir_5}', col_id_4)
WHERE col_id_4 != ''
AND col_id_4 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_7 = CONCAT('{filedir_5}', col_id_7)
WHERE col_id_7 != ''
AND col_id_7 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_10 = CONCAT('{filedir_8}', col_id_10)
WHERE col_id_10 != ''
AND col_id_10 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_12 = CONCAT('{filedir_9}', col_id_12)
WHERE col_id_12 != ''
AND col_id_12 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_14 = CONCAT('{filedir_9}', col_id_14)
WHERE col_id_14 != ''
AND col_id_14 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_16 = CONCAT('{filedir_10}', col_id_16)
WHERE col_id_16 != ''
AND col_id_16 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_18 = CONCAT('{filedir_10}', col_id_18)
WHERE col_id_18 != ''
AND col_id_18 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_20 = CONCAT('{filedir_11}', col_id_20)
WHERE col_id_20 != ''
AND col_id_20 NOT LIKE '{filedir_%'