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 [login to view URL] [login to view URL] Pat D'Angelo - President pd@[login to view URL] (954) 575-2300 Coral Springs, FL Andrew Frankford - CTO andrew@[login to view URL] (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\[login to view URL] ' (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.