import from CSV take 2
I read through your reasoning on why you don't want to tackle supporting import from CSV. There is no standard, and creating one can be messy, particularly with the details you mentioned. However, the cases, if limited to a two-way split are simple to start and would cover that scenario.
I would expect to download a sample CSV (or my own db from your website), append to it exactly as it is, and reupload it to your parser. If a case isn't covered a quick "we don't understand this line please run us through it can feed back into a db where you can update your code to add support to it based on user inteaction with a modified "add a bill portion"
Some people that can't get it right will be frustrated, and shouldn't be using the "advanced" mode.
You'd be surprised how well we can contribute to your informatics when provided with an efficient avenue. e.g. i prefer text based vim and am far more effective with it than clunking around with a mouse. Heck, I could have an automated script SVN commit my banking CSVs parsing for transfers from my roomate into your database... wait a minute.
Happy coding!
Lev
Thanks for the detailed thoughts! Building an importer is definitely possible, but it just hasn’t been a high enough priority for us yet – only a handful of people have asked for it, and we’re a tiny team (2 developers), so other updates end up taking precedence. We might get to it someday, but I wouldn’t expect it any time soon, unfortunately.
If you’re feeling brave though (and you’re willing to ignore XKCD’s advice), we do have an API you could use for importing! Docs are here: http://dev.splitwise.com. Maybe someone will put a nice CSV import program up on GitHub for the power users :)
-
Bobby Simpson commented
It's been 7 years. Is it possible to develop this feature?
-
Grace Jordan commented
I’ve discovered a platform https://qweetly.com. There is an extensive database of samples of academic papers. No need to spend money to read them.
-
Brijhb commented
Understand this is a forum for splitwise app, but I need to import old txns from another app into this. Trying to use the esecules splitwise-csv importer (https://github.com/esecules/splitwise-csv) But I am stuck at this error...can anyone help, please ?
===========
python groupsplit.py transactions.csv myGroupNameFile "groupsplit.py", line 164
print '\n'.join([str(t) for t in rows[0:2]])
^
SyntaxError: invalid syntax
======================= -
Kathan Shukla commented
Thanks urielmon, I think your script will be very helpful to me.
-
urielmon commented
Hi,
If anyone is interested, I was able to use this great Python script to import my expenses:
-
Jen commented
Most of my bills can be added to an excel format. It would make it so much easier if a format for importing could be developed. Even if it was in a simple format as Date, Subject, How much?
-
Luca Urti commented
SplitWise is a great project with great features. The missing feature is the import through a csv file. You could generate a csv template file and allow it to be loaded into a group.
Those interested in this feature download the template, fill the columns appropriately and upload the file to the appropriate group. If correctly evaluated, the values contained within the file will be loaded correctly.Thank You
-
Vibhav commented
Need a mechanism to import existing expenses from Excel format into splitwise.
-
Pranay commented
Ability to add few items at one go. Say 3 differrent bill items. This can even be done by adding a support to import CSV file in a template. This will be good atleast for group upload.