Dynamics Community Forum Thread Details

Help with Dexterity 10.0 - output text file

I would really appreciate any help on this.

I need to generate a text file (position) from within Dexterity. I read that there is a "savefile()" function, but you have to write a report and then run the report with the export option.

But I need to produce a text file, with three distinct areas: a header, then detail lines, then a trailer. For example:

HD20100315AARON015

LDINV0003400456.70

LDINV0003503456.86

LDINV0003600788.09

TR00003

There is a header section (HD) with a date and the customer number.

Then detail lines, show each invoice number with document total

And then a trailer line to show there are 3 detail lines.

How would I implement this using Dexterity?

Thank you in advance!

Why do you need to use Dexterity to create this output file?

Why not create a sql view or stored procedure to query this GP data and then save the results to a text file with SSIS or sqlcmd? You could create a sql view for each part of the file (a separate sql view for the header, detail, and footer) and then combined them and save the results to a file.

With the sqlcmd utility you can specifiy the -o command-line option to write the query results to an output file. A problem with using sqlcmd is you need to install sqlcmd.exe on the machine(s) generating the file.

If you are interested in using SSIS to generate a text file w/ headers and footers check out this article:

http://agilebi.com/cs/blogs/jwelch/archive/2008/02/08/adding-headers-and-footers-to-flat-files.aspx

If you need to generate this text file by performing some action in GP then try using VBA to execute the sql rather than Dexterity.

Quick Links