FCM_User Reference Manual.pdf.pdf - 第176页

MIS User Re ference Manual 4022 5 91 96082 5-84 F CM Mult ifl ex 02.02 ▼ Controls ■ sel ect the MIS peri od from the [A v ail abl e pe riod s ] win do w in th e [Expo rt. ..] men u (se e SCREEN 5-49) fr om which y ou w a…

100%1 / 306
4022 591 96082 User Reference Manual
02.02 FCM Multiflex 5-83
MIS
fcm0570a.tif
SCREEN 5-62 MIS periods data files directory relations
fcm0571a.tif
SCREEN 5-63 MIS export files directory relations
Deleting a certain MIS period will also automatically delete all associated MIS
export files, unless you allocated an alternative, not-default export directory
before.
}
MIS periodes data
directories, called
after their related
order names
MIS export
sub-directory,
created with
the same name
as the concerned
MIS period
MIS export
data files,
numbered
00 through 99
MIS
User Reference Manual 4022 591 96082
5-84 FCM Multiflex 02.02
▼Controls
■ select the MIS period from the [Available periods] window in the [Export...]
menu (see SCREEN 5-49) from which you want to export its data
■ select the proper export format in the
[Select export file format] window
■ select
[OK] to export the MIS data
■ select [Cancel] to quit the menu
fcm0572a.tif
SCREEN 5-64 [Export...] screen example
If you selected a past MIS period, an export file is immediately created with all MIS
data from that period.
If you selected a running MIS period, an export file is immediately created with all
MIS data so far. Each time you give this command again, a new, extra file will be All
these files will be numbered as “MANEXPxx.TXT”, where
MAN = manual
1 ;
EXP = export;
xx = serial number.
Numbering is from 00 through 99; after number 99 is reached, MIS will overwrite
the old exports, starting with the number 00.
Selected export file format
Within the
[Export...] menu (see SCREEN 5-49), you can select different export file
formats. All formats are in ASCII text, and they differ only in what delimiter
format is used.
1. This text was only functional in the former MIS
version to distinguish between manual and auto-
matic export.
4022 591 96082 User Reference Manual
02.02 FCM Multiflex 5-85
MIS
Following formats advice is given.
TABLE 5-42
Examples
A fragment of a MIS export file generated with the
[Quoted strings] file format
option could look as follows:“Module:” “PIP 1”
“Label” “feed_pos” “pick_pos” “n_pick” “Aut.AP” “Aut.AA” “Man.AA” “Man.AP” “Lost.AA” “Ret.AP” “skipped” “placed”
“COUNTS” 1 1 2086 0 2 0 0 2 0 1 2080
“COUNTS” 2 1 3124 1 1 0 0 3 0 0 3120
“COUNTS” 3 1 1048 2 2 1 0 0 3 1 1040
“COUNTS” 4 1 1045 0 2 1 0 0 1 1 1040
“COUNTS” 5 1 2083 0 2 1 0 0 0 1 2080
“COUNTS” 6 1 3134 3 0 1 0 4 0 0 3120
TABLE 5-43
The same fragment
[Comma delimited] would read:
Label feed_pos pick_pos n_pick Aut.AP Aut.AA Man.AA Man.AP Lost.AA Ret.AP skipped placed
COUNTS 1 1 2086 0 2 0 0 2 0 1 2080
COUNTS 2 1 3124 1 1 0 0 3 0 0 3120
COUNTS 3 1 1048 2 2 1 0 0 3 1 1040
COUNTS 4 1 1045 0 2 1 0 0 1 1 1040
COUNTS 5 1 2083 0 2 1 0 0 0 1 2080
COUNTS 6 1 3134 3 0 1 0 4 0 0 3120
TABLE 5-44
▼Export file description
Each export file is split up into:
■ Period info
■ Time registration
■ Production counts
■ Process errors
■ Machine errors
REMARK: PLease bear in mind that not all MIS reports data are included in the export
files.
Delimiter External program Remarks
[Quoted strings] Lotus 1-2-3 import into Lotus 1-2-3 with command
[File] > [Import; Delimited text file]
[Tab delimited] MS-Excel and OS/2-
Excel
open file in Excel as [Text file]
[Comma delimited] dBase or MS-Excel
[“|” delimited] SQL databases e.g. Informix