[development-axapta] Excel Import Error: ContactPerson Table

2005-05-06 Thread Dick Howard 




When importing into the ContactPerson table using Excel receive error 
message "Field 'Reference' must be filled in". Have tried putting a 
value in the Reference field but this changes the message to "Unknown 
Type: VT_BSTR".

Need help with work-around. Have imported CustTable with no problem 
and over 800 of the customers have contact person imformation that 
also needs to be imported.

Best Regards,

Dick Howard
BKD Technologies
Indiana USA













Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Re: Simple email vaidation

2005-05-06 Thread Mayle, Michael 




Yeah, this is a looping operation, but thanks for the tip. I may have to
use that.

--Mike

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Malcolm Burtt
Sent: Friday, May 06, 2005 6:08 AM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Re: Simple email vaidation

You could also consider the SysMailer.validate() method although its
approach to validation (DNS lookup, etc) might be more than you wanted
to do especially if you want the results really quickly.

  -Original Message-
  From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Mayle, Michael
  Sent: 05 May 2005 13:58
  To: development-axapta@yahoogroups.com
  Subject: RE: [development-axapta] Re: Simple email vaidation
  
  
  Hi Andrew,
  
  Thanks, but I actually have a library of regular expressions,
it's just
  that Axapta does not use quite the same syntax. It uses :n
instead of \w
  and many other differences which made my attempt at translation
fall
  flat. I was just seeing if anyone else solved this problem
before.
  
  Thanks for the tip on the Match() function; I did find that in
the
  documentation (believe it or not.)
  
  --Mike
  
  -Original Message-
  From: development-axapta@yahoogroups.com
  [mailto:[EMAIL PROTECTED] On Behalf Of ozzage
  Sent: Wednesday, May 04, 2005 6:04 PM
  To: development-axapta@yahoogroups.com
  Subject: [development-axapta] Re: Simple email vaidation
  
  Hi Mike
  
  If you google "regex valid email address" you'll find a lot of
hits for
  sites with exactly what you are after.
  
  Here is one:
  
  http://www.codeproject.com/aspnet/Valid_Email_Addresses.asp
  
  It shows a regular _expression_ used to validate an email address.
  
  The regular _expression_ checker in Axapta is the match()
function, in
  case you hadn't got that far yet.
  
  Cheers
  
  Andrew
  
  --- In development-axapta@yahoogroups.com, "Mayle, Michael"
  <[EMAIL PROTECTED]> wrote:
  > Hi all,
  > 
  > I am trying to adapt a regular _expression_ to use in Axapta for
email 
  > address checking. Does anyone have one? Any help appreciated,
but I 
  > can of course write a method to satisfy this. I just thought
there was
  
  > an easy way in Axapta to do it.
  > 
  > Thanks in advance.
  > --Mike
  > 
  > Michael Mayle
  > Lead Programmer
  > Disc Makers
  > 7905 N Route 130
  > Pennsauken, NJ 08110
  > 1-800-468-9353 x5540
  > [EMAIL PROTECTED]
  > 
  > 
  > 
  > [Non-text portions of this message have been removed]
  
  
  
  
  
  
  
  Yahoo! Groups Links
  
  
  
  
  
  
  
  
  
  
  
  _  

  Yahoo! Groups Links
  

  *  To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/
      
  *  To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

be> 
      
  *  Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service  . 




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





 
Yahoo! Groups Links



 














Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Production Resource Tools

2005-05-06 Thread d_udayreddy 




Dear all
recently i am working wit AXAPTA 3.0 Sp3.
i want to know how do i need to attach Production resource tools like 
Inserts, Jigs & Fixtures.

Thanks in advance
uday













Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Re: Simple email vaidation

2005-05-06 Thread Malcolm Burtt 




You could also consider the SysMailer.validate() method although its
approach to validation (DNS lookup, etc) might be more than you wanted
to do especially if you want the results really quickly.

  -Original Message-
  From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Mayle, Michael
  Sent: 05 May 2005 13:58
  To: development-axapta@yahoogroups.com
  Subject: RE: [development-axapta] Re: Simple email vaidation
  
  
  Hi Andrew,
  
  Thanks, but I actually have a library of regular expressions,
it's just
  that Axapta does not use quite the same syntax. It uses :n
instead of \w
  and many other differences which made my attempt at translation
fall
  flat. I was just seeing if anyone else solved this problem
before.
  
  Thanks for the tip on the Match() function; I did find that in
the
  documentation (believe it or not.)
  
  --Mike
  
  -Original Message-
  From: development-axapta@yahoogroups.com
  [mailto:[EMAIL PROTECTED] On Behalf Of ozzage
  Sent: Wednesday, May 04, 2005 6:04 PM
  To: development-axapta@yahoogroups.com
  Subject: [development-axapta] Re: Simple email vaidation
  
  Hi Mike
  
  If you google "regex valid email address" you'll find a lot of
hits for
  sites with exactly what you are after.
  
  Here is one:
  
  http://www.codeproject.com/aspnet/Valid_Email_Addresses.asp
  
  It shows a regular _expression_ used to validate an email address.
  
  The regular _expression_ checker in Axapta is the match()
function, in
  case you hadn't got that far yet.
  
  Cheers
  
  Andrew
  
  --- In development-axapta@yahoogroups.com, "Mayle, Michael"
  <[EMAIL PROTECTED]> wrote:
  > Hi all,
  > 
  > I am trying to adapt a regular _expression_ to use in Axapta for
email 
  > address checking. Does anyone have one? Any help appreciated,
but I 
  > can of course write a method to satisfy this. I just thought
there was
  
  > an easy way in Axapta to do it.
  > 
  > Thanks in advance.
  > --Mike
  > 
  > Michael Mayle
  > Lead Programmer
  > Disc Makers
  > 7905 N Route 130
  > Pennsauken, NJ 08110
  > 1-800-468-9353 x5540
  > [EMAIL PROTECTED]
  > 
  > 
  > 
  > [Non-text portions of this message have been removed]
  
  
  
  
  
  
  
  Yahoo! Groups Links
  
  
  
  
  
  
  
  
  
  
  
  _  

  Yahoo! Groups Links
  

  *  To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/
      
  *  To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

be> 
      
  *  Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service  . 




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












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Oracle First Row Fix

2005-05-06 Thread hwimmer 




Hi
Having major performance problems with our Oracle DB, I played 
around with the First Row Fix Parameter. The Configuration help says 
(search for "setting oracle options" in help file):

"Special first Row fix should be checked if performance problems are 
experienced while sorting rows within forms."

So I was thinking that this parameter only has the effect whether 
a "FIRST ROWS" hint is added to the select generated by a form or 
not.

BUT: it also confuses the optimizer with simple SQL statements.

I have a select statement like: (Attention: there is no 
a "firstonly" here )

 while select forupdate rc where rc.PackSlipHeader == _lsnr &&
   rc.Calc == 
RMCalc::C1 &&
   rc.Fil == _fil &&
   rc.KalkType == 
KalkType::Item &&
   !rc.BSNr &&
   rc.CLDy == 
NoYes::Yes &&
   rc.ItemQty > 0

When I have the First Row fix turned OFF (=default), the optimizer 
chooses an index containing the fields: PackSlipHeader, Fil, ItemId, 
ConfigId, ActivityId
and it will make the select in 20 seconds

When I have the First Row fix turned ON, the optimizer chooses an 
index containing the field: BSNr
and it will take 15 minutes !!! for the select.

So, the First Row Fix does not only change the way how forms behave 
but must also do something to the optimizer ?!?

Did anybody make a similar experience?
Who of you is using the first row fix parameter turned on?

Best regards
Helmut













Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

SV: [development-axapta] Preload and Cache in a AOS cluster

2005-05-06 Thread Stefan Lundquist (Priv) 




Hi
This is a problem with 3.0 versions before Sp3. It's fixed in Sp3.

The only workaround is to disable ALL cache handling when using clustrered
AOS.

To disable the cache handling you can do following in the advanced field on
BOTH client & AOS settings
-internal=maxcachelevel:0

/Stefan L
  -Ursprungligt meddelande-
  Från: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] Ed Ladner
  Skickat: den 3 maj 2005 16:33
  Till: development-axapta@yahoogroups.com
  Ämne: [development-axapta] Preload and Cache in a AOS cluster


  I'm having a problem with managing the cache of an group of clustered
  AOS's, where a GL account is created by one user on AOS1, but cannot
  be seen by a user signed on to AOS2.
  We can get around this problem by forcing users on to the same AOS, or
  waiting until after midnight for the AOS's to flush the queues.

  When I use the menu option on the AOS with the stale cache,
  Tools/Development Tools/Application Object/Refresh Data I do not get
  the refreshed data.

  I attempted to use a customized menu item to flush the AOS cache using
  a call to class SysFlushAOD with run on set to Server, but this only
  appeared to refresh the dictionary, not the data cache.

  I've conidered using the same approch to call SysFlushData, but this
  would only work on a 'on demand' solution, which would not be ideal
  for my users.

  Short of customizing the tables in question to not use cacheing, does
  anyone have any ideas that will have the AOS's keep more up todate
  with their caches?

  Thanks,

  Ed L.









--
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/

    b.. To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

AW: [development-axapta] select from inventtrans doesn't work

2005-05-06 Thread Jim Dickie 




I'm not an expert on joins, but it seems to me you have limited the
InventDim select with locationId == ambar, which will then restrict the
selection in the InventTrans.

The join on InventJournalTable has no further restriction, so which
TransRefId from which InventTrans should be used to fetch the IJT?

Of course if you group by ItemId you cannot select the it.TransRefId
anyway, that is also true.  But then I don't know exactly what you are
trying to achieve...

I would probably start playing with nested while selects at this stage,
but as I say, I am no expert on joins...    

Jim

-Ursprüngliche Nachricht-
Von: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] Im Auftrag von Cenk Ince
Gesendet: Mittwoch, 04. Mai 2005 18:18
An: development-axapta@yahoogroups.com
Betreff: YNT: [development-axapta] select from inventtrans doesn't work

Hi;
 
I don't select transrefId, that is rigth but i don't select inventDimid
eigther!
And i'm able to select from inventDim. What is different?
 
Thanks.
 



Kimden: development-axapta@yahoogroups.com bu kiþinin yerine: Jim Dickie
Gönderilmiþ: Çar 04.05.2005 16:52
Kime: development-axapta@yahoogroups.com
Konu: AW: [development-axapta] select from inventtrans doesn't work



Hi,

you have not select it.TransRefId iin your select it statement, only
sum(Qty).

Mit freundlichen Grüssen / kind regards,
Jim Dickie, 
Circon Circle Consulting GmbH,
Färbergasse 13, A-6850 DORNBIRN
e-mail: [EMAIL PROTECTED]
phone: +43 (0)664 2337785

-Ursprüngliche Nachricht-
Von: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] Im Auftrag von Cenk Ince
Gesendet: Dienstag, 03. Mai 2005 08:30
An: development-axapta@yahoogroups.com
Betreff: [development-axapta] select from inventtrans doesn't work

Hi all;

I prepare a report that gives transfers to a inventlocation between
date1 and date2.
When i add a join at the and of the select (below in red) it doesn't
return any value.
With out red line it gives me sum of all transfers in inventtrans.
But i want to devide them according to their "journalnameid" field on
inventjournaltable.

Any idea?


real fason_Giris(Inventlocationid ambar, transdate d1,transdate d2)
{
    inventDim   id;
    inventtrans it;
    inventTransposting  itp;
    inventjournaltable  ijt;
    ;
    id.InventLocationId = ambar;
    select sum(qty) from it index hint TransIdIdx group by itemid  where
it.ItemId == this.ItemId &&
   it.TransType ==
inventtranstype::InventTransfer &&
   (it.StatusReceipt ==
StatusReceipt::Received || it.StatusReceipt == StatusReceipt::Purchased)
&&
   it.Direction == inventDirection::Receipt
// stok giri?i
   join id where
   it.inventDimId == id.inventDimId
   && id.InventLocationId == ambar

   join itp index hint ItemTypeDateIdx where
   itp.ItemId == it.ItemId &&
   itp.InventTransId  ==
it.InventTransId &&
   itp.InventTransPostingType ==
InventTransPostingType::Physical &&
   itp.Voucher  ==
it.VoucherPhysical &&
   itp.TransDate >= d1 &&
   itp.TransDate <= d2
   join ijt where ijt.JournalId ==
it.TransRefId;
    return it.Qty;
}



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







Yahoo! Groups Links














Yahoo! Groups Links










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





 
Yahoo! Groups Links



 















Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

SV: Antwort: AW: Antwort: AW: [development-axapta] performance problems after upgrade ax30sp2 to ax30sp3

2005-05-06 Thread Dahlsgaard Jan 




Even though SQLServer should manage the optimization of statistics automatically, we have good experiences running update statistics once in a while. So reindex your db and update statistics.
 
Regards 
Jan Stelsig Dahlsgaard
Fujitsu DK



Fra: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af [EMAIL PROTECTED]
Sendt: 4. maj 2005 19:44
Til: development-axapta@yahoogroups.com
Emne: Antwort: AW: Antwort: AW: [development-axapta] performance problems after upgrade ax30sp2 to ax30sp3


hi arthur,

we have deleted the axapd.aoi and rebuild it. but there was no change from 
this situation.

but i want to try to rebuild the database indexes whith the axapta sql 
manager.

thanks.

Mit freundlichen Grüßen/Best Regards

Sascha Güttler

Cosi Elektronik GmbH
Software & Service
In den Käppeleswiesen 4
72488 Sigmaringen

Tel.  +49 (0)75 71 / 7 33 - 1 42
Fax. +49 (0)75 71 / 7 33 - 2 20 

mailto: [EMAIL PROTECTED]



"Arthur Gorski" <[EMAIL PROTECTED]> 
Gesendet von: development-axapta@yahoogroups.com
04.05.2005 16:10
Bitte antworten an
development-axapta@yahoogroups.com


An

Kopie

Thema
AW: Antwort: AW: [development-axapta] performance problems after upgrade 
ax30sp2 to ax30sp3






Hallo Sascha,



hast du versucht die Indexes über Axapta vielleicht mal neu aufzubauen?



Gruß

Arthur







-Ursprüngliche Nachricht-
Von: development-axapta@yahoogroups.com 
[mailto:[EMAIL PROTECTED] Im Auftrag von 
[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. Mai 2005 14:38
An: development-axapta@yahoogroups.com
Betreff: Antwort: AW: [development-axapta] performance problems after 
upgrade ax30sp2 to ax30sp3



Thanks Tom,

but I have a 2-Tier installation, so we work whithout AOS-Server.

The Database is a msql2000 with 10 Gb size.

When I start a standard report on the server, the sql server rises over 90 

percent in the taskmanager.

I dont know  what the sql server do at this time.

And I don't know how long does it need. 

I cancelled the last report after 30 minutes whith the task manager, 
because i have no other possibility.

And know?

Mit freundlichen Grüßen/Best Regards

Sascha Güttler

Cosi Elektronik GmbH
Software & Service
In den Käppeleswiesen 4
72488 Sigmaringen

Tel.  +49 (0)75 71 / 7 33 - 1 42
Fax. +49 (0)75 71 / 7 33 - 2 20 

mailto: [EMAIL PROTECTED]



"Tom Aulbert (TAU.DE)" <[EMAIL PROTECTED]> 
Gesendet von: development-axapta@yahoogroups.com
04.05.2005 11:37
Bitte antworten an
development-axapta@yahoogroups.com


An

Kopie

Thema
AW: [development-axapta] performance problems after upgrade ax30sp2 to 
ax30sp3






Hi Sascha,
May be, the new Kernel helps. An other thing could be "unicode" on 
SQL-Server (in AOS-Settings).

Mit freundlichen Grüßen / Best regards / Med venlig hilsen

Tom Aulbert 
MBS Axapta Certified Professional

Berater / Consultant

Columbus IT Partner Germany GmbH
Oeynhausener Straße 48-54
32584 Löhne, Deutschland

tel +49 5732 902-0
fax +49 5732 902-599
mailto:[EMAIL PROTECTED]
http://www.columbus-it.com

-Ursprüngliche Nachricht-
Von: development-axapta@yahoogroups.com 
[mailto:[EMAIL PROTECTED] Im Auftrag von 
[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. Mai 2005 09:42
An: development-axapta@yahoogroups.com
Betreff: [development-axapta] performance problems after upgrade ax30sp2 
to ax30sp3

hi,

we have a big problem, after an upgrade from axapta 3.0 sp2 to axapta 3.0 
sp3, our customer has performance problems in his complete it-network when 


he starts in a axapta a standard report like saslesstatics_custitem.

the performance problem at the local network are, f.e. to save a word 
document  needs more than two minutes..

for tests i imported the axas30sp3hf1. when i start in my testsytem the 
report salestatistic_custitem then it more terrible like before.


has anybody experiences whith this problem?

best regards
sascha



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






Yahoo! Groups Links







Checked for virus in e-mail by mailFence from Sure 
Solutions(www.SureSolutions.dk)




Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


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








Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/


* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <
mailto:[EMAIL PROTECTED]> 



* Your use of Yahoo! Groups is subject to the Yahoo! Terms of 
Service  . 



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




Yahoo! Groups Links
To visit