Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

how to handle data of " Electronic Data Capture" file


  • This topic is locked This topic is locked

#1
dracula

dracula

    New Member

  • Member
  • Pip
  • 8 posts
i have few EDC--electronic data capture" files, which are viewed with the application.. "QEDCVIEW",
if i open the file in excel to do some edit the data goes wild and i cant open it.

now when the file is opened in QEDCVIEW the entries are shown as :


1
DATE: day/month/year TIME: xx:xx:xx
A/C: xxxxxxxxxxx
PAN: xxxxxxxxxxxxx
TXN: WITHDRAWAL SEQ: 1234
STAN: 567890
AMOUNT: PKR 500.00
CAS1[0]: CAS2[1]:
STATUS: OK

2
DATE: day/month/year TIME: xx:xx:xx
A/C: xxxxxxxxxxx
PAN: xxxxxxxxxxxxx
TXN: WITHDRAWAL SEQ: 1234
STAN: 567890

STATUS: ACCOUNT IS BLOCKED


now i want such a way to get extract only the transaction with

STATUS: OK

moreover i want this transaction to be given in excel or any other software as below

SEQ stan Amount
1234 567890 500

and leave the rest data like data, time, A/C, PAN, TXN


i would be delighted if i get the query resolved.
  • 0

Advertisements


#2
makai

makai

    Portlock - Oahu

  • Member
  • PipPipPipPipPip
  • 2,793 posts
Hello,
Google search for QEDCVIEW returned no hits. What is the application used for? Is this work related?
  • 0

#3
dracula

dracula

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
the screen shots of the program is attached. please find the attached.

the software is used for reading the EDC files, like electronic data capture,
do you that ATM prints a receipt, the whole Journal roll is alsp present in a a soft copy as an EDC file...

i have to manually pick out the Ok entries and add all the amounts.

i was thinking if i could find some other ways ..
anyways....best of luck

Attached Files

  • Attached File  1.zip   103.47KB   332 downloads

  • 0

#4
dracula

dracula

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
moreover the comlpete name of the application is


Quick EDC View Utility. V1.12
© 2004-KLM-..
  • 0

#5
makai

makai

    Portlock - Oahu

  • Member
  • PipPipPipPipPip
  • 2,793 posts
Google still can't obtain a hit on this software even when searched with quotes... ie... "Quick EDC"; "Quick EDC View Utility"; "Quick EDC View Utility V1.12"; "EDC View Utility". Do you have a link?

Is this work related? This is an important question because the TOC does not allow us to help with issues an IT Dept should be handling. I can't see any reason to take journals of ATM's and have to extract "OK" entries unless it's work related. ATM's are Federally governed, so this is dangerous territory unless it's work related, in which case, we can't help you. So, please answer the question. Thanks!
  • 0

#6
dracula

dracula

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
yes it is work related. i do this ATM balancing every day in a bank and it consumes me alot.
n i do not have the link to this software......



dracula
pakistan

Edited by dracula, 18 September 2010 - 03:23 PM.

  • 0

#7
makai

makai

    Portlock - Oahu

  • Member
  • PipPipPipPipPip
  • 2,793 posts

yes it is work related

With that, I have to say this is something your IT Dept must help you with.
  • 0

#8
dracula

dracula

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
makai !!!sad thing is they are not helping. they insist it is not required as all other branches do it manually with paper and pencil.
i am new here, just graduated so i know somewhat about excel, so i started doing it on excel, yet it is a hard job to take enter data manually, it sucks all my time.

I want you to guide me here, i will work hard to learn things as you guide me, as it is going to help me in the most amazing ways.

makai i know it would be difficult for you to digest that IT Dept not helping here yet you must remember i do not belong to a very developed country, change is feared. so do help out here,
  • 0

#9
rshaffer61

rshaffer61

    Moderator

  • Moderator
  • 34,114 posts
dracula the issue is our TOU does not allow us to bypass your IT department.
Section 3 line B of our TOU clearly states:

We offer free computer help and tech support for home and personal use. We are not here to support others that work for profit, or to support/replace your company's IT department.

Since they have stated:

they insist it is not required as all other branches do it manually with paper and pencil.

We can not assist you in going against their rules.
  • 0

#10
dracula

dracula

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
rshaffer61 ...
oh God that is so sad for me, anyways is there any way, any-other site. do guide me

thx
  • 0

#11
SpywareDr

SpywareDr

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,767 posts
Helping you break a Bank's IT department's rules and regulations is not a good idea. It could very well end up in a lawsuit, fine and prison time ... for any/all parties involved.
  • 0

#12
dracula

dracula

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
i am not breaking the laws, i mean they are not helping me but if i can do it on my own they have no issue with that. it is my work.
if you really see the my post, i changed everything.....n even deleted some material.

but the main problem is as mkaii said

Google still can't obtain a hit on this software even when searched with quotes... ie... "Quick EDC"; "Quick EDC View Utility"; "Quick EDC View Utility V1.12"; "EDC View Utility"..........


  • 0

#13
dracula

dracula

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
the only thing i have found yet is "InterBold Electronic Data Capture (EDC) (Optional)"
this link

http://www.diebold.c...99925-001-1.htm
  • 0

#14
makai

makai

    Portlock - Oahu

  • Member
  • PipPipPipPipPip
  • 2,793 posts
dracula,

The short of it is this... if it's work related, then we can't help you.

makai
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP