[ic] RE: How can I make subcategories ?
Ramana
ramana@myweb.com.my
Fri, 23 Mar 2001 15:40:42 +0800
hi Dan Garwood,
ya I hope , thats a good idea , but can u please explain me in detail
How I can use these two new tables ? How I can link these to interchange
admin interface?
Tqu,
--Pease--(^_^)
----- Original Message -----
From: <interchange-users-admin@lists.akopia.com>
To: <interchange-users@lists.akopia.com>
Sent: Friday, March 23, 2001 2:44 PM
Subject: Interchange-users digest, Vol 1 #383 - 2 msgs
>
> Send Interchange-users mailing list submissions to
> interchange-users@lists.akopia.com
>
> To subscribe or unsubscribe via the web, visit
> http://lists.akopia.com/mailman/listinfo/interchange-users
> or, via email, send a message with subject or body 'help' to
> interchange-users-request@lists.akopia.com
> You can reach the person managing the list at
> interchange-users-admin@lists.akopia.com
>
> When replying, please edit your Subject line so it is more specific than
> "Re: Contents of Interchange-users digest..."
>
>
> Today's Topics:
>
> 1. RE: Wholesale vs Retail (Dan Garwood)
> 2. RE: How can I make subcategories ? (Dan Garwood)
>
> --__--__--
>
> Message: 1
> From: "Dan Garwood" <res087jh@verizon.net>
> To: <interchange-users@lists.akopia.com>
> Subject: RE: [ic] Wholesale vs Retail
> Date: Fri, 23 Mar 2001 01:31:57 -0500
> charset="iso-8859-1"
> Reply-To: interchange-users@lists.akopia.com
>
> Allen,
>
> Look in your catalog.cfg file about 3/4 of the way through and you will
see
> a nice paragrapg descirbing how to actually make it happen. IC has this by
> defualt. You have to make dealers or wholesalers have a 1 in a field in
the
> userdb and that will allow wholesale prices to be displayed.
>
> Dan Garwood
> E-Profit Designs
>
> -----Original Message-----
> From: interchange-users-admin@lists.akopia.com
> [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Young
> Family
> Sent: Tuesday, March 20, 2001 8:41 PM
> To: interchange-users@lists.akopia.com
> Subject: [ic] Wholesale vs Retail
>
>
> Hello
> How have you all been managing selling at wholesale vs selling at retail?
> I want to use the same shopping cart, and depending upon the user's
> category, show him wholesale prices or retail prices. Is this possible?
> Alan Young
> ary@communicationfactory.com
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>
>
> --__--__--
>
> Message: 2
> From: "Dan Garwood" <res087jh@verizon.net>
> To: <interchange-users@lists.akopia.com>
> Subject: RE: [IC] How can I make subcategories ?
> Date: Fri, 23 Mar 2001 01:29:24 -0500
> charset="iso-8859-1"
> Reply-To: interchange-users@lists.akopia.com
>
> Thre are several ways to accomplish this. I my self made one table called
> catergory_tbl
> cat_id
> cat_name
> cat_date
>
> second table
> subcategory_tbl
> subcat_id
> cat_id
> subcat_name
> subcat_date
>
> I added the following fields to the Products table
> category
> subcategory
>
> now all these id fields are numbers. Which should speed searches up.
>
> Now since I got away from the cat and area. I generate my category list
and
> subcategory list with [perl]query code here [/perl]
>
> That is how I handle it. I am sure someone has another way of
accomplishing
> this.
>
>
> Dan Garwood
> E-Profit Designs
> -----Original Message-----
> From: interchange-users-admin@lists.akopia.com
> [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Ramana
> Sent: Friday, March 23, 2001 1:12 AM
> To: interchange-users@lists.akopia.com
> Subject: [IC] How can I make subcategories ?
>
>
> Hi All,
> Could any one help me out , how can I create subcategories?
>
> Thank u,
> --Peace-- (^_^)
>
>
>
> ----- Original Message -----
> From: <interchange-users-admin@lists.akopia.com>
> To: <interchange-users@lists.akopia.com>
> Sent: Friday, March 23, 2001 8:00 AM
> Subject: Interchange-users digest, Vol 1 #381 - 16 msgs
>
>
> >
> > Send Interchange-users mailing list submissions to
> > interchange-users@lists.akopia.com
> >
> > To subscribe or unsubscribe via the web, visit
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> > or, via email, send a message with subject or body 'help' to
> > interchange-users-request@lists.akopia.com
> > You can reach the person managing the list at
> > interchange-users-admin@lists.akopia.com
> >
> > When replying, please edit your Subject line so it is more specific than
> > "Re: Contents of Interchange-users digest..."
> >
> >
> > Today's Topics:
> >
> > 1. Configuration Management .... Re: [ic] Re: Big Login Problem,
> :backup, access.Asc , and an encryption problem (Young Family)
> > 2. I'm really sorry! (Viktors Rotanovs)
> > 3. Re: Grabbing a web page content using LWP::Simple (Dan McFarland)
> > 4. How to Activate Signio???? (Young Family)
> > 5. Re: how to use a variable in a usertag in flypage.html (Ed
LaFrance)
> > 6. Re: Paypal (David Schnardthorst - Eregion)
> > 7. Bug found: was Re: [ic] DBI error - syntax error in CREATE INDEX?
> (LM)
> > 8. RE: E-Smith (Jon Pamment)
> > 9. Re: Grabbing a web page content using LWP::Simple (Steve & Patti
> Getzinger)
> > 10. Re: Re: Paypal (Mike Heins)
> > 11. Re: Bug found: was Re: [ic] DBI error - syntax error in CREATE
> INDEX? (Mike Heins)
> > 12. makecat non-interactive? (tzf@tzf.net)
> > 13. Re: makecat non-interactive? (cfm@maine.com)
> > 14. Re: Re: Paypal (Ed LaFrance)
> > 15. RE: E-Smith (Jon Pamment)
> > 16. Re: makecat non-interactive? (Mike Heins)
> >
> > -- __--__--
> >
> > Message: 1
> > Reply-To: "Young Family" <ary@communicationfactory.com>
> > From: "Young Family" <ary@communicationfactory.com>
> > To: <interchange-users@lists.akopia.com>
> > Subject: Configuration Management .... Re: [ic] Re: Big Login Problem,
> :backup, access.Asc , and an encryption problem
> > Date: Tue, 20 Mar 2001 12:28:56 -0800
> > charset="iso-8859-1"
> > Reply-To: interchange-users@lists.akopia.com
> >
> > Thanks to you all for the help, I guess I got it working now, what a
> > nightmare.
> > I can now succesfully log in and out, but I cannot successfully change
the
> > password using the administrative interface, as the adfministrative
> > interface saves things in clear text, not encrypted.
> > But at least it is working now. I am sure that is a bug, I think...
> >
> > Ok now to the next step.... configuration management.
> > The way I understand Interchange to work, I change the setup using the
> > administrative interface, and then the page changes are "live" as soon
as
> I
> > click save. What if I want to work on a "pending" store with proposed
> > changes and then when the boss says it is okay, flip a switch and it is
> now
> > the live copy? I need to flip flop between copies so that there is
always
> a
> > "live shop" and a "proposed next version" shop? I am thinking that I
just
> > copy the live directory to a backup directory, and then that is that,
but
> > what problems will I come against? How do I keep the sales records
rolling
> > forward, but the catalog and web site content managed by a "flip-flop"
> type
> > approach? What tables should always keep moving forward.
> >
> > In other words, using the "Akopia Three Tiered Approach"
> >
> > Technical Implementor
> > Site Designer
> > Store Administrator
> > The site designer wants to work on a proposed site and see it
functioning
> in
> > a test mode before it is posted live. The we want to flip a switch and
see
> > the new content go public, ans start working on a new version offline
> again
> >
> > The store administrator does NOT want to go back and lose sales records,
> so
> > there is no "configuration management" need for him.
> >
> > The technical implementor (poor old me) is trying to figure out how to
> make
> > this happen.
> >
> > Can the many Interchange tables be identified as to their function and
> split
> > out so that a version control/configuration management type system could
> be
> > put in place? If this content configuration management feature were put
> in
> > to place, this system would rival the Vignette Story Server big boys.
> >
> > What is the scope of a project that would add these features?
> >
> > Alan Young
> >
> > ary@communicationfactory.com
> >
> >
> >
> >
> >
> > -- __--__--
> >
> > Message: 2
> > From: "Viktors Rotanovs" <Viktors@Rotanovs.com>
> > To: <interchange-users@lists.akopia.com>
> > Date: Thu, 22 Mar 2001 22:24:23 +0200
> > charset="iso-8859-4"
> > Subject: [ic] I'm really sorry!
> > Reply-To: interchange-users@lists.akopia.com
> >
> > I'm really sorry for the previous message!
> > I replied to the wrong message.
> > I promise I will be more careful next time.
> >
> > Best Wishes,
> > Viktors Rotanovs
> > Riga, Latvia. Phone +371 7377-472 Fax +1 760-418-8128
> >
> >
> >
> > -- __--__--
> >
> > Message: 3
> > From: "Dan McFarland" <dan@mailturtle.com>
> > To: <interchange-users@lists.akopia.com>
> > Subject: Re: [ic] Grabbing a web page content using LWP::Simple
> > Date: Thu, 22 Mar 2001 14:32:30 -0600
> > charset="iso-8859-1"
> > Reply-To: interchange-users@lists.akopia.com
> >
> > It can apply to both. You'll need legal advice for that one. I
wouldn't
> > have anyone NOT an attorney answer that question as you can be legally
> > liable if you act upon the answer.
> >
> > Dan M.
> >
> >
> > ----- Original Message -----
> > From: Viktors Rotanovs <Viktors@Rotanovs.com>
> > To: <interchange-users@lists.akopia.com>
> > Sent: Thursday, March 22, 2001 2:22 PM
> > Subject: Re: [ic] Grabbing a web page content using LWP::Simple
> >
> >
> > > Forgot to ask, how much can I change Xsell logo?
> > > ie, does trademark apply to the logo or to the name?
> > >
> > > Best Wishes,
> > > Viktors Rotanovs
> > > Riga, Latvia. Phone +371 7377-472 Fax +1 760-418-8128
> > >
> > > ----- Original Message -----
> > > From: "Ed LaFrance" <edl@newmediaems.com>
> > > To: <interchange-users@lists.akopia.com>
> > > Sent: Thursday, March 22, 2001 8:05 PM
> > > Subject: Re: [ic] Grabbing a web page content using LWP::Simple
> > >
> > >
> > > > At 09:46 AM 03/22/2001 -0800, you wrote:
> > > > >Are there any interchange docs on the [get-url] tag?
> > > > >
> > > > >Thanks
> > > > >
> > > > >Mat
> > > >
> > > > open the file ic/usertag/get_url.
> > > >
> > > > - Ed L.
> > > >
> > > >
> > > > >----- Original Message -----
> > > > >From: "Ed LaFrance" <edl@newmediaems.com>
> > > > >To: <interchange-users@lists.akopia.com>
> > > > >Sent: Thursday, March 22, 2001 9:19 AM
> > > > >Subject: Re: [ic] Grabbing a web page content using LWP::Simple
> > > > >
> > > > >
> > > > > > At 11:06 PM 03/21/2001 -0500, you wrote:
> > > > > > >I need to grab the contents of a web page. I have tried using
the
> > > below
> > > > > > >code.
> > > > > > >
> > > > > > >[perl Global=1 subs=1]
> > > > > > >use LWP::Simple
> > > > > > >my
$return=LWP::Simple::get('http::/www.somesite.com/index.html')
> > > > > > >return $return
> > > > > > >[/perl]
> > > > > > >
> > > > > > >No matter what library I use and the arguments to the perl
call.
> I
> > > can
> > > > >not
> > > > > > >get it to return the page. It will send the request but will
hang
> > up
> > > > >trying
> > > > > > >to read from the socket.
> > > > > > >
> > > > > > >I have tried setting it up as a Global Sub, as a usertag and
> plain
> > > perl
> > > > > > >using Use Socket. The code will work fine outside of minivend
but
> > > will
> > > > > > >always hang when it comes to reading from the socket. It will
> write
> > > to
> > > > >the
> > > > > > >socket but can not read from it.
> > > > > > >
> > > > > > >How can one read in the contents of a web page?
> > > > > >
> > > > > > I assume you have verified that LWP::Simple is installed. Did
you
> > try
> > > the
> > > > > > GET utility? it comes with the example scripts in the LWP dist,
in
> a
> > > /bin
> > > > > > subdirectory, or it may already be in your /usr/bin or
> > /usr/local/bin.
> > > > >Try
> > > > > > at the command line:
> > > > > >
> > > > > > GET http://www.someworkingsite.comn
> > > > > >
> > > > > > ...if it works you will see the html echoed to the screen.
Also,
> > > there is
> > > > > > a [get_url] usertag for Interchange, have you tried that?
> > > > > >
> > > > > > - Ed L.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ===============================================================
> > > > > > **** Virtual Hosting w/private IC Installation, $65/month! ****
> > > > > > ---------------------------------------------------------------
> > > > > > New Media E.M.S. Software Solutions for Business
> > > > > > 463 Main St., Suite D eCommerce | Consulting | Hosting
> > > > > > Placerville, CA 95667 edl@newmediaems.com
> > > > > > (530) 622-9421 http://www.newmediaems.com
> > > > > > (866) 519-4680 Toll-Free (530) 622-9426 Fax
> > > > > > ===============================================================
> > > > > >
> > > > > >
> > > > > > _______________________________________________
> > > > > > Interchange-users mailing list
> > > > > > Interchange-users@lists.akopia.com
> > > > > > http://lists.akopia.com/mailman/listinfo/interchange-users
> > > > >
> > > > >
> > > > >_______________________________________________
> > > > >Interchange-users mailing list
> > > > >Interchange-users@lists.akopia.com
> > > > >http://lists.akopia.com/mailman/listinfo/interchange-users
> > > >
> > > > ===============================================================
> > > > **** Virtual Hosting w/private IC Installation, $65/month! ****
> > > > ---------------------------------------------------------------
> > > > New Media E.M.S. Software Solutions for Business
> > > > 463 Main St., Suite D eCommerce | Consulting | Hosting
> > > > Placerville, CA 95667 edl@newmediaems.com
> > > > (530) 622-9421 http://www.newmediaems.com
> > > > (866) 519-4680 Toll-Free (530) 622-9426 Fax
> > > > ===============================================================
> > > >
> > > >
> > > > _______________________________________________
> > > > Interchange-users mailing list
> > > > Interchange-users@lists.akopia.com
> > > > http://lists.akopia.com/mailman/listinfo/interchange-users
> > > >
> > >
> > >
> > > _______________________________________________
> > > Interchange-users mailing list
> > > Interchange-users@lists.akopia.com
> > > http://lists.akopia.com/mailman/listinfo/interchange-users
> > >
> >
> >
> > -- __--__--
> >
> > Message: 4
> > Reply-To: "Young Family" <ary@communicationfactory.com>
> > From: "Young Family" <ary@communicationfactory.com>
> > To: <interchange-users@lists.akopia.com>
> > Date: Tue, 20 Mar 2001 12:41:50 -0800
> > charset="iso-8859-1"
> > Subject: [ic] How to Activate Signio????
> > Reply-To: interchange-users@lists.akopia.com
> >
> > Hello All
> > What Interchange files must I edit in order to get signio payflow pro
> going?
> > Thanks
> > Alan Young
> > ary@communicationfactory.com
> >
> >
> > -- __--__--
> >
> > Message: 5
> > Date: Thu, 22 Mar 2001 13:02:16 -0800
> > To: interchange-users@lists.akopia.com
> > From: Ed LaFrance <edl@newmediaems.com>
> > Subject: Re: [ic] how to use a variable in a usertag in flypage.html
> > Reply-To: interchange-users@lists.akopia.com
> >
> > At 01:35 PM 03/22/2001 +0530, you wrote:
> > >thanks ed can u just tell me how can i echo the value of $opt or $ary
in
> >
>http://developer.akopia.com/archive/interchange-users/2001/msg01180.html
> > >usertag user-price
> > >on flypage.html
> >
> > Like before: include them in the return value or push them into scratch
> > variables, per my last example. In either case you should convert list
> > data to scalar first.
> >
> > - Ed L.
> >
> >
> >
> >
> >
> >
> > >_______________________________________________
> > >Interchange-users mailing list
> > >Interchange-users@lists.akopia.com
> > >http://lists.akopia.com/mailman/listinfo/interchange-users
> >
> > ===============================================================
> > **** Virtual Hosting w/private IC Installation, $65/month! ****
> > ---------------------------------------------------------------
> > New Media E.M.S. Software Solutions for Business
> > 463 Main St., Suite D eCommerce | Consulting | Hosting
> > Placerville, CA 95667 edl@newmediaems.com
> > (530) 622-9421 http://www.newmediaems.com
> > (866) 519-4680 Toll-Free (530) 622-9426 Fax
> > ===============================================================
> >
> >
> > -- __--__--
> >
> > Message: 6
> > From: David Schnardthorst - Eregion <daves@eregion.org>
> > To: "'interchange-users@lists.akopia.com'"
> > <interchange-users@lists.akopia.com>
> > Date: Thu, 22 Mar 2001 15:30:14 -0600
> > Subject: [ic] Re: Paypal
> > Reply-To: interchange-users@lists.akopia.com
> >
> > I have found a lot of postings concerning integration with
> > Paypal. However, I have not found anybody yet who has complete
> > integration. Has this occurred yet, and if so, where can
> > I get some examples.
> >
> > Thanks,
> >
> > David J. Schnardthorst
> >
> > -- __--__--
> >
> > Message: 7
> > From: "LM" <lmorley@flexihost.com>
> > To: <interchange-users@lists.akopia.com>
> > Subject: Bug found: was Re: [ic] DBI error - syntax error in CREATE
INDEX?
> > Date: Thu, 22 Mar 2001 16:41:06 -0800
> > charset="windows-1251"
> > Reply-To: interchange-users@lists.akopia.com
> >
> > I think I've found & fixed the problem I reported in my original post -
> > it stems from a bug / error in the SQL code that Interchange puts in
> > order_returns.pgsql :
> >
> > CREATE INDEX order_returns_order_number ON
> > order_number (order_number)
> >
> > The problem is after the ON - there's no table etc. named
> > "order_number". After looking at the code in order_returns.ora,
> > and seeing how the index is creted there, the above statement
> > should read (I think):
> >
> > CREATE INDEX order_returns_order_number ON
> > order_returns (order_number)
> >
> > I issued that command from the postgres command line utility (psql);
> > it worked... Had to make the same change to the template
> > dbconf/pgsql/order_returns.pgsql too, so the error won't carry over
> > into any catalogs I create in the future.
> >
> > Has anyone else had and fixed the same problem? And, is there
> > anyone who's set up Interchange with Postgres who's willing to pass
> > along their experiences (off-list would be fine)?
> >
> > Thanks,
> > Larry
> >
> > > -----Original Message-----
> > > From: interchange-users-admin@lists.akopia.com
> > > [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of LM
> > > Sent: Thursday, March 22, 2001 4:51 PM
> > > To: interchange-users@lists.akopia.com
> > > Subject: [ic] DBI error - syntax error in CREATE INDEX?
> > >
> > >
> > > Hi, all -
> > >
> > > Using IC 4.6.3 (RPM install) I created a catalog that uses Postgres;
> > > for the most part everything seems to work fine.
> > >
> > > But - in my catalog's error.log file - the following line appears:
> > >
> > > [09/March/2001 ...] mycatalog - DBI: Post creation query 'create
> > > index on order_number (order_number)' failed: ERROR:
> > > DefineIndex: order_number relation not found
> > >
> > > The SQL that's apparently causing the error is in order_returns.pgsql.
> > > That's about all I've been able to figure out...
> > >
> > > The problem is that no table etc. named "order_number" exists. Does
> > > anyone know what's going on, what's causing this, how to fix it / what
> > > its really trying to do, etc.? Is this going to mess up the way
returns
> > > are processed by IC?
> >
> >
> >
> > -- __--__--
> >
> > Message: 8
> > From: "Jon Pamment" <jon@icaust.com>
> > To: <interchange-users@lists.akopia.com>
> > Subject: RE: [ic] E-Smith
> > Date: Fri, 23 Mar 2001 09:13:21 +1100
> > charset="iso-8859-1"
> > Reply-To: interchange-users@lists.akopia.com
> >
> > Thanks Dan, a guy buy the name of Luuk from the e-smith list emailed me
a
> > how to for the installation. If you're interested I'm sure he wont mind
me
> > forwarding it.
> > Thanks for the help
> >
> > Jon
> >
> >
> > -- __--__--
> >
> > Message: 9
> > Date: Thu, 22 Mar 2001 17:45:34 -0500
> > From: Steve & Patti Getzinger <steveandpatti@wubs.org>
> > To: interchange-users@lists.akopia.com
> > Subject: Re: [ic] Grabbing a web page content using LWP::Simple
> > Reply-To: interchange-users@lists.akopia.com
> >
> > I would start with lwp-download "http://somesite.com/index.html" and see
> what
> > happens. You shoudl end up with a file in the dir you executed from
named
> > index.html. Verify it is the actual file and you have a starting point.
> Now you
> > can include if you desire. I happen to use this with cron to build a
> database
> > hourly from listings at moreover.
> >
> > Steve
> >
> > Dan McFarland wrote:
> >
> > > It can apply to both. You'll need legal advice for that one. I
> wouldn't
> > > have anyone NOT an attorney answer that question as you can be legally
> > > liable if you act upon the answer.
> > >
> > > Dan M.
> > >
> > > ----- Original Message -----
> > > From: Viktors Rotanovs <Viktors@Rotanovs.com>
> > > To: <interchange-users@lists.akopia.com>
> > > Sent: Thursday, March 22, 2001 2:22 PM
> > > Subject: Re: [ic] Grabbing a web page content using LWP::Simple
> > >
> > > > Forgot to ask,...the name?
> > > >
> > > > Best Wishes,
> > > > Viktors Rotanovs
> > > > Riga, Latvia. Phone +371 7377-472 Fax +1 760-418-8128
> > > >
> > > > ----- Original Message -----
> > > > From: "Ed LaFrance" <edl@newmediaems.com>
> > > > To: <interchange-users@lists.akopia.com>
> > > > Sent: Thursday, March 22, 2001 8:05 PM
> > > > Subject: Re: [ic] Grabbing a web page content using LWP::Simple
> > > >
> > > >
> > > > > At 09:46 AM 03/22/2001 -0800, you wrote:
> > > > > >Are ...tag?
> > > > > >
> > > > > >Thanks
> > > > > >
> > > > > >Mat
> > > > >
> > > > > open the file ic/usertag/get_url.
> > > > >
> > > > > - Ed L.
> > > > >
> > > > >
> > > > > >----- Original Message -----
> > > > > >From: "Ed LaFrance" <edl@newmediaems.com>
> > > > > >To: <interchange-users@lists.akopia.com>
> > > > > >Sent: Thursday, March 22, 2001 9:19 AM
> > > > > >Subject: Re: [ic] Grabbing a web page content using LWP::Simple
> > > > > >
> > > > > >
> > > > > > > At 11:06 PM 03/21/2001 -0500, you wrote:
> > > > > > > >I need to... have you tried that?
> > > > > > >
> > > > > > > - Ed L.
> >
> >
> > -- __--__--
> >
> > Message: 10
> > Date: Thu, 22 Mar 2001 17:55:48 -0500
> > From: Mike Heins <mikeh@minivend.com>
> > To: interchange-users@lists.akopia.com
> > Subject: Re: [ic] Re: Paypal
> > Reply-To: mike@minivend.com
> > Reply-To: interchange-users@lists.akopia.com
> >
> > Quoting David Schnardthorst - Eregion (daves@eregion.org):
> > > I have found a lot of postings concerning integration with
> > > Paypal. However, I have not found anybody yet who has complete
> > > integration. Has this occurred yet, and if so, where can
> > > I get some examples.
> >
> > It is easy to *get to* PayPal, just not so easy to get back.
> >
> > Integrating is as simple as providing a button on the checkout
> > page. But completing the order is at the whim of the buyer, who
> > would have to click the link paypal.com provides on the payment
> > final page.
> >
> > That is the problem with most of the send-them-to-a-website payment
> > providers.
> >
> > Possible workarounds include setting up an email parser that would
> > receive emailed order notifications from PayPal and complete the order,
> > etc. And if by some chance PayPal allows a "silent post" then it
> > can be completed.
> >
> > Unfortunately they appear to have no developer integration links on
> > their website; I have looked (as recently as two days ago) and there
> > is no technical info on how to integrate.
> >
> > Right now there is and can be no module. No one has ever ponied up with
> > consulting dollars to have us integrate one, and there has been no
> > user-integrated module. And without technical info, I won't spend my
> > time working in the dark to do one.
> >
> > So there it sits.
> >
> > --
> > Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
> > phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
> >
> > Friends don't let friends use Outlook. -- Bob Blaylock
> >
> > -- __--__--
> >
> > Message: 11
> > Date: Thu, 22 Mar 2001 17:59:09 -0500
> > From: Mike Heins <mikeh@minivend.com>
> > To: interchange-users@lists.akopia.com
> > Subject: Re: Bug found: was Re: [ic] DBI error - syntax error in CREATE
> INDEX?
> > Reply-To: mike@minivend.com
> > Reply-To: interchange-users@lists.akopia.com
> >
> > Quoting LM (lmorley@flexihost.com):
> > > I think I've found & fixed the problem I reported in my original
post -
> > > it stems from a bug / error in the SQL code that Interchange puts in
> > > order_returns.pgsql :
> > >
> > > CREATE INDEX order_returns_order_number ON
> > > order_number (order_number)
> > >
> > > The problem is after the ON - there's no table etc. named
> > > "order_number". After looking at the code in order_returns.ora,
> > > and seeing how the index is creted there, the above statement
> > > should read (I think):
> > >
> > > CREATE INDEX order_returns_order_number ON
> > > order_returns (order_number)
> > >
> > > I issued that command from the postgres command line utility (psql);
> > > it worked... Had to make the same change to the template
> > > dbconf/pgsql/order_returns.pgsql too, so the error won't carry over
> > > into any catalogs I create in the future.
> > >
> > > Has anyone else had and fixed the same problem? And, is there
> > > anyone who's set up Interchange with Postgres who's willing to pass
> > > along their experiences (off-list would be fine)?
> > >
> >
> > That is the problem -- it is benign, though, and shouldn't have caused
> > anything but a speed decrease.
> >
> > Thanks for the find and fix. Fixed in CVS.
> >
> > --
> > Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
> > phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
> >
> > Few blame themselves until they have exhausted all other possibilities.
> > -- anonymous
> >
> > -- __--__--
> >
> > Message: 12
> > From: tzf@tzf.net
> > Date: Thu, 22 Mar 2001 15:01:12 -0800
> > To: interchange-users@lists.akopia.com
> > Subject: [ic] makecat non-interactive?
> > Reply-To: interchange-users@lists.akopia.com
> >
> >
> > Hi Folks,
> > By way of introduction, my name's Tim and I've been lurking for a while.
> > I'm starting an e-commerce hosting company with a friend. I'm
enthusiastic
> > about Open Source, and hoping Interchange will allow us to base the
> > business on an open source solution, despite some customers' insistance
> > that they want to go with Brand X.
> >
> > My question: I want to run makecat from the command line in a
> > non-interactive mode. i.e. I want to specify all paramters on the
command
> > line, and then have makecat "just do it", sending only error messages to
> > the standard output when necessary.
> >
> > I've been using something like this:
> >
> > makecat --serverconf=blah --servername=blahblah --demotype=construct
> ...etc.
> >
> > This sets the defaults correctly on the prompts for each of the
paramters
> I
> > set, but does not prevent makecat from prompting in the shell. I also
> tried
> > enclosing the entire thing in a perl system() function, with no change
in
> > results.
> >
> > I'm sorry if this is really too basic a question, I've only been writing
> > perl for about 3 months now.
> >
> > thanks!
> > tzf
> > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Find my contact info online at http://tzf.net/contact
> >
> > -- __--__--
> >
> > Message: 13
> > From: cfm@maine.com
> > Date: Thu, 22 Mar 2001 18:11:51 -0500
> > To: interchange-users@lists.akopia.com
> > Subject: Re: [ic] makecat non-interactive?
> > Reply-To: interchange-users@lists.akopia.com
> >
> > On Thu, Mar 22, 2001 at 03:01:12PM -0800, tzf@tzf.net wrote:
> > >
> > > Hi Folks,
> > > By way of introduction, my name's Tim and I've been lurking for a
while.
> > > I'm starting an e-commerce hosting company with a friend. I'm
> enthusiastic
> > > about Open Source, and hoping Interchange will allow us to base the
> > > business on an open source solution, despite some customers'
insistance
> > > that they want to go with Brand X.
> > >
> > > My question: I want to run makecat from the command line in a
> > > non-interactive mode. i.e. I want to specify all paramters on the
> command
> > > line, and then have makecat "just do it", sending only error messages
to
> > > the standard output when necessary.
> > >
> > > I've been using something like this:
> > >
> >
> >
> > We used to have something like that with Vend. A perl script that
simply
> > did the typical substitutions in catalog.cfg. It seems like most people
> > use the stock construct pages. So makecat makes sense for those. But
if
> > you start with your own templates, then it is pretty easy to build a
> minimal
> > perl script that iterates a template tree into a destination tree.
That's
> > more or less what we do now. Automating makecat is probably the hard
way.
> > TMTOWTDI
> >
> > cfm
> >
> > > makecat --serverconf=blah --servername=blahblah --demotype=construct
> ...etc.
> > >
> > > This sets the defaults correctly on the prompts for each of the
> paramters I
> > > set, but does not prevent makecat from prompting in the shell. I also
> tried
> > > enclosing the entire thing in a perl system() function, with no change
> in
> > > results.
> > >
> > > I'm sorry if this is really too basic a question, I've only been
writing
> > > perl for about 3 months now.
> > >
> > > thanks!
> > > tzf
> > > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > Find my contact info online at http://tzf.net/contact
> > >
> > > _______________________________________________
> > > Interchange-users mailing list
> > > Interchange-users@lists.akopia.com
> > > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
> > --
> >
> > Christopher F. Miller, Publisher
cfm@maine.com
> > MaineStreet Communications, Inc 208 Portland Road, Gray, ME
04039
> > 1.207.657.5078
http://www.maine.com/
> > Content management, electronic commerce, internet integration, Debian
> linux
> >
> > -- __--__--
> >
> > Message: 14
> > Date: Thu, 22 Mar 2001 15:15:34 -0800
> > To: interchange-users@lists.akopia.com
> > From: Ed LaFrance <edl@newmediaems.com>
> > Subject: Re: [ic] Re: Paypal
> > <51636DCAC862D1119AD700805FA982AD03FA12@aragorn.stryder.com>
> > Reply-To: interchange-users@lists.akopia.com
> >
> > At 05:55 PM 03/22/2001 -0500, you wrote:
> > >Quoting David Schnardthorst - Eregion (daves@eregion.org):
> > > > I have found a lot of postings concerning integration with
> > > > Paypal. However, I have not found anybody yet who has complete
> > > > integration. Has this occurred yet, and if so, where can
> > > > I get some examples.
> > >
> > >It is easy to *get to* PayPal, just not so easy to get back.
> > >
> > >Integrating is as simple as providing a button on the checkout
> > >page. But completing the order is at the whim of the buyer, who
> > >would have to click the link paypal.com provides on the payment
> > >final page.
> > >
> > >That is the problem with most of the send-them-to-a-website payment
> > >providers.
> > >
> > >Possible workarounds include setting up an email parser that would
> > >receive emailed order notifications from PayPal and complete the order,
> > >etc. And if by some chance PayPal allows a "silent post" then it
> > >can be completed.
> > >
> > >Unfortunately they appear to have no developer integration links on
> > >their website; I have looked (as recently as two days ago) and there
> > >is no technical info on how to integrate.
> > >
> > >Right now there is and can be no module. No one has ever ponied up with
> > >consulting dollars to have us integrate one, and there has been no
> > >user-integrated module. And without technical info, I won't spend my
> > >time working in the dark to do one.
> > >
> >
> > ...I went as far as to contact them, proposing that they consider some
> type
> > of gateway or "silent post" interface for their services, explaining
that
> I
> > and/or others would most likely hammer out some kind of support for such
a
> > service in Interchange and put it into the code base. We had a few
> > exchanges via email and they collected a slew of data from me (probably
> for
> > marketing). That was more than two months ago - no word since. I don't
> > think they are ready for it right now, or they just don't see the
benefit
> > to them.
> >
> > - Ed L.
> >
> >
> >
> >
> > ===============================================================
> > **** Virtual Hosting w/private IC Installation, $65/month! ****
> > ---------------------------------------------------------------
> > New Media E.M.S. Software Solutions for Business
> > 463 Main St., Suite D eCommerce | Consulting | Hosting
> > Placerville, CA 95667 edl@newmediaems.com
> > (530) 622-9421 http://www.newmediaems.com
> > (866) 519-4680 Toll-Free (530) 622-9426 Fax
> > ===============================================================
> >
> >
> > -- __--__--
> >
> > Message: 15
> > From: "Jon Pamment" <916senna@icaust.com>
> > To: <interchange-users@lists.akopia.com>
> > Subject: RE: [ic] E-Smith
> > Date: Fri, 23 Mar 2001 10:23:50 +1100
> > charset="iso-8859-1"
> > Reply-To: interchange-users@lists.akopia.com
> >
> > OOPPPS the guy that did the how to for e-smith is Justin Funke, my
> apologies
> > to both for that oversight.
> > Jon
> >
> > -----Original Message-----
> > From: interchange-users-admin@lists.akopia.com
> > [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Jon
> > Pamment
> > Sent: Friday, 23 March 2001 9:13 AM
> > To: interchange-users@lists.akopia.com
> > Subject: RE: [ic] E-Smith
> >
> >
> > Thanks Dan, a guy buy the name of Luuk from the e-smith list emailed me
a
> > how to for the installation. If you're interested I'm sure he wont mind
me
> > forwarding it.
> > Thanks for the help
> >
> > Jon
> >
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
> >
> > -- __--__--
> >
> > Message: 16
> > Date: Thu, 22 Mar 2001 19:00:06 -0500
> > From: Mike Heins <mikeh@minivend.com>
> > To: interchange-users@lists.akopia.com
> > Subject: Re: [ic] makecat non-interactive?
> > Reply-To: mike@minivend.com
> > Reply-To: interchange-users@lists.akopia.com
> >
> > Quoting tzf@tzf.net (tzf@tzf.net):
> > >
> > > Hi Folks,
> > > By way of introduction, my name's Tim and I've been lurking for a
while.
> > > I'm starting an e-commerce hosting company with a friend. I'm
> enthusiastic
> > > about Open Source, and hoping Interchange will allow us to base the
> > > business on an open source solution, despite some customers'
insistance
> > > that they want to go with Brand X.
> > >
> > > My question: I want to run makecat from the command line in a
> > > non-interactive mode. i.e. I want to specify all paramters on the
> command
> > > line, and then have makecat "just do it", sending only error messages
to
> > > the standard output when necessary.
> > >
> > > I've been using something like this:
> > >
> > > makecat --serverconf=blah --servername=blahblah --demotype=construct
> ...etc.
> > >
> >
> > Have you tried that? It does indeed work. Try looking at the makecat man
> > page ( "perldoc bin/makecat" works as well), it should give you all you
> need.
> >
> > Hint: look at -F parameter.
> >
> > --
> > Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
> > phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
> >
> > Research is what I'm doing when I don't know what I'm doing.
> > -- Wernher Von Braun
> >
> >
> >
> > -- __--__--
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
> >
> > End of Interchange-users Digest
> >
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>
>
>
>
> --__--__--
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>
>
> End of Interchange-users Digest
>