I am trying to use the scheduler to output a report to a .csv file for salesforce.com to pickup nightly - is this possible??
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi,
Not directly, no. Jet Reports does not support CSV as an output format from the scheduler. You could create a script to do the conversion something like what is described here: http://stackoverflow.com/questions/1858195/convert-xls-to-csv-on-command-line. Then rather than use the Jet Scheduler, you could add a line to the top of the script to run the report with AutoPilot and schedule the script it in the Windows Task Scheduler. The Jet Scheduler is really just a front end user interface which schedules reports to be run with AutoPilot in the Windows Task Scheduler. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hey Hughes,
I am struggling with the same problem; I really need to save an excel file to either .csv or .xml format for importing it ionto another system.
It would really help if Jet would be able to save files in these formats. I vote for this feature ;)
IS there realluy no other way than the Techie-way? I am not that familiar with coding, so if I don't have to, I won't.
kind regards,
Willem -
Jet Reports Historic Posts Joining the club - requirement needed as of a few hours ago.
Might schedule this report to run and save, and then program another Excel worksheet to open, copy the values from the closed Jet Report, and save as .csv.
I've done most of this already in VBA for another project (updating a Powerpoint presentation on the fly), so if the requirement comes to fruition, I'll share my code. Not sure when though.
If someone needs something in the next few days, and if they are reasonably sufficient in VBA, I don't mind looking into it for them. I do accept cash also #kidding ;) -
Jet Reports Historic Posts Hi Datalore,
I do have some experience with VBA (although I'm a bit rusty ;) ), so if you would be so kind as to give me some directions, that just might be the jumpstart I need :) .
Seems like a workaround that just might dio the trick for me.
It is all about generating 2 (not very complicated) .csv diles from the customer table and the cust.ledger entry table that I need to import in a Credit Management application.
If you would share your code for opening the saved .xlsx and saving it as .csv that would make me a happy man, and would certainly email you some cash :mrgreen:
Kindest regards,
Willem -
Jet Reports Historic Posts Hi Willem,
did you get my PM with link to file for download last Friday evening?
For some reason my PM's have been sticking in 'outbox' and I am not sure if you received my message.
Please sign in to leave a comment.