[ic] Priceing
Ramana
ramana@myweb.com.my
Fri, 16 Mar 2001 12:26:54 +0800
Hi all,
I am posting this question 2nd time since my erlier qustion not yet been
answered,
My client bassically selles cakes and flowers, the bussiness rule in
this is priceing the items depending on the weight and units,
CAKES: for example 1 quantity of American Chocolate cake costs depending on
the weight like 1kg -- $10, 2kg -- $20 and so on....
FLOWER Bouquets: these costs like 1 quantity of XXX flower Bouquet costs
depending on the unit of flowers used in it ... like 1 dozen of flowers used
in it costs $10 , 1 1/2 dozen costs $15 and so on...
so, please help me out, how can sovlve this problem?
Thanks for any advise,
Peace--(^_^)
----- Original Message -----
From: <interchange-users-admin@lists.akopia.com>
To: <interchange-users@lists.akopia.com>
Sent: Friday, March 16, 2001 8:15 AM
Subject: Interchange-users digest, Vol 1 #364 - 15 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: Permissions question (dstotten@mediabang.com)
> 2. How to override existing [shipping] and [total-cost] tags ? (Guido
Sohne)
> 3. needed examples of subscription sites! (Michelle Wilant (home))
> 4. Problems on Xmission Solaris (Chris Bair)
> 5. Re: Problems on Xmission Solaris (Jason Kohles)
> 6. Re: Basket content (Bill Randle)
> 7. Re: Problems on Xmission Solaris (Chris Bair)
> 8. Re: Please wait while your request is processed (Bill Randle)
> 9. Re: Authorize.Net integration instructions (Bill Shupp)
> 10. Bug (and fix) for File::CounterFile and MS Windows (Bill Randle)
> 11. Re: Importing tables... (Greg Gaskill)
> 12. Re: needed examples of subscription sites! (Randy Moore)
> 13. Re: Please wait while your request is processed (Mark Johnson)
> 14. Re: Basket content (Mark Johnson)
> 15. Re: Basket content (Bill Randle)
>
> --__--__--
>
> Message: 1
> Date: Thu, 15 Mar 2001 12:26:34 -0700
> From: dave@davetotten.com
> To: interchange-users@lists.akopia.com
> Subject: Re: [ic] Permissions question
> Reply-To: dave@davetotten.com
> Reply-To: interchange-users@lists.akopia.com
>
> On Thu, Mar 15, 2001 at 11:46:39AM -0600, Steve Palm wrote:
> >
> > (still getting nowhere, trying again for help on this one....)
> >
> >
> > I am trying to set up a user who only has permission to view pending
orders and change their status.
> >
>
--------------------------------------------------------------------------
--
> > Order Manager:
> > View list, View single, Edit, Archive, Un-Archive (Not Delete,
InputNew)
> >
> > Orderline and Transactions permissions:
> > View, Edit, Delete, Export (Not Hide, Create, Import)
>
--------------------------------------------------------------------------
--
> >
> > When they try to change the global order status, it doesn't update, and
when they log-out they get this error:
> >
> > Failure: Unauthorized for key archived
> >
> >
> > Any ideas?
>
> If you can live with a user that can view any orders, but only is allowed
> to change the status (to shipped, backordered... etc.) then this might
help
> you.
>
> When editting the access table in the admin interface, there is a column
for
> table_control. As the name depicts, you can control your tables with this.
>
> What goes into this field is an anonymous hash that may look like this:
>
> {
> 'pricing' => {
> 'no_fields' => "price_group",
> },
> 'products' => {
> 'no_keys' => "weight nontaxable",
> 'yes_keys' => "00-0011 00-0011a 00-342 00-343
00-404",
> 'yes_fields' => "sku artist title description
comment",
> },
> }
>
> of course you will have to put it all in one line. I have just formatted
> this so it is easier to see.
>
> so in this field, you could put something like
>
> {
> 'orderline' => {
> 'yes_fields' => "status",
> },
> }
>
> and when going into select an item to order, they will be able to see most
> of the order information, but when they go to edit a specific order, all
> they will get a chance to edit is the status field.
>
> I know this isn't exactly what you wanted, but perhaps it is enough.
>
> Dave Totten
>
>
>
> > --
> > Steve Palm <stevep@sga.org> * SGA * Loves Park, IL *
> > http://www.sga.org
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
>
> --__--__--
>
> Message: 2
> Date: Thu, 15 Mar 2001 11:31:29 -0800 (PST)
> From: Guido Sohne <caught_one@yahoo.com>
> To: interchange-users@lists.akopia.com
> Cc: cfm@maine.com
> Subject: [ic] How to override existing [shipping] and [total-cost] tags ?
> Reply-To: interchange-users@lists.akopia.com
>
> I've created a UserTag called [deliverycharge] that iterates over the
> shopping cart and calculates a delivery charge.
>
> Now, how do I override the [shipping] and [total-cost] tags so that the
> figures are correct and minimal changes would be necessary to ITL code
> ?
>
> If I override the [shipping] tag (which I have not yet figured out how
> to do), will the [total-cost] value reflect the new logic for shipping
> ?
>
> I would be interested in finding out the various ways in which this can
> be done.
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great prices.
> http://auctions.yahoo.com/
>
> --__--__--
>
> Message: 3
> Reply-To: "Michelle Wilant \(home\)" <michelle@wilant.com>
> From: "Michelle Wilant \(home\)" <michelle@wilant.com>
> To: "ic list" <interchange-users@lists.akopia.com>
> Date: Thu, 15 Mar 2001 16:05:37 -0500
> charset="iso-8859-1"
> Subject: [ic] needed examples of subscription sites!
> Reply-To: interchange-users@lists.akopia.com
>
> I need to "prove" to co-workers that interchange can/does sell
subscriptions
> (unlike a gift certificate, a product without a click through to a
> download). I would love to have tons of examples to give them. Also, any
> "pointers" regarding set up for subscriptions vs. other products are
> appreciated. Thanks in advance!
>
>
> --__--__--
>
> Message: 4
> Date: Thu, 15 Mar 2001 14:22:43 -0700
> To: interchange-users@lists.akopia.com
> From: Chris Bair <chrisbair@tssphoto.com>
> Subject: [ic] Problems on Xmission Solaris
> Reply-To: interchange-users@lists.akopia.com
>
> Our current shopping cart system is very lacking so I'm trying to set
> up Interchange. But I can't even get through the demo "construct"
> store!
>
> I didn't get any errors during the installation, I started up
> interchange and when I try to go into the system I get that
> "Interchange not available" error. I've checked the FAQ's, RTFM'd,
> searched this list's archive and I still can't figure it out. I've
> switched from UNIX mode and back again, set the CGI to -rwsr-xr-x
> and the socket file to srw-rw-rw- but I still get nothing. I suppose
> I must be mission something horribly obvious.
>
> I was wondering if anyone out there has had experience setting up
> interchange on Solaris (if that matters any) and especially on
> Xmission's server or one of their virtual servers.
>
> --
> ---
> Sincerely,
>
> Chris Bair, Webmaster Inkjet Art Solutions
> chrisbair@tssphoto.com The Stock Solution
> Phone: 801-363-9700 Fax: 801-363-9707
> Order Online! <http://www.tssphoto.com/sp/dg/>
> Free consulting line: 801-363-9709
> Toll-free for orders: 800-777-2076
>
> --__--__--
>
> Message: 5
> Date: Thu, 15 Mar 2001 16:29:17 -0500
> From: Jason Kohles <email@jasonkohles.com>
> To: interchange-users@lists.akopia.com
> Subject: Re: [ic] Problems on Xmission Solaris
> Reply-To: interchange-users@lists.akopia.com
>
> On Thu, Mar 15, 2001 at 02:22:43PM -0700, Chris Bair wrote:
> >
> > I was wondering if anyone out there has had experience setting up
> > interchange on Solaris (if that matters any) and especially on
> > Xmission's server or one of their virtual servers.
> >
> Funny you should ask, as I used to be one of XMission's system
administrators,
> and just this week moved to Virginia to work for Red Hat as an Interchange
> developer.
>
> The problem is that the shell server where you are doing the installation
is
> not the same machine as the web server where your virtual host is located,
you
> will need to do one of the following things:
>
> * Convince XMission to install interchange systemwide on the web servers
and
> setup a catalog for you.
>
> * Arrange with XMission to get the interchange server running on the
webserver
> your virtual host is located on.
>
> * Use tlink and set it up to connect to the interchange server you are
running
> on the shell server.
>
> * Write a CGI script you can load through your web site which will run the
> interchange server on the same machine your virtual host is located on.
>
> --
> Jason S Kohles
> jason@jasonkohles.com
>
> --__--__--
>
> Message: 6
> Date: Thu, 15 Mar 2001 13:33:10 -0800
> From: Bill Randle <billr@exgate.tek.com>
> Organization: Tektronix, Inc., Beaverton, OR
> To: interchange-users@lists.akopia.com
> Subject: Re: [ic] Basket content
> Reply-To: interchange-users@lists.akopia.com
>
> "Barry Treahy, Jr." wrote:
> >
> > You could use javascript to auto-submit a form based on a timer, I've
had to do
> > this before but it gets problematic with IE and NS handling JS and forms
> > differently in the DOM.
> >
> > Barry
> >
> > Mark Johnson wrote:
> >
> > > Sergey Sheykin wrote:
> > > >
> > > > Mark,
> > > >
> > > > can I make this without <Form ...>,
> > > > without sending parameters through the form
> > > > and clickon submit button?
> > > >
> > >
> > > You have to somehow pass the information to IC to make the action
occur.
> > > There's simply no way around it. That is, the user has to take *some*
> > > action--whatever it is--and based on that action, you have to set up
the
> > > proper directives. So, when you say, "Can I make this happen without a
> > > form or sending parameters or clicking on the submit button," I'd have
> > > to say no.
> > >
> > > But, perhaps I don't understand what you're asking, so maybe describe
> > > what you want to do, under what situation, and what you want to have
the
> > > user do to trigger that action. Then, I can tell you what would work.
> > >
> > > > > -----Original Message-----
> > > > > From: interchange-users-admin@lists.akopia.com
> > > > > [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Mark
Johnson
> > > > > Sent: Wednesday, March 14, 2001 5:46 PM
> > > > > To: interchange-users@lists.akopia.com
> > > > > Subject: Re: [ic] Basket content
> > > > >
> > > > >
> > > > > Sergey Sheykin wrote:
> > > > > >
> > > > > > How can I manually erease shopping cart content?
> > > > >
> > > > > mv_action=cancel
> > > > >
> > >
> > > --
> > > Mark Johnson
> > > Senior Developer - Professional Services
> > > Red Hat, Inc.
> > > E-Business Solutions
> > > markj@redhat.com
> > > 703-456-2912
> > >
>
> > Barry Treahy, Jr * Midwest Microwave * Vice President & CIO
> >
> > E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028
>
> I may be missing something, but why not:
> [perl global=1]
> use Vend::Session;
> @$Vend::Items = ();
> put_session();
> get_session();
> init_session();
> [/perl]
>
> This is what "mv_cancel" does.
>
> -Bill
>
> --__--__--
>
> Message: 7
> <20010315162917.A21696@mediabang.com>
> Date: Thu, 15 Mar 2001 14:59:08 -0700
> To: interchange-users@lists.akopia.com
> From: Chris Bair <chrisbair@tssphoto.com>
> Subject: Re: [ic] Problems on Xmission Solaris
> Reply-To: interchange-users@lists.akopia.com
>
> >On Thu, Mar 15, 2001 at 02:22:43PM -0700, Chris Bair wrote:
> >>
> >> I was wondering if anyone out there has had experience setting up
> >> interchange on Solaris (if that matters any) and especially on
> >> Xmission's server or one of their virtual servers.
> >>
> >Funny you should ask, as I used to be one of XMission's system
administrators,
> >and just this week moved to Virginia to work for Red Hat as an
Interchange
> >developer.
> >
> >The problem is that the shell server where you are doing the installation
is
> >not the same machine as the web server where your virtual host is
located, you
> >will need to do one of the following things:
> >
> >* Convince XMission to install interchange systemwide on the web servers
and
> > setup a catalog for you.
> >
> >* Arrange with XMission to get the interchange server running on the
webserver
> > your virtual host is located on.
> >
> >* Use tlink and set it up to connect to the interchange server you are
running
> > on the shell server.
> >
> >* Write a CGI script you can load through your web site which will run
the
> > interchange server on the same machine your virtual host is located
on.
>
> Let's see... Is this the same Jason that carried the umbrella to hit
> cars that tried to run him down while crossing the street? (I used to
> work there too, you might remember, although I'm sure you tried to
> forget!)
>
> I doubt I could get them to do the first two (although they sound
> like the better alternatives) how might I go about doing the last
> two? I tried setting up the catalog to use INET, rather than UNIX,
> but given my inexperience with Interchange, it still gave me that
> "unavailable" message.
> --
> ---
> Sincerely,
>
> Chris Bair, Webmaster Inkjet Art Solutions
> chrisbair@tssphoto.com The Stock Solution
> Phone: 801-363-9700 Fax: 801-363-9707
> Order Online! <http://www.tssphoto.com/sp/dg/>
> Free consulting line: 801-363-9709
> Toll-free for orders: 800-777-2076
>
> --__--__--
>
> Message: 8
> Date: Thu, 15 Mar 2001 13:59:21 -0800
> From: Bill Randle <billr@exgate.tek.com>
> Organization: Tektronix, Inc., Beaverton, OR
> To: interchange-users@lists.akopia.com
> Subject: Re: [ic] Please wait while your request is processed
> Reply-To: interchange-users@lists.akopia.com
>
> Mark Johnson wrote:
> >
> > cfm@maine.com wrote:
> > >
> > > On Wed, Mar 14, 2001 at 09:15:16PM -0800, Dan B wrote:
> > > > I have a metric ton of IML code that I would like to process in a
visually
> > > > aesthetic way. How do I write a page so that it goes something like
this:
> > > >
> > > > Please wait while your request is processed...
> > > >
> > > > -->(tons of code that takes 5+ seconds to complete goes here)<--
> > > >
> > > > ...Done. Thank you for your patience, you will now be forwarded to
...
> > > >
> > > > [bounce ...]
> > >
> >
> > All the IC processing will occur before the buffer is returned to vlink
> > (though it seems there's some way to force a flush that I can't
> > remember). However, you can always use good ol' html to solve your
> > problem, with a little restructuring of your messaging system.
>
> Are you thinking about $Document->send() and/or $Document->hot(1)?
>
> > We thank you for your patience while your request is processed...
> > <meta http-equiv="refresh" content="0;url=[area bouncepage]">
> >
> > Put the 5 seconds of code in 'bouncepage' along with whatever info you
> > were planning on having on the page that you previously were
> > [bounce]'ing to.
> >
> > --
> > Mark Johnson
> > Senior Developer - Professional Services
> > Red Hat, Inc.
> > E-Business Solutions
> > markj@redhat.com
> > 703-456-2912
>
> Another possibility, perhaps (untested):
> <HTML>
> <HEAD></HEAD>
> <BODY>
> <other tags you may want to use>
> [mvasp]
> <%
> HTML "This will take awhile, please be patient...";
> $Document->send(); # flush buffer
> $Document->hot(1); # send stuff as soon as it's written
>
> # some perl task that takes awhile
> # if there are some points in the process you can update the
> # user status, so much the better. E.g.:
> # foreach (@some_array) {
> # HTML " ."; # show another period as a progress indicator
> # some code that processes each item
> # }
>
> HTML "<br>All done, thank you for waiting.";
> %>
> [/mvasp]
> </BODY>
> </HTML>
>
> -Bill
>
> --__--__--
>
> Message: 9
> Date: Thu, 15 Mar 2001 16:34:42 -0600
> Subject: Re: [ic] Authorize.Net integration instructions
> From: Bill Shupp <hostmaster@shupp.org>
> To: Jud Harris <jud-lists@copernica.com>
> CC: <interchange-users@lists.akopia.com>
> Reply-To: interchange-users@lists.akopia.com
>
> on 3/14/01 3:35 PM, Jud Harris at jud-lists@copernica.com wrote:
>
> > Hey folks -
> >
> > Here's how to get authorize.net processing into Interchange. Please
note that
> > my understanding of the ins and outs of IC is limited, I just know our
store
> > is
> > working well so far with authorize.net. This should work out-of-the-box
with
> > the included demo construct store. We're using a slightly modified
> > pages/ord/checkout.html page for orders, but none of the processing
variables
> > were changed.
> >
> > First off...
> >
> > With the newer version(s) of IC, an authorizenet module is included in
the
> > [src/interchange]/eg/globalsub/authorizenet
> >
> > *copy this* file to your installed ../interchange/globalsub directory -
> >
> > NOTE: don't attempt to perl -d the file or run it to check its
functionality,
> > as
> > it is made to be embedded into interchange when it starts. If you make
> > modifications to it, remove everything except the section beginning with
"sub
> > authorizenet .. {" and ending with "}"
> >
> > After copying the file, take a look at it. It should tell you to add
the
> > following lines to your catalog's catalog.cfg file:
> >
> > Variable MV_PAYMENT_ID [YourAuthorizeNetID]
> > Variable MV_PAYMENT_SECRET [YourAuthorizeNetPassword]
> > Variable MV_PAYMENT_MODE custom authorizenet
> > Variable MV_PAYMENT_REFERER
> > [http://www.yourstore.com/cgi-bin/yourICbinary.cgi/process.html]
> >
> > Restart the interchange server - note: you won't see any textual
notification
> > that the authorizenet module is successfully included, but if there's an
error
> > in the file, it will report it.
> >
> > **NOTE: Be sure your authorize.net account is in TEST MODE before
running any
> > transactions, or at least be ready to void transactions and incur
transaction
> > fees.
> >
> > Now you *should* be able to order an item using a valid credit card.
You'll
> > notice that authorize.net won't notice any of your test transactions in
its
> > Transactions section, so there's no way for you to know if the customer
data
> > (other than the credit card num and expiration) are being transmitted
> > successfully.
> >
> > In fact, by default, they aren't. You'll notice the authorizenet module
only
> > processes a minimum amount of information with each transcation. For
> > instance,
> > if an order has different billing and shipping addresses, the billing
first
> > name
> > and last name, address, city, state, zip, etc, .. are transmitted to
> > authorize.net as the shipping information as well. You'll also probably
> > notice
> > that all other fields except first name, last name, city, state, and zip
are
> > NOT
> > transmitted to authorize.net. This is because the variable names in the
> > authorizenet module do not correspond to the variable names in the
> > checkout.html
> > file. You can easily adjust the code to account for other variable
names.
> > Refer to the Appendix B of the developer section of the authorize.net
> > interface
> > for a mapping of their field names (such as x_Ship_To_First_Name).
> >
> > Here's some code from my slightly modified authorizenet file. Now my
> > transactions are logging the correct address data, but I still can't get
the
> > phone or email to appear at all. (Anyone have clues?)
> >
> > ---
> >
> > # if the billing section of checkout.html appears to be blank,
> > # copy the customer shipping info to the billing vars
> >
> > if (($actual{b_address1} eq "") ||
> > ($actual{b_zip} eq "")) {
> >
> > $actual{b_fname} = $actual{fname};
> > $actual{b_lname} = $actual{lname};
> > $actual{b_company} = $actual{company};
> > $actual{b_address1} = $actual{address1};
> > $actual{b_address2} = $actual{address2};
> > $actual{b_city} = $actual{city};
> > $actual{b_state} = $actual{state};
> > $actual{b_zip} = $actual{zip};
> > $actual{b_country} = $actual{country};
> > }
> >
> >
> > # concatenate the two addresses into one if a second address line exists
> >
> > if ($actual{address2} ne "") {
> > $actual{address} = "$actual{address1}" . ", " . "$actual{address2}";
> > } else {
> > $actual{address} = $actual{address1};
> > }
> >
> > if ($actual{b_address2} ne "") {
> > $actual{b_address} = "$actual{b_address1}" . ", " .
> > "$actual{b_address2}";
> > } else {
> > $actual{b_address} = $actual{b_address1};
> > }
> >
> >
> > my %query = (
> > x_Method => 'CC',
> > x_Type => $actual{mv_payment_mode},
> > x_Card_Num => $actual{mv_credit_card_number},
> > x_Exp_Date => $exp,
> > x_Amount => $amount,
> > x_First_Name => $actual{b_fname},
> > x_Last_Name => $actual{b_lname},
> > x_Company => $actual{company},
> > x_Address => $actual{b_address},
> > x_City => $actual{b_city},
> > x_State => $actual{b_state},
> > x_Zip => $actual{b_zip},
> > x_Country => $actual{b_country},
> > x_Ship_To_First_Name => $actual{fname},
> > x_Ship_To_Last_Name => $actual{lname},
> > x_Ship_To_Company => $actual{company},
> > x_Ship_To_Address => $actual{address},
> > x_Ship_To_City => $actual{city},
> > x_Ship_To_State => $actual{state},
> > x_Ship_To_Zip => $actual{zip},
> > x_Ship_To_Country => $actual{country},
> > x_Email => $actual{email},
> > x_Invoice_Num => $actual{mv_order_number},
> > x_Phone => $actual{phone_day},
> > x_Password => $secret,
> > x_Login => $user,
> > x_Version => '3.0',
> > x_ADC_URL => 'FALSE',
> > x_ADC_Delim_Data => 'TRUE',
> > );
> >
> > ---
> >
> > So... give the default code a try first and let me know how it goes. I
really
> > sympathize with authorize.net folks because of the lack of documentation
and
> > scattered mailing list archive contents.
> >
> > Good luck!
> > -Jud
>
>
> Judd,
>
> Thanks so much for your post. I will be able to try this out later this
> weekend and will let you know how it goes.
>
> Thanks again!
>
> -Bill Shupp
>
>
> --__--__--
>
> Message: 10
> Date: Thu, 15 Mar 2001 14:37:36 -0800
> From: Bill Randle <billr@exgate.tek.com>
> Organization: Tektronix, Inc., Beaverton, OR
> To: interchange-users@lists.akopia.com
> Subject: [ic] Bug (and fix) for File::CounterFile and MS Windows
> Reply-To: interchange-users@lists.akopia.com
>
> As part of getting a site running under Windows I ran into a problem where
> the File::CounterFile messed up when it was given a DOS style directory
path.
> For example, lets say you set SratchDir to "C:\Minivend\tmp"; what will
> happen is that File::CounterFile will try to create the file (e.g.)
> "/usr/tmp/C:\Minivend\tmp/addr_ctr/1/2/127_0_0_1" - which needless to say
> does not work too well.
>
> The problem is that File::CounterFile does not recognize the "C:/" as
> specifying an absolute pathname. The fix shown below replaces the existing
> file name test with the test used in Vend::Util.
>
> This problem is in the version of CounterFile.pm shipped with Minivend
4.04
> and Interchange 4.6.3.
>
> -Bill
>
> --- CounterFile.pm.orig Sat May 6 08:27:40 2000
> +++ CounterFile.pm Tue Mar 13 15:54:15 2001
> @@ -101,13 +101,21 @@
> fallback => 1,
> );
>
> +# File test taken from Vend::Util and tweaked to check for relative
paths, too
> +
> +my $abs_rel_pat = $^O =~ /win32/i ? '^([a-z]:)?[\\\\/\.]' : '^[/\.]';
> +
> +sub fname_is_absolute_or_relative {
> + my($file) = @_;
> + $file =~ m{$abs_rel_pat}oi ;
> +}
>
> sub new
> {
> my($class, $file, $initial) = @_;
> croak "No file specified\n" unless defined $file;
>
> - $file = "$DEFAULT_DIR/$file" unless $file =~ /^[\.\/]/;
> + $file = "$DEFAULT_DIR/$file" unless
fname_is_absolute_or_relative($file);
> $initial = $DEFAULT_INITIAL unless defined $initial;
>
> my $value;
>
> --__--__--
>
> Message: 11
> From: "Greg Gaskill" <g.gaskill@aboron.com>
> To: <interchange-users@lists.akopia.com>
> Subject: Re: [ic] Importing tables...
> Date: Thu, 15 Mar 2001 17:55:29 -0500
> charset="iso-8859-1"
> Reply-To: interchange-users@lists.akopia.com
>
>
> ----- Original Message -----
> From: "Dan McFarland" <dan@mailturtle.com>
> To: <interchange-users@lists.akopia.com>
> Sent: Thursday, March 15, 2001 1:15 PM
> Subject: [ic] Importing tables...
>
>
> > I am using the Construct template with the default databases. With that
> in
> > mind, I am trying to import to the products table a new list of items
with
> > the fields sku, description and price. Then I will go back and manually
> > edit those items to add quantity discounts, images, etc.
> >
> > When I try to import this data from a tab-delimited txt file, I get a
> FATAL
> > ERROR - Non-existent table 'sku description price
> > '
>
> Dan,
>
> What I did the first time I imported a database to the construct demo was:
>
> 1) Delete all products from the construct database, except the gift_cert
> using the UI.
>
> 2) Export the products database to my computer (just one line with field
> names and one item line to model after).
>
> 3) Open this exported version in Excel and cut and paste the sku,
> description, and price from my old system (also an exported text listing)
> leaving the unused columns blank.
>
> 4) Save the new text file and import that using the construct UI.
>
> Greg
>
>
> >
> > What would be causing this error?
> >
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
>
>
> --__--__--
>
> Message: 12
> Date: Thu, 15 Mar 2001 18:01:42 -0500
> To: interchange-users@lists.akopia.com
> From: Randy Moore <ramoore@axion-it.net>
> Subject: Re: [ic] needed examples of subscription sites!
> Reply-To: interchange-users@lists.akopia.com
>
> One of the stores we created uses subscriptions. Really it is a "buyers
> club" type of store. If you buy a membership (subscription), you can buy
> the rest of the products on the site at a discount.
>
> This store allows both member and non-member purchases at different
prices.
>
> The URL is:
> http://www.cigarsatcost.com
>
> This is not something you can do directly with the sample stores that come
> with Interchange, but Interchange is flexible enough to do just about
> anything you can imagine.
>
>
> At 04:05 PM 3/15/01 -0500, you wrote:
> >I need to "prove" to co-workers that interchange can/does sell
subscriptions
> >(unlike a gift certificate, a product without a click through to a
> >download). I would love to have tons of examples to give them. Also,
any
> >"pointers" regarding set up for subscriptions vs. other products are
> >appreciated. Thanks in advance!
> >
> >
> >_______________________________________________
> >Interchange-users mailing list
> >Interchange-users@lists.akopia.com
> >http://lists.akopia.com/mailman/listinfo/interchange-users
>
> Randy Moore
> Axion Information Technologies, Inc.
>
> email ramoore@axion-it.net
> phone 301-408-1200
> fax 301-445-3947
>
>
> --__--__--
>
> Message: 13
> Date: Thu, 15 Mar 2001 18:25:46 -0500
> From: Mark Johnson <markj@redhat.com>
> Organization: Red Hat E-Business Solutions
> To: interchange-users@lists.akopia.com
> Subject: Re: [ic] Please wait while your request is processed
> Reply-To: interchange-users@lists.akopia.com
>
> Bill Randle wrote:
>
> > Are you thinking about $Document->send() and/or $Document->hot(1)?
>
> That may be their intended purpose, but they don't work in that way. You
> can try below with a while loop that goes 10000000 times, which takes
> about 5 secs (on my server).
>
>
> >
> > Another possibility, perhaps (untested):
> > <HTML>
> > <HEAD></HEAD>
> > <BODY>
> > <other tags you may want to use>
> > [mvasp]
> > <%
> > HTML "This will take awhile, please be patient...";
> > $Document->send(); # flush buffer
> > $Document->hot(1); # send stuff as soon as it's written
> >
> > # some perl task that takes awhile
> > # if there are some points in the process you can update the
> > # user status, so much the better. E.g.:
> > # foreach (@some_array) {
> > # HTML " ."; # show another period as a progress indicator
> > # some code that processes each item
> > # }
> >
> > HTML "<br>All done, thank you for waiting.";
> > %>
> > [/mvasp]
> > </BODY>
> > </HTML>
> >
> > -Bill
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
>
> --
> Mark Johnson
> Senior Developer - Professional Services
> Red Hat, Inc.
> E-Business Solutions
> markj@redhat.com
> 703-456-2912
>
> --__--__--
>
> Message: 14
> Date: Thu, 15 Mar 2001 18:46:41 -0500
> From: Mark Johnson <markj@redhat.com>
> Organization: Red Hat E-Business Solutions
> To: interchange-users@lists.akopia.com
> Subject: Re: [ic] Basket content
> Reply-To: interchange-users@lists.akopia.com
>
> Bill Randle wrote:
> >
> > I may be missing something, but why not:
> > [perl global=1]
> > use Vend::Session;
> > @$Vend::Items = ();
> > put_session();
> > get_session();
> > init_session();
> > [/perl]
> >
> > This is what "mv_cancel" does.
> >
> > -Bill
>
> That certainly works. Putting mv_action=cancel in your query string
> seems easier to me. Just a matter of calling code that exists over
> re-writing and reparsing it.
>
> --
> Mark Johnson
> Senior Developer - Professional Services
> Red Hat, Inc.
> E-Business Solutions
> markj@redhat.com
> 703-456-2912
>
> --__--__--
>
> Message: 15
> Date: Thu, 15 Mar 2001 16:14:44 -0800
> From: Bill Randle <billr@exgate.tek.com>
> Organization: Tektronix, Inc., Beaverton, OR
> To: interchange-users@lists.akopia.com
> Subject: Re: [ic] Basket content
> Reply-To: interchange-users@lists.akopia.com
>
> Mark Johnson wrote:
> >
> > Bill Randle wrote:
> > >
> > > I may be missing something, but why not:
> > > [perl global=1]
> > > use Vend::Session;
> > > @$Vend::Items = ();
> > > put_session();
> > > get_session();
> > > init_session();
> > > [/perl]
> > >
> > > This is what "mv_cancel" does.
> > >
> > > -Bill
> >
> > That certainly works. Putting mv_action=cancel in your query string
> > seems easier to me. Just a matter of calling code that exists over
> > re-writing and reparsing it.
>
> For sure! I was under the impression that the requestor wanted to clear
> the cart without doing a form submission, like perhaps he had some
> other inline Perl code that did some checks and under some condition
> wanted to clear the cart without doing a seperate submit. On the
> otherhand, one could argue that the way to do that is via a mv_click
> routine that changes the mv_action from "submit" to "cancel" when the
> cart needs to be cleared. We don't really know enough about his
> requirements to say.
>
> -Bill
>
>
>
> --__--__--
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>
>
> End of Interchange-users Digest
>