Topic Options
#58796 - 10/01/18 07:49 AM GridView Views & Console
GT Offline
Adagio Virtuoso

Registered: 08/14/03
Posts: 626
Loc: Antigua
Is there a way to get a GV view to run automatically like console does for other modules?

A client has a supplier that needs a report to be run and pushed to their platform without intervention from the client's staff. I had some difficulties in getting the full report needed and ended up using a workspace because there were some files not updated or present with the new upgrade for GV as it pertains to composite tables.

I am not sure why a table like OE transactions master wouldn't come with items like Customer name, address and UOM (UOM being sold) since sales are coming from that module which has this information for processing an invoice. Hopefully an upgrade will fix this to ensure that creating views are simpler based on the table being chosen.

But now the problem is getting the report to run and exported as an excel file at a particular time each day.

Let me know if this is possible.
_________________________
Ishana Alexander
Grant Thornton

Top
#58798 - 10/01/18 09:44 AM Re: GridView Views & Console [Re: GT]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Ishana,

Check out "Command line parameters" in the F1-Help. Everything can be automated in GridView without requiring Console. You can easily create the shortcut necessary by using [b]File | Create Shortcut" in GridView.
_________________________
Andrew Bates

Top
#58806 - 10/02/18 01:52 PM Re: GridView Views & Console [Re: Retired_Guy]
GT Offline
Adagio Virtuoso

Registered: 08/14/03
Posts: 626
Loc: Antigua
Thanks Andrew.....with assistance from Pete the export to excel without operator intervention worked beautifully.
_________________________
Ishana Alexander
Grant Thornton

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 50 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30