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!
|
|
v6.2.6 to v7.2.2 - Attachments
Posted: 11 Jun 08 2:55 PM
|
I didn't notice this since I rarely do anything with this form but my users are saying that in v6.2 there was a document type icon visible as well as the document description. There is nothing like that in our v7.2.2 environment.
Is something broke or are they nuts?
I looked to see if the old 6.2 version was still around but it was not, so I couldn't go back to see. |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 12 Jun 08 7:49 AM
|
Hi Marc,
In SalesLogix 6.2 you could see a document type in the Attachment column - this form was one of the ones that you could not access in architect. In 7.0 and above the form has been made available in architect but without the document type in the attachment column.
Cheers,
Steve |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 12 Jun 08 7:58 AM
|
Steve,
Thanks for the info. That stinks that they removed that feature though. I appreciate that it's customizable now but now I'll have to figure out how to give them that info again.
Marc |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 12 Jun 08 11:32 AM
|
Hi Marc,
You will need the Image column type in the attachment datagrid. The Sales Dashboard Detail view does a similar sort of thing for Activties i.e showing the calls, meeting, to-do and personal activity icons respectively.
Cheers,
Steve
|
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 18 Jun 08 10:28 AM
|
The more I deal with this the more mad I am that Sage replaced the more functional form with a much weaker replacement, even if it is customizable now. That suggests to me that it went out half-baked.  |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 18 Jun 08 12:06 PM
|
What other features are missing?
I am VERY happy it is customizable and dont know of any missing functionality other than the icon. Given a choice I would choose the ability to customize over havving the icons without hesitation.
Timmus |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 18 Jun 08 12:27 PM
|
Perhaps it's just our system but it's also considerably slower than the previous version too.
Don't get me wrong, i like that it's customizable, though we have no need to customize it (except for the icon). That said, if the icon could have been added, why not? Many of my users have complained about that.
I'm probably just sore in general because I've not been terribly impressed with v7.2.2 stability or speed. Feels like we took a step forward in back-end technology and a step backwards on the user experience. |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 18 Jun 08 12:47 PM
|
Getting the icons related to a file extension is much more difficult (and inefficient) in VBScript than it is with a compiled language or at least that is my impression. I dont think this feature was left out accidentally.
Regarding performance, I suggest running a trace so you can see what queries are taking so long. There are some known issues where foreign keys are excluded or incorrectly accounted for so the entire table (or large recordsets) is loaded into memory on the client. If you see select statements against the attachments table that return more records than they should, let us know and we can trouble shoot.
If you are talking about the LAN product then I have not heard of any stability or performance issues that cannot be resovled. Please dont throw in the towel  .
HTH,
Timmus |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 25 Jun 08 12:41 PM
|
FWIW, I created a SQL view that extracts the last three characters of the filenames (DOC, PDF, MSG, etc.) and added that to the Attachment grids.
Interesting Gotcha, if you add the custom column to ANY postion other than last. the grid breaks and produces errors. So the filetype column is last, and the users can again tell before opening what kind of file it is.
|
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 25 Jun 08 1:59 PM
|
| Thanks, I'll look at doing that. Should be pretty simple. Interesting that it blows up the gird if you move it. I think I'm going to look at rewriting the file size column too, so that it shows in KB or MB instead of just bytes. |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 25 Jun 08 3:38 PM
|
Another option is to use a calculated field. If you make the type numeric you can enter any SQL syntax the provider will parse.
Timmus |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 26 Jun 08 3:11 AM
|
Originally posted by Dan Carvin
FWIW, I created a SQL view that extracts the last three characters of the filenames (DOC, PDF, MSG, etc.) and added that to the Attachment grids.
Interesting Gotcha, if you add the custom column to ANY postion other than last. the grid breaks and produces errors. So the filetype column is last, and the users can again tell before opening what kind of file it is.
|
|
Don't forget that not all filenames a re 3 letters e.g. DOCX with Office 2007 would show as OCX... |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 01 Jul 08 9:46 AM
|
So instead of a simple RIGHT(filename,3) I'll have to write a more complex piece of code to locate the . and return all the letters after it.
Thanks Microsoft. |
|
|
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 01 Jul 08 10:58 AM
|
Dan,
Did you ever have problems with two letter extensions. I know they are rare but they do exist out there. Did you just end up with a dot in the extension then? |
|
|
| |
|
Re: v6.2.6 to v7.2.2 - Attachments
Posted: 02 Jul 08 3:23 PM
|
| A two letter extension would show the dot in the grid column, yes. But that's not a huge deal. The users just want to know if it's a DOC, PDF, spreadsheet or email message. And 99 percent of the time they can tell. |
|
|
|