date:20070104

[Axapta-Knowledge-Village] Extra User Info

2007-01-04 Thread Andrew Bartley

I would like to display more user information in the Administration - 
Users table. The form is SysUserInfo, it uses the tables (well deta 
sources) UserInfo and SysUserInfo. There is a table SysUserInfo, but i 
cant find a physical table UserInfo. I was thinking of making a new 
table and linking it in. I would like to put a few columns 
like Status, Manager, Dept etc. 

any idea's on how I should procede? Should I just alter one of the 
existing tables to add the fields or is it safer to create a new table?

[Axapta-Knowledge-Village] Item Master Record

2007-01-04 Thread faiqa.khushi

Hi everyone,

I am trying to import inventory master record in Inventory Management module
using InvenTable. It imports record successfully but don't  show records in
Item form.

Can anyone please guide if I have missed something?

Regards.

 

 



[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] How to terminate a session in AOS?

2007-01-04 Thread mkd_programmer

Hi,
I have a class (batch) to find out who loged in twice in AOS and after :
session = new xSession(sesId);
session.terminate();
I run that batch through COM+ (Navision Axapta Business Connector). 
batch process can find that session and terminate() runs, but session 
is still alive.
If I run batch in any AOS client, it'll work but doesn't work through 
COM+.
Any idea?
thanks advance.
MASSOUD

Re: [Axapta-Knowledge-Village] How can we Connect PHP software to Axapta ,Is it Possible through business connector?

2007-01-04 Thread [EMAIL PROTECTED]

Example COM with phpAccountNum  Name  Address  Phone  Fax  Dear All,
   
  I wrote below code in PHP,i got this error ,anybody how can i solve this 
error.
   
   
  Fatal error: Cannot instantiate non-existent class: com in 
/var/www/html/demos/traniee/phpCOMExample.php on line 30 
Regards,  Shaburuddin. 

Luis Martinez [EMAIL PROTECTED] wrote:  An example, retrieving 
customer information code.

Observation: in my last post , I said to yours that had problems with com
connector... peculiarly with php does not appear to me any error (Apache +
php)... but with IIS (Internet Information Server) yes,
any Idea about it ?

greetings.

***
html
head
style type=text/css
.encabezado {
font-size:9px;font-family:'Arial,Verdana';background-color:#c0c0c0;font-weight:bold
}
.sombra {
font-size:10px;font-family:'Arial,Verdana';background-color:#cc;font-weight:bold
}
.sinsombra {
font-size:10px;font-family:'Arial,Verdana';background-color:#ff;font-weight:bold
}
/style
titleAxapta Internet Connector - PHP Sample/title
/head
body
center
table style=border:1px solid #00 CELLSPACING=1 CELLPADDING=0
WIDTH=600
trtd colspan=5 align=center class=EncabezadoExample COM with
php/td/tr
tr
td WIDTH=20% class=encabezadoAccountNum/td
td WIDTH=25% class=encabezadoName/td
td WIDTH=25% class=encabezadoAddress/td
td WIDTH=15% class=encabezadoPhone/td
td WIDTH=15% class=encabezadoFax/td
/tr
?php
$Axapta = new COM(AxaptaComConnector.Axapta);
$Axapta-Logon(Admin,,,c:\fortaAOS.axc);
$CustTable = 77;
$CustTable_Name = 2;
$AxaptaQuery = $Axapta-CreateObject(Query);
$AxaptaDataSource = $AxaptaQuery-Call(AddDataSource, $CustTable);
$AxaptaRange = $AxaptaDataSource-Call(AddRange, $CustTable_Name);
$AxaptaQueryRun = $Axapta-CreateObject(QueryRun, $AxaptaQuery);

$result = $AxaptaQueryRun-Call(Next);
$si = 1;
while ($result) {
$CustTableBuffer = $AxaptaQueryRun-Call(GetNo, 1);
$AccountNumber = $CustTableBuffer-Field(AccountNum);
$Name = $CustTableBuffer-Field(Name);
$Address = $CustTableBuffer-Field(Address);
$Phone = $CustTableBuffer-Field(Phone);
$Fax = $CustTableBuffer-Field(Telefax);
if($si) { echo TR class='sinsombra'; $si = 0; } else { echo TR
class='sombra'; $si = 1; }
echo TD WIDTH='25%'
VALIGN='TOP'.mysql_real_escape_string($AccountNumber)./TD;
echo TD WIDTH='55%'
VALIGN='TOP'.mysql_real_escape_string($Name)./TD;
echo TD WIDTH='55%'
VALIGN='TOP'.mysql_real_escape_string($Address)./TD;
echo TD WIDTH='10%'
VALIGN='TOP'.mysql_real_escape_string($Phone)./TD;
echo TD WIDTH='10%'
VALIGN='TOP'.mysql_real_escape_string($Fax)./TD/TR\n;
$result = $AxaptaQueryRun-Call(Next);
}
$Axapta-Logoff();
unset($Axapta);
?
/table
/center
/body
/html

***

On 1/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:

 Dear all,
 I can connect .NET to Axapta using Business connector(Using IAxapta...
 Interfaces ).
 I have one functionality in which we need to connect PHP software to
 Axapta using Business connector ,Is it possible ,if possible how can I
 connect PHP to Axapta Using Axapta Business connector..
 If possible plz send some sample codes ,why because i am new to PHP
 software.
 Any kind of help will be highly appreciated.

 Regards,
 Shaburuddin | Technical Consultant | Hyd | India | +91-09885776135.


 __
 Do You Yahoo!?
 Tired of spam? Yahoo! Mail has the best spam protection around
 http://mail.yahoo.com

 [Non-text portions of this message have been removed]

 


-- 
Lic. Luis Enrique Martínez Peña
Analista Programador Axapta
Consultor Sistemas Web
Off. (81) 8335 0620 ext 8564
http://www.it-soluciones.com.mx

[Non-text portions of this message have been removed]



 

 __
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Item Master Record

2007-01-04 Thread Harry Deshpande

Hi

Please search the previous posts, this has already been discussed multiple 
times*s*

Regards

Harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of [EMAIL PROTECTED]
Sent: 04 January 2007 06:22
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Item Master Record


Hi everyone,

I am trying to import inventory master record in Inventory Management module
using InvenTable. It imports record successfully but don't show records in
Item form.

Can anyone please guide if I have missed something?

Regards.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

AW: [Axapta-Knowledge-Village] How can we Connect PHP software to Axapta ,Is it Possible through business connector?

2007-01-04 Thread Andreas Rudischhauser

 

http://www.php-center.de/de-html-manual/faq.com.html

 




Von: Axapta-Knowledge-Village@yahoogroups.com im Auftrag von [EMAIL PROTECTED]
Gesendet: Do 04.01.2007 05:54
An: Axapta-Knowledge-Village@yahoogroups.com
Betreff: Re: [Axapta-Knowledge-Village] How can we Connect PHP software to 
Axapta ,Is it Possible through business connector?



Example COM with php AccountNum Name Address Phone Fax Dear All,

I wrote below code in PHP,i got this error ,anybody how can i solve this error.


Fatal error: Cannot instantiate non-existent class: com in 
/var/www/html/demos/traniee/phpCOMExample.php on line 30 
Regards, Shaburuddin. 

Luis Martinez [EMAIL PROTECTED] mailto:enriquemtz%40gmail.com  wrote: An 
example, retrieving customer information code.

Observation: in my last post , I said to yours that had problems with com
connector... peculiarly with php does not appear to me any error (Apache +
php)... but with IIS (Internet Information Server) yes,
any Idea about it ?

greetings.

***
html
head
style type=text/css
.encabezado {
font-size:9px;font-family:'Arial,Verdana';background-color:#c0c0c0;font-weight:bold
}
.sombra {
font-size:10px;font-family:'Arial,Verdana';background-color:#cc;font-weight:bold
}
.sinsombra {
font-size:10px;font-family:'Arial,Verdana';background-color:#ff;font-weight:bold
}
/style
titleAxapta Internet Connector - PHP Sample/title
/head
body
center
table style=border:1px solid #00 CELLSPACING=1 CELLPADDING=0
WIDTH=600
trtd colspan=5 align=center class=EncabezadoExample COM with
php/td/tr
tr
td WIDTH=20% class=encabezadoAccountNum/td
td WIDTH=25% class=encabezadoName/td
td WIDTH=25% class=encabezadoAddress/td
td WIDTH=15% class=encabezadoPhone/td
td WIDTH=15% class=encabezadoFax/td
/tr
?php
$Axapta = new COM(AxaptaComConnector.Axapta);
$Axapta-Logon(Admin,,,c:\fortaAOS.axc);
$CustTable = 77;
$CustTable_Name = 2;
$AxaptaQuery = $Axapta-CreateObject(Query);
$AxaptaDataSource = $AxaptaQuery-Call(AddDataSource, $CustTable);
$AxaptaRange = $AxaptaDataSource-Call(AddRange, $CustTable_Name);
$AxaptaQueryRun = $Axapta-CreateObject(QueryRun, $AxaptaQuery);

$result = $AxaptaQueryRun-Call(Next);
$si = 1;
while ($result) {
$CustTableBuffer = $AxaptaQueryRun-Call(GetNo, 1);
$AccountNumber = $CustTableBuffer-Field(AccountNum);
$Name = $CustTableBuffer-Field(Name);
$Address = $CustTableBuffer-Field(Address);
$Phone = $CustTableBuffer-Field(Phone);
$Fax = $CustTableBuffer-Field(Telefax);
if($si) { echo TR class='sinsombra'; $si = 0; } else { echo TR
class='sombra'; $si = 1; }
echo TD WIDTH='25%'
VALIGN='TOP'.mysql_real_escape_string($AccountNumber)./TD;
echo TD WIDTH='55%'
VALIGN='TOP'.mysql_real_escape_string($Name)./TD;
echo TD WIDTH='55%'
VALIGN='TOP'.mysql_real_escape_string($Address)./TD;
echo TD WIDTH='10%'
VALIGN='TOP'.mysql_real_escape_string($Phone)./TD;
echo TD WIDTH='10%'
VALIGN='TOP'.mysql_real_escape_string($Fax)./TD/TR\n;
$result = $AxaptaQueryRun-Call(Next);
}
$Axapta-Logoff();
unset($Axapta);
?
/table
/center
/body
/html

***

On 1/3/07, [EMAIL PROTECTED] mailto:sha1232004%40yahoo.com  [EMAIL 
PROTECTED] mailto:sha1232004%40yahoo.com  wrote:

 Dear all,
 I can connect .NET to Axapta using Business connector(Using IAxapta...
 Interfaces ).
 I have one functionality in which we need to connect PHP software to
 Axapta using Business connector ,Is it possible ,if possible how can I
 connect PHP to Axapta Using Axapta Business connector..
 If possible plz send some sample codes ,why because i am new to PHP
 software.
 Any kind of help will be highly appreciated.

 Regards,
 Shaburuddin | Technical Consultant | Hyd | India | +91-09885776135.


 __
 Do You Yahoo!?
 Tired of spam? Yahoo! Mail has the best spam protection around
 http://mail.yahoo.com http://mail.yahoo.com 

 [Non-text portions of this message have been removed]

 


-- 
Lic. Luis Enrique Martínez Peña
Analista Programador Axapta
Consultor Sistemas Web
Off. (81) 8335 0620 ext 8564
http://www.it-soluciones.com.mx http://www.it-soluciones.com.mx 

[Non-text portions of this message have been removed]

__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com http://mail.yahoo.com  

[Non-text portions of this message have been removed]



 


[Non-text portions of this message have been removed]

Re: AW: [Axapta-Knowledge-Village] How can we Connect PHP software to Axapta ,Is it Possible through business connector?

2007-01-04 Thread Steen Rabol

Yes It's possible to use PHP to Axapta.

You need to be sure that your PHP installation have the com module installed - 
It's default in most PHP installations.
For best result, use PHP v5.1xx or newer.

Best
Steen


Andreas Rudischhauser [EMAIL PROTECTED] wrote:
  
 
 http://www.php-center.de/de-html-manual/faq.com.html
 
  
 
 
 
 
 Von: Axapta-Knowledge-Village@yahoogroups.com im Auftrag von
 [EMAIL PROTECTED]
 Gesendet: Do 04.01.2007 05:54
 An: Axapta-Knowledge-Village@yahoogroups.com
 Betreff: Re: [Axapta-Knowledge-Village] How can we Connect
 PHP software to Axapta ,Is it Possible through business
 connector?
 
 
 
 Example COM with php AccountNum Name Address Phone Fax Dear
 All,
 
 I wrote below code in PHP,i got this error ,anybody how can
 i solve this error.
 
 
 Fatal error: Cannot instantiate non-existent class: com in
 /var/www/html/demos/traniee/phpCOMExample.php on line 30 
 Regards, Shaburuddin. 
 
 Luis Martinez [EMAIL PROTECTED]
 mailto:enriquemtz%40gmail.com  wrote: An example,
 retrieving customer information code.
 
 Observation: in my last post , I said to yours that had
 problems with com
 connector... peculiarly with php does not appear to me any
 error (Apache +
 php)... but with IIS (Internet Information Server) yes,
 any Idea about it ?
 
 greetings.
 
 
 ***
 html
 head
 style type=text/css
 .encabezado {
 font-size:9px;font-family:'Arial,Verdana';background-color:#
 c0c0c0;font-weight:bold
 }
 .sombra {
 font-size:10px;font-family:'Arial,Verdana';background-color:
 #cc;font-weight:bold
 }
 .sinsombra {
 font-size:10px;font-family:'Arial,Verdana';background-color:
 #ff;font-weight:bold
 }
 /style
 titleAxapta Internet Connector - PHP Sample/title
 /head
 body
 center
 table style=border:1px solid #00 CELLSPACING=1
 CELLPADDING=0
 WIDTH=600
 trtd colspan=5 align=center
 class=EncabezadoExample COM with
 php/td/tr
 tr
 td WIDTH=20% class=encabezadoAccountNum/td
 td WIDTH=25% class=encabezadoName/td
 td WIDTH=25% class=encabezadoAddress/td
 td WIDTH=15% class=encabezadoPhone/td
 td WIDTH=15% class=encabezadoFax/td
 /tr
 ?php
 $Axapta = new COM(AxaptaComConnector.Axapta);
 $Axapta-Logon(Admin,,,c:\fortaAOS.axc);
 $CustTable = 77;
 $CustTable_Name = 2;
 $AxaptaQuery = $Axapta-CreateObject(Query);
 $AxaptaDataSource = $AxaptaQuery-Call(AddDataSource,
 $CustTable);
 $AxaptaRange = $AxaptaDataSource-Call(AddRange,
 $CustTable_Name);
 $AxaptaQueryRun = $Axapta-CreateObject(QueryRun,
 $AxaptaQuery);
 
 $result = $AxaptaQueryRun-Call(Next);
 $si = 1;
 while ($result) {
 $CustTableBuffer = $AxaptaQueryRun-Call(GetNo, 1);
 $AccountNumber = $CustTableBuffer-Field(AccountNum);
 $Name = $CustTableBuffer-Field(Name);
 $Address = $CustTableBuffer-Field(Address);
 $Phone = $CustTableBuffer-Field(Phone);
 $Fax = $CustTableBuffer-Field(Telefax);
 if($si) { echo TR class='sinsombra'; $si = 0; } else {
 echo TR
 class='sombra'; $si = 1; }
 echo TD WIDTH='25%'
 VALIGN='TOP'.mysql_real_escape_string($AccountNumber)./T
 D;
 echo TD WIDTH='55%'
 VALIGN='TOP'.mysql_real_escape_string($Name)./TD;
 echo TD WIDTH='55%'
 VALIGN='TOP'.mysql_real_escape_string($Address)./TD;
 echo TD WIDTH='10%'
 VALIGN='TOP'.mysql_real_escape_string($Phone)./TD;
 echo TD WIDTH='10%'
 VALIGN='TOP'.mysql_real_escape_string($Fax)./TD/TR\n
 ;
 $result = $AxaptaQueryRun-Call(Next);
 }
 $Axapta-Logoff();
 unset($Axapta);
 ?
 /table
 /center
 /body
 /html
 
 
 ***
 
 On 1/3/07, [EMAIL PROTECTED]
 mailto:sha1232004%40yahoo.com  [EMAIL PROTECTED]
 mailto:sha1232004%40yahoo.com  wrote:
 
  Dear all,
  I can connect .NET to Axapta using Business
 connector(Using IAxapta...
  Interfaces ).
  I have one functionality in which we need to connect PHP
 software to
  Axapta using Business connector ,Is it possible ,if
 possible how can I
  connect PHP to Axapta Using Axapta Business connector..
  If possible plz send some sample codes ,why because i am
 new to PHP
  software.
  Any kind of help will be highly appreciated.
 
  Regards,
  Shaburuddin | Technical Consultant | Hyd | India |
 +91-09885776135.
 
 
  __
  Do You Yahoo!?
  Tired of spam? Yahoo! Mail has the best spam protection
 around
  http://mail.yahoo.com http://mail.yahoo.com 
 
  [Non-text portions of this message have been removed]
 
  
 
 
 -- 
 Lic. Luis Enrique Martínez Peña
 Analista Programador Axapta
 Consultor Sistemas Web
 Off. (81) 8335 0620 ext 8564
 http://www.it-soluciones.com.mx
 http://www.it-soluciones.com.mx 
 
 [Non-text portions of this message have been removed]
 
 __
 Do You Yahoo!?
 Tired of spam? Yahoo! Mail has the best spam protection
 around 
 http://mail.yahoo.com http://mail.yahoo.com  
 
 [Non-text portions of this message have been removed]
 
 
 
  
 
 
 [Non-text portions of this message have

[Axapta-Knowledge-Village] Extra User Info

[Axapta-Knowledge-Village] Item Master Record

[Axapta-Knowledge-Village] How to terminate a session in AOS?

Re: [Axapta-Knowledge-Village] How can we Connect PHP software to Axapta ,Is it Possible through business connector?

RE: [Axapta-Knowledge-Village] Item Master Record

AW: [Axapta-Knowledge-Village] How can we Connect PHP software to Axapta ,Is it Possible through business connector?

Re: AW: [Axapta-Knowledge-Village] How can we Connect PHP software to Axapta ,Is it Possible through business connector?

7 matches

Site Navigation

Mail list logo

Footer information