Austlink Help Centre

Follow

Jiwa - Integration with Excel

I have created a video below on how to extract data from Jiwa Financials to Excel.

 

There are two methods, a simple copy and paste method and a more complected direct SQL connection method

 

Extract Data from Jiwa Financials - Simple Method

This first method is a simple copy and paste from any of the Jiwa Transaction Grids.

Just right click on the grid header and choose "Select All"

Then use Ctrl-C (the Control Key and the "C" Key together) to copy the selected data

 

JiwaExcel01.png

 

Now open Excel, right click on a cell and select to paste.

The contents of the Jiwa Transaction grid will now be available to you inside Excel

 

JiwaExcel02.png

 

JiwaExcel03.png

 

Extracting Data from Jiwa Financials via a Report - Simple Method

 

Another way to extract data from Jiwa is to use the report system which is based on Crystal Reports

Select a report from the menu, tick "Print to Screen" and press the printer icon

 

JiwaExcel16.png

 

From the report tab click on the export button

 

JiwaExcel17.png

Select a location, a file name and choose a type of "Microsoft Excel"

 

JiwaExcel18.png

 

Now locate the file you saved and open it. Your data will now be in Excel

 

JiwaExcel19.png

 

 

 

 

Extract Data from Jiwa Financials - Advanced Method

Another way to extract data from MYOB Exo or indeed any other Microsoft SQL data source is to us the data connectivity features within Excel to create a direct connection to the Microsoft SQL database.

In Excel select the data tab and the "from Other Sources" button

 

JiwaExcel04.png

Select "From SQL Server"

 

JiwaExcel05.png

Enter in your SQL Server Name and Credentials 

 

JiwaExcel06.png

 

Select your Jiwa SQL database and the table you want data from and press "Finish"

 

JiwaExcel07.png

 

Select the cell you want the data to be copied into and press "OK"

 

JiwaExcel08.png

 

Enter in your credentials again and press "OK"

 

JiwaExcel09.png

 

The data from the chosen table will automatically flow into Excel

 

JiwaExcel10.png

 

To update your data just right click anywhere on the data and select "Refresh"

 

JiwaExcel11.png

 

Modifying the SQL Query

 

If you know a bit of SQL you can edit the Query. Right click on your data and select "Table" and "Edit Query"

 

JiwaExcel12.png

Change the "Command Type" to "SQL" and enter in your SQL statement in the "Command Text" box below

 

JiwaExcel13.png

Enter in your Credentials and press "OK"

 

JiwaExcel14.png

The data returned will now be modified in line with your new SQL Query

 

JiwaExcel15.png

 

 

This video is best seen on the full screen. Just click on the icon at the bottom right of the video (see image below).

To exit full screen just press escape 

 

VideoFullScreen.jpg

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

This entire document, including design, text, videos,graphics, and photographs are Copyright © 2014 Austlink Plus Pty Ltd, All Rights Reserved.
No part of this document may be reproduced in any way or by any means for commercial or any other purposes, without prior written permission of Austlink Plus Pty Ltd. Use of any data for the purpose of creating promotional materials or producing a printed or electronic catalog of any kind is expressly forbidden without prior written permission of Austlink Plus Pty Ltd.

Powered by Zendesk