The file layout of "Current license information files" is shown as follows.
File format
The first line: Download date and time, select section, section code License name
The second line: Item names
"Order number", "supplementary number", "section that can use usable section name", "purchased number", "allocated number", "purchased amount of money", "purchase date", Supplier, Purchasing Department, Purchaser, License Type, License Type (Remarks), License Form, License Form (Remarks), License Agreement, License Agreement (Remarks), License Certificate, Certificate Number, Management Department, Storage Location, Original License Management Number, Other Conditions, Scheduled Update Date, Remarks, "section code", "PC name", "user ID", and "name"
The third line: collect information and distribute data
1st column: order number
2nd column: supplementary number
3rd column: section that can use
4th column: purchased number
5th column: allocated number
6th column: purchased amount of money
7th column: purchase date
8th column: Supplier
9th column: Purchasing Department
10th column: Purchaser
11th column: License Type
12th column: License Type (Remarks)
13th column: License Form
14th column: License Form (Remarks)
15th column: License Agreement
16th column: License Agreement (Remarks)
17th column: License Certificate
18th column: Certificate Number
19th column: Management Department
20th column: Storage Location
21st column: Original License Management Number
22nd column: Other Conditions
23rd column: Scheduled Update Date
24th column: Remarks
25th column: Section Code
26th column: PC Name
27th column: User ID
28th column: Name
File output example
"06/23/2016 16:28:18","Object for management","111111","SOFTA" "Order number","Supplementary number","Section that can use","Purchased number","Allocated number","Purchased amount of money","Purchase date","Supplier","Purchasing Department","Purchaser","License Type","License Type (Remarks)","License Form","License Form (Remarks)","License Agreement","License Agreement (Remarks)","License Certificate","Certificate Number","Management Department","Storage Location","Original License Management Number","Other Conditions","Scheduled Update Date","Remarks","Section code","PC name","user ID","Name" "100000",1,"Information Systems Department",3,0,,"06/17/2016","","","General Affairs Department","Jhon Smith","Package license","","Full license","","Concurrent connections lisense","10","Package","","Information Systems Department","A05 ","","Downgradable","","111111","PC1","USER1","SOFTA" "100001",1,"Information Systems Department",2,1,,"06/23/2016","","","","","","","","","","","","","","","","","","111111","PC2","USER2","SOFTB" |