Importing Data: Difference between revisions
From MultiCharts
→How to import ASCII data
Dave Masalov (talk | contribs) No edit summary |
|||
Line 41: | Line 41: | ||
#*# Click '''Custom''' if there is no such template. | #*# Click '''Custom''' if there is no such template. | ||
#*# Create a template. If the number of symbols in the date changes, use an asterisk * to replace the symbol, e.g. 9/9/2004 changed to 10/9/2004. The number of symbols changes from 6 to 7. | #*# Create a template. If the number of symbols in the date changes, use an asterisk * to replace the symbol, e.g. 9/9/2004 changed to 10/9/2004. The number of symbols changes from 6 to 7. | ||
#*#* Allowed symbols in template for Date: '''m''' - month, '''d''' - day, '''y''' - year; | |||
#*#* '''*''' sign means that length of chunk is undefined;<br><div style="background-color: #E5F6FF;">'''Example''': To convert date ''1 Feb 2002'' (2/1/2002) type ''*d mmm yyyy'' in the template field.</div> | |||
#*# Apply the created template by selecting it from the list. | #*# Apply the created template by selecting it from the list. | ||
#* The Time filed is not defined or not properly defined | #* The Time filed is not defined or not properly defined | ||
Line 48: | Line 50: | ||
#*# If the template does not exist, click '''Custom'''. | #*# If the template does not exist, click '''Custom'''. | ||
#*# Create a template. If the number of symbols in the date changes, use an asterisk * to replace the symbol, e.g. 8:30 changes to 10:10. The number of symbols changes from 4 to 5. | #*# Create a template. If the number of symbols in the date changes, use an asterisk * to replace the symbol, e.g. 8:30 changes to 10:10. The number of symbols changes from 4 to 5. | ||
#*# | #*#* Allowed symbols in template for Time: '''h''' - hour, '''m''' - minute, '''s''' - second, '''t''' - time modifier AM/PM. | ||
#*#* '''*''' sign means that length of chunk is undefined; | |||
#*#* '''@''' sign split the whole template and time modifier PM lexem.<br><div style="background-color: #E5F6FF;">'''Example''': To convert time ''9:20 PM'' type ''*h:*m tt@pm'' in the template field.</div><br><div style="background-color: #E3FBE5;">'''Note''': Templates are stored in recognition engine's local settings. Time modifier can be in any language supported by current operating system.</div> | |||
#*# Apply the created template by selecting it from the list. | #*# Apply the created template by selecting it from the list. | ||
#* Wrong detection of the starting line of quotes | #* Wrong detection of the starting line of quotes | ||
Line 58: | Line 62: | ||
<br> | <br> | ||
== Invalid ASCII files == | == Invalid ASCII files == | ||
In most cases the invalid files are lacking the required fields, lacking data in some column, mixed up time and dates, irregular bar intervals. The program filters most faults and informs the user of them, but it is not possible in each and every case. Please see the analysis of typical invalid files below. | In most cases the invalid files are lacking the required fields, lacking data in some column, mixed up time and dates, irregular bar intervals. The program filters most faults and informs the user of them, but it is not possible in each and every case. Please see the analysis of typical invalid files below. |