Hi Experts, An automation of Unprocessed data(oracle rows) table where a shell script is written to check if there are any records inserted into the table on daily basis. Whenever rows passed into this table on a particular day, there will be a time where the script can be scheduled around 7:00 am GMT on crontab to raise automated alerts such as Assyst ticket detailing the source row information.
1) Here got stuck up about how the output rows are attached with the automated ticket in CSV format.
2) Any correction of code, if that can be achieved in simple. thanks in advance,
Here goes my code,
Code:
# /* ----------------------- Initialisation ---------------------------- */
# /*---------------------------------------------------------------------*/
# /*------- Determine ORACLE schema for HUB
SCHEMANAME=`echo ${ENVDEF}_HUB | tr 'A-Z' 'a-z'`
fExtractInstance
# /*--------------------- Main Process
fSelectRow
Moderator's Comments:
Please use code tags when posting data and code samples!
Last edited by pludi; 03-04-2011 at 07:36 AM..
Reason: code tags, please!
Hi,
I need a script that can insert csv file into the special sheet of excel (other sheets in this excel include charts which use data of the special sheet). Could you help me please? (2 Replies)
I need help with writing a shell script for writing data from a table into a .csv file and send the file has email attachment.
I stuck up with attaching the file to the email.
Thanks, (1 Reply)
Hi,
The result of a script is a csv file in the following format: cat $file_name
DATA_USAGE_FACT,YES_NO_FLG,TARGET_TABLE,YES_NO_FLG,1,0,15,0
DATA_USAGE_FACT,DATE_OF_CREATION,TARGET_TABLE,DATE_OF_CREATION,29,9,19,0
DATA_USAGE_FACT,UPDATION_DATE,TARGET_TABLE,UPDATION_DATE,29,9,19,0... (3 Replies)
Hi,
My requirement is to get attach two different text file contents to two different sheets in same excelsheet. Also, is there any way we can name the tabs as desired ?
Kindly assist. (2 Replies)
Hi Guys,
I need a help with attaching the sub mirrors as it keep throwing errors.
I have done solaris live upgrade and it was succesful but it keeps throwing error only for root (s0) and swap (s1)when i try to attach them.
For rest of the partitions for slices 3,4,5 on target 1 are able to... (4 Replies)
Hi,
I have installed few Veritas packages in my local zone. Prior to that, I had detached non-global zones. After successfull installation of veritas packages on global zone, I am attaching non-global zones with -u option, but stuck with one NGZ. One of the NGZ is having gsk7bas 7.0.4.38 while... (5 Replies)
Hi All, Firstly I will like to wish A Happy New Year to all.
Now my issue is
I have one csv file say(data.csv) and one excel file say(result.xls)
The result.xls contains two sheet name Sheet1 and Sheet2, Now What I am trying to do is to First I want to delete that data of Sheet2 if present any,... (6 Replies)
Hi folks,
I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx).
Spreadsheet contains few lines of hyperlink data (pic attached).
P.S. Hyperlink is behind the data and not visible in excel sheet directly.
Now using perl script I need to copy the hyperlinks in... (3 Replies)
Hi All,
I woulk like thanks to all of you for your instant support. I am again in a trouble so move to here for solution. I want to add a new sheet or a new tab in a csv file means a singly csv file having two or more sheets. Please help me any help towards this should highly be appreciated.
... (3 Replies)
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
LEARN ABOUT DEBIAN
mdbfontencoding
mdbFontEncoding(5) The m17n Library mdbFontEncoding(5)NAME
mdbFontEncoding - Font Encoding
DESCRIPTION
The m17n library loads information about the encoding of each font form the m17n database by the tags <font, encoding>. The data is loaded
as a plist of this format.
FONT-ENCODING ::= PER-FONT *
PER-FONT ::= '(' FONT-SPEC ENCODING [ REPERTORY ] ')'
FONT-SPEC ::=
'(' [ FOUNDRY FAMILY
[ WEIGHT [ STYLE [ STRETCH [ ADSTYLE ]]]]]
REGISTRY ')'
ENCODING ::= SYMBOL
FONT-SPEC is to specify properties of a font. FOUNDRY to REGISTRY are symbols corresponding to Mfoundry to Mregistry property of a font.
See m17nFont for the meaning of each property.
For instance, this FONT-SPEC:
(nil alice0 lao iso8859-1)
should be applied to all fonts whose family name is 'alice0 lao', and registry is 'iso8859-1'.
ENCODING is a symbol representing a charset. A font matching FONT-SPEC supports all characters of the charset, and a character code is
mapped to the corresponding glyph code of the font by this charset.
REPERTORY is a symbol representing a charset or 'nil'. Omitting it is the same as specifying ENCODING as REPERTORY. If it is not 'nil', the
charset specifies the repertory of the font, i.e, which character it supports. Otherwise, whether a specific character is supported by the
font or not is asked to each font driver.
For so called Unicode fonts (registry is 'iso10646-1'), it is recommended to specify 'nil' as REPERTORY because such fonts usually supports
only a subset of Unicode characters.
COPYRIGHT
Copyright (C) 2001 Information-technology Promotion Agency (IPA)
Copyright (C) 2001-2011 National Institute of Advanced Industrial Science and Technology (AIST)
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License
<http://www.gnu.org/licenses/fdl.html>.
Version 1.6.2 12 Jan 2011 mdbFontEncoding(5)
02-15-2011
Help in attaching the csv sheet in alerts
