General
What Language is Ostendo written in?
The Ostendo program itself is written in Delphi (latest version). The scripting Engine is Pascal 'based'. Development-X use the base complier that comes with Fast Reports (Report Writer). Development-X have enhanced this to include some of our own ...
Outlook - Operation Aborted Message when emailing from Ostendo
If this message is displayed when attempting to send an email from within Ostendo, this could be related to an Outlook policy setting relating to either or both Outlook Object Model Prompt or Outlook Object Model Scripts Our recommendation would be ...
Performance Speed Test
Sometimes it can be useful to conduct a speed test in order to benchmark read / write speed in a database. This is useful when attempting to diagnose a performance problem on a specific database within different environments. By running the speed ...
Unable to Install Ostendo Client from Client Install Program - Alternative Setup Method Using Multi Companies
Sometimes there maybe occasions when, for a number of reasons (eg: permissions settings, registry access etc..) you are unable to successfully run the standard Ostendo Client Installation application. An alternative method for setting this up is by ...
Outlook Undeliverable Email Message When emailing from Ostendo
Error Message Returned From Outlook: The above message is returned form Outlook if the Ostendo users settings are not set correctly for the Email application being used. Typically, this is because the Ostendo user is using Outlook, however their ...
How can I enquire onto the database?
Ostendo provide facility to enquire on any table in the database by going into General>Data Spreadsheet and entering your selection criteria. The data will be returned to the screen from which you can save as a Spreadsheet.
How do I Export data from Ostendo?
To export data from Ostendo you should go to File>Data Export. That function allows you to export data from Ostendo to either a Comma Separated Value file or an Excel Spreadsheet. The procedure uses a simple Wizard that takes you through the whole ...
Incorrect Date Format In Ostendo - Windows 7 and Windows 10
There is an issue with later versions of Windows whereby if the Regional Settings are initially set to a country where the date format is dd/mm/yyyy, that the format is still interpreted as mm/dd/yyyy. This is a bug within Windows. To resolve this, ...
Tested Label Printers that work with Ostendo
Label Printers that work well with Ostendo are:- - Zebra TLP 2822 or TLP 2824 works fine but that only works with the PC it is connected to. A networked Zebra printer should be used from multiple workstations - For small jobs you can use the normal ...
Minimum Hardware Requirements for Ostendo
Hardware Requirements for Ostendo Development-X Limited recommends Ostendo is installed on Microsoft Windows server based networks by Microsoft qualified and experienced technicians. Ostendo can also be hosted on Cloud Servers. Before you install and ...
Cannot see Help File
Three possible solutions: First Possible Solution: - In IE7 there is a setting under Security. Click on Tools>Internet Options, then select Security>Local intranets. Click on the 'Sites' button. Untick Automatically detect network paths and tick ...
Email via Google Apps
Ostendo supports either MS Outlook (using a direct COM connection) or via MAPI for other email clients - Gmail is neither and is therefore not supported. You can get MAPI for Outlook if you purchase Google Apps and use their Google Sync product. It ...
What tools are available for managing the Ostendo database?
There are two free applications that allow you to interrogate the Ostendo database, allowing views, and triggers to be created EMS SQL Manager EMS SQL Manager for SQL Server Freeware (EMS SQL Manager Lite for SQL Server) is a light and easy-to-use ...
Reverting to 30-Day License Key
Ostendo keeps reverting to a 30-Day Key whenever I sign in This is caused by Internet Explorer. Windows 7 stores all links to 'keys' under a Cookies Folder in the Registry. Internet Explorer has the option to delete all 'Cookies' and, if selected, ...
Ostendo running slowly
Some of the most common factors that could influence speed are: 1) Firebird database needs to be backed up & restored (effectively fixes indexing or data issues) 2) The server is not optimised as a database server (i.e. the disk configuration is ...
What spell checker does Ostendo Use?
The spell checker itself is a component in Ostendo. However, the dictionary it uses is to 'open office' format. You can download the Dictionaries from http://wiki.services.openoffice.org/wiki/Dictionaries In the downloaded zip file you will see a ...
NetTests fail when communicating with ports on server
Ensure the following Server ports have Window Firewall Exceptions set: Port 3050 (Required for Firebird) 4380 (Required by Ostendo) are open on the firewall.
What is an ODBC driver and what does it do?
ODBC stands for Open DataBase Connectivity and is a Microsoft standard for accessing different database systems from within Windows. Most popular databases have an associated ODBC connection routine. It is provided free with some databases but others ...
How do I Prevent a User from updating a specific field?
You should create a Screen Data Script. The following example prevents a User from updating the AdditionalField_1 field in the Job Order Header. This script first obtains the Order Number and AdditionalField_1 values from the current displayed record ...
Validating and Repairing a Corrupt database
This document describes the process of Database Validation and Repairing. It should be run directly on the host machine. Partners have the same tools available to them as Development-X. If the database is still corrupt after performing the DOS level ...
Can you schedule an Auto backup of the Ostendo database
Ostendo Scripts will NOT provide access to backing up / copying the database Ostendo Script Scheduler will NOT provide access to backing up / copying the database. The best method is to allow WINDOWS operating system to run BACKUP on a timed event or ...
How can I copy a user grid settings?
Occasionally you may set up a new user and want them to initially use another users grid settings. This can be acheived by creating a Standard Custom Script and loading the attached script file. NB: This will replace any grid settings that the user ...
Simple XML Order Example Script
The attached script provides a simple example of coding using the Ostrendo XML functions to export data from a Purchase Order and import that data into a Sales Order.
Error - Can't change sql text because frmxxxxxxxxxxxx.qryMaster_.SelectQuery dataset open
If the above message is encountered where 'frmxxxxxxxxxxx.qryMaster' refers to a tablename, the cause could indicate that the Customised List fields for that user has been corrutped in some way. Simply go to the list grid of the referred screen and ...
Outlook Default Times New Roman Font When Emailing from Ostendo
When emailing from Ostendo using Outlook, the Ostendo user account settings should be set to the following under File System Configuration-> User Security and Options -> User Options Tab against the user: Email Client = Outlook Incl Signature = ...
Dynamic SQL Error when performing a Global Name Change (Apostrophes in the Primary Key)
If data has been introduced into Ostendo outside of the normal user interface eg: Importing, then in most cases the database will reject the record. The normal Ostendo interface automatically deals with this by changing a ’ to a ` when the record is ...
Reports and Views not Updated When Appling Update
On occasions when running an Ostendo Update, the dbupdate may hang when it tries to update all System Reports and Views. To resolve this, follow these steps: 1. Do a validation, followed by backup & restore of the Database. 2. Use the attached script ...
Global Name Change - Customer/Supplier etc with a blank name
In versions of Ostendo (Up to and including Update 160) you were able to inadvertently change a key field (eg: Customer or Supplier name) to a blank through the Global Name Change. This of course becomes a big problem and needs fixing ASAP. In order ...
Mass Global Name Change
On occasions you may require a global name change to occur across multiple records. eg: you may need 10 customers requiring name changes. A script may be run to read data from a spreadsheet and then process each record in turn. Attached is a Standard ...
Incorrect Item Master On Hand Qty
If the ITEMMASTER.QTYONHAND field is inccorrect (usually due to someone importing a value into this field) you are able to re-calculate the ItemMaster qty based on actual INVENTORY records by running the Stored Procedure below from as a std script. ...
Preventing Users From Logging in more than once
To use this script, do the following: 1. Go to your script editor and add a script called "LOGIN_ONCE". Then import the attached script. 2. Next, go to File --> System Configuration --> User Security & Options --> User Options tab. For each user, go ...
No attachment received when using SendEmailMessage function
In Updates 187 and earlier (possibly back to Update 182), when you specify an attachment in this function, the resulting email that is generated does not include the attachment itself but rather tries to embed it as shown in the example below. To ...
Email Forms Package and Tutorial
The Email Forms package and tutorial can be download from the attachment to this article. The package consists of: EMAIL FORMS.pdf – a tutorial on how to set up and use EMAILFORMS. Forms Template folder- contains several sample forms EForms-PROCESS ...
Swapping out Ostendo functions for others
From time to time you may wish to stop users from accessing specific functions within Ostendo and rather swap that function out with another. An example of this might be if we had a user called 'GENERAL' who when they press the Items option, instead ...
Controlling Users Updating / Adding or Deleting records
From time to time you may wish to stop an individual or group of users the ability to add / update or delete records in Ostendo, whilst still giving them access to specific functions within Ostendo. In this example we will prevent a user 'GENERAL' ...
Copying Users From Another Ostendo Database
Use these std scripts to copy all users from one Ostendo database to another. Create a std type export script in the originating database, then create a std type script in the other database to import these users
Upgrading from Update 180 to 211+
As some Partners have pre-releases of Ostendo updates beyond 211 you should note that databases of 180 cannot be directly updated to your pre-release without first being upgraded to 211. If you are upgrading a version of Ostendo from 180 to a version ...
Datascreens
The concept of Datascreens was released in Nov 2015 with Update 211 principally timed with the release of Time Capture Lite and Track functionality. When Edit Views / Custom Data Screens, Pivots, Analysis Views and Reports are run, they will lock the ...
Error Message - Error in expression when running a Report. [Square Brackets]
The F4 function Key in Ostendo automatically inserts a date and timestamp along with the UserName all enclosed in Square Brackets. Unfortunatley sometimes when reports are generated with this data contained, throw an error message Error Message ...
Changing or Transferring Ostendo onto a new Server
If a site requires a new server to be installed which will result in the loss of Ostendo, perform the following checks and tasks to ensure a straight forward transfer.... It is suggested that the new Server has the same name as the old server ...
Next page