Sage 100

I need to create an automatic VI export for certain records one day prior to the current system date. (no user input!) I've tried a few ideas from the Sage Forum but no luck yet. Anyone done this and want to share?

Write @AlnoorCassim a check to provide the perform logic to do it for you.

OK. I was hoping there was an undocumented date formula I could use., but Perform Logic will be fine.

Could also use Crystal or Access. VI exports are slow.

Let's throw in MS Excel. All these are easy to automate. The choice may be dependant on the final form in which the data is needed.

Cindy, I have been able to create an export that runs automatic, though the key was having someone create a batch file that ran at a specific timeframe. I had a shortcut icon with the following command line. ""c:\sage\Version42\mas90\home""\pvxwin32.exe..\launcher\sota.ini...\soa\startup.m4p -ARG DIRECT UION ron """" KIR VIWI0C auto Ron = user, """" password in this case no password, KIR Company Code, VIWI0C VI Job If you want to try this I will be glad to help, I have done it a few times, you will need a batch file as well and then task manager will run the batch file. Let me know.

Why not use VBScript or something similar? I've attached a file that I used to export things automatically. I'm not particularly proud of this script, and I know there are others in this group who could do better, but this could easily get you started in the right direction.

Goodnesss @AaronClark , I opened the text file and thought I was reading ancient Greek Hieroglyphics. Don't sell yourself short on these skills. Unfortunately, the scripting gift does not come easily for many people so we are stuck in the VI world. Maybe Cindy is one of the fortunate ones..............

Thanks, @JeffSchwenk. You're too kind. Se habla ancient greek, I guess.

@CindyIsche - Perhaps I can summarize for you. Your 1 bank of options is instead of exporting out of V/I, pull the same data via external apps Crystal, Access, Excel, VB Script, SQL Server. If you're able to do this yourself, then you'll have the same feeling of ""that was pretty cool, pretty slick, why was I exporting from VI in the 1st place"" that others have. Or you can engage these others to do this for you. Your other route is to have someone create a pre-import utility (the perform logic @RobertWood referred to) that would automatically set the date selections for you inside the export job prior to doing the export itself, all unattended of course.

Or you might have the feeling of ""Wow! that was sure fast! Why was I exporting from VI in the 1st place?"" My preference is to stay as far away from perform logic as possible unless there is a large incentive otherwise. It's less difficult to find talented script programmers than ProvideX types - maybe harder in a few years. In this case THERE IS A DIS-INCENTIVE with perform logic! Speed! All the mentioned applications can have the date thing automated.

Great ideas. All of them. Ron your idea is brilliant because if you run you report around 11:30 PM it will in effect be the prior date transactions the next morning when you get the file. I have used Visual cut and crytal reports in a very similar manner. Visual Cut is dos batch file scriptable front end for Crystal reports. www.milletsoftware.com.

I'm loving the brain trust!! Thanks all for the answers. Much as I curse VI some days, my client doesn't have Access or SQL, and I don't know VB Scripting. They need the file in DAT format, and there are VI several jobs already built that fall under this new umbrella. I was hoping for something logical on the system date, but it is VI, and that may be enough said! I'll be hitting my dev group up for perform logic.