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
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
