RE: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Robert Reil
Thanks guys. I got a good feel of what to do. Teddy: I have a relationship with them and then it kind of fell apart when Harry started managing the store. Martin however is a realist. The E-Store is an ASP managed by a consultant. He wont give me the consultant contact info so we can not collaborat

RE: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Charlie Arehart
Either way will work. I've made my point for why checking on demand (via either cfhttp or a web service) may be better than just getting a daily feed. It's really your (and their) call. /charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTEC

Re: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Teddy Payne
Robert,I am a technologist.  I would have to evaluate the vendor to see if they offer any automation as Charlie mentioned.  If they do not have that much technology support, I would try to develop a rapport with a representative that I could periodically ask for a detailed dump of product informati

RE: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Robert Reil
Good stuff Charlie and all. I understand what you are saying and how teddy is saying CSV etc. So am I hearing you say have them provide a CSV? Are there better solutions? So I should ask them to create an automated daily CSV that we can navigate to and import? This sounds reasonable. I think I a

RE: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Charlie Arehart
(I was writing this email and found that I had not sent it yet before responding to the last one, if it seems a little out of order).   Well, the problem is that many vendors are not to tech-savvy. They may well have a way on their web site for a human to determine if a product is in stock,

RE: [ACFUG Discuss] Vendor Data Problem (funny)

2006-08-25 Thread Dave Bellevue
Consider the vendor's point of view. I expect that the vendor has many, many wholesalers and resellers. Some of them very, very large, with many of those stocking inventory. Many of them are probably even buying from your same distributor at prices far lower than you are. I am a wholesaler and a r

RE: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Charlie Arehart
I'm saying you would ask them to create a NEW page that take in URL variables to control what to show, and then not only shows only those records, but does so in a simpler way (not all that HTML that is designed for making the site friendly to humans). We're talking about getting them to create a n

Re: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Teddy Payne
Robert,It is really not up to to determine what you need.  If you need information about these parts, you collect the specific type of information that you need and then communicate that with your vendor.  The vendor will figure out what is the best way to provide that information to you.  If one

RE: [ACFUG Discuss] Vendor Data Problem (funny)

2006-08-25 Thread Robert Reil
The capture idea is a reasonable one but that makes more work for us on our end. Right now we tell the card vendor to process at 11:30 pm daily. And on the weekends we miss the opportunity to catch these items. There are no other vendors for this product line. As to adapting... IM trying a find a

RE: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Robert Reil
I see where you are going but I don't know if that will work. The page that posts the data is at: Take a peek and see. I think it is too many pages and does not show complete info. http://www.siriusconinc.com/carb/parts.asp However I will be looking for part number "K?-" where ? is a variable

RE: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Robert Reil
but the vendor should know that it is their responsibility to notify all the people who want to buy their products if their product is available   ... THANK YOU...   You feel my pain I see...   Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Wa

RE: [ACFUG Discuss] Vendor Data Problem (funny)

2006-08-25 Thread Dave Bellevue
If their inventory policies changed, then it is up to you to adapt. If they didn't tell you, then you need to ask. I would expect they didn't change it only because they needed something to do, but rather did some analysis to determine what inventory moves the quickest. If it was forced upon them b

RE: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Charlie Arehart
Robert, are you familiar with the CFHTTP tag? It's a CFML tag that allows you to point at any web page and pull its results into a variable. The thinking here (if you don't use web services) is to have them offer a page which accepts whatever input you need to be able to give them, and it give back

Re: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Teddy Payne
Robert,All that you are referring to is best served as a webservice as Charlie had suggested.  HTML is a very poor container for data.  CF can consume webservices created by other technologies, so the ASP aspect is not too relevant.  The only caveat to the webservice is the type of webservice whthe

RE: [ACFUG Discuss] Vendor Data Problem HOW TO?

2006-08-25 Thread Robert Reil
Charlie, and Dave: Thanks for your replies. I am intrigued that you guys eluded to the possibility of using an ASP results file to data scrape. The real question is what is the easiest and most reasonable way to: List Part numbers and their availability, where: PN = Yes/no I wish I could do th

RE: [ACFUG Discuss] Vendor Data Problem (funny)

2006-08-25 Thread Robert Reil
I can understand your perspective. However one fact that may or may not be relevant. They are the North American Distributor for this Japanese Manufactured product line. As to thought out etc. They changed their inventory policy and product line without telling anyone. It used to work perfect. No

RE: [ACFUG Discuss] Vendor Data Problem (funny)

2006-08-25 Thread Dave Bellevue
Well, I don't post here much, but have to speak up >From what I read, this should all have been thought out and documented BEFORE you posted a site. You're dealing with a common vendor problem. On one hand, you want to sell the vendor's product but you're depending on the vendor to bear the

RE: [ACFUG Discuss] Vendor Data Problem (funny)

2006-08-25 Thread Charlie Arehart
Robert, if I understand, you're asking them to expose some data to you in a form that some current web page doesn't suffice, right? And you're asking them to either create a new web page for you to scrape, or grant you security to be able to have a local DSN that points at their remote database. I

[ACFUG Discuss] Vendor Data Problem (funny)

2006-08-25 Thread Robert Reil
For a good laugh on how not to run a business read this. Read from the bottom up for a laugh, and please advise me if I am correct in my assumptions that my proposal would work... Respectfully... Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga.