paulvollmer / ofxcsv Goto Github PK
View Code? Open in Web Editor NEWopenFrameworks addon for reading and writing CSV(Character Separated Values) Files.
License: MIT License
openFrameworks addon for reading and writing CSV(Character Separated Values) Files.
License: MIT License
Add generated doxygen files to gh-pages branch.
Thank you for this great addon. It's super useful.
Is there a way to sort according to a specific column?
I assume not since I did not see any in the code. But maybe you know of a good reference that I can use to implement it.
I will look around myself too.
Thank you.
I always seem to get 0 when I load the first value of the first row. For example for the following csv file:
20,3,2 2,34,12 293,12,1 39,10,10
using this code:
`
ofxCsv thisCsv;
ofSetLogLevel(OF_LOG_VERBOSE);
if (thisCsv.load("test.csv"))
{
ofLog(OF_LOG_VERBOSE) << "there should not be an 0's below";
for (int i = 0; i < thisCsv.size(); i++)
{
ofxCsvRow thisRow = thisCsv.getRow(i);
int val1 = thisRow.getInt(0);
int val2 = thisRow.getInt(1);
int val3 = thisRow.getInt(2);
ofLog(OF_LOG_VERBOSE) << val1 << "," << val2 << "," << val3;
}
}`
I always get 0 for val1? This is of9.8 windows, 0.20 of the addon
I would like to read an encrypted csv file using this addon:
https://github.com/jkosoy/ofxCrypto
My idea is to hide the file (previously encrypted outside OF) when using my app on an installation.
ofxCrypto encodes strings (md5 or sha1) and buffers using base64.
Now I am reading a plain csv file with ofxCsv and I would like to know how to start to try to do this:
I want to combine both plugins, and to modify ofxCsv to read the csv encrypted file, decode and read the rows/columns.
but I don't know how to manage ofBuffers and ofFile yet...
any help is appreciated.
a function for displaying the csv file.
or need a drawing function an other addon?
I am trying to use this addon on Ubuntu, with OF 0.9.8. I have the following error:
/home/nuc/Documents/Code/openFrameworks/addons/ofxCsv/src/ofxCsvRow.cpp: In member function ‘void ofxCsvRow::trim()’:
/home/nuc/Documents/Code/openFrameworks/addons/ofxCsv/src/ofxCsvRow.cpp:315:50: error: no matching function for call to ‘regex_replace(std::string&, std::regex&, const char [3])’
col = std::regex_replace(col, s_trimRegex, "$1");
Any idea how to fix this?
Seems to be compiling issues with 0.10 latest version. withing the file ofxCsvRow.h
'string'; did you mean 'std::string'
'vector'; did you mean 'std::vector'
It would be really nice if we could load the csv file and get the number of rows for easy processing in loop.
Alternatively a iterators solution may work better for easy looping over the csv.
hey @paulvollmer , thanks for your addon, it's being very helpful!
I am using it to make a time playlist event trigger. I am loading an external file using a space " " as separator and it's working really fine.
Now, after having the file finished, I want to hardcode all the file into the OF ofApp, just to hide the file for unwanted modifications.
my file.csv looks like:
TIME DEV_TYPE ID COMMAND FADE_TIME
2000 RELAY 3 ON
2500 DMX 4 FADE_IN_PAUSE_OUT 2000
3000 RELAY 4 ON
3400 RELAY 8 ON
I am tring to joint all the lines into a string or a vector of string and then to try to use your load function to load the string... but I am not having success! :)
My idea is to not have to use all the addRow, addString methods manually, and just copy paste all lines from the external text editor to OF with something like that:
string myCSVfullString = "TIME DEV_TYPE ID COMMAND FADE_TIME\n2000 RELAY 3 ON\n ...";
I am trying with your
load(vector<string> rows)
method with a push_back for any line too, also trying with commas besides spaces, but without success neither...
any help? or that has not sense for you?
Thanks
Hello,
I'm having trouble compiling on Raspbian (on an RPi 3). I followed the openFrameworks installation guide at https://forum.openframeworks.cc/t/compiling-of-in-raspbian-stretch/27562/15 (using their method 1) successfully, but when I try and make ofxCsv (through a make of a project called Footfall (https://github.com/WatershedArts/Footfall) which names ofxCsv as a dependency) the make fails with the following message:
...
In file included from /home/pi/openFrameworks/addons/ofxCsv/src/ofxCsv.h:33:0,
from /home/pi/openFrameworks/addons/ofxCsv/src/ofxCsv.cpp:31:
/home/pi/openFrameworks/addons/ofxCsv/src/ofxCsvRow.h:45:19: error: 'string' does not name a type
ofxCsvRow(const string &cols, const string &separator=",");
/home/pi/openFrameworks/addons/ofxCsv/src/ofxCsvRow.h:45:39: error: 'string' does not name a type
ofxCsvRow(const string &cols, const string &separator=",");
/home/pi/openFrameworks/addons/ofxCsv/src/ofxCsvRow.h:48:19: error: 'vector' does not name a type
ofxCsvRow(const vector<string> &cols);
...
...
/home/pi/openFrameworks/libs/openFrameworksCompiled/project/makefileCommon/compile.project.mk:358: recipe for target '/home/pi/openFrameworks/addons/obj/linuxarmv6l/Release/ofxCsv/src/ofxCsvRow.o' failed
make[1]: *** [/home/pi/openFrameworks/addons/obj/linuxarmv6l/Release/ofxCsv/src/ofxCsvRow.o] Error 1
make[1]: Leaving directory '/home/pi/openFrameworks/apps/Footfall/Footfall'
/home/pi/openFrameworks/libs/openFrameworksCompiled/project/makefileCommon/compile.project.mk:124: recipe for target 'Release' failed
make: *** [Release] Error 2
I'm using oF version 0.9.8 and gcc 6.3 on Linux raspberrypi 4.9.80-v7+ #1098 SMP Fri Mar 9 19:11:42 GMT 2018 armv7l GNU/Linux.
Any help or information you can give is greatly appreciated.
Thanks!
They are included in the method parameters but not currently implemented?
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.