FAQ

Below is a collection of frequently asked questions and answers with regard to CSI Data Xtractor's functionality.

If the below FAQ collection does not help you out, don't hesitate to get in touch with the CSI tools support helpdesk.

What is the best way to register CSI Data Xtractor with a new manifest?

First, replace the older security manifest with the latest one in the installation folder of CSI Data Xtractor.

Start off by making sure you have writing rights on the following folders:

C:\Program Files (x86)\CSI tools (or any other installation folder)
C:\ProgramData\CSI tools (This is a hidden folder)

Once these actions are done, open up the application and accept the user license agreement. Hold the CTRL-key while clicking on "Request licenses". A new window will open, requesting the clear code. This clear code has to be provided by our support team, as this code changes daily.

Once applied, the server information will reset, allowing you to register the application by clicking "request licenses". Enter the email address of the person responsible in terms of licensing. The application should now be registered.

In case you get an error in the web, please follow the steps to generate an offline request file. This request file should then be sent to CSI tools' support desk for further offline validation.

Can we download any table in SAP? The application proposes a template for security, but can more tables be extracted as well?

It is possible to download single tables using the Quick Read functionality.

The data can then be filtered using SQL syntax.

Is there a limit to the amount of data CSI Data Xtractor can handle?

We have yet to run into a system where CSI DX could not handle the amount of data in a table. It is however possible that settings need to be tweaked somewhat, but data should not be an issue. Of course, the bigger the amount of data, the longer a download may take.

If you find a certain combination of tables useful, i.e. if you always download the same set of tables, it is possible to make your own download set (in addition to the default download set in CSI Data Xtractor.) This way you can prevent un-wanted tables from being included every time you perform a download.

The export of some tables appears to have failed, why is that?

SAP fields with internal type 'P' and datatype 'CURR,DEC,...' are, depending on size and decimal places, not always returned correctly by RFC_READ_TABLE. If you choose to read those fields an indication is placed in the log file and you should check the field values before using them in calculations.

In order to solve this particular issue, go to "Configuration - Download" and enable the checkbox "Read fieldtype P".

It looks like I'm getting corrupt data when I import STAD data into my database, why is that?

The screenshot above shows how you data may be displayed when STAD data becomes "corrupted".

This issue is caused by missing authorizations in SAP. The SAP user that is used to download the data needs to have the value "S_TOOLS_EX_A" for the authorization object "S_TOOLS_EX" in SAP.

When this authorization is added to the user, the data in the "BNAME" fields will not be encrypted when taking downloads from the SAP system.

Are there specific settings I need to take into account when I want to use SSO (Single-Sign-On)?

To start using SSO with the CSI tools applications, some configuration is required. In the configuration of CSI Data Xtractor, make sure to fill in the SNC (Secure Network Communications) properties. This info can be found in the System Entry Properties of your SAP system.

For more information, please See "SAP Connection"

I'm running into scaling issues with my application, I'm running the latest version of Windows 10. How can this be solved?

This can be solved by applying the following settings to the application's executable file:

Open the executable properties (for example: CSI DX.exe) and go to the compatibility tab. At the bottom, press "Change high DPI settings", this will open a new pop-up window. In this window, enable "Override high DPI scaling behaviour." Select "System (Enhanced)" for Scaling performed by."

Press OK twice to close all property windows, and open the application again.

The scaling issues should now be resolved. If not, please get in touch with our support helpdesk.

Is it possible in SAP to manually consult the STAD results for TOTAL?

Yes, this is possible by following these steps:

In SAP, run transaction SE37. In this transaction, enter SAPWL_WORKLOAD_GET_STATISTIC as the Function Module and press F8 on your keyboard to execute.

In the import parameters, fill in the appropriate parameters:

Periodtype: M

HostID: TOTAL

Startdate: e.g: 01.06.2019

Only_Application Statistic: X

Instance: TOTAL

Next, press F8 again to execute this function module.

Next, a result screen should open, where you can check the "APPLICATION_STATISTIC" for your results and amount of entries that are found.

My date filter is not being taken into account in my "WHERE" clause when preparing a download (set). What am I doing wrong?

When downloading data from SAP, take into account that the dates that are used are stored in a SAP table, on a database level. This also means that the date notation is always set as YYYYMMDD. When preparing a where clause with "ERDAT BETWEEN" two dates, use this time notation.

For example: ERDAT BETWEEN '20200101' AND '20201231'.