Delphi - Photo Names to a CSV File

Scope Of Effort:

This is a small project, a single Windows GUI application. Input is a CSV flat file and a directory of image files, output will be an updated CSV flat file. It does not involve data base operations, but requires FTPing files to a server.

Technology:

* Windows (XP, Vista) Desktop application GUI *.exe

* Using Delphi® 2007 for Win32®

## Deliverables

2008-05-08 - 12:52:59 EDST

Statement of Work - Photo Names to a CSV File

By: Alliance Commerce, Inc.

9900 W. Sample Road, Suite 300

Coral Springs, FL USA 33065

Main: (954) 575-2300

Fax: (954) 302-4961

[url removed, login to view]

[url removed, login to view]

Pat D'Angelo - President

pd@[url removed, login to view]

(954) 575-2300 Coral Springs, FL

Andrew Frankford - CTO

andrew@[url removed, login to view]

(561) 795-1119 West Palm Beach, FL

Who Are We, Why This Request:

Alliance Commerce provides on-line, real-time live auction technology, used world wide. We've authored the application in-house (Java, PHP, etc.). Currently we have an Immediate need for this application identified here, but no in-house resources will be available near term. This is a one-up application request, but could lead to additional work as we develop a business relationship.

Scope Of Effort:

This is a small project, a single Windows GUI application. Input is a CSV flat file and a directory of image files, output will be an updated CSV flat file. It does not involve data base operations, but requires FTPing files to a server.

Technology:

* Windows (XP, Vista) Desktop application GUI *.exe

* Using Delphi® 2007 for Win32®

Deliverables:

* The exe application wrapped in a standard installer.

* Well commented source code

*

Schedule:

Immediate need. We would expect a two week schedule

Principals will be readily available during development.

Application:

Input:

* An existing CSV file containing several columns (5 or more),

with 2,000 or less rows.

* A directory of JPG image files, may be several thousand images

Output:

* An updated CSV file

* FTP JPG files from the desktop to a server (Solaris, ProFTPD).

Description:

There exists a CSV file with various fields describing a product. One or more of the fields are meant to contain the names of JPG image files 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 an image and drop it into a field(s) in the table. At the same time (on drop) the image will be renamed to a specified scheme 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.

On completion, the CSV file will be saved locally and the renamed images FTP'd 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 FTPd to the host.

Incomplete table entries will be hi-lighted.

Also, it should show on-going stats, e.g. items complete, remaining, FTP progress, whatever is appropriate.

There are just a few other details to review when we meet, but they don't significantly alter the scope of effort.

\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|-

2008-05-09 - 11:17

Additional Program Details:

1. Target FTP Address:

The FTP address will be fixed for each user of this program. After the user initially enters the FTP address, we will retain it with a local ini file or via the Windows Registry. And, allow for it to be changed of course.

2. Operating on the JPG files:

2a. After the drag and drop, we 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.

2c. Option: Maybe another Thread to FTP the images while the user selects images for

the next items. Your choice on starting a second thread.

3. Renaming the Images:

First a big picture. Overall, this program supports creating an on-line live auction. The user prepares a list of the Lots or items that will be auctioned at this specific auction event. This list contains one row each describing each item or Lot. This list is the CSV file you wsill 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 up to nine (9) additional images to associate with this 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 chars). This Event ID will be constant throughout this run of our program.

The Event ID will be the first part of every image name. Concatonated 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:

' abc123\_450\[url removed, login to view] '

(Note - the server is Sun Solaris (Unix), names are case-sensetive, ALLWAYS make the extension lower case 'jpg'.)

The CSV only has one field for image name, but I said the user could assign (drag) up to 10 images to a 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 seven images associated with Event 'abc123', Lot '450', the image file names would be:

abc123\_140\_0,jpg

abc123\_140\_1,jpg

abc123\_140\_2,jpg

abc123\_140\_3,jpg

abc123\_140\_4,jpg

abc123\_140\_5,jpg

abc123\_140\_6,jpg

It is important to place the name of the first image the user selects in the CSV record, it has additional usage in the actual auction process. Beyond the first image selected, the sequence is not important.

4. We are anxious to have this completed as soon as is reasonable.

We will provide an example CSV file.

Delphi Engineering Microsoft MySQL PHP Software Architecture Software Testing Windows Desktop

Project ID: #2679291

About the project