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!
|
|
Export Group to csv file without the use of MSFT
Posted: 04 May 07 11:15 AM
|
fiogf49gjkf0d Hi - I need to create a function to allow users to export any list group to a .csv file. The problem being that many of our users access SLX through Citrix and this server does not and will not have any MSFT licenses installed. So the option to Export to Excel is grayed out. Ideally, I would like to give them the ability to create the .csv and save to their hard drive. I tried to create a secure function to accomplish this but keep getting the error "Unknown function number -1". I followed the SLX Help to no avail.
Any suggestions? |
|
|
| |
|
Re: Export Group to csv file without the use of MSFT
Posted: 04 May 07 12:34 PM
|
fiogf49gjkf0d Hi Ryan, thank you for responding so quickly! It seems like launching it is the problem. I added a toolbar button so it could be called from any group. I mirrored the Export to Excel Secure Function naming conventions. The function is created in the SECFUNCTIONS table with an ID of -1. |
|
|
| |
|
Re: Export Group to csv file without the use of MSFT
Posted: 07 May 07 12:46 PM
|
fiogf49gjkf0d I should have mentioned we are running SLX 7.0.1.
File | Export Group to File and Export Group to Excel are grayed out for users who do not have SLX installed locally. They log in through Citrix, as stated previously. And yes, these users have been granted access to these functions through the Administrator. Is there another way to set access to these File Functions? |
|
|
|
Re: Export Group to csv file without the use of MSFT
Posted: 07 May 07 1:17 PM
|
fiogf49gjkf0d Even if you don't have Excel installed *and* you have enabled the export through Admin - there is no reason why File | Export should not be working already. It doesn't rely on Excel to export to CSV - it does it natively. So, this suggests something else is wrong. What happens if you add a button and call Function | File | Export ?? |
|
|
|
Re: Export Group to csv file without the use of MSFT
Posted: 08 May 07 12:44 PM
|
fiogf49gjkf0d This works just fine if SLX is installed locally on the machine. This does not work with our users who log in through the Citrix server. In this case, the button is there but there is no recognition when it is clicked or hovered over - and going back to the original issue - the File menu options for these functions are grayed out. |
|
|
| |
| |
|
Re: Export Group to csv file without the use of MSFT
Posted: 17 May 07 1:19 PM
|
fiogf49gjkf0d Mike - I just read a post of yours on another site (ittollbox) from Oct 2006, "...pretty much hard-coded. During initialisation it determines if office is installed. This then sets a global for interrogation via functions etc. As it can't find it - you're stuffed until SLX make that change for you..." I would guess that the availability of all of these related file functions are relying on this...correct? |
|
|
| |
| |
|
Re: Export Group to csv file without the use of MSFT
Posted: 29 May 07 8:54 AM
|
| Hi Mike - An update re: issue: File|Export to Group function, I submitted a case with Sage and the answer that I rec'd from B.Adamich is as follows: "This is how the program is designed, right or wrong. This would require action to be taken by development. I can submit this as a defect, if it is rejected I can then submit as a feature request. This is little more than what you can already do from our support website. Your best resource at this point would be a knowledgeable Business Partner. They may have a way around this limitation. " It sounds like he's not convinced that this is how the prgm is supposed to work. He is supposed to let me know if this will be fixed in a HF or is rejected. In the meantime, I am back to square one and need to create a secure function to perform this task. |
|
|
|
Re: Export Group to csv file without the use of MSFT
Posted: 29 May 07 9:51 AM
|
Hi Crystal
You are correct - I sent an email to you last week and it failed to get through ! Essentially, I took a VMWare with no office on it and you are correct - it no longer works. However, it *should* work. It got broken in a 6.2 release. I've already raised this with Brian and Mim Dolan and they agree it's a bug and they've put it through to be fixed !
In the meantime, there's no easy workaround - short of loading office. |
|
|
| |
| |
| |
| |
|