Find Jobs
Hire Freelancers

Delphi - Display JPG, File Rename and move, FTP & CSV update

$500-750 USD

In Progress
Posted over 15 years ago

$500-750 USD

Paid on delivery
Scope Of Effort: ? ? ? This is a small project; a single Windows GUI application.? Input is a CSV file and a directory of image files; output will update the CSV file with the associated image name and requires uploading image files to a Web server using FTP.? It does not involve data base operations. ? Technology: ? ? ? * Windows (XP, Vista) Desktop application? GUI *.exe ? ? ? * **Using Delphi® 2007 for Win32® (.NET IS NOT ACCEPTABLE)** ## Deliverables ? 2008-09-04 - 14:03:02? EDST ? Delphi - Display JPG, File Rename and move, FTP & CSV update By: Alliance Commerce, Inc. ? ? ? ? Pat D'Angelo - President Andrew Frankford - Chief Technical Officer Who Are We, Why This Request: ? ? ? Alliance Commerce provides an on-line, real-time, live auction service, used worldwide.? We have? authored the application in-house (Java, PHP, etc.).? Currently we have an IMMEDIATE need for an? application (see details below) that will update the CSV file with a image name associated with corresponding lot information to be used to build an online auction catalog. This project could lead to additional work for the coder as we develop a business relationship. ? Scope Of Effort: ? ? ? This is a small project; a single Windows GUI application.? Input is a CSV file and a directory of image files; output will update the CSV file with the associated image name and requires uploading image files to a Web server using FTP.? It does not involve data base operations. ? Technology: ? ? ? * Windows (XP, Vista) Desktop application? GUI *.exe ? ? ? * Using Delphi® 2007 for Win32® (.NET IS NOT ACCEPTABLE) Deliverables: ? ? ? * The exe application wrapped in a standard installer. ? ? ? * Well commented source code Terms: ? ? ? * $750 for an error-free application that meets these specifications and the Delphi 2007 source files. ? ? ? * Delivery will be within 15 calendar days of start of contract. ? ? ? * $250 bonus if delivered at least one day before the due date. ? ? ? * $50 per day penalty for late delivery. ? ? ? * Principals will be readily available during development for questions. ? ? ? * You will regularly submit copies of the executable during development for review. Application: ? ? ? ? Input: ? ? ? ? ? * An existing CSV file containing several columns (5 or more), with 2,000 or less rows. ? ? ? ? ? * A directory of JPG image files. Could have up to several thousand images. ? ? ? ? ? Output: ? ? ? ? ? * An updated CSV file with an image name containing no spaces (UNIX Web server). ? ? ? ? ? * FTP JPG files from the desktop to a server (Solaris, ProFTPD). ? Description: ? ? ? ? There exists a CSV file with rows of various fields describing a product for the development of an auction catalog.? One column will contain the name of a JPG image file to associate with this product.? At the same time there exists a directory of JPG images the user imported from a camera. ? The task is to display the CSV data in a table and thumbnails of the images in a scrolling list.? The user will be allowed to drag one or more images and drop them into a field in the table. At the same time (on drop) the image will be renamed to a specified scheme (see below) and copied to an output directory with the new name. ? The user will repeat this drag 'n drop for every line item in the CSV file.? This operation will associate one or more images with that specific product using a naming convention described below. ? On completion, the CSV file will be saved locally and the renamed images transferred via FTP to a network server. ? The user may not complete the entire list at one time.? At the conclusion of each run or at any point during execution, the file will be saved and renamed images may be uploaded to the host if a connection is available. ? Incomplete table entries will be highlighted. ? Also, it should show on-going status, e.g. items complete, items remaining, FTP progress, whatever is appropriate. Additional Program Details: 1. Target FTP Address: 1a. The FTP address will be fixed for each user of this program.? After the user initially enters the FTP address, we will retain it and other settings using a local .ini file.? And, allow for it to be changed. 2. Operating on the JPG files: 2a. After the drag and drop, the code will copy and rename the JPG files into an output directory. 2b. The output directory then will be the list of JPG files that need to be FTP'd to the server.? Perhaps use an output dir for pending FTP ops, then, after FTP, move the image to a 'completed' directory. 2c. We would expect another Thread to FTP the images while the user selects images for the next items. ? 3c. Some of our auctions may contain upwards of a thousand lots. Maybe a user would like to associate images with lots using a notebook while not connected to the Internet (at home, or while commuting, etc.) In this case, images would accumulate in an 'outbound' directory waiting to be FTP'd when an Internet connection becomes available.? When a connection is available, the FTP thread would process the upload and probably move the images to a 'completed' directory (just for a backup).? The program would provide a Status of the FTP? operation (connection, files to process,etc) in a separate status window. 3. Renaming the Images: First a big picture.? Overall, this program supports creating an on-line live auction catalog.? The user prepares a list of the Lots or items that will be sold during a specific auction event.? This list contains one row each describing each item or Lot.? This list is the CSV file you will be updating. Each row has fields for 'lot number', description, etc.? One of the fields will contain the name of the PRIMARY image for this Lot.? The user 'may' assign additional images to a single lot.? The additional images are NOT named in this CSV record.? We use a naming convention to make an automatic association (explained later here). 3a. Basic image naming - On start up, the user will enter an auction Event ID (six or more characters).? This Event ID will be constant throughout this run of our program. ? The Event ID will be the first part of every image name.? Concatenated to that will be an underscore and the Lot Number, taken from a field in the selected row of the CSV file.? Finally, add another underscore and the digit zero (0). So far then, if we are dealing with Event 'abc123' and Lot number '450', the new name of the image would be: ' [login to view URL] ' (Note - the server is Sun Solaris (Unix) and names are case-sensitive. ALWAYS make the extension lower case 'jpg'.) The CSV only has one field for the image name, but the user could assign (drag) multiple images to a single Lot.? We do this by using the 'same' image name for all of them, but we vary the last character position or digit of the file name. Using the example above, if there were several images associated with Event 'abc123', Lot '450', the image file names would be: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] ................ [login to view URL] [login to view URL] [login to view URL] ................ [login to view URL] If they go beyond 'z', we will signal the user with an error. It is important to place the name of the first image the user selects in the CSV row/column. It has additional usage in the actual auction process. ***ADDITIONAL NOTES We can provide a nearly complete example of this app (just the *.exe, no source).? You might use it as a model or for ideas.? It is not necessary to duplicate this example. When complete and delivered, we will expect to open your source code using Delphi® 2007 for Win32® RAD.
Project ID: 3198166

About the project

9 proposals
Remote project
Active 16 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$637.50 USD in 15 days
4.9 (98 reviews)
6.1
6.1
9 freelancers are bidding on average $590 USD for this job
User Avatar
See private message.
$637.50 USD in 15 days
4.8 (75 reviews)
7.4
7.4
User Avatar
See private message.
$637.50 USD in 15 days
5.0 (85 reviews)
5.6
5.6
User Avatar
See private message.
$637.50 USD in 15 days
5.0 (9 reviews)
5.0
5.0
User Avatar
See private message.
$467.50 USD in 15 days
5.0 (5 reviews)
4.1
4.1
User Avatar
See private message.
$637.50 USD in 15 days
5.0 (3 reviews)
0.2
0.2
User Avatar
See private message.
$595 USD in 15 days
0.0 (1 review)
3.4
3.4
User Avatar
See private message.
$425 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$637.50 USD in 15 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
2
Member since May 8, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.