[ic] RE: How can I make subcategories ?
Dan Garwood
res087jh@verizon.net
Fri, 23 Mar 2001 02:59:10 -0500
Ramana,
What you need to do is for the new tables you create....now this is for a
mysql setup....
you simply create a files called
category_tbl.mysql
subcategorey_tbl.mysql
these will go into /yourhomedirectory/catalogdirectory/dbconf/mysql/
you will se other files in there. Open one and look at the format. This is
what the admin uses to know what tables your talking about in mysql.
Simply copy the outline of one of these files. I suggest looking at the
products.mysql file, siunce it will show you the largest examples of
different fields. Of course you will have to add a field to your products
table called subcategory so you will have to change products.mysql also.
Once these files are created and updated you simply need to restart
interchange to have access to them. If you are using postgres you would look
at the files in the postgres directory and so forth depending on what type
of database your using.
If you need any further help, you can email me directly.
Dan Garwood
E-Profit Designs
res087jh@verizon.net
-----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 2:41 AM
To: interchange-users@lists.akopia.com
Subject: [ic] RE: How can I make subcategories ?
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
>
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users