iDentist Tables

iDentist Tables

This document is useful to all dentists that purchased iReport PLUS to construct their own reports.
The tables are structured boxes that holds data. Each table consists by rows and columns. Rows are records. If you have 100 patients in your database. Then the Patients table has 100 rows. Every row is a collection of columns. Each column is like a small cell that contains the actual data. Every column has a name to refer to. All iDentist database structure is presented below:

—————————-

Table structure for Appointments
—————————-
“app_id”, record id number
“app_Date”, appointment date
“app_Patient_ID”, patient’s record id
“app_Time”, appointment time
“app_Notes”, notes on appointment
“app_Done”, indicates when the appointment is done or not – default value is 0 that means not done
“app_Date_String”, the appointment date as string

—————————-

Table structure for Clinic
—————————-
“cln_id”, record id number
“cln_ClinicName”, clinic name
“cln_Specialities”, clinic specialities
“cln_Address”, clinic address
“cln_ZipCode”, zip code
“cln_City”, city
“cln_Telephones”, telephones
“cln_TaxNumber”, clinic tax number
“cln_TaxOffice”, tax office
“cln_Notes”, some notes for the clinic
“cln_email”, email address (normally an accessible to all clinic members email address)

“myvolos.net” web site released

“myvolos.net” web site released

For the project ”myvolos.net” we are especially proud of. We are proud because it is a journalism site, which has surpassed 17,000 hits in one day! This is a clear proof that the amazing design, the very good graphics in combination with a fast executable code behind the scenes, is a key for the success. All that achieved by our team.
The site myvolos.net was from the very first day, the first page to multiple computers and tablets. This is a success story, that we share it with the entire editorial team of myvolos.net.
Our cooperation continues after the end of the site’s construction, since myvolos.net entrusted us to manage the site on an annual basis in the future.
If you want to take a tour in myvolos.net click here.

Orders

Orders

Orders, is a real-time ordering system affordable to small or medium-sized commercial enterprises that use seller network. Orders development came to put an end to the costly special ordering devices,
iPhone into such a device!!! Thus the business without investing a single penny extra in computer equipment (such as would require also a classical ordering system), may receive from the sellers, online and in real-time their orders.
A seller using Orders application acquires an electronic partner that will help him improve his performance and profits.

The idea was simple:
Using cutting edge technology, with implementation to be full potential and compatible with the IT facilities of all businesses and of course does not require lots of money for the acquisition.
A discussion in short, the way of implementation Orders function is:
a) Company shares a common website with their vendors (fully secured) and through the site receives and sends files to and from the mobile phones of sellers who use Orders. The common website is a Dropbox folder * (the service is FREE), and more information can be read in www.dropbox.com
b) Orders application installed in sellers mobile phones, can sync via Dropbox to business management program ERP, no matter which ERP is this**!
Orders application is compatible with all commercial management programs or ERPs ***.
c) Using Orders the seller can find:
– File paths (or routes) to be able to organize his professional routine better and which customers will see in his every day job.
– A Customer file with full financial information (fiscal charts, statistics)
– An electronic Warehouse file with multiple measurement units, wholesale or retail prices etc.
– An Order file, with viewable statistics.
– Monitoring objectives in sales revenues and quantities by kind. With a special graphic system for calculating the target achievement rate.
– Can print in laser or inkjet printers, reports based on various application files.
– Ability to export records from application’s database to csv files for editing on a desktop computer using Excel, Numbers, or such appalications. (compatible with windows, linux, mac OSX).
– Import csv or txt file from any business management software or ERP ****.
– Send orders via internet onto company computers using Dropbox. He can also choose what orders to send.
– Actual orders are submitted in business as pdf files which can be printed or viewed.
In environments with multiple vendors or application Orders has the structure to facilitate the recognition orders which came from what seller.

“thermovolos.gr” a new e-store…

“thermovolos.gr” a new e-store…

A new presence in the infrared heating market, in Magnesia is Thermovolos.
Our company took over in December 2013 to build a web application to implement an online store for Thermovolos. The application should be user friendly for visitors – giving them almost within just a click away, any information that probably would ask. Extremely easy to use would be the back office, to make more effective the maintenance of the site.
All these features are harmoniously tied with an elegant UI and the result is an excellent web site  – online store -which you can visit here.
The web site currently supports only Greek language, but it is in the near future plans to make it multilingual.

iPetrol

iPetrol

The helps drivers to find the cheapest fuel station near them. The app has a nice UI and collects data via internet. It also shows the position of the station on map and has a “drive to” system to guide the driver to reach easily the station.
The app also has an up to date,  database with blacklisted fuel stations. A Very helpful app for all drivers.