Re: Design question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Aug 18, 9:25 am, "Cowboy \(Gregory A. Beamer\)"
<NoSpamMgbwo...@xxxxxxxxxxxxxxxxxx> wrote:
Here is the basic idea:

1. Create upload mechanism
2. Consume file using ADO.NET with the Jet provider
3. Create DataSet from data
4. Save off information from DataSet to your database

There are variations on this, but it is a basic pattern.

Lesson 1: Big fish eat little fish

What this means is the ideal above will only work if you are the big fish..
This is probably not the case and all vendors (big fish) will have their own
format.

Here is the likely scenario.

1. You create a common format
2. You send out a document that this is the format to use your service
3. Salesman gets a call from a vendor who wants to use your site
4. Vendor states to salesman he can "go to hell" if he can't use his Excel
spreadsheet format
5. Salesman talks to executive
6. Executive tells you to code for this spreadsheet as it represents dollars

Once you are the big fish, you can say "no". Until then, the import will
likely be a mix of formats. I would go ahead and account for specifying an
upload format per vendor type and creating a provider model type parser.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my bloghttp://feeds.feedburner.com/GregoryBeamer#

or just read it:http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box!                               |
********************************************"cowznofsky" <jhco...@xxxxxxxxx> wrote in message

news:c70e4731-1001-4562-ad1e-bf0dc4611524@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



The plan is this:  we want to host a site where vendors will upload a
list of parts, and buyers can then browse them.  We are not going to
be part of the transaction, but will charge both buyers and vendors to
use the site.

The business analysts figure that all the vendors have a price list in
excel, so they figure it will be a simple matter to have them upload
an excel file of parts, and then have the ability to modifiy their
list as needed.

I'm not sure of the simplicity of this approach, but if anybody has an
example, or an open source project that could be used, it would be
appreciated.

I know that when I look for car parts there is a fairly common model
for searching by year, make, and part.  I'm guessing there is a common
technique for loading parts lists, but I'm not familiar with this kind
of application.

Any comments welcome.- Hide quoted text -

- Show quoted text -

Ok. Good point.
I guess we would have to think about providing some sort of mapping
facility (i.e. indicate the columns for part name and price) as
opposed to defining it ourselves.
And also the row where the raw data starts.
.

Relevant Pages

  • Re: Design question
    ... Big fish eat little fish ... This is probably not the case and all vendors will have their own format. ... I would go ahead and account for specifying an upload format per vendor type and creating a provider model type parser. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ElementTree XML Namspace
    ... I will then use python to convert the data to another format for ... upload to another vendor. ...
    (comp.lang.python)
  • Re: help with object design for a database
    ... By conversion I meant loading the vendor data into the DB. ... You are going to have to write some code somewhere to parse the vendor format and convert it into a format that the RDB can eat. ... But with RAD IDEs like Access you can make a pure form-based UI where the clerk enters text fields from the keyboard. ... You are going to have to write some code for that interface because the RAD IDEs don't have infrastructure support for that yet AFAIK. ...
    (comp.object)
  • Re: help with object design for a database
    ... and load it on the database or throw an error. ... If I type in a serial number, the system will detect the format of the ... Why three tables in the RDB? ... Presumably you only have to do this when the vendor ...
    (comp.object)
  • Re: For the last time
    ... He changes the format by converting it to a mp3. ... He uploads the mp3 to a peer-to-peer site. ... copyright laws no longer apply to the artistic work. ... for upload for other people to get free, or shared the files with other ...
    (rec.music.progressive)