Exportix tutorial

Turn a saved query into a file another system expects. License Exportix on the site.

Before you start

Register or log into the main VizGenesys website at www.vizgenesys.com. Set up your company. Click Sites and set up or add a new site. Click Download and download the client-side package.

Unzip the package and copy the entire vizgenv4 folder to your target web server. Go to http://yourserver/vizgenv4/ and log in with that same username and password.

1. Click the Connections tab and add connections to your database servers (MySQL / MariaDB or Microsoft SQL Server). These connection details remain on your server. They are not stored on vizgenesys.com or any other server. Save the connection. If the details are correct you will see that you have an active connection to that database server.
2. Click Users & Groups. Select a user (your first user is the site administrator). Edit the user and select which connections and SQL types that user is allowed to use.
3. Click Misc and tailor theme, branding, and the data folder to your environment if desired.
4. Click Jobs and add your first export. Start from a saved query when you can.

Design the export

1. Start from a working query so column names are stable.
2. Jobs → add an Export. Choose CSV, TXT/DAT, JSON, or XML.
3. For nested text files, define record types: header, break, detail, footer.
4. Use padding, comma masks, and system values (today, row number) where the downstream system is picky.
5. Test, then save.

Run and collect the file

1. Dashboard Run or prompt.php?job=… fills prompts, then writes the file.
2. Staff pick it up from the download tray (same idea as spool history for PDFs).
3. A custom app can call the run API with mode=export and download=1 to receive the bytes — HTTP API.

Exports write on the client server into the site data folder (…/downloads), not onto the VizGenesys host.

More: all tutorials · HTTP API (PHP, VB, C)