[ic] CyberSource?
Sam Lloyd
slloyd@convineo.com
Tue, 12 Dec 2000 19:27:20 -0600
Has anyone integrated with the cybersource payment service?
-----Original Message-----
From: interchange-users-admin@minivend.com
[mailto:interchange-users-admin@minivend.com]
Sent: Tuesday, December 12, 2000 7:11 PM
To: interchange-users@minivend.com
Subject: Interchange-users digest, Vol 1 #187 - 16 msgs
Send Interchange-users mailing list submissions to
interchange-users@www.minivend.com
To subscribe or unsubscribe via the web, visit
http://www.minivend.com/mailman/listinfo/interchange-users
or, via email, send a message with subject or body 'help' to
interchange-users-request@www.minivend.com
You can reach the person managing the list at
interchange-users-admin@www.minivend.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: CyberCash Message Not Showing In Log (James Guillot)
2. Database Structure general question. (Keith Pettit)
3. Re: Database Structure general question. (Dan)
4. mysql odbc access question (Eric Hull)
5. Re: Interchange server only runs for a while, then dies (Jonathan
Melhuish)
6. Re: Interchange server only runs for a while, then dies (Jonathan
Melhuish)
7. Re: mysql odbc access question (Daniel Gardner)
8. Re: mysql odbc access question (Daniel Gardner)
9. Re: mysql odbc access question (delionsweb - interchange)
10. Re: mysql odbc access question (Dan)
11. Re: Interchange server only runs for a while, then dies (Dan)
12. Re: CyberCash Message Not Showing In Log (Adrian Galindo)
13. Re: How to automate creation of catalogs (Mike Heins)
14. Re: European taxation (again...) (Mike Heins)
15. Re: PLEASE HELP! - FORBIDDEN, NO PERMISSION! (Ryan Hertz)
16. Re: Database Structure general question. (Mike Heins)
--__--__--
Message: 1
From: "James Guillot" <jwguillot@huntforpro.com>
Organization: Hunt Forest Products, Inc.
To: interchange-users@minivend.com
Date: Tue, 12 Dec 2000 15:39:56 -0600
Subject: Re: [ic] CyberCash Message Not Showing In Log
Reply-To: interchange-users@www.minivend.com
Thanks again for you reply. I have been doing some more
testing. It doesn't seem to matter which userid I use to start
Interchange. I went to /usr/lib/interchange/bin/ and executed
'./interchange' as user interch and the errorlog showed that
CyberCash was found! I then went to /etc/rc.d/init.d/ and executed
'sh interchange start' as userid interch and the errorlog did NOT
show that CyberCash was found. I'm not sure the problem is
permissions?
I starting to think it has to do with running interchange as a
daemon as opposed to foreground? Anything I should look at
there?
Date sent: Tue, 12 Dec 2000 11:12:41 -0500
To: interchange-users@minivend.com
From: Eric Paul <epaul@spellbook.net>
Subject: Re: [ic] CyberCash Message Not Showing In Log
Send reply to: interchange-users@minivend.com
> If it can't write to the error.log, then you definately have some
> permission problems somewhere... Chec your dirs and make sure that the
> UID/GID are right on all of them (most should be the UID/GID of the IC
> user). Sounds like at one point you ran the IC server as root and it
> chowned a bunch of files...
>
> Eric
>
> At 11:01 AM 12/12/00, you wrote:
> > Thanks for your reply. I am starting the init.d/interchange
script
> >as root, but the script /usr/sbin/interchange checks for root and
> >su's the user id to interch. When I look at the running interchange
> >process it shows the user as interch. When I start using this
> >method I don't get a CyberCash found message in the error.log.
> > If I go to /usr/lib/interchange/bin and type ./interchange -
> >DEBUG as user interch I get a message that CyberCash was
> >found and some messages about not being able to write error.log.
> > I am dead sure that I am running CyberCash 3.2.0.6 with the updated
> > pm's for interchange.
> >Meanwhile none of my test transactions show up on CyberCash's web site.
> >Which makes sense.
> >Any other ideas?
> >
> >Date sent: Mon, 11 Dec 2000 18:26:40 -0500
> >To: interchange-users@minivend.com
> >From: Eric Paul <epaul@spellbook.net>
> >Subject: Re: [ic] CyberCash Message Not Showing In Log
> >Send reply to: interchange-users@minivend.com
> >
> > > Are you starting the Interchange server as the right user? From what
> > > you've said, it looks like maybe you're starting it as root in one
case
> > > (bad thing) and not in another.... What are you doing differently
between
> > > the command lines in initd and the ones you type from the command
> > > line? What user are you starting it as when you do it from the
command
> > line?
> > >
> > > There's some things to check at first...
> > >
> > > Eric
> > >
> > > At 06:18 PM 12/11/00, you wrote:
> > >
> > > >Hi All,
> > > >
> > > > I'm having a problem with CyberCash. I don't get a message
in
> > > >the Interchange error.log showing that CyberCash was found. I
> > > >have sucessfully tested CyberCash outside of Interchange. Here is
> > > >my setup: Redhat 7, Interchange 4.6.1, CyberCash 3.2.6 w/ the
> > > >updates from homestead.com. I have moved all the required
> > > >CyberCash files to VendRoot (/usr/lib/interchange/lib)
> > > > If I start Interchange using Interchange Start from
> > /etc/rc.d/initd
> > > >I don't get a CyberCash message in the Interchange error.log.
> > > >However if I manually start Interchange from /usr/lib/interchange/bin
> > > >I do get the CyberCash found message. Maybe a permission
> > > >problem? Any help would be appreciated!
> > > >
> > > >Catalog.cfg:
> > > >Variable CYBER_CONFIGFILE
> > > >/usr/lib/interchange/lib/merchant_conf
> > > >Variable CYBER_VERSION 3.2
> > > >Variable CYBER_MODE mauthonly
> > > >
> > > >James W. Guillot
> > > >IS Manager
> > > >Hunt Forest Products, Inc.
> > > >
> > > >
> > > >_______________________________________________
> > > >Interchange-users mailing list
> > > >Interchange-users@www.minivend.com
> > > >http://www.minivend.com/mailman/listinfo/interchange-users
> > >
> > > ---
> > > Eric Paul
> > > SpellBook Systems
> > > http://www.spellbook.net
> > >
> > >
> > > _______________________________________________
> > > Interchange-users mailing list
> > > Interchange-users@www.minivend.com
> > > http://www.minivend.com/mailman/listinfo/interchange-users
> > >
> >
> >
> >James W. Guillot
> >IS Manager
> >Hunt Forest Products, Inc.
> >
> >
> >_______________________________________________
> >Interchange-users mailing list
> >Interchange-users@www.minivend.com
> >http://www.minivend.com/mailman/listinfo/interchange-users
>
> ---
> Eric Paul
> SpellBook Systems
> http://www.spellbook.net
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
>
James W. Guillot
IS Manager
Hunt Forest Products, Inc.
--__--__--
Message: 2
From: "Keith Pettit" <keithp@censoft.com>
To: <interchange-users@minivend.com>
Date: Tue, 12 Dec 2000 15:21:19 -0700
charset="iso-8859-1"
Subject: [ic] Database Structure general question.
Reply-To: interchange-users@www.minivend.com
I wanted to use MySQL so I wouldn't more reliable datastorage than plain
text file. But after I upgrade to MySQL I noticed that Interchange still
uses some text files instead of the database. For example shipping.asc is
used instead of the database, but the coutry list is in the database.
It just seems kind of stupid to use two methods. Why on earth not use the
database for everything (execpt images). I'm just curious why the default
configuration is like that.
Keith
--__--__--
Message: 3
Reply-To: "Dan" <db@cyclonehq.dnsalias.net>
From: "Dan" <db@cyclonehq.dnsalias.net>
To: <interchange-users@minivend.com>
Subject: Re: [ic] Database Structure general question.
Date: Tue, 12 Dec 2000 14:27:43 -0800
charset="iso-8859-1"
Reply-To: interchange-users@www.minivend.com
Because the items in the text files very rarely, if ever, change. So, as I
understand it, they are loaded into memory and queried directly from memory,
instead of putting extra load on the SQL server for no good reason.
----- Original Message -----
From: "Keith Pettit" <keithp@censoft.com>
To: <interchange-users@minivend.com>
Sent: Tuesday, December 12, 2000 2:21 PM
Subject: [ic] Database Structure general question.
> I wanted to use MySQL so I wouldn't more reliable datastorage than plain
> text file. But after I upgrade to MySQL I noticed that Interchange still
> uses some text files instead of the database. For example shipping.asc is
> used instead of the database, but the coutry list is in the database.
>
> It just seems kind of stupid to use two methods. Why on earth not use the
> database for everything (execpt images). I'm just curious why the default
> configuration is like that.
>
> Keith
>
>
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
>
--__--__--
Message: 4
Reply-To: <eric@webuildpcs.com>
From: "Eric Hull" <eric@webuildpcs.com>
To: <interchange-users@minivend.com>
Date: Tue, 12 Dec 2000 16:56:26 -0600
charset="iso-8859-1"
Subject: [ic] mysql odbc access question
Reply-To: interchange-users@www.minivend.com
Hello all,
Ok got mySQL up and can access it from Access no problem - well lots of
problems but we got over it.
here's our problem we just cant figure out:
in access linked tables when a change is made in the to a record in a
table - we get a write conflict that says: This record has been changed
since you started editing it, blah blah....
We do not think it is an access error. It could be - we are getting bruses
from beating our heads on the wall
anyone - H E L P
Thanks
Eric Hull
___________________________________________
visit us on the web at www.webuildpcs.com
--__--__--
Message: 5
Date: Tue, 12 Dec 2000 22:58:39 +0000
From: Jonathan Melhuish <jonathanmelhuish@email.com>
To: interchange-users@minivend.com
CC: =?iso-8859-1?Q?Adri=E1n?= Galindo <agalindo@liceaga.facmed.unam.mx>
Subject: Re: [ic] Interchange server only runs for a while, then dies
Reply-To: interchange-users@www.minivend.com
I will try installing it on something other than Mandrake 7.1 - I have a
Mandrake 7.2 laptop I could try it on. However, I do need confidence than I
will be able to install it successfully on a Cobalt RAQ3, which will be
commisioned after the site has been coded. I don't want to be in the
situation
where I cannot run the site I have spent hours coding! Does anyone have any
experience of running an IC server on a similar setup (Cobalt/RedHat Linux)?
Sorry I could not provide a more specific error message or symptom, I
understand how diagnosing such a vague symptom could be rather difficult!
Thanks for your valued co-operation.
Jon
Adrián Galindo wrote:
> Jonathan Melhuish wrote:
> >
> > Pretty much every other thread is receiving a prompt and helpful reply -
I
> > was just wondering why mine wasn't!
> >
> > Is it me? Am I stupid? Is it an obvious mistake? Or is it really so
> > difficult that it is incurable?
> >
> > PLEASE help me and the othe rpeople who are experiencing this problem to
> > experience the miracle of Interchange!
>
> With all respect you deserve, I suggest to you, that instead of being
> complaning about it, try to install everything from the scratch.
> If it's necessary, try on another machine, or another O.S.
>
> It is clear that there is something wrong with your
> installation/machine, cause there are thousands or maybe millions of IC
> servers running, with problems and difficulties if you want, but finally
> running.
>
> I don't remember your machine, O.S. or specific error message. We can
> help to you without information about it.
>
> Cheers.
> Adrian Galindo.
> Mexico City.
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
--__--__--
Message: 6
Date: Tue, 12 Dec 2000 23:05:30 +0000
From: Jonathan Melhuish <jonathanmelhuish@email.com>
To: interchange-users@minivend.com
Subject: Re: [ic] Interchange server only runs for a while, then dies
Reply-To: interchange-users@www.minivend.com
I'm impressed - you wouldn't find anybody from Microsoft posting in a user
group, even if you have paid a considerable sum of money for the software!
:-)
Your response makes it sound like I'm doing something really basic wrong - I
don't see why my machine should be all that different; I'm only running a
fairly bog-standard Mandrake 7.1/Cyrix 686 setup.
I promise to post my findings, even if they are embarrassingly simple :-)
Your support is greatly appreciated.
Jon
Mike Heins wrote:
> Quoting Jonathan Melhuish (jonathanmelhuish@email.com):
> > Pretty much every other thread is receiving a prompt and helpful reply -
I
> > was just wondering why mine wasn't!
> >
> > Is it me? Am I stupid? Is it an obvious mistake? Or is it really so
> > difficult that it is incurable?
>
> I think it is just that no one knows the answer. I don't. I have installed
> this stuff on hundreds or thousands of machines and never seen the problem
> without some process-watchdog or memory quota in place.
>
> You might try typeing "limit" at your shell and seeing what you get back.
>
> --
> Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
> phone +1.513.523.7621 fax 7501 <heins@akopia.com>
>
> Light travels faster than sound. This is why some people appear bright
> until you hear them speak. -- unknown
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
--__--__--
Message: 7
Date: Tue, 12 Dec 2000 23:30:53 +0000
From: Daniel Gardner <daniel@beenz.com>
To: interchange-users@minivend.com
Subject: Re: [ic] mysql odbc access question
Reply-To: interchange-users@www.minivend.com
It's been a while since i used odbc to mysql, but i'm almost
positive that there's something in the mysql docs about this.
There's an option in the myodbc setup about returning matching
rows - or something similar. check that box - it might help
ta,
daniel
On Tue, Dec 12, 2000 at 04:56:26PM -0600, Eric Hull wrote:
> Hello all,
>
> Ok got mySQL up and can access it from Access no problem - well lots of
> problems but we got over it.
>
> here's our problem we just cant figure out:
>
> in access linked tables when a change is made in the to a record in a
> table - we get a write conflict that says: This record has been changed
> since you started editing it, blah blah....
>
> We do not think it is an access error. It could be - we are getting
bruses
> from beating our heads on the wall
>
> anyone - H E L P
>
> Thanks
> Eric Hull
>
>
> ___________________________________________
> visit us on the web at www.webuildpcs.com
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
--__--__--
Message: 8
Date: Tue, 12 Dec 2000 23:38:51 +0000
From: Daniel Gardner <daniel@beenz.com>
To: interchange-users@minivend.com
Subject: Re: [ic] mysql odbc access question
Reply-To: interchange-users@www.minivend.com
Sorry i was totally lying to you. From the mysql manual - section
18.3:
With some programs you get an error like: Another user has
modified the record that you have modified. In most cases this
can be solved by doing one of the following things:
o Add a primary key for the table if there isn't one already
o Add a timestamp column if there isn't one already
o Only use double float fields. Some programs may fail when they
compare single floats
If the above doesn't help, you should do a MyODBC trace file and
try to figure out why things go wrong
HTH,
daniel
On Tue, Dec 12, 2000 at 11:30:53PM +0000, Daniel Gardner wrote:
> It's been a while since i used odbc to mysql, but i'm almost
> positive that there's something in the mysql docs about this.
>
> There's an option in the myodbc setup about returning matching
> rows - or something similar. check that box - it might help
>
> ta,
> daniel
>
>
> On Tue, Dec 12, 2000 at 04:56:26PM -0600, Eric Hull wrote:
> > Hello all,
> >
> > Ok got mySQL up and can access it from Access no problem - well lots of
> > problems but we got over it.
> >
> > here's our problem we just cant figure out:
> >
> > in access linked tables when a change is made in the to a record in a
> > table - we get a write conflict that says: This record has been changed
> > since you started editing it, blah blah....
> >
> > We do not think it is an access error. It could be - we are getting
bruses
> > from beating our heads on the wall
> >
> > anyone - H E L P
> >
> > Thanks
> > Eric Hull
> >
> >
> > ___________________________________________
> > visit us on the web at www.webuildpcs.com
> >
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@www.minivend.com
> > http://www.minivend.com/mailman/listinfo/interchange-users
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
--__--__--
Message: 9
Date: Tue, 12 Dec 2000 18:47:19 -0500
To: interchange-users@minivend.com, interchange-users@minivend.com
From: delionsweb - interchange <interchange@delionsweb.net>
Subject: Re: [ic] mysql odbc access question
Reply-To: interchange-users@www.minivend.com
I get it too and there is not much you can do about it unless you fix the
ODBC driver itself.
At 05:56 PM 12/12/2000, you wrote:
>Hello all,
>
>Ok got mySQL up and can access it from Access no problem - well lots of
>problems but we got over it.
>
>here's our problem we just cant figure out:
>
>in access linked tables when a change is made in the to a record in a
>table - we get a write conflict that says: This record has been changed
>since you started editing it, blah blah....
>
>We do not think it is an access error. It could be - we are getting bruses
>from beating our heads on the wall
>
>anyone - H E L P
>
>Thanks
>Eric Hull
>
>
>___________________________________________
>visit us on the web at www.webuildpcs.com
>
>
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@www.minivend.com
>http://www.minivend.com/mailman/listinfo/interchange-users
--__--__--
Message: 10
Reply-To: "Dan" <db@cyclonehq.dnsalias.net>
From: "Dan" <db@cyclonehq.dnsalias.net>
To: <interchange-users@minivend.com>
Subject: Re: [ic] mysql odbc access question
Date: Tue, 12 Dec 2000 15:48:23 -0800
charset="iso-8859-1"
Reply-To: interchange-users@www.minivend.com
I don't know about your problem, but check into the MySQL / ODBC mailing
lists.
----- Original Message -----
From: "Eric Hull" <eric@webuildpcs.com>
To: <interchange-users@minivend.com>
Sent: Tuesday, December 12, 2000 2:56 PM
Subject: [ic] mysql odbc access question
> Hello all,
>
> Ok got mySQL up and can access it from Access no problem - well lots of
> problems but we got over it.
>
> here's our problem we just cant figure out:
>
> in access linked tables when a change is made in the to a record in a
> table - we get a write conflict that says: This record has been changed
> since you started editing it, blah blah....
>
> We do not think it is an access error. It could be - we are getting
bruses
> from beating our heads on the wall
>
> anyone - H E L P
>
> Thanks
> Eric Hull
>
>
> ___________________________________________
> visit us on the web at www.webuildpcs.com
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
>
--__--__--
Message: 11
Reply-To: "Dan" <db@cyclonehq.dnsalias.net>
From: "Dan" <db@cyclonehq.dnsalias.net>
To: <interchange-users@minivend.com>
Subject: Re: [ic] Interchange server only runs for a while, then dies
Date: Tue, 12 Dec 2000 15:51:25 -0800
charset="iso-8859-1"
Reply-To: interchange-users@www.minivend.com
> fairly bog-standard Mandrake 7.1/Cyrix 686 setup.
Wow. Cyrix makes a 686 now? I thought they were bought out by Via after
their last 586. If they didn't quit, they should've. Their chips are as
reliable as Windows 95.
--__--__--
Message: 12
Date: Tue, 12 Dec 2000 18:49:08 -0600 (CST)
From: Adrian Galindo <agalindo@liceaga.facmed.unam.mx>
Reply-To: Adrian Galindo <agalindo@liceaga.facmed.unam.mx>
To: interchange-users@minivend.com
Subject: Re: [ic] CyberCash Message Not Showing In Log
Reply-To: interchange-users@www.minivend.com
On Tue, 12 Dec 2000, Chip Adair wrote:
> Remember that the SU command does not by default carry over the
environment
> information (paths etc) that the su'd user (in your case "interch") would
> have if it were ran on the command line directly as that user.
> This could be where your problem is coming in.
This can be solved if invoke the su command with an after dash:
su - interch
which call the environment for the user interch.
Adrian.
--__--__--
Message: 13
Date: Tue, 12 Dec 2000 19:44:06 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@minivend.com
Subject: Re: [ic] How to automate creation of catalogs
Reply-To: mike@minivend.com
Reply-To: interchange-users@www.minivend.com
Quoting Paul Cauberg (paul@quarp.com):
>
> Is there a way in wich I can create the automation of a catalog? If I set
> all the variables
> in the environment and then start makecat it still asks me to confirm that
> input, is there someway I can have it accept my environment settings
> without asking me for the confirmation?
>
We just removed an example, makecat.redhat, which showed the call
to make a catalog on the commandline:
bin/makecat -F \
--cgibase=$CGIBASE \
--basedir=$BASEDIR \
--documentroot=$DOCROOT \
--sharedir=$DOCROOT \
--shareurl=/ \
--interchangeuser=interch \
--interchangegroup=interch \
--serverconf=$SERVERCONF \
--vendroot=$VENDROOT \
--catroot=$BASEDIR/$i \
--cgidir=$CGIDIR \
--$RELOCATE \
--servername=$HOST \
--cgiurl=$CGIBASE/$i \
--demotype=$i \
--mailorderto=interch@$HOST \
--catuser=interch \
--permtype=user \
--samplehtml=$DOCROOT/$i \
--imagedir=$DOCROOT/$i/images \
--imageurl=/$i/images \
--linkmode=UNIX \
--sampleurl=http://$HOST/$i \
--catalogname=$i \
company="your company"
The -F parameter says "don't ask me whether it is correct, just
do it". You can also put in the substitutions for the __MVC_*__
templating stuff as I did above with "company".
--
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>
For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled. -- Dick Feynman
--__--__--
Message: 14
Date: Tue, 12 Dec 2000 20:05:04 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@minivend.com
Subject: Re: [ic] European taxation (again...)
Reply-To: mike@minivend.com
Reply-To: interchange-users@www.minivend.com
Quoting Rene Hertell (rene@hertell.com):
> Hi list!
>
> I have been browsing the mail-archives for a while and trying to find an
> clear and easy solution in solving the tax-problem that probably many of
the
> European minivend-users bump into. As many of you know, the tax is based
on
> product-categories.
>
> Does anyone have a simple solution (I'm a real amateur with this...) in
how
> to solve this issue. It would be nice have a solution that would use the
> normal [salestax] tag. The prices are given in the productdb without tax.
>
>
>
> Here a small example: The db contains a field with the tax percentage.
This
> field should then be used when calculating the basket.
>
> products.txt db
> name price tax
> toothbrush 10.00 0.22
> toothpaste 20.00 0.22
> a book 35.00 0.17
>
>
>
> Basket:
>
> Item qty price tax incl tax
> toothbrush 1 10.00 2.20 12.20
> toothpaste 1 20.00 4.40 24.40
> a book 1 35.00 7.70 42.70
>
There are several ways to do it. For Interchange 4.8 (and later 4.7.x)
I will have a UI to help do this.
The thing I like best is to create a new *shipping* method and
add tax with mv_handling. I will probably be using this method.
The quick and dirty way is to write a UserTag which does it
and then include that in salestax.asc.
UserTag vat-calc Order table field
UserTag vat-calc addAttr
UserTag vat-calc Routine <<EOR
sub {
my ($table, $field, $opt) = @_;
my $error = sub {
my $msg = shift;
Log($msg);
return undef;
};
my $tax = 0;
foreach my $item (@$Vend::Items) {
my $taxrate = tag_data($table, $field, $item->{code});
$tax += ($taxrate * $item->{quantity});
}
return $tax;
}
EOR
(If you put the above in your catalog.cfg instead of interchange.cfg, you
will
have to make sure you have referenced the products table before you call
it.)
Now this in salestax.asc:
default [vat-calc products tax]
UK [vat-calc products tax]
FR [vat-calc products tax]
US 0
and this in catalog.cfg:
SalesTax country
should do it. You can also key it on category if you want, simply by
creating a "tax" table and using:
AutoModifier products:category
Now use $item->{category} to key into the table for getting the tax
rate by percentage of price. (Obviously you will have to calculate the
price somehow, but that is not too difficult depending on your CommonAdjust
definition.)
--
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>
Unix version of an Outlook-style virus:
It works on the honor system. Please forward this message to everyone
you know, and delete a bunch of your files at random.
--__--__--
Message: 15
Date: Tue, 12 Dec 2000 18:00:16 -0700
To: interchange-users@minivend.com
From: Ryan Hertz <rhertz@gyb.baits.com>
Subject: Re: [ic] PLEASE HELP! - FORBIDDEN, NO PERMISSION!
Reply-To: interchange-users@www.minivend.com
At 07:53 AM 12/12/00 , you wrote:
>Why is this happening?
>I have installed Interchange on Mac OS X (which is basically FreeBSD) and
>have actually had it up and running on many different occasions. Sometimes
>for only an hour or so, sometimes all day. It works fine until suddenly I
>get "Forbidden - You don't have permission to access
>/cgi-bin/construct/index.html on this server" when either the "admin" or
the
>"customer" link, on the main store entrance page, is clicked for any store.
Okay, well that is definitely an Apache error message. Start looking there
-- access logs, error logs, etc.
>Interchange is running. Apache is running. All other cgi scripts work.
>I "bin/restart", I have rebooted the server and done a "bin/interchange"
but
>nothing works.
>Is Interchange always so finicky?
No, it doesn't seem to be Interchange's fault to me. At least, IC is not
outputting that particular error message.
>Does anyone have any ideas?
>If I am not providing enough info, please tell me.
Look over your Apache logs. Does this error occur only on the same
links? Does it always say 'cgi-bin/construct/index.html'? This could
quite possibly be an Apache configuration error, but as for a reason why it
seems to be sporadic, I don't know. Double check your permissions (since
it is a permission error). Who is the owner/group of the construct demo's
index.html? What is your umask -- is it possible that it breaks only when
someone/something accesses that file? Does just /cgi-bin/construct/ work
(no index.html)?
Ryan Hertz tel 800-645-BAIT
Webmaster fax 520-645-2588
Advertising Director http://yamamoto.baits.com
Gary Yamamoto Custom Baits, Inc. http://www.insideline.net
--__--__--
Message: 16
Date: Tue, 12 Dec 2000 20:11:15 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@minivend.com
Subject: Re: [ic] Database Structure general question.
Reply-To: mike@minivend.com
Reply-To: interchange-users@www.minivend.com
Quoting Keith Pettit (keithp@censoft.com):
> I wanted to use MySQL so I wouldn't more reliable datastorage than plain
> text file. But after I upgrade to MySQL I noticed that Interchange still
> uses some text files instead of the database. For example shipping.asc is
> used instead of the database, but the coutry list is in the database.
>
> It just seems kind of stupid to use two methods. Why on earth not use the
> database for everything (execpt images). I'm just curious why the default
> configuration is like that.
I am sorry I am stupid. I will try and improve. 8-)
For one thing, shipping.asc is not really a database. It is a
configuration table.
Second of all, there are things you can do with the internal DB
that you can't with SQL -- for instance, we would have to munge the
UPS-supplied tax tables because SQL doesn't allow you to have a field
name that is digits only.
Third, part of this is that Interchange has grown over a five-year
period from other software. It didn't even have SQL to begin with.
I am actually pretty proud of the way that Interchange will mix-and-match
tables in the same installation. You can use LDAP for one of your
VariableDatabase tables to get centralized configuration, the internal
database for miscellaneous non-changing stuff, an Oracle database to
transmit orders to your ERP system, and MySQL for the fast product
display stuff. All in the same catalog.
--
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>
I don't buy from direct telephone or email marketers. This makes it
hard for me to find a phone company. ;>
--__--__--
_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users
End of Interchange-users Digest