Hot answers tagged

6

Thanks for the question. I too have spent a lot of time handcrafting reports and was exposed to Tableau when others at a previous employer used it. I downloaded the trial, worked my way through the tutorials and was impressed at how much can be generated, how quickly, with little technical expertise. Of course, there will always be some reports that we have ...


4

Since the sunrise and sunset times are determined by 3 factors, position on the earth in Lat/Long & Altitude, date plus possibly obscuring items like mountains and most services leave out the mountains you rarely need a public API rather than using an Ephemeris library. Depending on which language you are using you will find libraries available for most ...


4

You might want to log to SQLite databases instead of plain text files for the following reasons: SQLite is part of the python standard runtime library. Thus, databases can be created, filled and maintained very easily binary distribution consists of a single (scriptable) commandline executable, the sqlite shell, which can be used to easily query the logs ...


4

You might be able to use: https://www.digitalocean.com/community/tutorials/how-to-install-elasticsearch-logstash-and-kibana-elk-stack-on-ubuntu-14-04 Logstash forwards the logs to the central logging server. Also, rsyslog can be configured to forward to a central store, and cache logs locally with the following config setting: $WorkDirectory /rsyslog/work ...


3

I don't think you have the right approach. You are supposing that an exact clone of Tableau is the best answer. It might not be. Notice that if Tableau (which I don't know and don't care about) was only running on Windows and you'll have been given a Mac (under MacOSX) you'll have a similar problem. And it is not a matter of money (in other words, free ...


3

There is a tool called SelectCompare that allows you to compare two queries. SelectCompare allows to create comparison projects, which define queries against any two data sources that can be connected with OLEDB, ODBC or .NET connectors. The free edition allows to create once comparison project and unlimited number of connections. Here's a screenshot of ...


2

ownCloud Enterprise Edition supports Google, Dropbox, and more. Egnyte HybridCloud supports Google and some other services, but I don't think it integrates with Dropbox DriveHQ proprietary system that only has WebDAV, no integration with Google or Dropbox but allegedly cheaper than Dropbox, and explicitly designed for servers I know I saw another service ...


2

If you are interesting in creating an application that can do this, I reccomend checking out the LEADTOOLS Forms Recognition SDK. This SDK has C DLL and .NET libraries for OMR recognition. The .NET interface includes a forms recognition and processing library for defining a form such as this and processing it. The SDK includes scanning support as well as ...


2

I figured this out by contacting surveygizmo.com's support staff (they're very lovely people, by the way.) I will leave this question open in case anyone is experiencing a similar situation in the future. The answer is surveygizmo's HTTP Connect feature, which allows one to post or get data from an external database or spreadsheet. It is perfect for ...


2

Helium - App Sync and Backup (originally named Carbon) has a gratis version and can do that: Helium (source: Google Play; click images for larger variants) It's quite a while since I last used it – but AFAIR it stored multiple sets for each app. You can decide whether the .apk should be included with backups as well (by default it's not), and setup ...


2

On linux, you might find gnuplot to be useful.


2

Python is quick and easy to learn plus there are domain specific tools for what you are trying to do as a part of the sci-kit learn package including being able to extract a corpus from an on-line source filtering as you go. It may also be worth looking at using an AWS instance to do the processing - thereby avoiding a full hard disk but read the charges ...


2

I would suggest an arbitrary combination of a Windows QR code generator (that can encode arbitrary portions of text) and an Android QR code reader app. I use this combination for exactly the same purpose, for quickly transferring small amounts of data from a PC to a mobile device. The only requirement from the question that is not fulfilled by this is ...


2

Indeed, combining worksheets and databases, simple scripts are more suitable than Power Query. But easy-to-learn and easy-to-use processing scripts are rare. You can try esProc. I have a small example of this, and you can refer to: A1=file("./employee.xlsx").xlsimport@t() A2=DB.query("select ORDERID,SELLERID,AMOUNT from sales") > A2....


2

I've been using EmEditor for years. Can open practically any size file (up to 248GB realistically) and can split CSV and other delimited text into columns. With tons of other features. There's a free version, but if you need it for a company, then I highly recommend getting the lifetime license. https://www.emeditor.com/


2

What about RRDtool? github What RRDtool does RRDtool is the OpenSource industry standard, high performance data logging and graphing system for time series data. RRDtool can be easily integrated in shell scripts, perl, python, ruby, lua or tcl applications. It's fairly old-school, and well-known among sysadmins, but it is not really an SQL database.


1

This is the sort of think that the python data exploration and visualization tool chain Pandas is excellent for - you will have to do a little exploring of the data yourself but you will be amazed at what you can find out quite rapidly. If you would like to go the whole hog of machine learning then there is the SciKit Learn Machine Learning in Python ...


1

There is a python based spreadsheet pyspread that is able to use python code directly in each cell, in fact each cell can contain a complete python program, that you might like to take a look at. But I would also strongly suggest taking a look at Jupyter notebooks. They will let you obtain, store, manipulate, evaluate and present your data in a lot of ways. ...


1

Since there was no answer posted yet, I decided to include it anyway. Currently the best option of achieving that is using Network Connections as Izzy rightly suggested (and I happen to use the same application as well). This app is user friendly can be installed on non-rooted devices as well. After you launch the app, the first thing you will see is ...


1

Ok, from my understanding you want to share easily transfer files between your 2 machines, from a same network which is ( indirectly connected), but have you checked if the networks use the same gateway or is there a network bridge of some sort? In you have same gateway and you are able to ping either machine then simply create a mapped folder where you ...


1

I solved, perhaps, slightly different case with tree representation on Confluence pages with https://bobswift.atlassian.net/wiki/display/GVIZ/Digraph+Macro plugin that can take a table as a source.


1

I found a cool web-app that dose exactly what I am asking, is free and doesn't even require registration... I hope it helps anyone else looking at this question. - http://listmoz.com


1

My company recently started using OFSpro for exactly what you are saying you are in need of. It is a great software for managing field services. The other thing we love about it is that they have an App that makes it super easy to keep up with things that are happening from the office and field. Check it out. You may be surprised on how helpful it is.


1

If your data was captured at regular intervals and you can convert it into this format: { "Channels" : [ // pressure { "Coupling" : 1, "Samples" : [ 1000, 1004, 1007, 1008, 1000, 1008, 1015, 1022, 1030 ] }, // temperature { "Coupling" : 1, "Samples" : [ ...


1

Although this is not a solution for JPEG containers, this illustrates a solution that will work with free Amazon Prime photo storage using a BMP container. "Japanese user YDKK has developed a tool to store arbitrary data inside a .bmp file, which can then be uploaded to Amazon's service. A 1.44GB test image containing an executable file uploaded at over ...


1

I cannot give you a single recommendation here, as I have nothing completely fitting your requirements. But there are several approaches you could take, each requiring a specialized app: Using an automation app to turn-off mobile data whenever you start that app Using a firewall to forbid the app access to mobile data Using an automation app to turn-off ...


1

I think Pryv may meet most of your requirements. Main features Log what you want You can log data (numeric or not) and see numeric as graphs. I also used as a diary for one time. Share what you want You can choose to share some of your Pryv data (let's say your tomatoes harvest) with other users via a URL while keeping other streams private. Automate ...


1

I've tried a couple of solutions for this before, including writing my own Node.js server which redirect calls to a MongoDB table and stores responses as objects. It's easy and simple, but you lack control of about anything. If I would do it today, I would use a Symfony 2 application with the Rest Bundle from Stan Lemon. A Symfony 2 application is quite ...


1

See my (barely on-topic) question JSON test server with regularly updating data The accepted answer works for me. [Update] In fact, I found something which I consider to be far superior to the answer which I previously accepted. Mockaroo lets you generate up to 1,000 rows of realistic test data in CSV, JSON, SQL, and Excel formats. It has 89 predefined ...


1

Short answer: LaTeX will surely stay your friend. You could switch to lualatex to write plugins reading special formatted files. Regarding your CSV-like files, you could use the csvsimple package. Detailed answer discussing alternatives: Very long documents and wrapping make it difficult, to suggest something. Being gone through http://alternativeto.net/...


Only top voted, non community-wiki answers of a minimum length are eligible