Converts an ADO query into an excel file and returns it to the user
Is there any documentation on how to direct the method to a specific smart object?I have a smart object named WellnessSubmissions and I try using the select * from WellnessSubmissions and it returns an error:"Exception has been thrown by the target of an invocation. Error with ADO Query : 'select * from WellnessSubmissions' Msg : SmartObject [WellnessSubmissions] could not be found."
@HardieK2 Try querying against the Smo system name instead.
this control working fine in Smart object testign tool popup coming tosave excel file b
but how we can use this in form i am have added button contol in form on this button click added execute smart object action
but it is not giving file download popup in form but ssame time it is working when i am trying form smart object testing tool
Please help or guide
This rocks! To use it in a Form, have the SmartObject Execute Method output to a File Attachment control on the form. The user will have to click on the File Attachment to download the exported file.
I just came across your comment about extending the ADO to EXCEL service object to export to csv and other flat files.
Can you help out with the extending version of the service object, as I have been looking for something that can deliver Export to CSV and other formats.
Will be really glad if you can respond to this message, as soon as you get this message...if possible.
This is awesome! I could only get it working when connecting to SQL Server databases. Is there any special configuration to make it work with Oracle databases?
I'm querying a SmartObject that was created based on an Oracle View, and it keeps saying there is no List methods on the SmartObject, which is weird, because the SmartObject does have a List method.
Ok, I've just figured it out!
It's an ADO Query Syntax thing. I had to specify the name of the method manually, like this:
SELECT * FROM [SmartObjectName.ListMethodName] WHERE [PropertyName] = '[somevalue]' ORDER BY [PropertyName]
we need keep simple ADO query and we need use SMO internal name in Query
SELECT * FROM <Smartobject Internal name> WHERE PropertyName = 'value' ORDER BY PropertyName
Is there a way i can use this for exporting data from a smartobject built from SharePoint List? If so, Please suggest me on how to achieve it.
May I ask when we use this function, where the file has been saved?
Thank you :)
i have created and tested the smart objects - works
if i add a control to a view/form, when i click control, execute the method
nothing happens - no dialog box comes up to save excel file
What you have to do is very simple.
1. Drag an 'Attachment Control' on the view or form, where you are calling the ADO query.
2. The ADO to excel SmartObject returns an output when used on a view or form. The output is going to be a file, which you then map to an Attachment Control you have made available, from (1) above.
After you pass in the input parameter, which is the ADO query, navigate to the output section of the ADO SmartObject configuration and map the output from your ADO SmartObject to an 'Attachment Control'.
Good luck braddo.
@kolade NAILED IT!
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.