OJS versions and file_stage DB field

Software Support
1

Hi,

Is it possible to get catalog table for DB field file_stage in submission_files table? I would like to know what every number/value means. I need a value for a published article. In OJS versions < 2.4.0 this field was called type and for published articles value was set to “public”. In OJS versions 2.4.x field was renamed to file_stage and “public” become something like 7 or 1 (still don’t know the difference). Now, in OJS 3.x value is changed again. Can someone post value → meaning table? Thx.

Regards,

Nino

2

Hi @orcalator,

Those values are defined in SubmissionFile.inc.php.

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hi @asmecher,

Thank you for help. Great support these days with OJS :slight_smile:

Regards,

Nino

4

@asmecher,

One more question. So, according to this table:

define(‘SUBMISSION_FILE_PUBLIC’, 1);
define(‘SUBMISSION_FILE_SUBMISSION’, 2);
define(‘SUBMISSION_FILE_NOTE’, 3);
define(‘SUBMISSION_FILE_REVIEW_FILE’, 4);
define(‘SUBMISSION_FILE_REVIEW_ATTACHMENT’, 5);
// SUBMISSION_FILE_REVIEW_REVISION defined below (FIXME: re-order before release)
define(‘SUBMISSION_FILE_FINAL’, 6);
define(‘SUBMISSION_FILE_FAIR_COPY’, 7);
define(‘SUBMISSION_FILE_EDITOR’, 8);
define(‘SUBMISSION_FILE_COPYEDIT’, 9);
define(‘SUBMISSION_FILE_PROOF’, 10);
define(‘SUBMISSION_FILE_PRODUCTION_READY’, 11);
define(‘SUBMISSION_FILE_ATTACHMENT’, 13);
define(‘SUBMISSION_FILE_REVIEW_REVISION’, 15);
define(‘SUBMISSION_FILE_DEPENDENT’, 17);
define(‘SUBMISSION_FILE_QUERY’, 18);

public published article should get a value of 1 or ? Thx.

Regards,

Nino

5

Hi @orcalator,

This aspect isn’t particularly well documented :slight_smile:

The published articles themselves – galley files – should have SUBMISSION_FILE_PROOF. SUBMISSION_FILE_PUBLIC is a hold-over from OJS 2.x that’s not used in OJS 3.x.

Regards,
Alec Smecher
Public Knowledge Project Team

6

@asmecher

Thank you, this is a great help!

Regards,

Nino