Menu

Features

Giacomo Fabris

Features

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.

What does D2P migrate?

  • title, description, filename
  • publication's date
  • published (yes/no)
  • categories
  • ordering
  • hits

What does not D2P migrate (yet)?

  • users permissions
  • access control

Further instructions for developers

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 access 0 corresponds to Phocadownlaod access 1