Language:


Raw Data

This page describes the 'Raw Data' Export function in the System module.

---

The Raw Data export is used for system maintenance, and requires a HansaWorld system expert to be used correctly.

If your database somehow becomes damaged while you are using it, you will be prompted to create a Raw Data export. You should do so, from the prompt or using this function. The Raw Data option exports data in byte order, while the Database Text Backup exports data in record order, on a register-by-register basis. When a database is damaged, the Raw Data option may create an export file where the Database Text Backup fails. However, because the database is damaged, restoration from a Raw Data export is not guaranteed. Therefore, if the Raw Data option successfully creates an export file, you should then attempt to create a Database Text Backup, to make a successful restoration more likely.

If you need to restore a database from a Raw Data file to follow these steps (using the GUI application in a client-server system):

  1. Make sure the folder or directory containing your Standard ERP application does not contain a "HANSA.HDB". file and launch the application.

  2. When the 'Welcome to Standard ERP' window appears, click the [Local Company] button. Follow the instructions on the Creating a New Database - Server or the Creating a New Database - Single-user pages respectively.

  3. Referring to the 'Single-user' section on the Changing and Adding Companies page, create all the Companies as they were in the damaged database (in particular, the Codes must be the same as they were in the damaged database).

  4. Create all Fiscal Years exactly as they were in the damaged database (in every Company).

  5. In every Company, configure the Company Date and Numeric Format setting in the System module as follows:

    Date Order
    Month, Day, Year

    All three check boxes
    ticked

    Date separator
    / or -

    Decimal Separator
    . (a single full stop, not a comma)

    Thousand separator
    space (one single space)

  6. Ensure you are in the System module and use the Ctrl-Shift-I/⌘-Shift-I keyboard shortcut to open the 'Imports' window. Choose one of the options depending on where the Raw Data file is located and import it.

    If the Raw Data file is large, you may prefer to use the command line application (Linux or macOS) for this step, as the speed benefit will be significant.

  7. Even if the Raw Data file is imported successfully, the database will not be useable because no indexes will be created. Therefore, as soon as the Raw Data file has been imported, you must immediately create a Database Text Backup and import that file to a new database. This will ensure the data is properly indexed. Again, you may prefer to use the command line application (Linux or macOS) for this step.
---

Go back to: