What is QXchange?
QXchange is a data integration tool. It can integrate data between Text, Excel and other supported DAPs.
Benefits:
-
A powerful ETL solution that reduces maintenance and deployment costs.
-
Easy and timely access to data.
-
Fast ETL delivery through a simple wizard-driven interface.
-
Comprehensive Source and Target Support.
-
Provides accurate output of data.
-
Moving and improving data.
What are the system requirements for running QXchange?
The following minimum hardware is required for the effective functioning of QXchange:
- Operating System
- Microsoft Windows 2000 Service Pack 4
- Microsoft Windows XP Service Pack 2 or Later
- Microsoft Windows Vista
- Microsoft Windows Server 2003 Service Pack 2
- Processor - Minimum 1.5 GHz processor (2.2 GHz preferred), x86 based system
- Memory - 512 MB of RAM (1 GB preferred)
- Modules - Dot Net Framework 2.0 (with SP1 recommended)Browsers - IE 5.1(For windows 2000 only) or later
How is the Salesforce user authenticated and is the password secure in QXchange?
We are using Sales force secure web service API for authentication. Password is encrypted and stored within your local system. We are using Blowfish 128 bit encryption algorithm.
What sort of machines and usage does the license cover?
The license covers the installation and usage of our software on one machine.
Can QXchange handle custom date formats in excel?
We are supporting custom date formats in excel.
Are there any user permission requirements for scheduling?
We create the job and push it to Windows Scheduler. So the user must have enough permission to run the Windows Scheduler.
Who can use QXchange?
QXchange can be used by Database Administrators, System Administrators and Developers.
How do I install QXchange?
Installing QXchange is quite simple since it is available in an executable program mode. You need to specify the directory in which you want to install QXchange if you do not accept the default directory.
-
Double click the QXchange.exe file.
-
On the Welcome screen, click Next.
-
On the License Agreement screen, click on "I accept the terms of the license agreement", and then click Next.
-
On the Choose Destination Location screen, choose the path to install the files. Click the Change button to select the path or save it in the default path (C:\Program Files\QXchange) and click Next button.
-
On the Ready to Install the Program screen, click the Install button to start the installation process or click the Back button to move to the previous screens or click Cancel button to exit the wizard.
-
On the Install shield Wizard Complete screen, click the Finish button to complete the Installation process.
Is it possible to create a customer job in QuickBooks without job Start Date / End Date using QXchange?
Yes, QXchange can be used to create customer job without job Start Date / End Date in QUickBooks, provided there is no mapping for these fields. If the job Start Date / End Date fields are mapped, then QuickBooks SDK expects valid date as input for the fields.
Is it possible to clear the existing job start date/end date for customer job in QuickBooks using QXchange?
No this is not possible using QXchange as QuickBooks SDK does not allow to clear the dates. However it is possible to modify the existing date.
How to view and print the error log?
To view the Error log, go to the Options menu, select Error log and click View Error log. To print the Error log, go to the Options menu, select Error log and click Print Error log.
How to reset all columns in a table?
The columns in a table can be reset by clicking the Reset All button.
How to integrate the source and target databases/data sources after selecting the source and target databases/data sources?
After mapping the source and the destination database/data sources, click the Save Profile icon that appears on the toolbar. Alternatively you can select Save Profile option from the Options menu or press Ctrl+S. Then click Run Data Transfer icon that appears on the toolbar. Now the source and target databases/data sources will be integrated.
Can I view the path of a profile? If so, how?
Yes, you can view your current profile while working with the application. To do so, click on the View Profile icon that appears on the toolbar. Alternatively, you can select View Profile from Profile menu or press Ctrl+V.
What is meant by Profile in QXchange?
Profile is a file that stores all settings related to a particular data transfer.
Can I create multiple profiles? If so, how many profiles will be active at a time?
Yes, you can create multiple profiles. Only one profile will be active at any particular time.
Can I view my current profile while working with the application? If so, how?
Yes, you can view your current profile while working with the application. To do so, click on the View Profile icon that appears on the toolbar. Alternatively, you can select View Profile from Profile menu or press Ctrl+V.
What are the databases does QXchange supports?
QXchange supports Excel sheets, Flat files (Text files) and other supported DAPs.
What is source database?
Source database is one from which the data is taken and inserted to the target.
What is target database?
Target database is one on which data manipulation and data insertion are done.
I have selected source database as Text, where should I browse for the required file name?
To browse for the required file, click the Browse button that appears next to the source database drop down box.
What is a Row Delimiter that is specified in a text file?
Row Delimiter is a separator that is used to separate rows or fields in the text file.
What is a Column Delimiter that is specified in a text file?
Column Delimiter is a separator that is used to separate columns or fields in the text file.
What are the encoding formats allowed while choosing a text file?
Encoding formats that can be used are ANSI, OEM and Unicode.
What is test connection?
Test connection is to test the particular database, sheet or file.
How to view the data type and length of a particular column while selecting the columns?
While selecting the columns, the data type and length of a particular column can be viewed at the bottom of its respective tree views.
What is mapping?
Mapping is process by which a particular column gets its values from the corresponding mapped column(s) of the source table.
What are tables and columns in Source and Target data sources?
For Excel Sheet, sheets are interpreted as tables and the first row of each sheet is interpreted as the columns for the corresponding sheet. For Text Files, each text file is one table where the text file name is the table name and the first row in the text file is its corresponding columns.
How to map the selected Source and Target databases?
The Source and Target databases can be mapped by dragging the columns from the Source and dropping it in the required columns of Target.
What is the use of mapping table?
Mapping table is used to integrate data.
Can I reset my mapped columns selectively? How?
Yes, you can reset the mapped columns selectively by selecting the required mapped column and clicking Reset button.
What are the various output formats supported? How do I enable a particular output format?
The various output formats supported by QXchange are as follows:
-
Zip code
-
Phone Number
-
Social Security Number
-
International Standard Book Number (ISBN)
To implement a format on a particular column, select the column and click the Format button. A window pops up, displaying the format list. Select the required option from the list and click Apply.
