Sage 100

VI-Export - I want to export items and customers changed today. Seems simple via VI. Here are the steps on the community http://community.sagemas.com/t5/Technical-and-Installation/Visual-Integrate-getdate/m-p/78950#M9294 What am I missing?

Can't do it. I tried similar exports of daily shipments, but discovered that VI expects a literal value, not a formula. Logged a case with Sage and was told same thing. Ended up using Crystal instead.

We've had a similar discussion before: https://90minds-com.socialcast.com/messages/14345125. Exporting from VI = More Pain Than Gain

what is weird is it is working perfectly on a different table at different client.

@AaronClark Thanks for that sad refresher discussion.

Use Explore view of customers, select edit, column settings, uncheck what you don't want, click the Add button scroll down and pickup the Date Updated on the customer file. Then you can export to a file. I just ran this in ABC demo data and looks like it worked great.

@MoiraGoggin The idea is to schedule everyday an auto VI export of just basic info what has changed and then FTP to a Magento website.

Querying the data via ODBC, writing a file and ftping it could all be done from a VBscript you could run from Windows Scheduler.

I may even have a sample here somewhere.

Am working on a similar project now. Using Crystal to build file, Logicity to schedule and generate it and Core FTP to send it. Have others in place that perform this task hourly (importing orders and exporting shipping info at end of day). Using Core FTP due to secure ftp requirements.

To help with @MoiraGoggin's non-automated suggestion, MacroExpress might be an option.

Knowledgesync can also be used to trigger and manage the exports. Especially if the customer has other business automation and alerts needs, this is worth considering.

@RobertWood if you find that sample script I'd love to see it!

@EricAnderson it's not that impressive, but I'll dig it out.

I went the crystal logicity route initially and it worked for a few files but then would never complete for others. I am betting some corruption somewhere. Old Server, lots of data I let it go for 6 hours and gave up. I brought the file locally and imported into Access and found a few bad dates and corrected in the live data. This should be so simple and little time involved to write out 5 files and now has turned into a over budget project!