[ic] Empty Order Manager and Databases after correct Checkout

Paulo Moniz interchange-users@lists.akopia.com
Thu May 24 17:26:01 2001


Hi All

My VS does not save transactions in the transactions.txt or orderline.txt
databases. When I go to the Order Manager in the Back-Office no Order
appears. However the e-mail receipt is sent. I have the following relevant
lines in catalog.cfg and checkout.html.

Thank You in advance
Paul
Inteliware.net - Lisbon Portugal

Catalog.cfg
*********************************************************
Database            locale          locale.txt        TAB
Database            2ndDayAir       2ndDayAir.csv     CSV
Database            Ground          Ground.csv        CSV
Database            NextDayAir      NextDayAir.csv    CSV
AsciiTrack          logs/tracking.asc
Onfly			  onfly
OrderCounter        etc/order.number
OrderLineLimit      25
RouteDatabase       route
SpecialPage         report         ../etc/report
UpsZoneFile         products/450.csv

Database            country      country.txt       TAB

Database	mv_shipping	shipping.asc	TAB

Database	products	products.txt	TAB

Database	userdb		userdb.txt	TAB

Database	access		access.asc	TAB

Database	mv_metadata     mv_metadata.asc	TAB

Database	orderline	orderline.txt	TAB

Database	transactions	transactions.txt	TAB

Database            variable        variable.txt      TAB

ProductFiles	products

VariableDatabase variable

# E-Mail que recebera as encomendas
MailOrderTo	interchange@192.168.48.3

SpecialPage	order		basket

SpecialPage	flypage		flypage

SpecialPage	checkout	checkout

SpecialPage	receipt		receipt

SpecialPage	catalog		index

OrderProfile	etc/profiles.order etc/profiles.login etc/profiles.misc

SpecialPage          search         results

Locale          pt_PT

#Locale		pt_PT currency_symbol	PTE

#Locale		pt_PT p_cs_precedes	0

#Locale		pt_PT mon_thousands_sep	.

#Locale		pt_PT mon_decimal_point	.

Variable	CONTACT_EMAIL	bleuline@mail.pt
Variable	DISPLAYDATE	[tag time]%R  %A, %d de %B de %Y[/tag]
Variable	TOP		[include config/top]
Variable	LEFT	[include config/left]
Variable	BOTTOM	[include config/bottom]
Variable	MENUBAR [include config/menubar]

DescriptionField	descricaoproduto


checkout.html
*********************************************************
__TOP__
__MENUBAR__
__LEFT__

<b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Encomenda</font></b>
<hr>

      <table width="494" cellspacing="0" cellpadding="0" height="274">
      <tr>
          <!-- Coluna de espaco -->
          <td width="12" height="274"></td>

          <td valign="top">


		  [if session failure]
		  <font face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="#ff0033"><b>[data session failure]</b><br><br></font>
		  [data base=session field=failure value=""]
	  	  [/if]

		  [if session ship_message]
		  <font face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="#ff0033"><b>[data session ship_message] [data session
failure]</b><br><br></font>
  		  [data base=session field=ship_message value=""]
  		  [data base=session field=failure value=""]
		  [/if]

<form method=post action="[process-target]">
<input type=hidden name=mv_todo value=submit>
<input type=hidden name=mv_order_profile value=order_profile>
<input type=hidden name=mv_cyber_mode value=minivend_test>

	<!-- 	  <INPUT TYPE=hidden NAME=mv_order_route   VALUE=""> -->
	<INPUT TYPE=hidden NAME=mv_order_route   VALUE="log main copy_user">

		  <INPUT type=hidden NAME=mv_username VALUE="[value mv_username]">

          <font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Empresa:</b><br>
	      <input type="text" name="company" size="10" value="[value
company]"><br><br></font>
          <font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Nome:</b><br>
		  <input type="text" name="fname" size="10" value="[value
fname]"><br><br></font>
          <font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Apelido:<br></b>
		  <input type="text" name="lname" size="10" value="[value
lname]"><br><br></font>
		  <font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Endereco:<br></b>
		  <input type="text" name="address1" size="10" value="[value
address1]"><br><br></font>
		  <font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Localidade:<br></b>
		  <input type="text" name="city" size="10" value="[value
city]"><br><br></font>
		  <font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Código
Postal:<br></b>
		  <input type="text" name="zip" size="10" value="[value
zip]"><br><br></font>
		  <font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>País:<br></b>
		  <input type="text" name="country" size="10" value="[value
country]"><br><br></font>
		  <font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Contribuinte:<br></b>
		  <input type="text" name="contribuinte" size="10" value="[value
contribuinte]"><br><br></font>

   		  <input type=hidden name=mv_check value="Save_database">
		  [set Save_database]
		  [userdb save]
		  [tag export userdb][/tag]
		  [/set] -->

    <SELECT onChange="this.form.submit()" NAME=mv_shipmode>
    [shipping
		label=1
		mode=|[data table=country key='[default country US]' sf=selector
col=shipmodes]|
		]
    </SELECT>


  		  <font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Numero
Cartao de Credito:<br></b>
 		  <input type=text name=mv_credit_card_number value=""
size=20><br><br></font>
   		  <font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Validade:<br></b>
          <select name=mv_credit_card_exp_month>
			[loop
				lr=1
				option=mv_credit_card_exp_month
				list="
1	Janeiro
2	Fevereiro
3	Marco
4	Abril
5	Maio
6	Junho
7	Julho
8	Agosto
9	Setembro
10	Outubro
11	Novembro
12	Dezembro"]
			<option value="[loop-code]">[loop-pos 1]
			[/loop]
			</select>
			<select name=mv_credit_card_exp_year>
			[comment]
				This should always return the current year as the first, then
				7 more years.
			[/comment]
			[loop option=mv_credit_card_exp_year lr=1 list=`
				my $year = $Tag->time( '', { format => '%Y' }, '%Y' );
				my $out = '';
				for ($year .. $year + 7) {
					/\d\d(\d\d)/;
					$last_two = $1;
					$out .= "$last_two\t$_\n";
				}
				return $out;
			`]
			<option value="[loop-code]"> [loop-pos 1]
			[/loop]
			</select>
      	  <br>
  		  <hr>


		<INPUT TYPE=radio NAME=email_copy [checked name=email_copy value=1
default=1] VALUE="1">Yes
		<INPUT TYPE=radio NAME=email_copy [checked name=email_copy value=0]
VALUE="0">No
		<INPUT TYPE=radio NAME=mail_list [checked mail_list 1] VALUE="1">Yes
		<INPUT TYPE=radio NAME=mail_list [checked name=mail_list value=0
default=1] VALUE="0">No

[if items]
<TABLE WIDTH=450>
<TR><TD COLSPAN=4 __HEADERBG__>
	<FONT SIZE="+2" COLOR="__HEADERTEXT__">Review order details</FONT>
	</TD>
</TR>
[item-list]
<TR>
	<TD VALIGN=TOP MARGINWIDTH=12 MARGINHEIGHT=12>
	<FONT SIZE="-2"><INPUT TYPE=checkbox NAME="[quantity-name]"
                        VALUE=0 onClick="this.form.submit()"> remove</FONT>
	<INPUT TYPE=hidden NAME="[quantity-name]" value="[item-quantity]">
	</TD>
	<TD VALIGN=TOP MARGINWIDTH=12 MARGINHEIGHT=12>
	[item-description]</A>
	</TD>
	<TD VALIGN=TOP>[item-quantity] @ [item-price]</TD>
	<TD VALIGN=TOP ALIGN=RIGHT>[item-subtotal]</TD>
</TR>
[/item-list]
<TR>
	<TD COLSPAN=2><A HREF="[area basket]">Back to cart</A><BR></TD>
	<TD>Subtotal</TD>
	<TD ALIGN=RIGHT>[subtotal]</TD>
</TR>
<TR>
	<TD COLSPAN=2></TD>
	<TD>Sales Tax</TD>
	<TD ALIGN=RIGHT>[salestax]</TD>
</TR>
<TR>
	<TD COLSPAN=2></TD>
	<TD>Shipping</TD>
	<TD ALIGN=RIGHT>[shipping]</TD>
</TR>
<TR>
	<TD COLSPAN=2></TD>
	<TD>TOTAL</TD>
	<TD ALIGN=RIGHT>[total-cost]</TD>
</TR>
</TABLE>
[/if]

<input type=submit name=submit value="Finalize!">
		  </form>
</td>
</tr>

</table>

__BOTTOM__



Paulo Moniz                 Inteliware.net
Phone	: +351.21.4527104/5   Av. São Miguel
Fax	: +351.21.4527106     Lote 80, Escritório 71
paulo.moniz@@inteliware.net São Miguel das Encostas
www.inteliware.net          2775-751 Carcavelos