Skip to end of metadata
Go to start of metadata

There are several words and characters that should be avoided in Phocas, e.g., when naming measures etc. This is because in software development, these words or characters typically have a specific meaning that may affect results. 

Reserved words in measures

WordReason
CountCount is a reserved word as when used as a scalar it depicts the count of rows in the transactions.
TransTrans is reserved for internal usage.

Unsupported characters

CharacterNameReason
\BackslashBackslash is a common programming character.
;SemicolonThe semi-colon is reserved as when used in searches it defines multiples. For example, in a equal to search, it splits codes.
*AsteriskThe asterisk is reserved for wildcard searches, and shouldn't be used in raw data.

Reserved words and characters in Designer

Unsupported characters (these should not be used in names of measures, streams, properties or dimensions)

Character
\
@
!
?
~
|
*

Reserved words

Word
Code
Date

Reserved characters in Sync

CharacterName
.Period or full stop/full point'

Use of "." (period character) in a file name can cause an application (i.e. like Sync) to unexpectedly recognize a file with an unsupported file type suffix. For example, a file named "example_filename.txt" might be correctly recognized as a text file.  But a file named "example.filename.txt" could result in an unsupported file type error (if the application does not support a file type of ".filename" (such as Sync)).   

8 Comments

  1. Suggestion: Use of "." (period character) in a file name can cause an application (i.e. like Sync) to unexpectedly recognize a file with an unsupported file type suffix. For example, a file named "example_filename.txt" might be correctly recognized as a text file.  But a file named "example.filename.txt" could result in an unsupported file type error (if the application does not support a file type of ".filename" (such as Sync)).   

    1. Bill Allen belatedly, I have updated the page to include this. My oversight.

  2. DEV-15222 
    The forward slash "/" is also a reserved character - 

  3. Is the underscore also a reserved character in Sync Srujana Jammalamadaka?

    1. Yes, underscore is reserved for "Source names", but not for Data Items.

      1. Srujana Jammalamadaka are you able to update this page accordingly?  Thanks. 

        1. Sure Tim Leonard. I will consolidate the info and share with Helen Gosper for updating the doco.