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
