1 reply to this topic

[Frank Coppola]

Can anyone give me an easy way to automatically call excell from the pro-iv 4.6 client and import a csv file. Here is what I did so far:
In the Proiv.ini file I set up my report editor to be Excel. Then I put the file type to be csv. I changed my spool to be CRT:OUTFMT= D which produced the comma seperated file. The problem of course is having excel as the report editor when I an not using CRT:OUTMT=D.

Is there a way to change the report editor conditionally or issue a client command from the unix server to call excel with the file I am creating?

Also the CRT:OUTFMT=D puts the minus sign on negative numbers after the number. Excel sees this as an alpha field rather than a negative number, does anyone have a solution for this? Obviously I'm not an Excel user.

Thanks in advance,

Frank

[DARREN]

The ability to change the client report editor dynamically is a known issue and I am aware that is on the PROIV enhancement requests lists. There are, however, alternative solutions. These are all available in PROIV version 5.5.

If the data that is being sent to the spreadsheet is not to large i.e. Kb's as apposed to Mb's you could use DDE. The PROIV demo's provide good examples on how to do this (see the demo function DM_SP12). There are other demo functions in the Timesheet sample application that is also included as part of the demo software.

The second method is to write the data as an ASCII file on the server and then use a powerful command called CLIENT.SEND to then send the file to the client. The "SEND" "method" as it is known is one of many client methods that have been introduced. Further examples are RECEIVE, EXECUTE , PRINT. They are logic commands and are therefore implemented as part of a PROIV function like any other logic command. Again the demo functions provide examples of these.