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
|
|