Syteline: Export To Excel

Hi everyone,

I am trying to write some form script to export a CLM to Excel but tried various code scenario's just cannot seem to get it correct. Does anyone have any sample code on how to achieve this. Step so far include ;

Created Stored Procedure in SQL to return the required results.

Extended existing IDO and added CLM for the Stored Procedure.

Added Button and Event to Form to call Form Script.

Cannot get the Form Script correct to call the Stored Procedure and Export it to Excel.

Your help would be greatly appreciated.

PS: Also if anyone has any really good documentation on Form Script and using the SDK, examples etc. I'd appreciate it.

Find more posts tagged with

UI Design

Accepted answers

Legacy Contributor

Create a new Background Task Definition for your Dataview.

In the Report Options default the DataView to output to Excel and AutoView

On a form place your button and then set an Event Handler on Button Press to Run your Background Task. This is how it is possible.

All comments

Legacy Contributor

I guess I’m not super clear on which your data table is trying to look like. I have, however, worked quite a bit with excell vba & the odbc backend driver for facts 79 to many different things. Something to keep in mind is that you’re not cross working with activeX forms.

I also began writing the api test workbook for Storefront/facts in excel; my point being, there’s always more than one solution with computers.

Shoot me a private message if you’d like to troubleshoot remotely some time

Legacy Contributor

Hi,

I appreciate there is probably more than one way to do this, so as mentioned above, its not a datatable, I have created a StoredProcedure in Excel, and just want to retrieve the records from a Syteline 9 Form Button and then export to Excel using the Form Script Event for the Button in the same way you can right click on a grid and click "To Excel" or even selecting the "To Excel" icon from the toolbar. I just want to be able to do this is code from a button click a form. I'm not sure if I need to create a new IDO, or whether I can just do a dynamic call using the SP! method for Syteline into a collection. It seems that only an IWSIDOCOllection has the method to Export to excel, so I think my question is how do I get my custom stored procedure into a collection to export to excel on a single click of a button on a form ?

Regards

KJ

Legacy Contributor

Facts 79 doesn’t have a right click export to excel option; But maybe you can recreate your stored procedure the be callled using the function name. I really think I may know what you’re trying to do, but I’ve also never heard of Syteline forms either.

Email me @ r.valizan@cfmkc.com if you’d like to try a remote work session to solve it.

Legacy Contributor

Exporting to a CSV seems the quickest:

ThisForm.PrimaryIDOCollection.RecordCapOverride = 0

ThisForm.PrimaryIDOCollection.Refresh()

Dim filename As String = ExpandEnvironmentVariables("%temp% mp.csv")

If ThisForm.PrimaryIDOCollection.ExportCollection(True, filename, False) Then Process.Start(filename)

ThisForm.PrimaryIDOCollection.RecordCapOverride = -1

for the ExportCollection function:

The first boolean parameter is "TabSeparated", speaks for itself.

The last boolean parameter "UncappedQuery" goes wrong for CLMs when set to True; it will do a regular IDO call, not a CLM. So, before exporting, you may want to set ThisForm.PrimaryIDOCollection.RecordCapOverride to any number of records you need to get, or 0 if you want them all (up to the max definede in SystemParameters), and then refresh the collection. Afterwards, i reset the record capping to it's default with -1

Copyright © 2025 Infor. All rights reserved.