Excel-Import

Aus PPwiki
Version vom 5. September 2017, 15:54 Uhr von Admin (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „A prerequisite for the import of Excel folders is that the columns to be imported have been set up previously and have been saved using the VTE button. To imp…“)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Wechseln zu: Navigation, Suche

A prerequisite for the import of Excel folders is that the columns to be imported have been set up previously and have been saved using the VTE button.

To import an Excel folder from the workbook, follow the steps below.


1. Open the Order section in the main screen and then click the item Auftragsverwaltung über Auswahlmaske

2. Open now neue Arbeitsmappe

ArbeitsmappeImport 01.jpg

3. Change to the tab Arbeitsmappe. A new window opens.

4. In the new window, click the small Button on the right and confirm in the calendar with o.k.

ArbeitsmappeImport 02.jpg


ArbeitsmappeImport 03.jpg

5. Now confirm the delivery time with Ausführen.

ArbeitsmappeImport 04.jpg


6. You are now back in the mask of the workbook and you can go to the top rightButton VTI

7. In the now open window, select the Excel folder to be imported.

(If the file you are looking for should not be shown, please check if you are in the correct folder and if you are looking for the correct Excel version)

ArbeitsmappeImport 05.jpg

8. If you are using the file with o.k. You will be imported into the workbook

  If your import is a customer with several delivery addresses, you must first select the delivery address.


ArbeitsmappeImport 06.jpg

9. Once the data has been imported, you have the option to change, delete, or add rows.

10. Now the order has still to be with the button Auftrag vorschlagen be handed over. Confirm the query with Yes to create a single job for each delivery week.

ArbeitsmappeImport 07.jpg


Deutsch.png Flag-of-Sweden-300px.png