Hello, design your own RPC layer thru https with all the credentials you need.
Best. On Mon, Apr 7, 2014 at 12:21 PM, Armando Gonzalez <yomand...@gmail.com>wrote: > Donald: > > I appreciate the response. > > I guess that using a command line interface program could work. I used it > for a local database and it worked perfectly, but the problem is that I'm > not sure how to do it when the original file is in a remote server. Again, > maybe I'm missing something obvious and if I am, I'm sorry. > > I need the downloads from a remote server to be scheduled. That's why I was > thinking about using powershell - I have used it before in scheduling > tasks. I still found your suggestion interesting, but I can't really make > use of it effectively. > > Thank you for your time and advice. I hope you could keep helping me! > > Armando > > -------- Original Message -------- > Subject: Re: [sqlite] Establishing a connection and downloading tables > from an SQLite server > From: Donald Griggs <dfgri...@gmail.com> > Date: Sat, April 05, 2014 5:31 am > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > > Greetings, Armondo. > > Would a simple script invoking the Sqlite3 commandline interface > program<http://sqlite.org/sqlite.html>do what you want? > http://sqlite.org/sqlite.html > > sqlite3 <MyScriptFile > possibly invoked by a cron job, > where MyScriptFile contains something like: > ==================== > .open MyAsteriskDatabaseFilename > .mode csv > .output MyExportFileName.csv <http://myexportfilename.csv/> > SELECT MyDesiredFields FROM MyDesiredTable > WHERE MyConditions > ORDER BY MyDesiredOrder; > .quit > ===================== > > > > > > > On Fri, Apr 4, 2014 at 12:45 PM, Armando Gonzalez ><yomand...@gmail.com > >wrote: > > > To whom it may concern: > > > > I am absolutely new to to the world of SQLite (and SQL in general, to be > > honest, please don't assume any previous knowledge from me) and well, I > > stumbled upon an SQLite issue I can't seem to resolve on my own. > > > > I have an Asterisk VoIP phone server at my workplace. It was installed by > > an external company, and it provides a variety of services, like reports > of > > the phone activity, etc. > > > > It was (and still is) working fine, but one of my colleagues wanted a > > different type of report that the external company wasn't supplying, and > > they wouldn't be able to supply them as he wanted, to be honest. > > > > The external company granted me access to the server's databases, and I > > learnt that they worked with SQLite. The server used a service called > > SQLite Manager to manage the SQLite databases. The manager has an easy > > enough to understand GUI, and I managed to download the table I needed > > manually and produce the wanted reports with software locally installed > in > > my computer. > > > > That's all working fine. The thing is that it would be so much better and > > much more efficient if I could automatically download the needed table to > > produce the reports, because that way I could produce the reports much > > faster and get on with other things I have to do. > > > > I have Google'd how to do it with Powershell and well, I don't really > know > > what I'm doing. I would really appreciate any assistance/guidance if > > possible. > > > > As a quick recap: > > > > I need to automatically download a table from a SQLite database on a > local > > server. > > > > I have access to Visual Studio 2012 and Powershell if any programming is > > necessary. > > > > Anyways, I'm going to leave it at that. > > > > Thank you very much for taking the time to read this and hopefully for > > helping me in the future! > > > > Armando Gonzalez > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
