Test a GetConnector using Profit

You test a GetConnector by running it manually. The GetConnector retrieves the data from the Profit database.

You can also test a GetConnector via Connect.afas.nl.

Note: Maximum size of the take

ls the number of lines being fetched is too large, you may get an "Out of Stringspace" or an "Out of memory" error message. To avoid this, make sure the Take is not too large. We recommend this rule: [Number of columns] x [Number of lines] < 150,000. In other words, choose the Take so that the number of fields in your GetConnector times the Take does not exceed 150,000. At present, this is a recommendation, not a rule. We do ask you to check your requests and adjust them if necessary, because in the future a limit to the maximum size of a Get request will be built into our software. As soon as we know when this will happen, we will inform our customers.

To test the GetConnector from Profit:

1. Go to: General / Output / Management / GetConnector.
2. Select the GetConnector.
3. Click on the action: Run.

   

4. Enter the user name and password of the connector user.
5. You determine the format and layout of the output using the Output format and Layout fields. Make certain that the output data is suitable for the 'receiving' external application.
   • XML

     In the Layout field, select Microsoft DataSet or Data set including empty values.

   • Text with separator

     In the Layout field, specify whether the field values should be separated with tabs or semicolons.

6. Select Include meta-data in the export if you want to include the field names in the output as well.
7. Select Filter and enter a filter. Use the XML Filter button to view the XML code for the filter. The more precise the filter, the better the performance of the GetConnector.

   In Command line (without filter), you see how the command line looks with the settings that you have entered. Any filters that have been set are not incorporated into this.

8. Click on: OK. 

   You see the records retrieved by the GetConnector in a separate window.

9. Close the window.