Sponsored Content
Top Forums Programming Shell script - to see if any change from last csv Post 302991795 by robertkwild on Friday 17th of February 2017 04:20:21 AM
Old 02-17-2017
i will give you the code to the Imacros -

Code:
VERSION BUILD=10.3.27.5830
TAB T=1
URL GOTO=http://172.17.4.52/
FRAME NAME=theHeader
TAG POS=1 TYPE=A ATTR=TXT:Properties
FRAME NAME=theBottom
TAG POS=1 TYPE=INPUT:TEXT FORM=ACTION:/userpost/xerox.set ATTR=NAME:webUsername CONTENT=admin
SET !ENCRYPTION NO
TAG POS=1 TYPE=INPUT:PASSWORD FORM=ACTION:/userpost/xerox.set ATTR=NAME:webPassword CONTENT=password
TAG POS=1 TYPE=BUTTON:SUBMIT FORM=ACTION:/userpost/xerox.set ATTR=TXT:Login
FRAME NAME=theTree
TAG POS=1 TYPE=A ATTR=TXT:Login/<SP>Permissions/<SP>Accounting
TAG POS=1 TYPE=A ATTR=TXT:Accounting<SP>Methods
FRAME NAME=theContent
TAG POS=1 TYPE=BUTTON ATTR=TXT:Report<SP>and<SP>Reset
TAG POS=2 TYPE=INPUT:RADIO FORM=ACTION:# ATTR=NAME:frmusageReportList CONTENT=YES
ONDOWNLOAD FOLDER=Z:\printers\accounts\ FILE={{!NOW:dd-mm-yyyy}}_XSAreport.csv WAIT=YES
TAG POS=1 TYPE=BUTTON FORM=ACTION:# ATTR=TXT:Download<SP>Report<SP>(.csv)
WAIT SECONDS=10

and i run this batch script everynight using task scheduler -

Code:
"C:\Program Files\Ipswitch\iMacros\iMacros.Sidebar.exe" -macro "C:\ie_imacro\iMacros\Macros\accounts.iim"

so what the batch file does is that it runs the imacro program for the accounts printer

it saves the file in the location "Z:\printers\accounts\ FILE={{!NOW:dd-mm-yyyy}}_XSAreport.csv"

it runs 24/7 and produces csv reports for all the days (the attachment i showed you)

all this runs on a windows 7 machine

now i want to extract the csv data in specific columns D, E, F and the whole of column A as column A is showing the clients/customers names

am i making any sense?

sorry if im not

---------- Post updated at 11:20 AM ---------- Previous update was at 10:42 AM ----------

im getting somewhere -

Code:
awk -F"," '{print $1,$4,$5,$6}' 16-02-2017_XSAreport.csv

---------- Post updated 02-17-17 at 04:20 AM ---------- Previous update was 02-16-17 at 11:20 AM ----------

Code:
awk -F',' 'NR>3 {print $1,$4,$5,$6}' 16-02-2017_XSAreport.csv

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Modifying a csv file from Shell Script

Hi all, I have some script that creates a temp csv file. What I need to do is do some search and replace and modify the file from my shell script. I know the commands to open the file and then apply the reg ex but wasnt sure how I could do this from a script and modify the file? Any help... (2 Replies)
Discussion started by: not4google
2 Replies

2. UNIX for Advanced & Expert Users

shell script to format .CSV data

Hi all, I have written a shell script to search a specified directory (e.g. /home/user) for a list of specific words (shown as ${TMPDIR}/wordlist below). The script works well enough, but I was wondering if there was a way to display the line number that the word is found on? Thanks! cat... (1 Reply)
Discussion started by: tmcmurtr
1 Replies

3. Shell Programming and Scripting

how to create csv file using shell script

I have a file in multiple directory which has some records in the following format File: a/latest.txt , b/latest.txt, c/latest.txt -> Name=Jhon Age=27 Gender=M Street=LA Road Occupation=Service I want to generate a csv file from the above file as follows File: output.csv -> ... (9 Replies)
Discussion started by: rjk2504
9 Replies

4. Shell Programming and Scripting

Shell script for CSV conversion

thanks for allowing me join your forum i have an output of linux command "who" which provides following details..... CURRENT USER/ACCT INFO 17:31:36 up 4:49, 4 users, load average: 0.03, 0.04, 0.00 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT root :0 - 12:59 ?xdm? 4:54 0.02s /bin/sh /usr/bi... (1 Reply)
Discussion started by: ayyappancheta
1 Replies

5. UNIX for Dummies Questions & Answers

Help to parse csv file with shell script

Hello ! I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so... As said in the title, I want to read a csv file with a bash script. Here is a sample of the file: ... (4 Replies)
Discussion started by: Grhyll
4 Replies

6. Shell Programming and Scripting

Shell script to csv

I am preparing script and trying to send output into CSV format. there is property called RNAME when it is blank, next propery(XMIT) is coming into RNAME propery. So i want whenever RNAME is blank it should put "," in that field. So that all will fit in proper coloums in csv file. Can you please... (8 Replies)
Discussion started by: darling
8 Replies

7. Shell Programming and Scripting

Reading a csv file using shell script

Hello All, I have a csv file that looks like below ProdId_A,3.3.3,some text,some/text,sometext_1.2.3 ProdId_B,3.3.3,some text,some/text,sometext_1.2.3 ProdId_C,3.3.3,some text,some/text,sometext_1.2.3 ProdId_A,6.6.6,some text,some/text,sometext_9.9.9 I will get ProdId from... (5 Replies)
Discussion started by: anand.shah
5 Replies

8. Shell Programming and Scripting

CSV File Creation Within Shell Script

Hi All, I am trying to create a CSV file within a shell script test.ksh and the code snippet is something like below: #!/usr/bin/ksh # Set required variables. . $HOME/.prof # Output file path Group1=/tmp/G1.csv Group2=/tmp/G2.csv Group3=/tmp/G3.csv $ORACLE_HOME/bin/sqlplus -s... (2 Replies)
Discussion started by: swasid
2 Replies

9. UNIX for Beginners Questions & Answers

Shell script to fetch values in csv

I need to fetch below values from this file. (1 Reply)
Discussion started by: nit42
1 Replies
HTML::Lint::Error(3pm)					User Contributed Perl Documentation				    HTML::Lint::Error(3pm)

NAME
HTML::Lint::Error - Error object for the Lint functionality SYNOPSIS
See HTML::Lint for all the gory details. EXPORTS
None. It's all object-based. METHODS
Almost everything is an accessor. Error types: "STRUCTURE", "HELPER", "FLUFF" Each error has a type. Note that these roughly, but not exactly, go from most severe to least severe. o "STRUCTURE" For problems that relate to the structural validity of the code. Examples: Unclosed <TABLE> tags, incorrect values for attributes, and repeated attributes. o "HELPER" Helpers are notes that will help you with your HTML, or that will help the browser render the code better or faster. Example: Missing HEIGHT and WIDTH attributes in an IMG tag. o "FLUFF" Fluff is for items that don't hurt your page, but don't help it either. This is usually something like an unknown attribute on a tag. new() Create an object. It's not very exciting. is_type( $type1 [, $type2 ] ) Tells if any of $type1, $type2... match the error's type. Returns the type that matched. if ( $err->is_type( HTML::Lint::Error::STRUCTURE ) ) {.... where() Returns a formatted string that describes where in the file the error has occurred. For example, (14:23) for line 14, column 23. The terrible thing about this function is that it's both a plain ol' formatting function as in my $str = where( 14, 23 ); AND it's an object method, as in: my $str = $error->where(); I don't know what I was thinking when I set it up this way, but it's bad practice. as_string() Returns a nicely-formatted string for printing out to stdout or some similar user thing. file() Returns the filename of the error, as set by the caller. line() Returns the line number of the error. column() Returns the column number, starting from 0 errcode() Returns the HTML::Lint error code. Don't rely on this, because it will probably go away. errtext() Descriptive text of the error type() Type of the error POSSIBLE ERRORS
Each possible error in HTML::Lint has a code. These codes are used to identify each error for when you need to turn off error checking for a specific error. config-unknown-directive Unknown directive "DIRECTIVE" You specified a directive in a comment for HTML::Lint that it didn't recognize. config-unknown-value Unknown value "VALUE" for DIRECTIVE directive Directive values can only be "on", "off", "yes", "no", "true", "false", "0" and "1". elem-unknown Unknown element <TAG> HTML::Lint doesn't know what a TAG tag is. These are pulled from HTML::Entities elem-unopened </TAG> with no opening <TAG> elem-unclosed <TAG> at WHERE is never closed elem-empty-but-closed <TAG> is not a container -- </TAG> is not allowed elem-img-alt-missing <img src="FILENAME.PNG"> does not have ALT text defined elem-img-sizes-missing <img src="FILENAME.PNG"> tag has no HEIGHT and WIDTH attributes elem-nonrepeatable <TAG> is not repeatable, but already appeared at WHERE doc-tag-required <TAG> tag is required attr-repeated ATTR attribute in <TAG> is repeated attr-unknown Unknown attribute "ATTR" for tag <TAG> text-invalid-entity Entity ENTITY is invalid text-unclosed-entity Entity ENTITY is missing its closing semicolon text-unknown-entity Entity ENTITY is unknown text-use-entity Character "CHAR" should be written as ENTITY COPYRIGHT &; LICENSE Copyright 2005-2012 Andy Lester. This program is free software; you can redistribute it and/or modify it under the terms of the Artistic License v2.0. http://www.opensource.org/licenses/Artistic-2.0 AUTHOR
Andy Lester, "andy at petdance.com" perl v5.14.2 2012-04-06 HTML::Lint::Error(3pm)
All times are GMT -4. The time now is 08:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy