DataConverterProduct

FAQ Related To MindStick DataConverter

What is MindStick DataConverter and why should I use it?

MindStick DataConverter is a powerful tool which helps you to:
1. View, Filter, Sort and Export the data from different sources (MS SQL, Oracle, Access, ODBC DSNs etc.) in one place
2. Export the query results in HTML, CSV, XML and .XLS (Excel) format
3. Minimize typing by saving most frequently used queries in a database as query snippets
4. Make changes on fly in a query result grid and export it to XML, HTML, CSV or .XLS (Excel) format to communicate your suggested changes to your team members without really making the database changes.
5. Share data which can be easily read and modified by another MindStick DataConverter user in grid format which allows filtering, sorting, group by features or any other user which can use XML, CSV or XLS(Excel) file
6. Easily create queries to fetch records
7. Lets you see database schema (Example - Tables) from different data sources (MS SQL, Oracle, Access, ODBC DSNs etc.) in one window.

You can download MindStick DataConverter from MindStick site, followed by Product section or you can directly download MindStick DataConverter by visiting http://mindstick.com/Products/DataConverter

No, You don’t need any additional software to use MindStick DataConverter. MindStick DataConverter is stand alone software.

Currently we do not provide any technical support regarding MindStick DataConverter but in near future we will be providing technical support, for the time being if you have any question or query regarding MindStick DataConverter then you can contact us by visiting http://mindstick.com/ContactUs URL.

Yes, you can add link of MindStick DataConverter on your own site.

No you don’t need to uninstall old version. MindStick DataConverter installer will do it automatically. For downloading latest version of MindStick DataConverter please visit on MindStick Product section page.

No, you will get a wizard which will guide you for installation process.

Using MindStick Data Converter, you can browse records from different – different databases, apply filters on those records and save records in form of XML, EXCEL, CSV and HTML files. So that you can easily transfer records from one place to another in several format.

Using MindStick Data Converter, you can browse records from different – different databases, apply filters on those records and save records in form of XML, EXCEL, CSV and HTML files. So that you can easily transfer records from one place to another in several format.

MindStick DataConverter supports all major database servers like SQL Server 2000/2005/2008, Oracle, Pervasive and Microsoft Access etc.

Currently .mdb file format of access database is supported by MindStick DataConverter.

When you save any query text in MindStick DataConverter then that text is known as query snippet. You can save complex query in format of query snippet and use it again and again by drag and drop to query analyzer window.

When you want to execute your own queries, then you can use query analyzer of MindStick DataConverter. You can execute all SQL (Structured Query Language) statements in query analyzer window of MindStick DataConverter.

For executing any SQL query in MindStick DataConverter, follow the following steps: Write down your query in Query Analyzer window of MindStick DataConverter. Click on Run Query menu option.

When you establish connection with database, then all tables of database is displayed in Explorer window. All the query snippets which you have saved are also displayed in Explorer window of MindStick DataConverter. You can directly drag and drop query snippet and tables name in query analyzer window.

For showing and hiding explorer window, you need to follow the following steps: Go to Options menu. Click on Explorer sub menu option. By clicking on Explorer sub menu if Explorer is visible then it hides or vice versa.

You can view all saved query snippets by performing these steps. Open Explorer window. See at bottom of Explorer window and Find Query Snippets button if it is not visible then click on smart tag followed by Add or Remove Buttons then click on Query Snippets button. Click on Query Snippets button.
By performing above mentioned steps you will see all saved query snippets.

When you click on Tables button then all available tables will be displayed in Explorer window and when you click on Query Snippets then you will see all saved query snippets in Explorer window.

To change CSV separator you need to follow the following steps:
Click on option menu.
Click on Setting sub menu.
After performing this action, Setting dialog box is open where you can specify separator character for your CSV file.

You can use Option menu to perform following actions:
To change settings for CSV file. To show/hide Explorer window.

MindStick DataConverter supports XML, EXCEL, HTML and CSV file format.

Yes, you can use your own connection string for MindStick DataConverter. To use your own connection string you need to follow the following steps:
Open login window. Check on Advance option. Check on Custom Connection String. Click on Next button then you will see a text area where you can enter your own connection string.

Whenever you want to use OleDb option or you want to provide your own connection string then you can use Advance option of Login window of MindStick DataConverter.

Yes, you can open multiple connection of MindStick DataConverter simultaneously.

Whenever you want to execute your own SQL statements in query analyzer window of MindStick DataConverter then you can use Run Query button to execute it.

Value which you have provided in Nick Name text box is displayed in menu of DataConverter.

If you have already created DSN (Data Source Name), then you can use “I already have DSN” option provided by MindStick DataConverter login window.

If databases are not displayed in Database dropdown list after providing connection string then you need to recheck the following:
Check connection string again, including server name, user id and password. Check that particular database server have database or not. If it have database then check whether you have permission or not.

For changing all values of particular column you need to perform steps mentioned below:
Click on Update Local Grid Value menu option. Update Local Grid Value dialog box opens. Select column name from column drop down. Add new vale in textbox. Click on OK button to reflect these changes on local grid.

No, any modification which you perform on Local Grid of MindStick DataConverter that is reflected only on local grid value.

For exporting data in format of excel file you need to perform the following steps:
Right click on output area of MindStick DataConverter. Click on Export option. Finally click on EXCEL option

You can click on Reset Filter menu option to rollback it to original state.

For creating query snippet you need to follow the following steps:
Type your query in query window. Right click on query window. Select Add Snippet/Add Selected Snippet menu option from pop-up menu. Add Snippet dialog box open. Provide name of snippet and click on ok button to save snippet.

To make group result by column name drag column name from column header and drop it to header of output area.

Yes, you can filter records according to your need. To filter records according to your need perform the mentioned below steps:
Click on Filter icon. Select Custom from filter drop down. Filter dialog box appears. Here you can provide filtering according to your need.