Versions Compared

Old Version 2

changes.mady.by.user Hauke Gulich

Saved on

compared with

New Version 3

changes.mady.by.user Bärbel Neitzel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


In the basic data programs

it is possible to export the table contents into a csv.file.

This file can be edited and imported back into the table.

The data export can be performed from the entire database table without any constraints.
If, for instance, the basic data are separated by client, the system would export the data of all clients.
Please make sure to modify the data of the correct client when editing the table.

Lines with billing codes that are deleted in the Excel list will still remain in the database table.


 The data export and import does not result in the deletion of database entries.



Contents

Table of Contents

Link to the basic data


Aura panel
summaryIntroduction
paramsJTdCJTIyYm9keSUyMiUzQSU3QiUyMnRleHQlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyMzQ2NTY3MSUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybm9ybWFsJTIyJTJDJTIyZm9udFNpemUlMjIlM0ExNiU3RCU3RCUyQyUyMmhlYWRlciUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzMDE0OWIwJTIyJTdEJTJDJTIyaWNvbiUyMiUzQSU3QiUyMnNpemUlMjIlM0ExOCUyQyUyMm5hbWUlMjIlM0ElMjJib29rLW9wZW4lMjIlMkMlMjJjb2xvciUyMiUzQSUyMiUyM2ZmZiUyMiU3RCU3RCUyQyUyMmhlYWRsaW5lJTIyJTNBJTdCJTIydGV4dCUyMiUzQSU3QiUyMnRleHQlMjIlM0ElMjJJbnRyb2R1Y3Rpb24lMjIlMkMlMjJjb2xvciUyMiUzQSUyMiUyM2ZmZiUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybm9ybWFsJTIyJTJDJTIyZm9udFNpemUlMjIlM0ExOCU3RCUyQyUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJzdGFydCUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzMDA0OWIwJTIyJTJDJTIyc3R5bGUlMjIlM0ElMjJzb2xpZCUyMiUyQyUyMnRvcCUyMiUzQWZhbHNlJTJDJTIycmlnaHQlMjIlM0FmYWxzZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBZmFsc2UlMkMlMjJ3aWR0aCUyMiUzQTElN0QlN0QlMkMlMjJiYXNlJTIyJTNBJTdCJTIyYm94U2hhZG93JTIyJTNBJTdCJTIyc2hhZG93cyUyMiUzQSU1QiU3QiUyMmNvbG9yJTIyJTNBJTIycmdiYSgwJTJDJTIwMCUyQyUyMDAlMkMlMjAwLjA4KSUyMiUyQyUyMnglMjIlM0EwJTJDJTIyeSUyMiUzQTElMkMlMjJibHVyJTIyJTNBMSUyQyUyMnNwcmVhZCUyMiUzQTAlN0QlMkMlN0IlMjJjb2xvciUyMiUzQSUyMnJnYmEoMCUyQyUyMDAlMkMlMjAwJTJDJTIwMC4xNiklMjIlMkMlMjJ4JTIyJTNBMCUyQyUyMnklMjIlM0ExJTJDJTIyYmx1ciUyMiUzQTMlMkMlMjJzcHJlYWQlMjIlM0ExJTdEJTVEJTdEJTJDJTIyYmFja2dyb3VuZENvbG9yJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjNmZmZmZmYlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyMzAwNDliMCUyMiUyQyUyMnN0eWxlJTIyJTNBJTIyc29saWQlMjIlMkMlMjJ3aWR0aCUyMiUzQTElMkMlMjJib3R0b20lMjIlM0F0cnVlJTJDJTIydG9wJTIyJTNBdHJ1ZSUyQyUyMmxlZnQlMjIlM0F0cnVlJTJDJTIycmlnaHQlMjIlM0F0cnVlJTdEJTJDJTIyc2l6ZSUyMiUzQSU3QiU3RCUyQyUyMmJvcmRlclJhZGl1cyUyMiUzQSU3QiUyMnJhZGl1cyUyMiUzQTglN0QlN0QlN0Q=

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

The following basic data settings are necessary to be able to use this interface.

Contents

Table of Contents

Function in the order

Export

The export of the data takes place in the corresponding master data menu.

Open the respective basic data menu and select the local menu item Export.

Image Removed
Image Added

.

The Export CSV tab opens:

Image Removed
Image Added

.

Activate the checkbox Show column names in first row in order to export the csv. file with the field names as column headers.

Click the button ... to select the folder into which you would like to export the file.
→ A mask to select the folder opens.
→ Select a folder, name the file in the field File name and save.

The path is now saved.

Image Removed


Image Added


. 
→ Click Export to start the export.

A log about the export is also available.
Close the Export CSV tabif the export was successful.

Image Removed
Image Added



Edit the csv. file

The csv. file can now be found and opened in the target folder.

We recommend to convert the csv. file into an Excel file to edit.

ATTENTION: The column layout must NOT be changed. Otherwise the data import will no longer be possible.

ATTENTION: Please format the column CLIENT as text in Excel since it may occur that the leading zero is not saved during the conversion.
                      To verify that the column CLIENT contains a 3-digit value, open the csv. file with the editor.

Image Removed


Image Added

.

→ After editing, convert the Excel back into a csv. file.

Image Removed
Image Added

Image Removed


Image Added


Import

The import of the data takes place in the corresponding master data menu.

Open the respective basic data menu and select the local menu item Import.

Image Removed
Image Added


The Import CSV tab opens:

If you have activated the checkbox Show column names in the first row for the export, it must be activated again for the import.

Image Removed
Image Added


Select the source folder the csv. file is stored in.

Click Execude to start the import.

The log shows how many datasets have been loaded and whether the file contains erroneous datasets.
Errors are logged per line.

Image Removed
Image Added

Close the Import CSV tabif the import was successful.