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

完了済み 投稿 Sep 4, 2008 着払い
完了済み 着払い

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:

' [url removed, login to view] '

(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:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

................

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

................

[url removed, login to view]

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.

デルファイ エンジニアリング マイクロソフト MySQL PHP ソフトウェアアーキテクチャ ソフトウェアテスト ウィンドウズデスクトップ

プロジェクトID: #3198166

プロジェクトについて

9個の提案 リモートプロジェクト アクティブ Sep 9, 2008

アワード:

alexstep

See private message.

$637.5 USD 15日以内
(98レビュー)
6.1

9人のフリーランサーが、平均$590 で、この仕事に入札しています。

miguelkhouri

See private message.

$637.5 USD 15日以内
(75件のレビュー)
7.4
sergiles

See private message.

$637.5 USD 15日以内
(85件のレビュー)
5.6
rwn56

See private message.

$637.5 USD 15日以内
(9件のレビュー)
5.0
PCornelius1234

See private message.

$467.5 USD 15日以内
(5件のレビュー)
4.1
manojtalukdarvw

See private message.

$637.5 USD 15日以内
(3件のレビュー)
0.2
durga2009

See private message.

$595 USD 15日以内
(レビュー1件)
3.4
yehiaasalam

See private message.

$425 USD 15日以内
(0件のレビュー)
0.0
konstshe

See private message.

$637.5 USD 15日以内
(0件のレビュー)
0.0