CARL Source
System FAQ
System > System FAQ
 Access to the application

How do I find the feature I need?

If, after following the steps described in the online help, you cannot find the feature, it means your user profile does not have access to it. Ask the administrator to perform an assignment of a different profile (Edit a user), or to edit the profile you are assigned to (Edit a Profile). This may also be related to your customization group.

 

I forgot my password

Ask the administrator to reset your password (Manage users).

 Data access restriction group

How do I add the criteria values that users in the group are entitled to?

To modify this list, you must first uncheck the "Access to all values" box for the criterion in question.

 Data exchange
No lines were processed; how should I interpret the runtime errors?

These errors may be due to an incorrect file format or a server error.

Specifically:

"Msg: The export failed with errors: queue not bound"
means that a service did not start correctly. In this case, the administrator must view the server log.

"javax.xml.transform.TransformerException: org.xml.sax.SAXParseException: The processing instruction target matching "[xX][mM][lL]" is not allowed."
means that the file contains syntax errors or that its format is incorrect.
Verify that the file is in the format specified by the external system, and if it is not, convert it.

 

The file to be imported is too large.

The maximum file size for import is parameter central editable.

 

Importing a reading causes an error.

In import files, the order of attributes is generally irrelevant. However, for reading records, the Reading point must be placed in the file BEFORE the measurement.

 

How do I export a constant value to a CSV file?
  • In the Standard version, add a field without an alias, of the "Alphanumeric" type.
    Check the "Ignore" box.
  • Access the transformations In the "Transformation" column, enter the value of the constant in quotation marks.
    Example: "CONSTANTE" or "CONSTANTE".
 Data cleansing
Some tables are growing significantly; is it possible to reduce their size?

There are jobs allowing you to delete data.
Examples:

  • EXCHPURGEJOB deletes messages imported from external systems.
  • CSJOBPURGEINTEXEC deletes the execution history of exchange interfaces.
  • CSJOBPURGEAUDIT deletes audit tables and allows you to specify which audit table to clean.

Additionally, in the functionality System ConfigurationIn the [Traces] tab, there is a setting called "Number of days of history"; the default is 10 days, but you can reduce this if you wish.
Also pay attention to the enabled trace profiles (see the [Traces] tab—subtabs: [Trace Profiles] and [Specific Configuration]); the more traces you enable, the more likely the trace table is to increase in size.

 Changing the display format of a numeric value
How do I change the display format of a numeric field?

The procedure to follow is described below using an example.

From the functionality Customization of labels, click on Creation To add a line as shown in the example:

  • Code: MONTANT3D (if 3 decimal places, 4D if 4)
  • Language: French
  • Original text: #0.000 ¤ (#0.0000 ¤ if 4 decimal places)
  • Custom text: (leave blank)
  • File: formats

Then, save.

If multiple languages are used, a label must be added for each language.

Next, depending on the field to be modified, select the relevant object in the Dictionary. (For example, INVOICELINE, to modify the format of an amount on the invoice line).
Select the relevant attribute:

  • invoiceNetUnitPr (for unit price excluding tax)
  • InvoiceAmountHT (for the total price excluding tax)
  • AmountHT (for the total amount billed excluding tax on the invoice)

Add the following to the "Format" field: MONTANT3D (or 4D)
Then, save.