Docman To Phoca Downlaod migrator converts Docman files and categories tables into Phocadownload tables. Since Docman uses Joomla's categories tables, you will also need them to do the migration.
Following tables shows which columns may be copied from Docman's to Phoca Download's tables. jml
is Joomla's 2.5 defaut table prefix (you have to change it with your prefix!).
jml_docman | jml_phocadownlaod |
---|---|
cat_id (1) | cat_id (1) |
dmname | title |
dmdescription | description |
dmdate_published | published_up |
dmfilename | filename |
published | published; approved |
dmcounter | hits |
access (2) | access (2) |
Note:
(1) docman's cat_id refers to the table jml_categories; Phoca Download's cat_id refers to jml_phocadownload_categories.
(2) Docman default access (everyone) is represented as 0, Phoca Download default access as 1
jos_categories (1) | jml_categories | jml_phocadownload |
---|---|---|
parent_id | parent_id | parent_id |
title | title | title |
name | ####### | name |
alias | alias | alias |
image | ####### | image |
image_position | ####### | image_position |
description | description | description |
published | published | published |
checked_out | checked_out | checked_out |
checked_out_time | checked_out_time | checked_out_time |
editor | editor | editor |
ordering | ordering | ordering |
access (2) | access | access |
count | count | count |
params | params | params |
Note:
(1)jos_category
means a Joomla 1.5 categories table,jml_categories
a Joomla 2.5 table.
As you may notice, Joomla's tables have different structure (it depends on Joomla's version).
(2) As before, Joomla access0
corresponds to Phocadownlaod access1