Thread: Creating an api & connecting it with a script.

  1. #1
    Registered User
    Join Date
    Sep 2016
    Posts
    2

    Lightbulb Creating an api & connecting it with a script.

    Hello all,

    Project description:
    The idea of the project is to receive a notification in my email when an event is activated.
    I will try to explain it as easy as possible.

    I need an API which receives (input) data from excel & PDF files. After receiving this data it has to be send (output) to a script which calculated this data and determines if a certain notification has to be send to an email or not.

    The script:
    The script has to calculate if an certain employee has abused his fuel card (received from the company) or not. If this is the case then the administration has to receive a notification of this (by mail). It is possible to calculate if an employee has abused its fuel card (For example if the employee uses the fuel card for his own (private) car and not for the companies car.

    It is possible to calculate this by calculating this data:
    - average usage per certain car (there are for example 4 different cars the company uses so this has to be different for each car)
    - How many kilometers this car has passed
    - How much fuel is filled in the car reservoir

    Example:
    When a car uses in average 7 liters of diesel per 100 kilometers and the employees has driven 100 kilometers this means that the car has used 7 liters. If the employee "pays" with the fuel card for 20 liters it means that the other 13 liters have been filled somewhere else (for example his own car). This means that the employee has "stolen" from the company and the administration should receive an notification about it.

    If it's not the case that the employee "stole" fuel then the script should not send any notification to the administration.
    So basically there are 2 kind of outputs from the script:
    - Employee stole fuel -> send email to for example administration
    - Employee did not steal fuel -> nothing happens.

    I hope this was a little bit clear enough for you.
    Please send me a PM or reply here on this topic on how much money you expect from this.
    As the project continues I will inform you with more specific information!

    If there are any questions please ask here or send me a PM.

    Kind regards,

    Pajo.

  2. #2
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    39,661
    If the file is already in excel format, a trivial "conditional formatting" rule allows you to analyse all the data without leaving the application.

    If it's PDF, do you have a reliable PDF to text conversion program? If the PDF's are just the result of "print to PDF" inside excel, then just get the raw excel file instead.

    Which OS are you using? Windows/Linux/MacOS/.... ?

    You're working from the premise that every employee ALWAYS fills up the car at the end of every journey. If someone forgets, the next employee who actually fills the car will get stiffed with the theft accusation.
    If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
    If at first you don't succeed, try writing your phone number on the exam paper.

  3. #3
    Registered User
    Join Date
    Sep 2016
    Posts
    2
    Yes you are correct, there are still some little things which are in a need to be discussed. Next week I will have a meeting to discuss this project and after that I can give you more information.

    We are using Microsoft and I haven't tried to convert these PDF files to excel. I will try this, what if it is not possible to convert it?

    Kind regards,

    Pajo.

  4. #4
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    39,661
    PDF to ... depends on the quality of source used to generate the PDF in the first place.

    If it's the direct output of another program, results are usually fairly good.

    If it's just a bitmap scan of a fuzzy fax, you're basically SoL. Even the best OCR software will struggle.
    If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
    If at first you don't succeed, try writing your phone number on the exam paper.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Noob Script Help ~ Simple Script Error
    By WiredAnomaly in forum C++ Programming
    Replies: 5
    Last Post: 10-05-2013, 05:57 AM
  2. Replies: 15
    Last Post: 06-16-2011, 05:17 AM
  3. Replies: 0
    Last Post: 02-05-2009, 06:59 PM
  4. Connecting With IP
    By Phanster in forum C++ Programming
    Replies: 13
    Last Post: 10-20-2004, 08:01 PM
  5. Creating a configure script
    By WebmasterMattD in forum Linux Programming
    Replies: 1
    Last Post: 05-18-2002, 01:20 AM

Tags for this Thread