-
- Preview browser
- Page designer
- DQL editor
- Application wide settings
- Security settings
- Page caching module
- Modules
- Snippets
- Actions
- Context editor
- Task editor
- Scheduler editor
- Search engine editor
- Web server console
- Site layout editor
- Template editor
- Robots editor
- Style definitions
- Database manipulation
- Table designer
- Transfer editor
- Reporter
- Deployment module
- Deployment server settings
- Debugger
- .end
- .form header
- .form trailer
- .items
- assign
- application status
- backup db
- begin transaction
- break
- call menu
- call program
- case
- cluster by
- commit
- connect
- copy all from
- data-entry
- db status
- delete records
- define
- disconnect
- do
- documents
- exec SQL
- else
- end
- enter a record
- error messages off
- error messages on
- exit
- export
- for
- global
- if
- import
- imports
- in
- input using
- install application
- into
- list records
- lock
- lock db
- modify records
- message
- named
- others
- prompt
- query selection
- record entry
- records
- reorganize
- restore db
- rollback
- run procedure
- servers
- temp
- then
- tran off
- tran on
- unclustered
- unlock
- unlock db
- via form
- while
- with
- abs
- acos
- addressof
- ampm
- anylookup
- asin
- atan
- atan2
- ceil
- CHR
- concat
- ConsoleCopy
- ConsoleMemoCopy
- ConsoleShow
- ConsoleWriteToFile
- cos
- cosh
- date
- DatePicker
- day
- DEOS
- DialogOpen
- DialogOpenRelated
- DocumentCloseName
- DoesObjectExist
- ExecDQL
- ExecuteFile
- exp
- FileExecDQL
- firstc
- firstlast
- firstw
- FixedWidth
- floor
- futurevalue
- GetCurrent
- GetVar
- hours
- if
- installment
- jointext
- julian
- lastc
- lastfirst
- lastw
- length
- log
- log10
- lower
- MemoChunk
- MemoCopy
- MemoDecodePair
- MemoExecDQL
- MemoFind
- MemoGetGlobal
- MemoLength
- MemoMemoCopy
- MemoMemoReplace
- MemoReadFromFile
- MemoReplace
- MemoSetGlobal
- MemoStringBetween
- MemoStringFrom
- MemoStringTo
- MemoWordCount
- MemoWriteToFile
- midc
- midw
- minutes
- mod
- month
- OpenForm
- OpenMenu
- OpenProcedure
- OpenReport
- periods
- power
- presentvalue
- proper
- random
- rate
- RefreshForm
- RefreshScreen
- RefreshStatus
- Remote
- Remote authentication
- Remote POP3
- Remote IMAP
- Remote SMTP
- Remote XML
- seconds
- SetColor
- SetCurrent
- SetFocus
- SetLabelText
- SetMemoValue
- SetState
- SetStyle
- SetValue
- SetVar
- sin
- sinh
- spellcurrency
- spelldate
- spellmonth
- spellnumber
- spellweekday
- sqrt
- StringBetween
- StringEscape
- StringFind
- StringFrom
- StringReplace
- StringTo
- tan
- tanh
- textpos
- timeampm
- ToText
- UniqueID
- upper
- Wait
- weekday
- WriteToFile
- year
- yearday
- yearweek
- " (quotation marks)
- () (parentheses)
- + (addition)
- , (comma)
- - (subtraction)
- . (period)
- -- (comment)
- / (division)
- * (multiplication)
- * (asterisk)
- ? (question mark)
- ~ (tilde)
- : (colon)
- := (assignment operator)
- ; (semicolon)
- < (less than)
- <= (less than or equal to)
- = (equals)
- > (greater than)
- >= (greater than or equal to)
- all
- all files
- and
- any
- between
- blank
- count
- count of
- file
- highest of
- in groups
- in groups with group-totals
- in order
- in reverse
- item (Statistical)
- item (Conditional Statistical)
- lock files
- lock nothing
- lock records
- lookup
- lowest of
- max
- mean
- mean of
- min
- not
- number
- numeric string
- or
- pause
- percent
- selected record
- std.dev.
- std.err.
- sum
- sum of
- text
- time
- to
- variance
- window
- Rules for queries
- * (asterisk)
- ? (question mark)
- ~ (tilde)
- and
- or
- not
- ( ) (parentheses)
- Debug querys
- Livetext tags
- xdg3 query
- Sessions
- Pagination
- Free text search
- Intro on fields
- Text
- Hidden
- Date
- Dropdown
- List
- Checkbox
- Radio button
- Text edit
- Redactor (richtext)
- CKEditor
- TinyMCE
- Intro
- hasPrismConnection
- doAction
- doDerivation
- doMenuItem
- doPrismDerivation
- setFormField
- runPrismFunction
- @GetDefinition
- . document
- . listcommands
- . listdocuments
- . listdrives
- . listfiles
- . listfunctions
- . listinternals
- . listoperators
- . listrelated
- . listtables
- . object
- . table
- . testdql
- @SetDefinition
- . document
- . object
- Extra modules intro
- python
- Qt
- wkhtmltopdf
- PySide
- PyXCC
- django
- Apache
- LightTPD
- nginx
- pywin32
- flup
- cssutils
- Pillow
- psutil
- mysqldb
- psycopg2
- pyodbc
- python_dateutil
- requests
- suds-ews
- setuptools
- Whoosh
- wmi
- django-send
- bootstrap
- bootstrapmultiselect
- jquery
- jqueryui
- ckedit
- tinymce
- redactor
- JavaScript EU VAT Number Validation
- feedparser
- beautifulsoup
- appsdir
- six
- pycparser
- pyOpenSSL
- cryptography
- cffi
- enum34
- pyasn1
- idna
- ipaddress
- PyYAML
- coverage
- coveralls
- docopt
- mock
- funcsigs
- pbr
- nose
- paypalrestsdk
- paypal
- libcurl
- 7zipcpp
- cef
- cpp-jwt
Deployment server settings
Used on the live server to configure the real web server that will serve DG3 application to the web.
How to set it up
When you want to use DG3DS, you need to install DG3 on the server and go into this section, do you changes to settings and do at least one Save.
The commands
SaveUsed to save changes to settings. A setting is not active until this button is pressed. You also need to do a valid save before the first time to use DG3 web server or DG3DS. Error is shown in List commands tab.
Start web serverStarts the web server on this computer either as a service or as an application, depending on settings. It does nothing if the web server is already started.
Stop web serverStops the local web server or web server service on this computer.
Start DG3DSStarts DG3DS on this computer either as a service or as an application, depending on settings.
Stop DG3DSStops DG3DS on this computer. Web server settings
Root path This is where all files deployed on the server is stored. Make sure your services have all rights to this path. You also have to make sure that DG3 are able to store the settings for this path in the DG3 Program files folder the first time you save settings. Web server to use If you have no special need, just leave it blank and DG3 will use the default one (now lighttpd). It support two different types out of the box lighttpd and nginx. Nginx have some issues when it comes to stopping as a windows service, but is the one most used on the web. Start web server as service Checked to make web server start automatically when Windows restarts. Make sure you read the trouble shooting section at the end of the document. Deployment server settings
This is settings for DG3DS (the deployment server). This is the service you need to start on you server to make it possible to do remote deployment. To work, you firewall on the server must be able to let tcp/ip pass on port 81 if you not have changed that setting.
Start deployment server as a service Checked to make DS start automatically when Windows restarts. Make sure you read the trouble shooting section at the end of the document. Deployment server port The tcp/ip port used by DG3DS to communicate with DG3. Only port 81 is supported and tested at the moment. List commands
Show the result of the commands you do. If you try to save the settings without the proper right to you program files, this will show up in this list.
Server access log
This is a view showing the latest use of the web server. It is the standard access log, that can be found as text files in the webserver folder under the root path.
Server error log
This is a view showing the latest errors of the web server. It is the standard error log, that can be found as text files in the webserver folder under the root path.
DG3 Task list
Show all services that might be related with DG3. You can refresh the services list by the refresh icon and kill services that should not be running by a right click menu on the service.
Trouble shooting DG3 Web servers
If you run DG3 as a service, you need to make sure that the service user have proper rights to the system. The problem is that the service is not running as administrator or you, but a special "Local System" user. This user must have the proper rights to files on your system where DG3 is set up to run your web application.This is in your "My documents" folder by defefault if you did not set another path when you configured the deployment server. In newer Windows servers this user do not have any rights to files outside the ones configured for IIS and the like. In the same manner, you as an administrator do not have right on new server to automatically start and stop the services if not done from inside the Locals services app. You can do it in the Local Services app, but not from DG3. All of this gets solved by making sure that DG3DS, the DG3App and the DG3Webserver runs as the same user and that user have right to the My Documents for the user that installed and configured the deployment service. Because of this the best way to avoid problems is to let the services run as you admin user. If not you have to dig into file security and server policy settings.