Konica Minolta bizhub C364e PageScope Authentication Manager User Manual Versi - Page 49

Editing an exported file

Page 49 highlights

Authentication Manager 3 3.1.19 Editing an exported file Editing an exported file The exported file can be edited and saved in a spreadsheet application. 2 Reminder To edit and save an XML file in a spreadsheet application, specify the file type to "XML Spreadsheet", and then save it. For the procedure to edit a tab-delimited text file (.txt) or a commadelimited CSV file (.csv) in a spreadsheet application, see "Editing a text or CSV file". Editing a text or CSV file The following procedure describes how to edit an exported tab-delimited text or comma-delimited CSV file in Microsoft Excel. 1 Open the spreadsheet application. 2 Select "Open". 3 Select the exported file. - As a file type, select "All Files" or "Text File". The Text Import Wizard appears. 4 Specify the format of data to be delimited, and then click the [Next] button. - For "Original data type", select "Delimited - Characters such as commas or tabs separate each field". - As the reading start row, select "1". - Select "UTF-8" as the character code. 5 Specify a delimiter for the field, and then click the [Next] button. - To edit a text file, select the "Tab" check box in the "Delimiters" section. - To edit a CSV file, select the "Comma" check box in the "Delimiters" section. - Clear the check box for specifying whether the continuous delimiters are to be handled as one character or not. - Select " (double quotation mark) for "Text Qualifier". Authentication Manager 3-32

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188

Authentication Manager
3
Authentication Manager
3-32
3.1.19
Editing an exported file
Editing an exported file
The exported file can be edited and saved in a spreadsheet application.
2
Reminder
To edit and save an XML file in a spreadsheet application, specify the file
type to "XML Spreadsheet", and then save it.
For the procedure to edit a tab-delimited text file (.txt) or a comma-
delimited CSV file (.csv) in a spreadsheet application, see "Editing a text
or CSV file".
Editing a text or CSV file
The following procedure describes how to edit an exported tab-delimited
text or comma-delimited CSV file in Microsoft Excel.
1
Open the spreadsheet application.
2
Select "Open".
3
Select the exported file.
As a file type, select "All Files" or "Text File".
The Text Import Wizard appears.
4
Specify the format of data to be delimited, and then click the [Next]
button.
For "Original data type", select "Delimited - Characters such as
commas or tabs separate each field".
As the reading start row, select "1".
Select "UTF-8" as the character code.
5
Specify a delimiter for the field, and then click the [Next] button.
To edit a text file, select the "Tab" check box in the "Delimiters"
section.
To edit a CSV file, select the "Comma" check box in the
"Delimiters" section.
Clear the check box for specifying whether the continuous
delimiters are to be handled as one character or not.
Select " (double quotation mark) for "Text Qualifier".