CSV import of job and work step data

Created by support@fm-maschinenbau.de, Modified on Sat, 28 May, 2022 at 11:53 AM by support@fm-maschinenbau.de

What

Using CSV import, you can quickly and easily import a large number of orders and scheduled work stepsinto smartblick.


What for

You probably already work computer-aided in managing orders and planning your production. Most programs offer an export of your data.

With this function you can link the data of your planning or order management programs with smartblick.

How

If necessary, consult the instructions for the program you are already using, e.g. for Microsoft Excel or Google Sheets, to export your data to the CSV format.


The CSV format is used to display data in tabular form.

Data is sorted into columns. For the import, the file must have a specific structure.

We have prepared a template for you, which you can fill directly.

You can find this template as an attachment to this article or download it directly from the Dashboard.



Attention 
Only semicolon and tab are allowed separators!
Decimal numbers must be separated with a dot --> 10.5 



The name of the machine must exactly match the machine name at smartblick. If necessary, you must create the machine beforehand.

The planned duration of the operation must be given in hours as a decimal number.

For example, 0.75 for 45 minutes.

Each work step you want to create must be entered in a new line.


Import

Navigate to the job management and click on CSV-IMPORT.

Upload the prepared file.
You will then see which jobs and work steps will be created or modified.

When you are satisfied with the preview, you can click Createorders to complete the process.



here you can watch the instructions for the import process as a video.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article