Sounds like they don't know how to setup the ODBC to your system. And they would have to know how to get only the specific data they wanted (date range, etc). Might be a bit much without you walking them through it.
Good luck! :) Best Regards, Caryl Lange Programmer/Business Analyst HME 14110 Stowe Drive Poway, California 92064 phone: (858) 646-8806 fax: (858) 535-6094 mailto:cla...@hme.com Visit our website: www.hme.com Avante on Windows/UniData, 9.1.7a way modified and tasty gui, dude -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, April 06, 2010 3:44 PM To: 'U2 Users List' Subject: Re: [U2] VSG view question Yes, the vendor has access to our system but we were only allowing limited access while they were "trying" to connect and retrieve the data. I told them to use ODBC. We'll see how it goes. Thanks for the help, Bruce -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Caryl Lange Sent: Tuesday, April 06, 2010 3:38 PM To: U2 Users List Subject: Re: [U2] VSG view question You created the schema so another program can use ODBC to view the data (in a single sentence). If your vendor is expecting a text or csv type file, you could create that using Excel or Access and send that to her. Or you could skip ODBC all together an create the file using UD. Here, they use the ODBC to bring the data into their tool and then they can manipulate it (this is both good and bad). Generally for reporting purposes. Does your vendor have access to your system? Perhaps rather than trying to make this work, maybe this isn't the best solution for your problem. Best Regards, Caryl Lange Programmer/Business Analyst HME 14110 Stowe Drive Poway, California 92064 phone: (858) 646-8806 fax: (858) 535-6094 mailto:cla...@hme.com Visit our website: www.hme.com Avante on Windows/UniData, 9.1.7a way modified and tasty gui, dude -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, April 06, 2010 3:34 PM To: 'U2 Users List' Subject: Re: [U2] VSG view question That is the part that I am missing: how to create the file? With what tool? Am I supposed to do something in UniData? Or is this a file that is readable from Windows? How do your folks using VB, Excel and Access with the views get the data? Thanks, Bruce -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Caryl Lange Sent: Tuesday, April 06, 2010 3:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] VSG view question I would think she would have to create the file herself using the view you created (or you would have to do it for her). We have folks here using VB, Excel and Access with the views. Best Regards, Caryl Lange Programmer/Business Analyst HME 14110 Stowe Drive Poway, California 92064 phone: (858) 646-8806 fax: (858) 535-6094 mailto:cla...@hme.com Visit our website: www.hme.com Avante on Windows/UniData, 9.1.7a way modified and tasty gui, dude -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, April 06, 2010 2:45 PM To: u2-users@listserver.u2ug.org Subject: [U2] VSG view question Hi All, I installed the VSG software onto our HPUX UniData machine and generated my first view. This is meant for an external vendor to be able to import daily sales. I cannot find much in the way of documentation but with the help that I got last week I was able to run VSG and create the view. When I told our vendor that she could get the data from the view she told me that it is not readable by her. She was expecting a flat-file or cleat text file. This is neither. Obviously, I am missing something more. Can anyone help me or guide to with an example? Thanks, Bruce _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
