Sandy Morton wrote:
Quote:
In article <4e6f1c0353invalid-email-address@invalid-domain.co.uk>, Paul Vigay <invalid-email-address@invalid-domain.co.uk> wrote:
Quote:
|
And I'd certainly be interested in your Prophet support application - especially as I run my entire company on it.
|
I would like some info. on this if possible?
|
Well, what it achieves can be seen at
www.beamends-lrspares.co.uk
once you have clicked on "Store-Man", eveything below that is created
automatically
from a CSV output file from !Prophet - except the "Info" html files,
which are just
copied to the correct loacation by the app.
It uses the supplier 2 field to provide a link to the "Info" files, if
present, and 3 digit codes to are used in supplier 3 to put the part in
the right places (there is an alternative for things like nuts that
appear in many, many places, where a file, also created by the app., is
used to look up multiple locations when the !Prophet field is full, or
in danger of being so. This file also alows alternative descriptions to
be used so the very long descriptions seen for many parts can be done
away with), which also helps keep invoices/purchase orders nice and
tidy.
Where the parts get put on the site is decided by the three digit code,
which is generated by the app from a text file via a menu. These codes
can be "injected" into !Prophet fom the
app to avoid any typo's.
It also uses a code to look up the branding/maufacurer of a part and
puts their logo in the appropriate place (due to a total lack of
artistic ability these are just gif names on the site).
The headers and footers for each page are defined by the user and
pulled in as required by the app, so the BeamEnds bit at the top can be
replaced with anything you like, as can the footer - the app does the
table in the middle. It also provides (dam, need to make that
optional) links for each part to a free on-line shopping trolley &
secure card details collection provider, but only where there is a
price - likewise a TSV file for upload to Froogle is also created.
The page titles are generated automatically from the code input menu,
as are the file names where things are put (they are actually the same,
but with spaces removed), so things can be found easily if only one
price needs changing or something.
The motivation was to create something that could deal with maintaining
correct prices for 23,000 stock items on a web site without having to
spend all day typing, and I got a bit carried away. It curently takes
about 2 hours to process the 23,000 parts on a StrongArm RPC, about
33Mb of data it's very much a batch job app - it used to multi-task
when building the site, but it would lieterally take all day with that
many stock items.
Theres a special code for things you don't want to appear on the site
that are in the !Prophet stock list - temporerily not availbale parts
etc
Hopefully tomorrow I'll be able to say all the output will validate at
w3c.
Theres loads of stuff, like automatically using FTP when done to update
the server, picking out special offers, doing automatic trace-throughs
of superceeded parts ("Use ABC1234") etc that may get added. There will
be an option to display the price including VAT, without VAT, or both
since I've noticed the competiton have started listing VAT free prices,
so Googlers see them first.
The other apps are one to read a suppliers CSV file and inject new
prices directly into
!Prophet - with sanity checking and keeping an eye on margins, one to
find a stock number in the purchase order file for dealing with
returns, and one to record stock items bought against a suppliers
invoice number and GI number, again for returns. These are not
releaseable at present.
Richard
FS: A9Home
Linear Mode
