5/4/2024 10:31:03 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of .NET Extensions in SalesLogix version 7 and higher. View the code of conduct for posting guidelines.
|
|
|
|
New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 16 May 06 10:35 AM
|
fiogf49gjkf0d Just thought I would mention for anyone following this subject for v7, that there is new syntax coming to load .NET assembly from SalesLogix. This is post beta2 syntax (no longer using only Run):
Dim guid
Dim retval
guid = Application.Managed.Create("[PluginTitle]", "[Namespace.Class]")
retval = Application.Managed.Run(guid, Array())
There is also a new Destroy method available under Managed as well. More info to come on these, but wanted to pass things along. |
|
|
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 16 May 06 4:04 PM
|
fiogf49gjkf0d "retval = .." .. ".Run(..)"
Could also be "Set retval = ..." Note that a CLR object can return itself or another object. Good for passing back a smart object model; on the other hand, in the case of an object model, I don't recollect what this would entail as far as where <ComVisible(true)> would need to be declared. VBScript ultimately sees this stuff through the lens of COM. |
|
|
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 16 May 06 4:15 PM
|
fiogf49gjkf0d Well, sort of. It is true that an object can be returned, however returning a .NET object would not be understood in a VBScript world. Any object returned would have to not only be COM exposed, but also be COM created. That is, even if you have a COM exposed layer, the object itself would have to be created via the same COM layer. To clarify, if Class1 was COM exposed, you would have to create the Class1 object via the COM layer in order to return it to a VBScript. Make sense? Also, there's nothing in the .NET support in v7 that would allow you to export a COM type library for a .NET assembly - although that would be easy enough for you to construct yourself.
Ah, it is fun to think of the possibilities of things to try with this new functionality.  |
|
|
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 16 May 06 4:22 PM
|
fiogf49gjkf0d My tests indicate that the object would indeed be exposed to VBScript given that the objects are loaded via the COM layer from the get-go (at the point of Create()). The problem is that the members are only exposed at the surface level--the members that return non-intrinsic values would return objects that COM does not expose. This is where I think <ComVisible(true)> was missing in the objects I was exposing so the CCW did not extrapolate the sub-member interfaces.
These tests were from way back when I was playing with creating a VBScript/JScript powered MSH/Monad look-alike before Microsoft started going down that road, about three years ago. Specifically I was trying to evaluate via VBScript the properties of a .NET Framework defined object (System.Xml.XmlDocument I believe), which of course I had no access to declare for COM visibility directly. |
|
|
| |
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 17 May 06 10:24 AM
|
fiogf49gjkf0d v7 is in beta (currently beta2). I'm not sure how their beta program works exactly - all I know is I get my hands on the bits as soon as I can If you're interested you could contact Sage to inquire about participating in the beta program. |
|
|
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 17 May 06 12:54 PM
|
fiogf49gjkf0d Login to SupportOnline
Contact Us
Beta Program
Read policies and contacts then use the form to sign up. There are minimum requirements but I don't know what those are. There's also restrictions against installing it on a customer site. Personally I'd be testing the crap out of this in VPC so I doubt I'd qualify but I think I'll sign up just to stress the crap out of the .NET integration. I also want to see if SharpDevelop can make assemblies that work for it and suggest patches to the code if need be. We don't all have access to Visual Studio. |
|
|
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 17 May 06 1:01 PM
|
fiogf49gjkf0d The agreement says you need to report to Best weekly (the terminology shows how dated this is) so I'm hoping that's not the case.
Can anyone in the program describe the experience? Do you have to devote a good portion of time to this per week or do you do things at your leisure? I want to do as much as I can but I can't always devote time to something regularly when I have so much other stuff staring me in the face. |
|
|
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 17 May 06 1:02 PM
|
fiogf49gjkf0d SharpDevelop should work fine as long as it complies to .NET 2.0 (I've not followed SharpDevelop for the last couple years, but I assume it does 2.0 now). You could also use the VS 2005 express editions which are free. |
|
|
| |
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 18 May 06 3:00 AM
|
fiogf49gjkf0d Originally posted by Dhany
The registration form layout breaks in my IE7. I guess I'll have to download firefox,.. *sigh*
Regards,
Dhany |
|
same here, and when you email the "webmaster", after 2 days you will receive an email saying that it could not be delivered... so its pretty hard to sign up.
I just contacted tech support, and they have helped me quite a bit, so hopefully I will receive the beta very soon..  |
|
|
| |
| |
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 07 Aug 06 10:46 AM
|
fiogf49gjkf0d I haven't personally tried an upgrade (not something I normally do - I'm strictly code monkey ;p) My focus for beta testing has been OLE DB Provider, .NET Extensions, and some of the new Architect bits. Although I have heard of some successes testing upgrades from 6.x to 7. |
|
|
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 08 Aug 06 2:07 AM
|
fiogf49gjkf0d Hi
Yes, I did do this on Friday last with a moderately customised database - enclosed are results - sorry about format !
Mike
For the first time - I ran the upgrade, notes as follows:
My install was a VMWare copy of 6.2.4 with the SalesLogix_Evaluation
database and 2 other custom databases
My first update was on the SalesLogix_Eval Database:
Step 27 - Step d - new step required.
If you do NOT click "Allow Saving password" - you get an error - "Error
attempting to determine database version, check connection string""
I'm a bit bothered by the need to use the provider - as, as others have
said, this makes upgrading more than one database on the same server a
logistical nightmare. You would have to pre-upgrade every database before
running the install. Is this likely to change ?
Half way through installing Microsoft .NET framework I received an
InstallShield error 1603: Error installing MS Framework - install then
aborted! Running the install manually reported an out of disk space error.
Having corrected that, the install moved on. Would be nice if errors could
carry through to calling app.
Installation of the bundle - received a warning about an index on email3,
xpkleadsource, xpkliterature, xpaccount, xie13account, xpkcontract,
xpkcontractincident, xpkopportunity, xie1opportunity,
xpkopportunity_product, xpkproduct, xpkquota, - would be nice to be able to
install bundle without warning half-way through and bring up list after (of
any issues) - as you can't do anything anyway at this point. I know that
task 17 mentions and warns about this but it's not complete - for example,
email3 is an index on contact but task 17 only mentions "keys and indexes" -
but, OK, which ones should be removed - all of them - doubtful ? This
section needs clarifying.
Installing web client/server - the installer pauses and says that the
Architect and Admin are in use - but these aren't modified by the setup so
is this really an issue ?
Step 6 of upgrade guide - this mentions that it would detect an existing
site an upgrade it - it didn't do this (although I did have a working 6.2.4
version installed and running on port 1025.
I logged in and everything appeared to work (relatively smooth upgrade
!!) - aside from the items below:
Client/Server
-------------
The dashboard has an issue. Select the Product Sales Potential and received
Error callling method AxFormRefresh, Divide by zero encountered, L2771 char
8 in Sales Dashboard:Product Sales Potential
Mail-Merge - the upgrade installs duplicate templates
Tools | Activity Reminder - once invoked once, it doesn't appear again until
a complete refresh (can't reproduce this now but the window seemed to
disappear) even though it normally doesn't.
Opportunity Statistics - select all opps - run the report "competitor
analysis" (actually, should imagine any report on this menu) and then
immediately run export group - get "error exporting group, cannot perform
this operation on a closed dataset" - but does export.
Web
-----
Login: The logo for IE on the left hand side - how old !!!!!
The first 2 in the grid of the reminders section (top left) have no
checkboxes ??
The logo for SLX and the Reminders section seems disjointed (i.e.
graphically and aestetically don't "fit"
Got List Index out of Bounds when doing a MM and adding template to MRU list
Did a MM with ActiveMail - ran the merge, went to do SendSLX and the whole
IE disappeared ! Did a reset and, this time it worked. I may have chosen the
old MM document ?
The ActiveMail DLL is continually downloaded (on each login) - is this
correct ?
The attachment tab is not sorted in date order
Regards
Mike
PS More to follow on my other upgraded / custom db's.
OK, following on from the this - I upgraded a custom database which was
moderately customised.
> Installation of the bundle - received a warning about an index on email3,
> xpkleadsource, xpkliterature, xpaccount, xie13account, xpkcontract,
> xpkcontractincident, xpkopportunity, xie1opportunity,
> xpkopportunity_product, xpkproduct, xpkquota, - would be nice to be able
> to install bundle without warning half-way through and bring up list after
> (of any issues) - as you can't do anything anyway at this point. I know
> that task 17 mentions and warns about this but it's not complete - for
> example, email3 is an index on contact but task 17 only mentions "keys and
> indexes" - but, OK, which ones should be removed - all of them - doubtful
> ? This section needs clarifying.
Due to this issue - I removed all indexes from the noted tables in task 17
and re-ran the upgrade/conversion bundles. At the end my table indexes were
still all gone - aside from Campaign table. The upgrade completed without
erroring as above but now my index structure is shot!
The guidance needs to be much clearer on this section - as I removed the
constraints and indexes via EntMgr which, obviously, won't sync. As there is
no re-cut on the remotes then this section will fail on the remotes unless
the index removal is bundled 1st. Additionally, if you do remove indexes -
they will need to be restored post installation - the bundle won't do it for
you.
Post upgrade - everything worked extremely well - some odd looking toolbars
(massive icons underneath the main toolbar - anything that was in the old
NavBar appears here) but following instructions in task 42 soon sorted
those.
I too stumbled into the error Jerry Norman raised - that is, my system had
the form Ticket:Support Ticket History - this should be de-released by the
install as it does cause errors as detailed in Task 46. Also, the old RMA's
form still exists - this should be de-released too as it's replaced by
Returns.
A change appears to have been made on the function below - which I was using
it to open the MV on completion of an insert, but now it doesn't appear to
do anything:
Application.MainViews.AddEx "EventManagement:Event Details", 1, True,
1, CurrentEventID.Text, "" 'DNL
Anyone know why this would be - it essentially makes it appear that my
add/copy didn't do anything - but a manual F5 displays the data correctly ??
*** HUGE 101 ERROR *** The Notes-History tabs - are all unsorted ! This
should be in completeddate order. I removed HKCU\SLX\Client\Grids to
dbl-check but made no difference. This affects eval db too.
The error with the dashboard and Product Sales Potential did *not* appear in
this database, which was intriguing.
Whilst snooping around I noticed:
HKEY_CURRENT_USER\Software\SalesLogix\Client
With a DWord Entry of "OneInstance" - which is defaulted to 0. If you set it
to 1 then you can only load one instance of SLX.
It would be good if, at some point, we could get a list of the major reg
keys - as a "nice to have" !
CTRL-M to move a contact - this works (great new features) - but doesn't
update the account:contact grid at the end - consequently, it looks like
he's still there - an F5 sorts it though.
Item History - on the toolbar - isn't being cleared/reset correctly and
persists from database to database if you do a File | Logout - however, if
you are in the wrong DB and choose an item - it takes you to an invalid
record and causes an EOF/BOF if the Notes-History tab is active.
Admin - Tools | Options | System - there is an option for Refresh Activities
every X mins - this needs bringing out somewhere in docs / release notes -
good feature but very easily missed. Also, shouldn't this be per user as
opposed to per system? It should also mention it refreshes the activity list
and the calendar display.
*** Other than that - the upgrade seemed to work exceptionally well. Of
course, these were short term tests and I'm sure there's some other items
and time will tell - but, in the meantime, I'm well pleased with it so far -
well done all ! ***
|
|
|
|
Re: New Syntax coming for using a .NET Assembly from SalesLogix
Posted: 08 Aug 06 12:57 PM
|
fiogf49gjkf0d In 6.2 there is a disconnect between the Eval and Blank database, or at least evidence as present by the sitekeys descriptions. Blank has single character descriptions while Eval has the full thing (or I may have it backwards).
Notes-History sort problem was originally reported by Ryan here: http://saleslogixblog.com/rfarley/archive/2004/08/04/936.aspx
This wouldn't be the first time a very old problem came back to haunt a SLX install. Upgrade to 5.2 introduced the opportunity field sync issue. Upgrade to 6.x introduced the syncsequencing clustered primary key sync issue. The upgrade process could fix both of those but it doesn't, even in the 6.2 upgrade to my knowledge.
I'm signing up for the beta program to hopefully slap these issues out of existence. It may be too late for me though so hopefully others will take up the upgrade cause. While 4.x and 5.x is pretty much unsupported now, it's not going to be uncommon for users to upgrade from those platforms. I'm tired of supporting these issues, I feel like a broken record every time I see the symptoms hit (though I have been wrong in the diagnosis before). |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|