Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Sunday, December 16, 2018 
 
View User Profile  

 User Profile - Mike Spragg  
  Mike Spragg
(SalesLogix Business Partner)
empath-e Limited

fiogf49gjkf0d
10 Years+ with SLX !
(Formerly of e1 Business)


Log in to send this member a message!
 


 Mike Spragg's Contributions
Mike Spragg has contributed 35 comments and 4 articles.
 
Select to view:    
Comment: Re: E1 User Groups
fiogf49gjkf0d
Contact support@e1business.com to see if they have the source. Very doubtful as Declan left 5 years ago and I left (E1) over 3 years ago !

Author: Mike Spragg - 1/23/2010

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
Hi Kevin
Did you remember to change the Tools | Client Options in Admin to set the startup scripts to EM_AS_xxx as per notes - send me an email directly for help - mike.spragg@empath-e.com

Author: Mike Spragg - 9/2/2009

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
No, sorry Frank - just LAN. However, the table would be there anyway - so you could add the web into the mix with some web code. Which, afaik, no-one has done yet.

Author: Mike Spragg - 6/9/2008

 
Comment: Re: Using Classes in VBScript
fiogf49gjkf0d
You need to approach your Business Partner. If you have a valid Support & Maintenance contract you can get this for free from them.

Author: Mike Spragg - 4/13/2008

 
Comment: Re: SalesLogix Synchronization Report
fiogf49gjkf0d
Tracy, there are several components you need to register which I do not include as they can sometimes interfere with normal sendmail.dll - contact me directly on mike.spragg@empath-e.com for details.

Author: Mike Spragg - 4/9/2008

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
How does it maintain it's size ? In my experience - no-one wants to know about year dot - just relevance. The overwriting is deliberate for self-maintenance purposes.

Author: Mike Spragg - 1/17/2008

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
"how would it handle itself if a user were to terminate the saleslogix process"

You are correct of course - nothing could handle that and the next login would overwrite the last in a round-robin fashion.

Author: Mike Spragg - 1/12/2008

 
Comment: Re: SalesLogix Synchronization Report
fiogf49gjkf0d
Thanks for the info though - will adjust the master copy !

Author: Mike Spragg - 11/27/2007

 
Comment: Re: SalesLogix Synchronization Report
fiogf49gjkf0d
Really? Oh - it shouldn't do that - I always thought it was re-written especially if it's just a portion of the file. We're talking about a ZIP-FILExxxx file aren't we ?? If so, then, I defer to you and it should be createdate !!

Author: Mike Spragg - 11/27/2007

 
Comment: Re: SalesLogix Synchronization Report
fiogf49gjkf0d
Hi Konstantin

Would make no difference - the reason being - the zip file is actually a zip of the contents and the TEF's therein - not the document date of the content. The createdate/modifydate would actually be the same thing (as the file can never be modified once created).
A zipped TEF file contains many transactions and, importantly, only part of the actual file (if an attachment) as the SyncServer splits the file into several parts if > 1Mb.

So, in summary - we're looking at the date created/modifed of the TEF - not the content.

Cheers
Mike


Author: Mike Spragg - 11/27/2007

 
Comment: Re: How to Add a Custom Column to the Manage Products Grid
fiogf49gjkf0d
These are the steps I use when working in this area - they should still be current - but they document a few other areas that the above "touches" on too !

==========================================
"Simply" adding a new field to OppProduct:
==========================================

Form: Opportunity:Products
--------------------------
Sub PopulateDataGrid : modify to include col in sql, and the grdProducts
Sub CommitChanges : Modify to include col in sql, and the update rs

Form: System:Insert Opportunity
------------------------------
Sub SaveOpportunityProductInfo( )

Script: System:Insert Opportunity Common
----------------------------------------
Sub DefineProductsGrid(oppID) : modify to include new section detailing new column
Function CreateProductsRSStructure : modify to include new column
Function DoGridCalculations(Sender, FieldName, Value, OppID)
: Modify to include within loop/case the new field
If strCrntRecord = .Fields("KEYFIELDID").Value Then
.Fields("yourfieldhere").Value = Value
End If
Sub SaveOpportunityProductInfo( )
Sub RemoveProducts( )


Form: System:Add Opportunity Product
------------------------------------
Sub AddProductToGrid(objRS, intQty) : Modify to include any defaults
Sub UpdateCurrentProduct( )
Sub AddDeleteProductToDB( )


Author: Mike Spragg - 11/12/2007

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
With (1) - no need, as they are added into a different column
2) - specific to your site - sorry !!
3) - same as (1) - the date/time are captured into the last 5 logins (after being shuffled backward).

Cheers
Mike


Author: Mike Spragg - 6/7/2007

 
Comment: Re: SalesLogix Synchronization Report
fiogf49gjkf0d
Yes, because the DateDiff isn't valid for Oracle - you'd need equivalent function (this is mssql syntax):

convert(datetime, '" & f.DateLastModified & "',103))"

So, whatever Oracle uses (essentially, you're converting the time of the file to a valid [Oracle] date.

Author: Mike Spragg - 5/23/2007

 
Comment: Re: SalesLogix Synchronization Report
fiogf49gjkf0d
Leif, as this is not database/SLX specific - all you'd need to do is adjust the "provider" details - instead of using sqloledb (the Microsoft SQL Connection) simply use the Oracle equivalent (or MSDAORA) instead.

Author: Mike Spragg - 4/25/2007

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
Jeff - please download the latest bundle to resolve your sync issue.
Troy - sorry, will only work in 6.2 or above ! However, if you aren't planning to migrate any time soon then please contact me - you should be able to take the same script from 6.2 and it should work in 6.1
Everyone - I've asked Ryan to update the bundles - it now also stores/reports the last 5 logouts as well. There are two bundles - for 6.2.x and for v7.x

Regards
Mike

Author: Mike Spragg - 11/19/2006

 
Comment: Re: E1 User Groups
fiogf49gjkf0d
I'm very doubtful it would (whilst schema is same - the code/case etc. isn't) - we don't "do" Oracle I'm afraid.

Author: Mike Spragg - 9/19/2006

 
Comment: Re: E1 User Groups
fiogf49gjkf0d
Hi Todd, it's not related to any version - it doesn't use the provider - uses ODBC and simply queries the plugin table (so, any version would work)

Regards
Mike

Author: Mike Spragg - 5/27/2006

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
Sorry, yes, the screenshots (as you can guess) apply to v5.2 when this was first done. The Find option doesn't work in 6.2 due to a missing call ("JumpToTypeAhead") - and the workaround is not efficient ! Yes, will work in any version of 6.x.

Author: Mike Spragg - 5/3/2006

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
If you need the bundle before Ryan has a chance to upload - please contact me directly.

Author: Mike Spragg - 4/25/2006

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
**** SERIOUS ISSUE WITH THIS BUNDLE ****

It's come to my attention that there is a serious flaw with the ActiveScript part of this bundle. Essentially, when this was converted from Legacy code the LogSetGlobalID was carried through. However, this appears to cause a sync issue as it is not cleared. This didn't cause an issue with v5.x nor 6.1/6.2.x - the error appears to be 6.2.4. The error will manifest itself as the inability to record/see changes on the main detail views on other remote databases/users. Auxialliary records are created - but changes to the main details are not syncing.

My apologies if you have been affected. I have asked Ryan to post the new bundle.

Author: Mike Spragg - 4/25/2006

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
You're right - it should be. Hopefully, it will make it into v7 !

Author: Mike Spragg - 4/22/2006

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
Right, it's very simple (didn't think I needed notes!) - simply add the menu to the system - in Architect go to Tools | Client Options and add the menu strip. Then, to ensure it captures data, you need to add the E1AS_DBOpen script to the DB Open (in the same view) - so that it runs when the user logs in. To find the results - you will find this in Tools | Manage | User Audit - in the SalesLogix client

Author: Mike Spragg - 4/17/2006

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
It's at the top - of this thread or here: http://www.slxdeveloper.com/resources/articles/82/E1-UserAudit.zip

Author: Mike Spragg - 4/17/2006

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
Wolbo - see the other utility - E1 Sync Report.

Author: Mike Spragg - 3/21/2006

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
Wolbo - see the other utility - E1 Sync Report.

Author: Mike Spragg - 3/21/2006

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
Wolbo - see the other utility - E1 Sync Report.

Author: Mike Spragg - 3/21/2006

 
Comment: Re: E1 User Audit
fiogf49gjkf0d
Sam, you need to ensure that you set the DBOpen to the E1AS_DBOpen command - check the bundle for the actual name.

Author: Mike Spragg - 3/21/2006

 
Comment: Re: SalesLogix Synchronization Report
fiogf49gjkf0d
Sorry, I've only just seen these issues. Please send me an email directly (mike.spragg@e1business.com) and, in return, you'll get full instructions plus the required files (sendmail.dll and mswinsck.ocx)

Author: Mike Spragg - 2/24/2006

 
Comment: Re: SalesLogix Synchronization Report
fiogf49gjkf0d
Sorry, I've only just seen these issues. Please send me an email directly (mike.spragg@e1business.com) and, in return, you'll get full instructions plus the required files (sendmail.dll and mswinsck.ocx)

Author: Mike Spragg - 2/24/2006

 
Comment: Re: SalesLogix Synchronization Report
fiogf49gjkf0d
Sorry, I meant fully remove (watch brackets):

dbConn.Execute "INSERT INTO SYNC_REPORT VALUES ('" & left(f.Type,4) & "', " & toMB(f.size) & ", convert(datetime, '" & f.DateLastModified & "',103))"

to

dbConn.Execute "INSERT INTO SYNC_REPORT VALUES ('" & left(f.Type,4) & "', " & toMB(f.size) & f.DateLastModified & "')"

Author: Mike Spragg - 2/7/2006

 
Comment: Re: SalesLogix Synchronization Report
fiogf49gjkf0d
Ryan's correct - the conversion is added for the UK only - so, for US, simply remove !

Author: Mike Spragg - 2/7/2006

 
Comment: Superb !
fiogf49gjkf0d
Well cool utility !

Author: Mike Spragg - 12/5/2002

 
Comment: Speed
fiogf49gjkf0d
Quick it certainly is !!
Ryan - as this is downloadable FOC - could we have a version without the CustomerFX stuff at the end ?? Don't wish to take away the kudos - but would be nice to send to a customer for tracing faults.

Author: Mike Spragg - 12/4/2002

 
Comment: So Cool !
fiogf49gjkf0d
Suddenly, the penny drops ! This idea is going to make new projects in v6 pretty simple. Of course, the opposite of code re-use (code proliferation) is that the breakage of one class/include will break everything else too that relies on it ! At least with the "old" version you could sandbox that effect. Still, must get out of the past and into the future !!! :-)

Author: Mike Spragg - 12/1/2002

 
Comment: Known other workaround
fiogf49gjkf0d
Hi Ryan - I always find it quicker to just slam in a blank password using isql/w or sql explorer e.g.

update sysdba.usersecurity set userpw = '62c3a78ae34a2b0f62' where userid = 'ADMIN'

Still, nice for the uninitiated !

Author: Mike Spragg - 11/28/2002

 


 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2018 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 12/16/2018 4:47:35 PM