slxdeveloper.com Latest Forum Posts

Re: QueMessage with Attachment

slxdeveloper.com Forums — Sat, 06 Sep 2008 12:11:36 GMT

[QUOTE]Originally posted by Sherri Waite

I have heard of examples of the QueMessage working for attachments but its just not working in my case. Which makes me think that it might be an Outlook version issue. Currently on Outlook Express version 6. Does anyone know if there is an incompatibility issue between Outlook Express v 6 and this QueMessage?

Your replies are much appreciated.
Sherri
[/QUOTE]
Sherri,
I believe you answered your own question:
Outlook Express
SalesLogix is "friendly" with "full" Outlook but guarenteed to work with Express....

View Post | Reply | Quote | View Thread

Posted by: Bob (RJ)Ledger on Saturday, September 06, 2008 7:11:36 AM
Forum: SalesLogix Scripting & Customization

I got Erro Deployselected in SaleslogixWeb7.2

slxdeveloper.com Forums — Sat, 06 Sep 2008 10:15:40 GMT

To,
The Devlopment Team I am new to saleslogix Web.When I was Trying to buildweb sucess .Thenafter I was trying to deploy Selected It"s show an Error
An error Occured Iis Server unable to find Localhost make sure Portnumber and Meachine name.

Please helpme how to rectify this.

View Post | Reply | Quote | View Thread

Posted by: venkat on Saturday, September 06, 2008 5:15:40 AM
Forum: SalesLogix 7.2 Web Client & Application Architect

DialogService window itself is there any possible to call the DialogService_onDialogClosing method

slxdeveloper.com Forums — Sat, 06 Sep 2008 07:58:26 GMT

Hi all,
After closing the DialogService window (using the close icon) the DialogService_onDialogClosing (...) method will fire where we cite in the base form inside it means where we are opening the DialogService window.

Now I want to know that DialogService window itself is there any possible to call the DialogService_onDialogClosing method.

Thanks
Elamparithi.C

View Post | Reply | Quote | View Thread

Posted by: Elamparithi.C on Saturday, September 06, 2008 2:58:26 AM
Forum: SalesLogix 7.2 Web Client & Application Architect

Re: Which Tables hold Teams

slxdeveloper.com Forums — Fri, 05 Sep 2008 20:27:48 GMT

I'm on v7.0.1 but I would imagine this will still work for you:

SELECT info.UserName, code.Seccodedesc
FROM SLXFixed_Prod.sysdba.userinfo info
inner join SLXFixed_Prod.sysdba.Secrights rights
on info.userid = rights.accessid
inner join SLXFixed_Prod.sysdba.Seccode code
on code.seccodeid=rights.seccodeid
where code.seccodetype='G'
and Seccodedesc='Insert Group Name'

View Post | Reply | Quote | View Thread

Posted by: Ian Fitzpatrick on Friday, September 05, 2008 3:27:48 PM
Forum: SalesLogix Scripting & Customization

Which Tables hold Teams

slxdeveloper.com Forums — Fri, 05 Sep 2008 18:08:33 GMT

I am using SLX 7.2.1 and for the live of me I cannot figure out how to find out via SQL who belongs to a team.... is there away to query which users belong to team A or B etc?

Thanks !

Chip

View Post | Reply | Quote | View Thread

Posted by: Chip on Friday, September 05, 2008 1:08:33 PM
Forum: SalesLogix Scripting & Customization

Re: URL in a DataGrid

slxdeveloper.com Forums — Fri, 05 Sep 2008 17:28:12 GMT

[QUOTE]Originally posted by Nick Hollis

Hi Ryan,

I thought it could be done that way - just couldnt figure out which format string to use! I changed it to custom smart part and did in ASP.NET instead

Cheers,
Nick[/QUOTE]

Maybe that is what the difference is. I didn't use a format string per-se, but used the FormatMethod for this. You basically get to create a code snippet where the value is passed in and you format it however using C# code. So I just used string.Concat to append the necessary values together to create the complete URL and that is what showed in the grid.

View Post | Reply | Quote | View Thread

Posted by: Ryan Farley on Friday, September 05, 2008 12:28:12 PM
Forum: SalesLogix 7.2 Web Client & Application Architect

Missing Lookup in Menu

slxdeveloper.com Forums — Fri, 05 Sep 2008 17:16:17 GMT

In SLX 5.2 LAN, there is a missing custom lookup in the lookup menu. It was there for years, then recently dissapeared for everyone.

We tried rereleasing it in Architect, updating it, even deleting and recreating it, but it still won't show up in the client. Is there some sort of "delete the cache" operation for Legacy that I'm not remembering?

View Post | Reply | Quote | View Thread

Posted by: Dan Carvin on Friday, September 05, 2008 12:16:17 PM
Forum: Legacy Development

Re: QueMessage with Attachment

slxdeveloper.com Forums — Fri, 05 Sep 2008 15:56:35 GMT

I have heard of examples of the QueMessage working for attachments but its just not working in my case. Which makes me think that it might be an Outlook version issue. Currently on Outlook Express version 6. Does anyone know if there is an incompatibility issue between Outlook Express v 6 and this QueMessage?

Your replies are much appreciated.
Sherri

View Post | Reply | Quote | View Thread

Posted by: Sherri Waite on Friday, September 05, 2008 10:56:35 AM
Forum: SalesLogix Scripting & Customization

Re: Can a custom table be created with VB Script

slxdeveloper.com Forums — Fri, 05 Sep 2008 15:25:26 GMT

Thanks for the update. Even though it took hours to recreate the tables, it took less time than I spen trying to automate it. I am just always trying to find a faster and easier way to do everything. It would have been nice if it worked. Then the reuse factor would have been worth the effort. Win some, lose some.

View Post | Reply | Quote | View Thread

Posted by: Lawrence Reid on Friday, September 05, 2008 10:25:26 AM
Forum: SalesLogix Scripting & Customization

Re: Can a custom table be created with VB Script

slxdeveloper.com Forums — Fri, 05 Sep 2008 15:17:04 GMT

Using the enable function like that does not do all of the set up you need. It does populate the sectable and resynctabledefs table entries but the error message you are getting is because the resynctabledefs table must have the keyfield attribute set. You can use a tsql script like this:

update resynctabledefs set keyfield = 'CustID' where tablename = 'CustFinancials'

As others have suggested, I would not recommend you try automating the table creation script the way you have. I have noticed that some other things like the UTC date flag in the sectabledefs are not honored for fields in tables enabled in the fashion you have.

I would suspect the issue of not being able to tie to the Account table is due to missing information in the JOINDATA table.

View Post | Reply | Quote | View Thread

Posted by: Kris Halsrud on Friday, September 05, 2008 10:17:04 AM
Forum: SalesLogix Scripting & Customization

Re: QueMessage with Attachment

slxdeveloper.com Forums — Fri, 05 Sep 2008 14:43:57 GMT

Just a thought Sherri, but would it work if you used CDO instead to send the message?

View Post | Reply | Quote | View Thread

Posted by: Paul Cannon on Friday, September 05, 2008 9:43:57 AM
Forum: SalesLogix Scripting & Customization

Re: Error while bulding Web Platform

slxdeveloper.com Forums — Fri, 05 Sep 2008 12:56:02 GMT

Hi Nick, thanks for your reply.

Finally i gave up and start all over again in a new Virtual Machine, because i tried diferent thing with no success. Of course i didn't tried what you told me but thanks anyway.

John

View Post | Reply | Quote | View Thread

Posted by: John on Friday, September 05, 2008 7:56:02 AM
Forum: SalesLogix 7.2 Web Client & Application Architect

Re: QueMessage with Attachment

slxdeveloper.com Forums — Fri, 05 Sep 2008 11:55:33 GMT

I beleive that the issue is that BasicFunctions.QueMessage basically invokes a MailTo: command, which does not actually support attachments. It's not really a SLX issue. You will find many people perplexed by MailTo and attachments if you google it, because it doesn't pop an error, but it doesn't support it either.

View Post | Reply | Quote | View Thread

Posted by: John Foster on Friday, September 05, 2008 6:55:33 AM
Forum: SalesLogix Scripting & Customization

Re: Converting from embedded .net user control to .NET Extension woes...

slxdeveloper.com Forums — Fri, 05 Sep 2008 10:33:11 GMT

The problem I have been having with updating existing binaries is that the .NET Extensions Manager does not seem to update only dependencies. As I have created a wrapper component around my .NET user control, changing just the user control would not result in the binary being updated.

I have resolved this by removing the wrapper component and instead have implemented a com visible class within my .NET user control.

I have had to amend the "jumpto" feature to use KeyDown rather than PreviewKeyDown as the PreviewKeyDown event does not get raised when emdedding the .NET user control within an SLX Form.

View Post | Reply | Quote | View Thread

Posted by: john on Friday, September 05, 2008 5:33:11 AM
Forum: SalesLogix .NET Extensions

Re: GroupTranslator.dll possible cause of block in customer web portal (hang)

slxdeveloper.com Forums — Fri, 05 Sep 2008 09:21:09 GMT

Have you checked grouptranslator.dll is the correct version? It sounds odd that a standard dll would cause this unless there is a) something wrong with the server, or b) a group in the database that is causing issues. Have you tried using a different (perhaps Eval) customer portal on the same server? It might be worth trying just to eliminate it being data related...

View Post | Reply | Quote | View Thread

Posted by: Nick Hollis on Friday, September 05, 2008 4:21:09 AM
Forum: SalesLogix 7.2 Web Client & Application Architect

Re: URL in a DataGrid

slxdeveloper.com Forums — Fri, 05 Sep 2008 09:18:02 GMT

Hi Ryan,

I thought it could be done that way - just couldnt figure out which format string to use! I changed it to custom smart part and did in ASP.NET instead

Cheers,
Nick

View Post | Reply | Quote | View Thread

Posted by: Nick Hollis on Friday, September 05, 2008 4:18:02 AM
Forum: SalesLogix 7.2 Web Client & Application Architect

Re: Error while bulding Web Platform

slxdeveloper.com Forums — Fri, 05 Sep 2008 09:16:07 GMT

Hi John,

Ouch, I recall having this one - I killed App Architect while it was building because it was taking too long, and it apeared to corrupt the VFS somehow.

Try closing App Architect, renaming the C:\Documents and Settings.....Application Data\Sage, to Sage_Old, then logging back in.

Now might be too late...but its a good idea to backup your VFS table at regular intervals - in case you do get a corruption, its very easy to restore the old VFS table....

SELECT * INTO VFSBAKTODAYSDATE FROM VIRTUALFILESYSTEM.....

Let me know how it goes.

The fact that the Eval VFS doesnt work suggests somethings gone awry on the build PC - not your VFS which is good news

Cheers,
Nick

View Post | Reply | Quote | View Thread

Posted by: Nick Hollis on Friday, September 05, 2008 4:16:07 AM
Forum: SalesLogix 7.2 Web Client & Application Architect

Re: Opportunity Products Add Grid

slxdeveloper.com Forums — Fri, 05 Sep 2008 09:09:08 GMT

Im not sure if this has changed in service pack 2, but the update methods duidnt contain parameters for the new columns - I had to create a sqldatasource manually:

And use this as the grid source. But it may be possible now.....havent tried since sp1.

View Post | Reply | Quote | View Thread

Posted by: Nick Hollis on Friday, September 05, 2008 4:09:08 AM
Forum: SalesLogix 7.2 Web Client & Application Architect

Re: Opportunity Products Add Grid

slxdeveloper.com Forums — Fri, 05 Sep 2008 00:32:42 GMT

I am trying to add 2 columns to this datasource, by pointing to the database, can i be able to continue using the select, update and delete methods?

View Post | Reply | Quote | View Thread

Posted by: Jorge on Thursday, September 04, 2008 7:32:42 PM
Forum: SalesLogix 7.2 Web Client & Application Architect

Re: QueMessage with Attachment

slxdeveloper.com Forums — Fri, 05 Sep 2008 00:07:36 GMT

Where is the variable strAttachment declared?

Phil

View Post | Reply | Quote | View Thread

Posted by: Phil Parkin on Thursday, September 04, 2008 7:07:36 PM
Forum: SalesLogix Scripting & Customization

Re: QueMessage with Attachment

slxdeveloper.com Forums — Thu, 04 Sep 2008 22:47:37 GMT

Did not matter what the name was. I have used GIF, JPG, PDF, and DOC and none of them were attached. I tried copying it and do it straight from the drive, as well. Thanks for the suggestion. Sherri

View Post | Reply | Quote | View Thread

Posted by: Sherri Waite on Thursday, September 04, 2008 5:47:37 PM
Forum: SalesLogix Scripting & Customization

Re: Failed to parse SQL

slxdeveloper.com Forums — Thu, 04 Sep 2008 20:46:53 GMT

Fixed it.

I recycled code on the main form that launched my view. The datamode was being set there and fouling up my ADO. As soon as I removed that line it worked without error.

View Post | Reply | Quote | View Thread

Posted by: Marc Johnson on Thursday, September 04, 2008 3:46:53 PM
Forum: SalesLogix Scripting & Customization

Re: Adding field to opportunity_product

slxdeveloper.com Forums — Thu, 04 Sep 2008 20:41:15 GMT

I need it in the record set to perform the calculation; but I also need to have the calculation field update if the record changes (i.e. Selecting a different price level, updating the discount %). I believe that Kris's suggestion will work, I just have not had a chance to fully implement it as of yet.

View Post | Reply | Quote | View Thread

Posted by: Corey on Thursday, September 04, 2008 3:41:15 PM
Forum: SalesLogix Scripting & Customization

Re: Failed to parse SQL

slxdeveloper.com Forums — Thu, 04 Sep 2008 20:30:36 GMT

I've used this code before (thanks to of Ryan) without problems. Using the Profiler is a great idea though. Everything looks good but maybe the profiler will give me some clues.

View Post | Reply | Quote | View Thread

Posted by: Marc Johnson on Thursday, September 04, 2008 3:30:36 PM
Forum: SalesLogix Scripting & Customization

Re: Adding field to opportunity_product

slxdeveloper.com Forums — Thu, 04 Sep 2008 20:25:41 GMT

What database field is this new ProductProgram field being stored to in Opportunity_Product.....or do you simply need it in the recordset for your calculation?

View Post | Reply | Quote | View Thread

Posted by: RJ Samp on Thursday, September 04, 2008 3:25:41 PM
Forum: SalesLogix Scripting & Customization

Re: QueMessage with Attachment

slxdeveloper.com Forums — Thu, 04 Sep 2008 20:21:39 GMT

How about ABC.txt instead of ABC?

It has been awhile (2004) but we used to do this all of the time.....

View Post | Reply | Quote | View Thread

Posted by: RJ Samp on Thursday, September 04, 2008 3:21:39 PM
Forum: SalesLogix Scripting & Customization

Re: Can a custom table be created with VB Script

slxdeveloper.com Forums — Thu, 04 Sep 2008 20:17:13 GMT

AND you'll have to have the correct FieldIndex and FieldOffset in SecTableDefs.....
AND.....

This is asking for BIG trouble.....

OK to create SQL tables for eventual Insert/Update into a SLX Table that itself was created in the DB Manager .....otherwise.....

all bets are off

and Your Mileage Will Not Vary.....

View Post | Reply | Quote | View Thread

Posted by: RJ Samp on Thursday, September 04, 2008 3:17:13 PM
Forum: SalesLogix Scripting & Customization

Re: Failed to parse SQL

slxdeveloper.com Forums — Thu, 04 Sep 2008 20:12:44 GMT

Personally I open up a Connection. Open up a RecordSet for that Connection, and then populate the recordset.
You are setting the connection for a RecordSet.....I've always set it the other way around.

DIM CN, RS
create the CN, Application.GetNewConnection
Create the RS,
RS.OPEN SQLstatement ,CONNECTION

I use .BOF, .EOF instead of RecordCount = 0....

.Fields("FeeDate").Value = dateFeeDate.DATETIME ?????

What happens in SLX Profiler?

What version of SLX?

is txtFeeAmount a legitimate number or does it have '$' and ',' in it?

View Post | Reply | Quote | View Thread

Posted by: RJ Samp on Thursday, September 04, 2008 3:12:44 PM
Forum: SalesLogix Scripting & Customization

QueMessage with Attachment

slxdeveloper.com Forums — Thu, 04 Sep 2008 20:04:54 GMT

Trying to add an attachment to the QueMessage Call. Have tried several ways to include the following which is similiar to the Attachment Support in a SLX 7 database.

Dim Shell
Dim ShellEnv
Dim strAttach
Dim FSO

Set FSO = CreateObject("Scripting.FileSystemObject") 'DNL
Set Shell = CreateObject("WScript.Shell") 'DNL
Set ShellEnv = Shell.Environment("PROCESS") 'DNL

strAttach = FSO.GetFolder(ShellEnv("TEMP")) & "\" & "ABC" 'DNL
FSO.CopyFile strAttachment, strAttach
Application.BasicFunctions.QueMessage strEmail, strCCEmail, "", strSubject, strHTMLBody, strAttach

FSO.DeleteFile(strAttach)
Set Shell = Nothing
Set ShellEnv = Nothing
Set FSO = Nothing

Where I copy the desired file into a dummy file named "ABC". The Outlook email pops with desired email addresses and body but no file attached. I have tried UNC file structure along with Saleslogix Attachments. I would like to pull one file off the drive and email it out.

Does the email body support HTML formatting. I have the tags but it seems to be straight text going out. Just a side note.

Your direction will be greatly appreciated.
Sherri

View Post | Reply | Quote | View Thread

Posted by: Sherri Waite on Thursday, September 04, 2008 3:04:54 PM
Forum: SalesLogix Scripting & Customization

Failed to parse SQL

slxdeveloper.com Forums — Thu, 04 Sep 2008 19:57:41 GMT

I'm not sure why this is failing. I've put msgboxes on all the values and everything looks good but I still get a failure to parse:
======================
sub InsertUpdateData
dim rs, strSQL
Set rs = CreateObject("ADODB.Recordset")
strDCFeeID = Application.BasicFunctions.GetIDFor("DCFEES")
strSQL = "Select * from DCFEES where DCFEESID = '" & strDCFeeID & "'"

With rs
Set .ActiveConnection = Application.GetNewConnection
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockOptimistic
.Open strSQL

if .RecordCount = 0 then
.AddNew
.Fields("DCFEESID").Value = strDCFeeID
.Fields("ACCOUNTPRODUCTID").Value = txtAccountProductID.Text
.Fields("CreateUser").Value = Application.BasicFunctions.CurrentUserID
.Fields("CreateDate").Value = NOW()
End If

.Fields("ModifyUser").Value = Application.BasicFunctions.CurrentUserID
.Fields("ModifyDate").Value = NOW()
.Fields("FeeType").Value = pklDCFees.Text
.Fields("FeeAmount").Value = txtFeeAmount.Text
.Fields("FeeDate").Value = dateFeeDate.Text
.Update

.Close
End With
Set rs = nothing
End Sub

View Post | Reply | Quote | View Thread

Posted by: Marc Johnson on Thursday, September 04, 2008 2:57:41 PM
Forum: SalesLogix Scripting & Customization