Cancelled

Database enhancement (filemaker or other)

A very small art promotion company (3 personnes) in Paris would like to optimize their database programme actually running under Filemaker Pro. They use this programme as a stock management and event management tool. They would like to extend the functionalities.

A such, they are looking for a programmer to EITHER retouch the actual Filemaker programme / database OR redo the User Interface/database in another format that is more practical, evolutive and inexpensive.

The work may start immediately once the bids are closed. The work will be executed if the appropriate price arrangement is found, otherwise they will fix it up internally as well as they can.

I will serve as an interface between the company as the developer. I have notions as to Filemaker, PHP, Mysql. You may write the programme in English and I will translate into French. Some part of the programme are in French and English.

The programme is based essentially on the Works of Art. Each work of art has about 25 fields to be entered : Name, Date, Height, Width, Depth (cm and inches), Number, Order Date, Production Date, Artist, Composition, Notes, Sales Price, Price sold, Date Sold, Date Bill of Sale, Bill of Sale Number, Price margins, Artist commissions, Notes AND Localisation (where the work of art is) and the modification that were made to the work of art during it life within the company (color change, body fixes, localization changes...). The orignal programme was just a tracking programme so that they knew where the works are (which gallery).

The eventual particularity of statues is as follows. Statues may be made in only 12 examples of a particular work. They are numbered from 1/8 to 8/8 et I/IV to IV/IV. They may also reproduce the statue at another size at 12 examples each. This makes finding a PRIMARY KEY on statues somewhat difficult.

Paintings are unique examples.

The programme’s event management concerns exhibitions essentially as well as order forms for works, annexe products or transport. Once it is decided to do an exhibition, they must find, reunite and/or create the ncessary works for that exhibit. This means changing the localization of certain works within the database (necessitates transporting the statues from one gallery to another) or creating new models of certain works (art casting).

The other categories that the database includes are ARTISTS, GALLERIES, CASTERS, SUPPLIERS (including NAME, ADRESSE, etc.).

They would like the programme to do the following:

- Visualization and modification of the database work of art files, contact file, etc.

- Localization of works of art with multiple selection possibilities (by gallery, by artist, by date, by statue name...)

- Sales statistics with multiple selection possibilities (by gallery, by artist, by name, by country, by size, by date, etc.)

- Exhibition organisation tables: choices of works with their actual localization or creation of new works of art within the database. This includes then the creation of bill of transport orders, statue casting ordering, etc.

The programme must create the following documents for printing purposes (in French or English):

Delivery note, Order forms, Transportation form, Price Offer, Bill of Sale, Authentic Work Certificate.

All prices must be translatable from euros to dollars (with a coefficient change when necessary). All prices must include with and without sales tax figures.

The actual database has around 1100 arts of work. Of course, if the new programme is in another form, we would like to retrieve the previous entries.

The company uses Windows XP and Vista. Compatibility for MacOs would be even better.

I will be the project coordinator. I will design the approximate screen layouts to make the project as easy and clear as possible for the developer.

Skills: Accounting, Data Processing, PHP

See more: work composition, find programmer works, find format, find key programmer, we transport, translate find new english, life php developer, screen printing artist, sales coordinator, retouch work, project casting, programmer find one, programmer start find, programmer filemaker, products database design, production tool, production management tool, processing find programmer, price user interface, php programmer prices, php developer paris, php developer means, php developer certificate, paris php programmer, other sales

About the Employer:
( 3 reviews ) Paris, France

Project ID: #230441

7 freelancers are bidding on average $1221 for this job

varun8211

Please see PMB.

$1500 USD in 21 days
(17 Reviews)
7.8
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$1100 USD in 50 days
(44 Reviews)
6.8
pgcoding

check pmb, sil vous plait.

$1200 USD in 30 days
(28 Reviews)
6.3
lakhvinder001

i have well exprience in accounting and Bookkeeping . so i can do this work perfectly with best regards lakhvinder sharma

$1050 USD in 30 days
(0 Reviews)
0.0
ownwtj

I guess that will be easy .. we already use FileMaker Pro ( since version 7 till now version 9 Pro )and we did couple of projects like that before so getting all data from you old FileMaker files will be easy , better More

$1000 USD in 20 days
(0 Reviews)
0.0
CoreDbSystems

Hi, We at Core Database Systems provide Database Solution(s) for all assortments of Database technology. We have worked on Fikemaker Pro and have professionals with experience ranging 3 to more than 10 years. Ple More

$1499 USD in 30 days
(0 Reviews)
0.0
alfalah

Manager Bank Alfalah here, check PM

$1200 USD in 30 days
(0 Reviews)
0.0