Skip to content

Exporting data

Your data belongs to you. You can download lists and key figures as a file at any time and hand a completed order over to the accounting software e-računi. This page shows both ways and says clearly what eelikField does not do: it does not write invoices.

Almost every list has an “Export” button above the table. This applies to “Orders”, “Inquiries”, “Customers”, “Locations”, “Assets”, “Articles”, “Suppliers” and “Material”. In “Offers”, the button is also called “Export”.

  1. Set up the list the way you need it: view, filter and search.
  2. Click “Export”.
  3. Choose “Export as CSV” or “Export as Excel”.
  4. The file is downloaded.

Important:

  • The file contains all the rows that your setting produces, not only the rows on the visible page. The file name begins with the name of the list, for example “auftraege”.
  • If the list is empty, the button is grey.
  • A CSV file separates the columns with a semicolon and is saved in UTF-8. Excel opens it correctly with umlauts.
  • The Excel file is a simple spreadsheet file that Excel opens directly. Numbers appear there as numbers.
  • In the list “Inquiries” there is also the bar for selected rows. Tick individual inquiries and click “Export” there to download only those.

Which columns are included depends on the list. In the order list they are “Number”, “Customer”, “Title”, “City”, “Type”, “Status”, “Material”, “Next date”, “Team”, “Value”, the currency and “ERP”.

Each of the six cards on the page “Reports” has an “Export” button. It downloads the figures of that card as a CSV file, for example “bericht-umsatz-angebote” or “bericht-wartungen-faellig” (see Reports).

The “Export center” under Integrations

Section titled “The “Export center” under Integrations”

Under “Integrations”, in the area “Data tools”, there is the tile “Export center”. Its description says what it does: “Downloads the list of connections on this page as a CSV file (status, imported and exported records). Offers, inquiries, documents and reports are exported from their own lists.” The button “Open” therefore downloads only an overview of the connections as a CSV file: for each connection the status and the number of imported and exported records. This file does not contain orders or invoices. For your orders and master data, use the lists above.

For importing there is the “Import wizard” (customers and articles from CSV). It is described with the master data (see Customers).

The page “Integrations”

The page separates what works today from what is planned.

Tile Description on the tile Status
“CSV / Excel” File import & export usable: The button “Open wizard” starts the import wizard.
“e-računi” Accounting & e-invoicing usable: “Configure”, “Test connection” and “Logs” (see below).
“Import wizard” Customers and articles from CSV usable
“Export center” List of connections as CSV usable (see above)
“ERPNext”, “PANTHEON”, “Minimax”, “SAOP”, “REST API”, “SFTP”, “Webhooks” for example “Open-source ERP”, “Custom interface”, “Event notifications” “Planned”: cannot be clicked
“Developer documentation” “Planned”: cannot be clicked

The planned connections are in the area “Planned connections” with the badge “Planned”. It says there: “These connections are in preparation and cannot be used yet.” They can be neither set up nor tested. The menu “Add integration” offers only e-računi.

e-računi is accounting software for invoices. eelikField can create a completed order there as an invoice draft. You check, complete and send the invoice itself in e-računi.

Only Owners and Administrators can do this.

  1. Open “Integrations” and the tile “e-računi”.
  2. Click “Configure”. “Connect e-računi” opens.
  3. Enter: “API username”, “API secret key (secretKey)”, “Organization token” and “API endpoint (URL)”. You get these details from e-računi. The endpoint must begin with https and belong to e-računi.
  4. Click “Save”. The access data is stored encrypted and is never shown.
  5. Click “Test connection”. Success reads: “Connection successful: endpoint reachable and authenticated.”

Later you change the data by entering it again. “Disconnect” ends the connection.

  1. Complete the order. Before that, the order says: “Export to e-računi only after the order is completed.”
  2. Open the order. At the “ERP status” there is the button “Export to e-računi”.
  3. Click it. After “Exporting…” you see: “Order exported to e-računi as a draft.”
  4. The “ERP status” of the order is “Exported”, with the invoice number below it.

These rules apply:

  • The roles Owner, Administrator and Office may export. Otherwise you see: “Not allowed to export.”
  • An order is exported only once. A second attempt gives “Already exported to e-računi.” This way no duplicate invoice is created.
  • Cancelled orders are not exported. Conversely, an order whose invoice is already in e-računi can no longer be cancelled.
  • The export only applies to orders in euros: “Export is only possible for documents in euros.”
  • If e-računi is not connected: “e-računi is not connected: set it up under Integrations first.”

“Export to ERP” and “Ready for ERP”

Section titled ““Export to ERP” and “Ready for ERP””

Every completed order automatically appears in the order list under “Ready for ERP” and on the overview in the tile “Ready for ERP export”. In the card “Completion” of a completed order there is also “Export to ERP”. This explicitly releases the order: the “ERP status” then says “Ready”, and in the order list the column “ERP” shows “Ready”. Nothing is transferred with the release. It is a marker for your work. The roles Owner, Administrator, Office and Dispatcher see the button.

If the transfer breaks off in the middle of sending, the invoice may already have been created in e-računi. The order then shows “Export status unclear” with a note that the Owner or Administrator checks this in e-računi and resolves it here. eelikField never transfers such an order again by itself, so that no second invoice is created.

This is how you resolve it (Owners and Administrators only):

  1. Look in e-računi to see whether the invoice was created for this order.
  2. On the order, click “Resolve export…”.
  3. Choose:
    • “Booked”: The invoice is in e-računi. Enter the “Document number from e-računi (required)”. The order counts as exported and is not transferred again.
    • “Not booked”: There is no invoice in e-računi. The order can be transferred normally again. If the transfer has only just broken off, wait a few minutes and look again. If e-računi still creates the invoice after all, the next export creates a second invoice.
  4. Click “Confirm”.
  • No invoices in eelikField. There is no function “write invoice”, no invoice numbers, no payment tracking and no reminders. You create invoices in your accounting software, if you wish from the draft in e-računi.
  • No further accounting connections. Under “Planned connections” you find ERPNext, PANTHEON, Minimax, SAOP, “REST API”, SFTP and Webhooks, plus the “Developer documentation”. They carry the badge “Planned” and have no function yet. Only e-računi is ready to use. The tile “CSV / Excel” stands for the import.
  • No export of times or work reports as a collective file. You download the work report of an order as a PDF (see Work report). You see the times of an order in the tab “Time entries”.

My Excel file shows everything in one column. The CSV file separates with a semicolon. In Excel, choose the semicolon as the separator when opening, or use “Export as Excel”.

Can I change a date of the list in the export? No. The file shows what the list shows.

Do I have to use e-računi? No. If you use other accounting software, download the order list as a file and carry on there.