7/5/2025 2:29:27 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 the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Upgrade to 7.5 now some users cannot export to excel
Posted: 17 Aug 09 2:29 PM
|
We have just recently upgraded to 7.5. This issue is only occurring on some machines but is driving me crazy since we have been waiting for our developers to figure it out. This is my first post and only because I am quite desperate to resolve this issue. I am not a developer so please be kind to me, I am very new at this. I can provide more information if needed.
When a user right clicks to export to excel they receive the following error:
Error: Object does not support this property or method.
When opened in MS script editor the break points to the following line (after -->):
function MailMergeJS_GetFileSize(strPath) {
var i = 1;
if (top.MailMergeGUI) {
try {
i = top.MailMergeGUI.GetFileSize(strPath);
} catch(e) {
// if it failed, we will pretend we are not here...
i = 1;
}
}
return i
}
function MailMergeJS_GetPersonalDataPath() {
if (top.MailMergeGUI)
--> return top.MailMergeGUI.GetPersonalDataPath();
}
function MailMergeJS_ExcelInstalled() {
if (!top.MailMergeGUI)
return false; //If no activeX do not try to use excel
if (xlinstalled == "unknown") {
try {
var xlapp = new ActiveXObject("Excel.Application");
} catch(e) {
xlinstalled = false;
return false;
}
xlinstalled = true;
}
return xlinstalled;
}
function MailMergeJS_GetUserPreference(strName, strCategory) {
return getFromServer(this.IBUrl + 'userpref&prefname=' + strName + '&prefcategory=' + strCategory);
}
MailMergeJS.prototype.GetFileSize = MailMergeJS_GetFileSize;
MailMergeJS.prototype.GetPersonalDataPath = MailMergeJS_GetPersonalDataPath;
MailMergeJS.prototype.ExcelInstalled = MailMergeJS_ExcelInstalled;
MailMergeJS.prototype.GetUserPreference = MailMergeJS_GetUserPreference;
Any help or suggestions would be greatly appreciated. Thank you.
|
|
|
|
Re: Upgrade to 7.5 now some users cannot export to excel
Posted: 17 Aug 09 2:36 PM
|
What is the error that you are getting?
Since it is working for some and failing for others, I would think it is not a scripting issue, but rather a browser permissions issue.
a) Make sure that all users have the site running under Trusted Site
b) Make sure that the permissions on Trusted Sites allows to Instantiate Objects marked as "Not Safe for Scripting"
|
|
|
|
Re: Upgrade to 7.5 now some users cannot export to excel
Posted: 17 Aug 09 2:39 PM
|
Does it really say this in the code
// if it failed, we will pretend we are not here...
What version of excel? Seems like it's a workstation configuration/integration issue if only a few machines are having it on the exact same workflow? |
|
|
| |
|
Re: Upgrade to 7.5 now some users cannot export to excel
Posted: 17 Aug 09 3:32 PM
|
Umm, just re-read your post, looking for further clarification of the issue:
- Where are the users "Right Clicking"? There is no Right Click/Export to Excel functionality on the SLX Web Client. IE is able to export some tables to Excel and that worked well under the Legacy web client, but it isn't a feature of the SLX Client. So, could you verify if this is indeed what they are doing? Otherwise they should be Clicking on the Groups menu, expanding the "For NAME group" submenu and choosing "Export to Excel(GroupName)" option.
If the users are indeed using the SLX Export functionality, then go ahead and follow up on the steps below, otherwise you may have a training issue on your hands.
- What is the error message that the failing users are getting?
If you have debug on IE turned off, you could still get the error message by clicking on the Icon on the Status bar (on the lower right hand corner).
- When you say ActiveX control is enabled, which setting under ActiveX control? There are several ActiveX control settings to choose and set. I typically reset the Trusted Sites security and then check the permissions.
- Finally, to make sure this is not something following the users, if you go to a machine that has worked previously for a different user and login (to SLX, not to the box) with one of the users having problems exporting to Excel, are they then able to export?
There are certainly other issues around Exporting to Excel. So the question |
|
|
|
Re: Upgrade to 7.5 now some users cannot export to excel
Posted: 17 Aug 09 4:04 PM
|
First of all, thank you so much for answering my post!
On to the info:
- In SLX web 7.5 users are going to contacts, right clicking a group and clicking on export to file (the method you described also generates the following error)
- The error reads (script debugging is enabled):
A runtime error has occurred.
Do you wish to debug
Line: 273
Error: Object doesn't support this property
-I've enabled all the active x controls listed,for testing purposes obviously. Luckily (?), I have a test machine that is having the same issue.
- Finally, I have an account in Saleslogix which I am using to test on all machines. From this acct I can export on a machine that has this function working however, I cannot on my test machine.
I'm wondering if maybe the script breaks at the line:
return top.MailMergeGUI.GetPersonalDataPath();
it may be because slx is having trouble reaching that path? I think it's supposed to be C:\Documents and Settings\%username%\
I don't know what would cause this issue and it may have nothing to do with it...
Thank you so much for your help.
|
|
|
|
Re: Upgrade to 7.5 now some users cannot export to excel
Posted: 17 Aug 09 5:07 PM
|
Check if the user has access to this folder: "C:\Documents and Settings\USERNAME\Application Data\SalesLogix\MailMerge\Temp\"
But the error message is "Object doesn't support this property, and since GetPersonalDataPath is not a property.....
Question: Is this user setup to use SLX ActiveMail? Can you see the "Write" Menu?
The MailMergeGUI object won't exist unless this user is running the SLX ActiveMail components. |
|
|
|
Re: Upgrade to 7.5 now some users cannot export to excel
Posted: 17 Aug 09 5:34 PM
|
Ok, thank you.
The only path I see is the following:
C:\Documents and Settings\USERNAME\Application Data\Saleslogix\Outlook\TempMailDir
Outlook is the only folder beneath Saleslogix.
What exactly is personaldatapath, then? Or why would it stop there (this is just out of curiosity I figure it may come in handy to know what to look for in these cases  )?
Also, the message states:Object doesn't support this property or method. Sorry for leaving that out.
I've tested the account checking the box 'Use active mail this time' when you first login.
I've also tested having only the 'use my settings' checked and checking the box active mail under the general/search options menu.
Also (just because I figured, why not?), I tested with both of the active mail options checked (when you first log in and when you are logged in and go to your general/search options).
None worked.
Also, I went through all of the security settings in IE and compared the pc that is unable to export and the one that is and made sure that they matched completely. I'm now wondering if it's an excel issue...
*sigh*
Thank you, any other suggestions?
|
|
|
|
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!
|
|
|
|
|
|
|
|