This laptop has all of my recipes and is a cornerstone for my mixstation. It's going to be a while before I can replace it. In the meantime, I've downloaded a recipe calculator on my android tablet called eJuice Calculator by Berlon Burch. It seems intuitive enough, but copying notes for 200 flavors and 100+ recipes is not a task I'm up for.
There seems to be a way to import csv and db files and I was wondering if there was a way I could do that in the Juice Calculator I'm using. I see that I can export as a juice file or export using excel, but changing default extensions tends to corrupt data.
Please provide exact links to the apps you are using, as well as to the files you are interested in importing/exporting.
I have enough programming chops and experience in format conversion to try and help here. But your post is vague. Where are you exporting from? What are you importing into?
I wasn't being vague. The names of these calculators are vague. This is the one on android. https://play.google.com/store/apps/details?id=com.rdvejuicecalculator.and&hl=en
This is the one on my laptop http://www.diyjuicecalculator.com/
I'm trying to export from my PC to the app, but their CSV formatting is different
This is a guess. It is possible that the file encoding is different on Windows and on Android (Linux) and the apps were not designed to handle it.
But what is probably happening here is that the Android app is expecting a specific order of columns in the CSV file, while the PC app is writing them in a different order. For instance, the android app may expect Column 3 in the CSV file to be milliliters of liquid (which is a number), while the PC app is using Column 3 to write names. Hence the complaint of invalid characters (letters instead of numerals).
Could you post your exported CSV file somewhere? I will try to convert it.
I can't export my flavors and recipes from the desktop app at all. Their formatting is definitely different but I can't get to the importing phase if I can't find out what's going on with this export. I can send you my juice file so you can try to replicate the issue if you're up for it
If it's Excel you need to export again to CSV from *Office. But I doubt that importing it will work out of the box. The android app probably expects the CSV with certain columns. Do you have a sample CSV for import that you can compare with the exported CSV?
Edit: few words
No, but I'm about to put some fake flavors into the android app and export them to get their csv
That should work. Good luck!
The csv format for the app is name,vendor,base,notes,basev,perct,gravity,inventory,count.
I have no idea where to go from here. Juice calculator is saying that I have unusable characters and something about names with more than 31 characters so it's not exporting properly. None of my names have special characters or long names. I'm stumped.
I don't have excel. I'm using some free version of excel called wps spreadsheets.
To sum it up if anybody else tries this: don't use CSV to export / import in this android app at the moment. It can not handle a comma in notes and exports 2 more columns then it imports, which merges the last 3.
Instead export / import as DB. You will get a sqlite3 DB file that can be used like... well like a database.
For export from the PC app we used the XML here. Not sure how the OP got that though.
A little shell scripting voodoo filled the DB from the XML.
I put everything to paper that. Way it will be good unless I lose it.
I have everything backed up to multiple storage lockers. Google drive, mediafire, and dropbox all have a copy.
Good, I'm in the Networking business and it seems like nobody backs up data anymore.
I take screen shots of the recipes, paste them into paint and save them as .png image files. Then I email them to myself, so I can view them anywheres without at any issues.
My recipes are backed up and accessible on android, iPhone, and pc. But I do a lot of tinkering, so the ability to edit recipes is a must. With the help of another user, I have all of my flavors imported on the android app. I just have to put my recipes on it.
Have you considered storing your recipes on a cloud storage service? Dropbox or Google sheets would both be great applications to save your work and be able to access it from anywhere!