OldGrantonian 18 Posted October 31, 2010 Share Posted October 31, 2010 I've used Personal Knowbase for many years, so I have many Knowbase notes.Does anyone know whether it's easy to convert these notes to Evernote? Link to comment
Ghalandar 1 Posted December 26, 2010 Share Posted December 26, 2010 Hello;I have decided to switch from Toodledo to Evernote,but I have a rather large problem.I have hundreds of notes in my Toodledo notebook and I want to import them into my evernote notebook.Toodledo has an export option which exports notes in csv format, but I couldn't find any way to import this csv file into evernote.please help me in this situation as my notes in Toodledo are very important and critical for me.Regards;Shahram Link to comment
BurgersNFries 2,407 Posted December 26, 2010 Share Posted December 26, 2010 Evernote does not import csv files.Plus, it's not a to-do manager, although some people have been able to tweak it for their use. Link to comment
Ghalandar 1 Posted December 26, 2010 Share Posted December 26, 2010 I don't want to import Toodledo's To-dos , as you may already know Toodledo has also a simple notebook and I want to import my notes from that notebook. Link to comment
Level 5* jefito 5,598 Posted December 26, 2010 Level 5* Share Posted December 26, 2010 The answer that BurgersNFries gave still holds: Evernote isn't able to import CSV format, at least directly. A third-party application might not be hard to make, as CSV is not hard to parse; a converter to .enex files (Evernote format) seems feasible.~Jeff Link to comment
NX70 0 Posted January 19, 2011 Share Posted January 19, 2011 Hi.I'm having the same problem. Just subscribed to Evernote Premium and want to import all 107 Notes from Toodledo.Do you know if a converter from csv to .enex allready exists?Regards, Carsten Link to comment
MartinPacker 2 Posted January 19, 2011 Share Posted January 19, 2011 A good intermediary would be a tool that converts CSV to HTML (tables). You might be able to import that directly. Tables definitely ARE supported - with some restrictions on tag case etc. If you can't import it directly someone could wrap the HTML to produce a .enex file.Just a thought.Martin Link to comment
MartinPacker 2 Posted January 22, 2011 Share Posted January 22, 2011 FWIW, 55 lines of Python code (half of which was boilerplate strings and quite a bit more was comments and whitespace) got me a .enex built with an HTML table populated from CSV.I suspect the actual requirement is 1 note per CSV row. (I didn't build that as my need is 1 table, if anything.)So, I conclude it's easy to take a CSV and turn it into whatever kind of .enex file you want (and use ENScript to import it).Sadly, I can't share my code - as it would mean jumping through a lot of hoops with my employeer. I just wanted to see if it could be done. And Python's CSV handling made it easy.Martin Link to comment
NX70 0 Posted January 22, 2011 Share Posted January 22, 2011 Hi Martin,thank you for your idea with Python.I've got a super fast answer from Evernote Support how to create some Excel macros to create Evernote compatible files.I will try it tomorrow and if I get the permission I will post it here in the forum.Regards, Carsten Link to comment
MartinPacker 2 Posted January 23, 2011 Share Posted January 23, 2011 @NX70 Excellent, Carsten (if you'll pardon the pun). I'd like to try those out on OpenOffice Spreadsheet and see if they'll work. (I've not written an OOS macro so it'll be an interesting exercise anyway.)Martin Link to comment
NX70 0 Posted January 27, 2011 Share Posted January 27, 2011 "Print #1, .Cells(iRow, "B").Value & "Link : "Print #1, .Cells(iRow, "C").ValuePrint #1, ""Print #1, .Cells(iRow, "E").ValuePrint #1, " Link to comment
klem67 0 Posted January 30, 2011 Share Posted January 30, 2011 Thank you for this article. I am trying to make the macro as described. I have open office. Will that work? Or do I actually have to use Excel. So far I cant get it to work.Thanks again. Klem Link to comment
MartinPacker 2 Posted January 31, 2011 Share Posted January 31, 2011 @klem67 Despite being an OpenOffice,org user I've never written any OO.o macros but I would observe that this looks like particularly simple logic that could be adapted - so long as there's a function to write to a file.(If I had time and energy now - being 8 hours west of home - I'd try it myself. As I'm not far south of Evernote HQ perhaps I should go visit them.) :-)Martin Link to comment
PLitv001 0 Posted December 1, 2011 Share Posted December 1, 2011 Hello,I emailed Evernote Support and with their method all my information is in the body of the new notes. I can't specify tags, created date or title. I would really appreciate it if anyone has any insight. They sent me the following:"Advanced" method for CSV Importing This script is provided as-is, with no additional support. Feel free to login and post to the Evernote Forum at http://forum.evernote.com should you require further assistance in customization.In Excel, create the following Macro (you will need to turn on the Developer tab - search Google for information on how to do that):Option Explicit Sub testme01() Dim iRow As Long Close #1 With ActiveSheet For iRow = 1 To .Cells(.Rows.Count, "A").End(xlUp).Row Open "c:\my documents\excel\test\" & iRow & ".txt" For Output As #1 Print #1, .Cells(iRow, "A").Value Print #1, .Cells(iRow, "B").Value Close #1 Next iRow End With End SubChange the filepath to a real one on your computer - best make it a new directory or you'll have 3000 files sitting somewhere you don't want them to be.If you want all of the columns (or some of them) in a row to appear on the same line, you can rewrite it to be like this:Print #1, .Cells(iRow, "A").Value & .Cells(iRow, "B").Value If you have 20 columns, just keep adding another "Print" line per Column letter, like: Print #1, .Cells(iRow, "C").Value Print #1, .Cells(iRow, "D").Value Print #1, .Cells(iRow, "E").Value Or, you can get fancy, if they all have the same header info format, and make them html, like: Close #1 With ActiveSheet For iRow = 2 To .Cells(.Rows.Count, "A").End(xlUp).Row Open "c:\my documents\excel\test\" & iRow & ".html" For Output As #1 Print #1, "<html> <head> " Print #1, .Cells(iRow, "B").Value & "<br /><br />Link : <a href=""" Print #1, .Cells(iRow, "D").Value Print #1, """>" Print #1, .Cells(iRow, "C").Value Print #1, " </a> <br/> <br /> <br /> " Print #1, .Cells(iRow, "E").Value Print #1, "" Close #1 Next iRow End With End Sub(You'll need to alter this one based on your content - if you don't have a Source URL, you wouldn't need to create a hyperlink, for example.)You can then go to Tools->Folder Import (Windows) to point to the directory of the files (after they've been created) or you can simply drag the folder of files (Mac) onto a Notebook Name in the left-hand Notebook pane, and Evernote will pick them up to import them as individual notes.Here is a sample file that includes the Macro to help you get started.More Advanced: You can also choose to export an existing note to .enex format, and examine the format of the file, then alter this macro to output individual .enex files. If you do that, you can use the Evernote File->Import for Evernote files.Alternately, you can attempt to use the following script created by one of our users:http://markstout.blogspot.com/2009/08/scripting-evernote-in-windows.htmlHope this helps!Big Thanks,Pavel Link to comment
BurgersNFries 2,407 Posted December 1, 2011 Share Posted December 1, 2011 There is no way to specify tags or alter the created date when using import folders or when dragging files into EN. However, you can specify what notebook each import folder should send the file(s) to. When using an import folder, the note title is defaulted to the file name. If you need more info on import folders, please search the board.If you choose to use the enex method, I think tags are assigned upon import, if you've assigned them to each note in the enex file. Link to comment
Rdub 2 Posted February 29, 2012 Share Posted February 29, 2012 Today I threw down for an annual subscription upgrade after being extremely impressed with Evernote. Unfortunately I did this before I learned there is currently no way to import the four years worth of notes I have created in Notespark. This is a HUGE disappointment. I never suspected this would be an issue.I really hope there are plans to address this issue. If not, I'll be cancelling the subscription because there is no way I have time to use two note programs, even if I am just using one for search purposes. PLEASE someone tell me this is going to happen soon...thanks,- r Link to comment
heather 604 Posted February 29, 2012 Share Posted February 29, 2012 There are a few ways out there to import from .csv into Evernote. Contact Support via my signature and we'll help you out. Link to comment
Rdub 2 Posted February 29, 2012 Share Posted February 29, 2012 Thanks, Heather. However I did contact customer support yesterday and was told it isn't possible to do it, and that I should just import it as a .pdf. Importing four years worth of notes as a .pdf isn't a viable option. If there is a particular person I can contact that would be much more helpful...There are a few ways out there to import from .csv into Evernote. Contact Support via my signature and we'll help you out. Link to comment
heather 604 Posted February 29, 2012 Share Posted February 29, 2012 Can you post your ticket number? I'll direct it for you and make sure the agent who told you it wasn't possible is flogged accordingly. Link to comment
Rdub 2 Posted February 29, 2012 Share Posted February 29, 2012 Can you post your ticket number? I'll direct it for you and make sure the agent who told you it wasn't possible is flogged accordingly. Aww, I don't want to get them in trouble, I just want a solution I actually just submitted a new regular ticket about two minutes ago... # 16051-73460 Thanks Heather! Link to comment
heather 604 Posted March 2, 2012 Share Posted March 2, 2012 I was just looking over today's tickets, and noticed that this was another successful import story for our team. Yay! Link to comment
Level 5* GrumpyMonkey 4,320 Posted March 2, 2012 Level 5* Share Posted March 2, 2012 good job!might want to put something on website so people know it is possible. i bet a lot of people never join the forums and certainly don't think to ask. Link to comment
Rdub 2 Posted March 2, 2012 Share Posted March 2, 2012 It's true!! I'm very pleased with the outcome. Thanks to Heather and Allan who really went above and beyond to help me! And I agree with Mr. GrumpyMonkey, it seems like something that would be useful for others in the knowledge base, yes?Three cheers for Evernote's awesome customer service team! Link to comment
galacticdude 0 Posted June 23, 2012 Share Posted June 23, 2012 I just got Evernote and also need to import all my notes from Notespark. There's no info about doing this on the website that I can find. Link to comment
jasvil 0 Posted August 6, 2012 Share Posted August 6, 2012 I also need to import from notespark. I am really surprised there isn't a csv import. It seems so basic, I had assumed it was there. I appreciate that we can get help from support but most of us would perfer to do it oursleves. Is there a way? Can nyone that has gone through it give us the steps? Link to comment
ElCroco 0 Posted August 28, 2012 Share Posted August 28, 2012 Hi all!Being new to Evernote, I'm just trying to get my data back from various other applications into it. All I have is CSV files, resulting from exporting out of Notepad or Upvise, for example. The most important in the first place is importing my to-do lists but I couldn't find any function to perform this: can anyone supply the procedure for importing a list into Evernote?Thanks in advance for any help! Link to comment
Level 5* jefito 5,598 Posted August 28, 2012 Level 5* Share Posted August 28, 2012 You'd need to convert the CSV into something that Evernote can use, like, say, HTML with tables. Try googling for "csv to html table", there appear to be tools out there to do it. Link to comment
ElCroco 0 Posted August 28, 2012 Share Posted August 28, 2012 OK, will try this! Anyway, CSV is kind of universal file format, would be good to be able to import directly CSV file... Missing feature?Thanks again for your help! Link to comment
BurgersNFries 2,407 Posted August 28, 2012 Share Posted August 28, 2012 OK, will try this! Anyway, CSV is kind of universal file format, would be good to be able to import directly CSV file... Missing feature?Thanks again for your help!I'm sure there's a valid reason EN does not import from any file format other than HTML. Additionally, if you can export/parse each note to a txt/ASCII file (one file per note), you can use an import folder to automatically pull in the txt files. One file = one note. You can search the board on import folder, should you want more info. Link to comment
ElCroco 0 Posted August 28, 2012 Share Posted August 28, 2012 Sure! By the way, once I've converted my CSV file to an HTML file, I cannot find any import "HTML file" function in the main menu: where's the magic button there? ;-) Does it work only through an Import folder? Link to comment
Level 5* jefito 5,598 Posted August 28, 2012 Level 5* Share Posted August 28, 2012 Yes, import folder appears to be the way. Link to comment
Mike Wood 139 Posted August 28, 2012 Share Posted August 28, 2012 @EICroco a few questions:How many columns/fields has your CSV got? and number of rows?Could you post an example of one of your notes in CSV format (one row).Are there any attachments does the CSV contain file paths to these?One option might be to import it into excel/word and then create a mail merge to a PDF writer (configured to produce a file per row) Link to comment
ElCroco 0 Posted August 29, 2012 Share Posted August 29, 2012 Hi Mike,The file structure is really straightforward: 6 columns x 25 lines, raw text only, no attachement. Here's an example (EDIT: seems the format is corrupted when copy/paste from the HTML file, I then remove the HTML code and give the original CSV file content):Title,Quantity,Unit,Price,Description,CategoryTube acier D40 interne,1,,,,QuincaillerieGravier,2,tonne,,,MatériauxTravertin,2,,,"250 x 950 + 510 x 1415Tel: 0442047100, 8h00-12h00/13h30-18h00, appeler avant",MatériauxMini niveau à bulle,2,,,http://www.fpv4ever.com/accessoires/521-niveau-a-bulle-.html,OutillageTube flexible 1m,1,,,,ElectricitéMètre ruban adhésif,1,,,,QuincailleriePince crocodile auto,2,,,,AutomobileRayonnages acier,8,,,"H = 2m, largeur à déterminer, Le Bon Coin",Equipements"Plaque ondulée bitumée rouge, 2x0.86 m",3,,8.9,,MatériauxProtecteur de peinture,1,,,"Type Duragloss #105, Finish Kare 1000P",Colles & PeinturesPied à coulisse digital,1,,19.25,M&P,OutillageMèche à centrer,1,,,http://www.metiers-et-passions.com/fr/catalogue/forets-centrer-forme-ahss-din-333/t-o-0004080201-skg.html,OutillageThis is a DIY shopping list and I just want it to stay that simple, adding a checkbox somewhere in the line that allows me to clear the entry...If you know Upvise (list manager), this is exported from Upvise as CSV file and converted to HTML. Going to PDF would add one extra step to a procedure that already looks pretty complicated... :-(Thanks in advance for any help. Link to comment
Mike Wood 139 Posted August 29, 2012 Share Posted August 29, 2012 @EICrocoSo you only have 25 items?If yes do you want to create one note or 25? I'd probably create 1 and add check boxes.Assuming one note and as its only 25 items I'd probably just paste what you have into a new note and just edit out the commas and add a check box to each line. If you had hundreds I would load into excel and export from there into a text document... This would allow you to control the width of columns and re arrange columns... You can also save out of excel as HTML.Key points... Have you got Microsoft Excel?How do you want notes to look?How many notes are you wanting to create? (are you going to combine multiple items into one note) Link to comment
Mike Wood 139 Posted August 29, 2012 Share Posted August 29, 2012 This Excel macro may also help - http://discussion.evernote.com/topic/22187-csv-import-assistance/ Link to comment
ElCroco 0 Posted August 29, 2012 Share Posted August 29, 2012 Hi Mike, @EICroco So you only have 25 items? If yes do you want to create one note or 25? I'd probably create 1 and add check boxes. As explained before, I just want to create lists, the first one (for trial) is my DIY shopping list, which is 25 items. Assuming one note and as its only 25 items I'd probably just paste what you have into a new note and just edit out the commas and add a check box to each line. This is what I did, but the final list looks ugly... If you had hundreds I would load into excel and export from there into a text document... This would allow you to control the width of columns and re arrange columns... You can also save out of excel as HTML. Keep in mind this is my first attempt to import a list into Evernote, other lists may contain tens of items, entering them again would really be a pain... Key points... Have you got Microsoft Excel? Yes, full Office 2007. How do you want notes to look? Would like to get an editable table, which I could sort by name/category/etc. instead of a static piece of text with checkboxes... Ticking the checkbox should grey out the related line or delete it after confirmation. Standard list manager style, see attached file. How many notes are you wanting to create? (are you going to combine multiple items into one note) I don't use the word "note", what I need is (multiple) "lists": food, DYI, todo, etc. Everything should be displayed as list, with a checkbox to clear out any entry in the list (done/purchased/saved...). Is there any chance to use Evernote for this or should I just buy an Upvise license? Thanks for your help! Link to comment
Level 5* jefito 5,598 Posted August 29, 2012 Level 5* Share Posted August 29, 2012 I don't use the word "note", what I need is (multiple) "lists": food, DYI, todo, etc. Everything should be displayed as list, with a checkbox to clear out any entry in the list (done/purchased/saved...).Mike's question is on point: It doesn't matter whether you want to use the word "note" or not -- notes are what Evernote uses. Evernote notes can contain different types of content, including lists. So if you want to store your CSV-based lists in Evernote, you will necessarily be using notes to hold them; the question is whether you will be importing multiple CSV files into a single note, or whether each CSV file will generate a single note. Link to comment
Mike Wood 139 Posted August 29, 2012 Share Posted August 29, 2012 @ElCroco Thanks for the info... To be honest I'm not sure EN is going to work the way you want on its own; you need to work this out first.I suggest you look at another app which links with EN perhaps http://trunk.evernote.com/app/egretlist/iphone Link to comment
ElCroco 0 Posted August 29, 2012 Share Posted August 29, 2012 Fine! The Egretlist application could actually do the trick, but I need an Android version... :-( This will probably end up with a auxiliary app...Thanks anyway to all of you for the help! Link to comment
Mike Wood 139 Posted August 29, 2012 Share Posted August 29, 2012 @ElCroco To inspire you, take a look at this site and it's use of EN to organise tasks etc. There as some great 5 minute videos which show the power of EN very well. http://www.thesecretweapon.org/ Link to comment
phxandy 0 Posted September 13, 2012 Share Posted September 13, 2012 I would also like to formally request that the ability to import a csv file with notes be added to the Evernote program. Link to comment
Stuartve 1 Posted October 23, 2012 Share Posted October 23, 2012 If anyone still needs an answer to this, I've recently made the transition and it was fairly painless thanks to this script for Mac:http://veritrope.com...-file-importer/It imports .csv files into evernote and works really well. You can export a .csv from Knowbase and you'll need to tweak it a little bit in excel and/or word to get all your tags to import properly.Follow these steps:1. Do a search and replace in Knowbase before you export the csv and get rid of all " marks, they mess the script up, I just replaced them ' marks2. If you have multiple tags on each file, open the csv file in notepad or a text editor and replace all the ' marks that surround your tags with " marks, but you only want to affect the ones around your tags so you search for ',' and replace with "," you'll also need to replace all the '" with just a " for the first and last tags3. Open the csv file in excel and change the word 'date' in the top row to an actual date (i.e. 01/01/2010). The other thing excel does is create blank cells for articles that have less tags than the others, this will help the script when importing. Make sure you're still saving a csv from excel.4. Go to the link above and follow the instruction to convert the csv to Evernote. Link to comment
Anthonyqld 0 Posted October 24, 2012 Share Posted October 24, 2012 OK, will try this! Anyway, CSV is kind of universal file format, would be good to be able to import directly CSV file... Missing feature?Thanks again for your help!CSV isn't a universal file format. It's a proprietry Microsoft format. Link to comment
Level 5 Martin Packer 162 Posted October 24, 2012 Level 5 Share Posted October 24, 2012 s/universal file format/widely-understood format/I was going to suggest someone - in their copious spare time :-) - create a CSV-to-ENEX utility. But as the OP mentioned "Android" that probably wouldn't work. Link to comment
Level 5* jefito 5,598 Posted October 24, 2012 Level 5* Share Posted October 24, 2012 CSV isn't a universal file format. It's a proprietry Microsoft format.Utter nonsense. http://en.wikipedia....eparated_values. A quote from that article: "CSV is a common, relatively simple file format that is widely supported by consumer, business, and scientific applications. Among its most common uses is moving tabular data between programs that natively operate on incompatible (often proprietary and/or undocumented) formats. This works because so many programs support some variation of CSV at least as an alternative import/export format.". Also see the referenced: http://tools.ietf.org/html/rfc4180Edit: Martin got there first. Link to comment
Level 5 Martin Packer 162 Posted October 24, 2012 Level 5 Share Posted October 24, 2012 Actually CSV gets you into trouble if it contains formulae. I only recently discovered some importers could tolerate that. Now, I've forgotten the syntax as well as which importers.But a la Titus Andronicus digression over. :-) Link to comment
Level 5* jefito 5,598 Posted October 24, 2012 Level 5* Share Posted October 24, 2012 I would expect CSV to be trouble free if all that you're asking of it is to replicate a flat database:: take a line of values and jam it into a database row, no problem. Once you get into trying to interpret the content of those values (as with formulas that relate to other members), then you're in murkier waters; really up to the implementor's conventions are. Link to comment
sindizzy 9 Posted October 25, 2012 Share Posted October 25, 2012 I had about 40 memos in my Palm Pre and was able to export them to CSV. Now I had a hard time importing that data into anything on my Galaxy S3. So I sat down for a couple hours and whipped up a program that will take a CSV file and convert it to an ENEX file that is easily imported into Evernote. Its simple and covers most fields and it met my needs. If the community thinks it will be useful i can make it available as freeware. Link to comment
Level 5 Martin Packer 162 Posted October 25, 2012 Level 5 Share Posted October 25, 2012 Sounds interesting - though I don't have the prereq equipment. As a matter of interest, what did you write it in? The standard Android pseudo-java? I'm just wondering what one uses for scripting and light application development on Android. Link to comment
sindizzy 9 Posted October 26, 2012 Share Posted October 26, 2012 Actually I should have mentioned its a Windows app. It assumes you have a CSV file and converts it to an ENEX file. I used the Evernote Windows application to import to my account. It dumps it into an import folder and then you can do whatever you want with it at that point. Link to comment
JasonBryant 0 Posted November 14, 2012 Share Posted November 14, 2012 I had about 40 memos in my Palm Pre and was able to export them to CSV. Now I had a hard time importing that data into anything on my Galaxy S3. So I sat down for a couple hours and whipped up a program that will take a CSV file and convert it to an ENEX file that is easily imported into Evernote. Its simple and covers most fields and it met my needs. If the community thinks it will be useful i can make it available as freeware.You would be my savoiur and bless you if you release it. We have recently moved away from these OLD Palm Treos and Palm hand helds to more modern Phones. Please and THANK YOU!!! Link to comment
JJSmyers 0 Posted November 19, 2012 Share Posted November 19, 2012 I am considering switching to Evernote from Notespark, as I would LOVE to have the offline notes available on my phone. I am gathering that import from Notespark may be "iffy", and need to know whether or not to spend time & money figuring it out. Please reply Heather! Thank you! Link to comment
sindizzy 9 Posted December 20, 2012 Share Posted December 20, 2012 Ok so sorry for being a bit late. Here is the link to the app I createdhttps://docs.google....VmY2RhYmRi/editIt's called CsvToEn and fairly easy to run. just follow the instructions in the menu Help. Let me know of any problems. The app as it stands works for me and is free as in beer.AGP Link to comment
ElCroco 0 Posted December 21, 2012 Share Posted December 21, 2012 Thanks a lot ! I'll try and come back to you soon... Link to comment
ImportantlyMe 0 Posted January 13, 2013 Share Posted January 13, 2013 Awesome! Thanks :-)Just one thing I'm struggling with....My CSV file has multiple tags (exported from Diigo). The App imports all of them as one single tag...Can it be done as multiple tags?RegardsJohnOk so sorry for being a bit late. Here is the link to the app I createdhttps://docs.google....VmY2RhYmRi/editIt's called CsvToEn and fairly easy to run. just follow the instructions in the menu Help. Let me know of any problems. The app as it stands works for me and is free as in beer.AGP Link to comment
sindizzy 9 Posted January 13, 2013 Share Posted January 13, 2013 ImportantlyMe, Im not sure what you mean. The CsvToEn app takes one field and one field only for the tag, it does not combine multiple fields. How many tag fields maximum are in your Diigo file (I've never used that system)? Can you post an example of a record from your Diigo file and what you would expect to see in Evernote.AGP Link to comment
ImportantlyMe 0 Posted January 13, 2013 Share Posted January 13, 2013 Sure :-) The records come out in three fields as per attached screenshot, with column three being all the single tags applied to an entry. I have an IFTTT recipe for posting current entries from Diigo to Evernote and that brings over multiple tags. (I do it this way because as mentioned above 'Diigo' has a nice red ribbon to show a page is bookmarked!) Kind Regards John Link to comment
sindizzy 9 Posted January 13, 2013 Share Posted January 13, 2013 ok so how would one of those entries look like in Evernote? Link to comment
ImportantlyMe 0 Posted January 13, 2013 Share Posted January 13, 2013 Hi Attached is screenshot with Note showing three tags Regards John Link to comment
sindizzy 9 Posted January 14, 2013 Share Posted January 14, 2013 oic, there is one field in your CSV that has multiple tags delimited by a space. And each element will get its own tag in Evernote. I think that may be do-able. Let me see what I can come up with. Link to comment
ImportantlyMe 0 Posted January 14, 2013 Share Posted January 14, 2013 Cool Thanks :-)John Link to comment
sindizzy 9 Posted January 26, 2013 Share Posted January 26, 2013 ok I ve made the changes and it is now an option. I made an "Options" tab so just set to your liking. Download CsvtoEn v1.0.0.1 at https://docs.google.com/folder/d/0B6RcZCcts8ceYWY4NTMzZjYtMmI2ZS00NmJiLWE5NTAtOGMyMGVmY2RhYmRi/edit~AGP Link to comment
mmunch51 0 Posted March 27, 2013 Share Posted March 27, 2013 The email response to my request for assitance in converting my Notespark csv notes into a form that can be imported by Evernote, was a script to run in excel. Since I'm a mac user, the only script function I can find is a utility called Apple Script Editor. I don't have a clue on how to use it with the csv file opened in Numbers. Is there information available for those of us with mac's to be able to get our csv notes into Evernote? I was able to migrate from an ipaq to notespark on a mac through third party software, but have been unable to find anything quite so user friendly to get my notes into Evernote. Outside of cutting and pasting each note individually, is there a way for non-programmers to batch process the importing? thanks Link to comment
HorseStapler 0 Posted April 11, 2013 Share Posted April 11, 2013 ok I ve made the changes and it is now an option. I made an "Options" tab so just set to your liking. Download CsvtoEn v1.0.0.1 at https://docs.google.com/folder/d/0B6RcZCcts8ceYWY4NTMzZjYtMmI2ZS00NmJiLWE5NTAtOGMyMGVmY2RhYmRi/edit~AGP Cheers! Before smartphones, and before I came to Evernote, I accumulated almost 1,000 diary entries in a program called Efficient Diary, and I was afraid that I'd have to convert all those entries by hand. Your little program helped streamline that process by quite a bit! One request, though: Evernote's entries have a Date Created field (I believe it's " <created>20130410T152853Z</created> " in the .enex file); can your program give us the option to map a field in the .csv onto that Date Created field? Otherwise, it just assumes that every entry was created on the same day, the day that you ran the conversion program, and that's no good. Link to comment
sindizzy 9 Posted April 11, 2013 Share Posted April 11, 2013 Suppose i could. The problem here is that I believe Evernote wants the data in GMT. The users data can be in other time zones so that can cause some improper conversion if that's important to you. I'll take a look and see how easy it is to add that. I might wait to see if anyone else has other requests. ~AGP Link to comment
HorseStapler 0 Posted April 12, 2013 Share Posted April 12, 2013 Great, thanks! I don't have (or care about) any timestamps at all - I'm just interested in preserving the yyyy-mm-dd. If Evernote asks for more specific timestamps, just tell it that all of my entries were created at noon on whichever date is specified? Link to comment
sindizzy 9 Posted April 13, 2013 Share Posted April 13, 2013 Even then the difference between local and GMT could be off by one day. Anyway post a sample of the exact data that you are parsing so i have an idea of what it looks like. Link to comment
HorseStapler 0 Posted April 13, 2013 Share Posted April 13, 2013 This is WordPad's rendition of a .csv that Efficient Diary exports: Icon,Importance,Date,Title,Content,Normal,4/12/2013,"Diary Entry","This is a test diary entry.",Normal,4/11/2013,"Diary Entry","Here are some new lines, apostrophes, and other special characters:This sentence is on a new line.So is this one. <-tab <-tabI don't ever use contractions. I can't; I won't.The word resumé ends in an accent aigu." After I put that file through your program (assigning "Importance" to "Tags" and "Date" to "Title", just as placeholder assignments), I find that some of those special characters don't quite display correctly, and some of the entries don't seem to display at all, but I'm just interested in getting the Date field and most of the Content to carry over automatically. I figure that I'll have to go back through and do some cleaning by hand. Also, I never really used the Icon, Importance, or Title fields. (I don't really use Tags on Evernote, either. Maybe I should look into them, if they can be used to do anything useful.) Link to comment
sindizzy 9 Posted April 14, 2013 Share Posted April 14, 2013 Ok I see the problem. The tags and titles are both protected by the framework and they will use the special XML character replacement. The content on the other hand ws being created "manually" so it didn't offer that protection and didn't even think about that when i first wrote the app. I've re-coded that routine and now it should work. Let me make some tweaks and I'll upload here within a day or two. Link to comment
HorseStapler 0 Posted April 18, 2013 Share Posted April 18, 2013 How are those tweaks coming? From where I'm sitting, it seems like your conversion script could at some point handle pretty much any .csv a user wanted to throw at it (as long as that file came from a similar Notes and/or Diary program). It also seems like you could pretty easily handle the conversion in the other direction, enex->csv, yes? Link to comment
sindizzy 9 Posted April 20, 2013 Share Posted April 20, 2013 Almost done. Some things I have to consider and test. The dates could be problematic. Yes the script can handle just about any CSV input file as long as it has proper structure. The reverse conversion is possible but a completely different routine. However, the Evernote for Windows application already has an Export function. Link to comment
sindizzy 9 Posted April 22, 2013 Share Posted April 22, 2013 ok CsvToEn v1.0.0.2 is here https://docs.google.com/folder/d/0B6RcZCcts8ceYWY4NTMzZjYtMmI2ZS00NmJiLWE5NTAtOGMyMGVmY2RhYmRi/editPlease take a minute to read the notes about dates in the Help>Instructions menu. Also note that I tested it in Windows 8 x64 and it didn't load. That means either it has a compatibility problem with Windows 8 or the 64 bit environment. I'm willing to bet its just the 64 bit environment as I tested it on Windows 7 x86 and it worked fine. Link to comment
HorseStapler 0 Posted April 23, 2013 Share Posted April 23, 2013 Seems to work okay so far. Better than okay - there were a lot of non-standard newline characters in my .csv (I'm not sure why), and I was afraid that I'd have to go through and convert them by hand, but your program caught them for me. Strange hiccup, though - the conversion process seems to have picked up some of my apostrophes, but missed some others. In some of my converted entries, there are contractions with the apostrophes intact; but other entries are sprinkled with words like "Didnt", even though the apostrophe is right there in the original .csv. And, as far as I can remember, all of those original entries were made by the same program (Efficient Diary). They might have been created on different versions of Windows, though. Anyway, an occasional missing apostrophe is a very minor hiccup, and one that I could easily correct manually. Evernote for Windows DOES have an Export function, but it only works with slightly obnoxious formats that would be difficult to transfer into any other format without the assistance of some third-party script, and I was under the impression that you already had a good portion of the necessary code written into your program. And that your program would be more attractive if it could convert files in both directions. That is, unless Evernote itself starts allowing us to import/export to/from .csv. Anyway, thanks to your program, my 950 old diary entries have been converted almost flawlessly! (AND I can sort/search them by Date.) Cheers! That saved me hours (days, weeks) of tedious data entry. Link to comment
sindizzy 9 Posted April 23, 2013 Share Posted April 23, 2013 Send me a sample of the offending entries to csv _at_ warpengine _dot_com and I'll put them through the debugger. The code written does go from csv to enex but doing the other way does require a completely different routine. writing to XML is different than reading from XML. even though you may know the structure, the code is essentially different. I originally wrote the program for my own memo csv file so not really all that intereted in doing the other way around. I may in the future if i have some time to kill. Link to comment
btocher 0 Posted June 8, 2013 Share Posted June 8, 2013 Hi - I would love to use CsvToEn to allow me to import my Diigo bookmarks, but unfortunately it crashes every time I run it: Is there any information I can give from logs etc that may help point to the problem? Link to comment
sindizzy 9 Posted June 8, 2013 Share Posted June 8, 2013 What OS are you running? I don't think it supports x64. Otherwise send me a sample to the email I posted above. Link to comment
btocher 0 Posted June 8, 2013 Share Posted June 8, 2013 Thanks for the rapid reply. I'm on Windows 7 Home Premium, and - yep - it's x64. Edit: I've a laptop that I can try it on that's not x64. Link to comment
sindizzy 9 Posted June 8, 2013 Share Posted June 8, 2013 That's been a show stopper for me. I develop on an x64 machine but one of the processes on the executable only runs on x86. Let me take a look to see if I can fix that. Link to comment
btocher 0 Posted June 8, 2013 Share Posted June 8, 2013 That's been a show stopper for me. I develop on an x64 machine but one of the processes on the executable only runs on x86. Let me take a look to see if I can fix that. Cool, many thanks. Link to comment
sindizzy 9 Posted June 8, 2013 Share Posted June 8, 2013 ok i just did a test with the newer process and it seems to work with x64. i'm going to compile this and test and probably release within a week. if you have any suggestions let me know. Link to comment
btocher 0 Posted June 9, 2013 Share Posted June 9, 2013 ok i just did a test with the newer process and it seems to work with x64. i'm going to compile this and test and probably release within a week. if you have any suggestions let me know. Wow, that was fast, thanks! Link to comment
ryant17 0 Posted June 13, 2013 Share Posted June 13, 2013 Hello all, I was hoping someone could help me with Importing From Excel into Evernote. I’m not much a programmer (not at all) but I found a thread on there that discusses exactly what I need to do, but I just cannot figure it out. Basically, I created a template in Evernote, and I want to fill in certain fields from that template from Microsoft Excel file. I have a spreadsheet setup, and I would like for every row to become a new note in Evernote, with certain cells populating the specific spots on my note template. I tried exporting my template out and into excel, but I just cannot figure it out for the life of me. If anyone could give me a quick step by step that has done this before I would be so thankful, as I have 10,000 rows of data that I want to turn into notes. Thanks,Ryan Link to comment
sindizzy 9 Posted June 15, 2013 Share Posted June 15, 2013 Don't know anything about templates in Evernote but have you tried the app I developed? I have a link some posts above. Link to comment
ryant17 0 Posted June 15, 2013 Share Posted June 15, 2013 sindizzy, Im running Windows 8 X64, so i downloaded and tried it but it wouldn't work. Thanks for responding. Link to comment
sindizzy 9 Posted June 15, 2013 Share Posted June 15, 2013 ok CsvToEn v1.0.0.3 is available at https://docs.google.com/folder/d/0B6RcZCcts8ceYWY4NTMzZjYtMmI2ZS00NmJiLWE5NTAtOGMyMGVmY2RhYmRi/editthis one works in x64 systems. any problems just let me know. Link to comment
ryant17 0 Posted June 17, 2013 Share Posted June 17, 2013 sindizzy, tried running it on my machine, still doesnt work. Windows box pops up and says program stopped working. Link to comment
sindizzy 9 Posted June 18, 2013 Share Posted June 18, 2013 What version did you download? Link to comment
ryant17 0 Posted June 18, 2013 Share Posted June 18, 2013 I downloaded the version CsvToEn v1.0.0.3 to my machine that runs Windows 8. It wouldnt work. In order to make sure I was doing everything properly, I fired up an old machine and downloaded a previous version, and I could open the program there. This machine is a POS and is about to go down, thats why i cant really use it too much. Link to comment
sindizzy 9 Posted June 20, 2013 Share Posted June 20, 2013 Are you extracting the zip package or running it inside the compressed folder? It will only work if you extract the contents first. Also make sure you have the .NET2 Framework installed at a minimum. Don't believe you need version 3, 3.5, or 4 but wouldn't hurt as many applications nowadays need at least one of those framework versions. Link to comment
renmandfx 0 Posted June 23, 2013 Share Posted June 23, 2013 ditto to sindizzy's comment. Tried both .2 and .3 versions. Win7 Home premiumSP 164 bit op sysi7 Q720 @1.6ghz6GB ramMS .Net 4 Link to comment
sindizzy 9 Posted June 23, 2013 Share Posted June 23, 2013 Not sure I understand. It does work or it doesn't work? Link to comment
renmandfx 0 Posted June 23, 2013 Share Posted June 23, 2013 does NOT work with either the .2 or .3 versions.Get the same "Quite Working" message with both.(got original poster's and your screen name confused) Link to comment
sindizzy 9 Posted June 24, 2013 Share Posted June 24, 2013 OK it doesn't work in x64 but have you tried extracting it first? If you run if from the compressed folder it will not work. You have to uncompress it first. On My Windows 8 x64 I tested it and it works no problem. Link to comment
renmandfx 0 Posted June 24, 2013 Share Posted June 24, 2013 yes, I know all about extracting (60 years old and former comp sci teacher).yes, did extract them bothand still: thbbbbbbbt! from the machine. Link to comment
sindizzy 9 Posted June 25, 2013 Share Posted June 25, 2013 Well let me test on another system. Do you have all the .NET framework versions installed? Link to comment
nomad55 4 Posted July 13, 2013 Share Posted July 13, 2013 I also get the same issue on Win 8x64 when running .v3. I just checked and I've get several versions of .Net installed: 1,1, 2, 3, 3.5 & 4. I also tried running the app as administrator and setting it to run in Vista compatibility mode. By looking through the event logs I managed to find the WER report archive which might help in debugging the issue: Version=1EventType=CLR20r3EventTime=130182055457494780ReportType=2Consent=1UploadTime=130182055459593808ReportIdentifier=01564b0a-ebd7-11e2-beee-00251159e1f3Response.type=4Sig[0].Name=Problem Signature 01Sig[0].Value=csvtoen.exeSig[1].Name=Problem Signature 02Sig[1].Value=1.0.0.3Sig[2].Name=Problem Signature 03Sig[2].Value=51b4d413Sig[3].Name=Problem Signature 04Sig[3].Value=CsvToEnSig[4].Name=Problem Signature 05Sig[4].Value=1.0.0.3Sig[5].Name=Problem Signature 06Sig[5].Value=51b4d413Sig[6].Name=Problem Signature 07Sig[6].Value=1Sig[7].Name=Problem Signature 08Sig[7].Value=12Sig[8].Name=Problem Signature 09Sig[8].Value=System.TypeInitializationDynamicSig[1].Name=OS VersionDynamicSig[1].Value=6.2.9200.2.0.0.256.48DynamicSig[2].Name=Locale IDDynamicSig[2].Value=2057UI[2]=C:\Users\Michael\Desktop\CsvToEn1_0_0_3\CsvToEn.exeUI[3]=CsvToEn has stopped workingUI[4]=Windows can check online for a solution to the problem.UI[5]=Check online for a solution and close the programUI[6]=Check online for a solution later and close the programUI[7]=Close the programLoadedModule[0]=C:\Users\Michael\Desktop\CsvToEn1_0_0_3\CsvToEn.exeLoadedModule[1]=C:\WINDOWS\SYSTEM32\ntdll.dllLoadedModule[2]=C:\Program Files\AVAST Software\Avast\snxhk64.dllLoadedModule[3]=C:\WINDOWS\system32\KERNEL32.dllLoadedModule[4]=C:\WINDOWS\system32\KERNELBASE.dllLoadedModule[5]=C:\WINDOWS\SYSTEM32\MSCOREE.DLLLoadedModule[6]=C:\WINDOWS\system32\apphelp.dllLoadedModule[7]=C:\WINDOWS\system32\ADVAPI32.dllLoadedModule[8]=C:\WINDOWS\system32\msvcrt.dllLoadedModule[9]=C:\WINDOWS\SYSTEM32\sechost.dllLoadedModule[10]=C:\WINDOWS\system32\RPCRT4.dllLoadedModule[11]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\mscoreei.dllLoadedModule[12]=C:\WINDOWS\system32\SHLWAPI.dllLoadedModule[13]=C:\WINDOWS\system32\USER32.dllLoadedModule[14]=C:\WINDOWS\system32\GDI32.dllLoadedModule[15]=C:\WINDOWS\system32\IMM32.DLLLoadedModule[16]=C:\WINDOWS\system32\MSCTF.dllLoadedModule[17]=C:\Windows\system32\guard64.dllLoadedModule[18]=C:\WINDOWS\SYSTEM32\fltlib.dllLoadedModule[19]=C:\Windows\Microsoft.NET\Framework64\v2.0.50727\mscorwks.dllLoadedModule[20]=C:\WINDOWS\WinSxS\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.6910_none_88dc8c812fb1ba3f\MSVCR80.dllLoadedModule[21]=C:\WINDOWS\system32\shell32.dllLoadedModule[22]=C:\WINDOWS\SYSTEM32\combase.dllLoadedModule[23]=C:\WINDOWS\SYSTEM32\SHCORE.dllLoadedModule[24]=C:\WINDOWS\SYSTEM32\profapi.dllLoadedModule[25]=C:\WINDOWS\assembly\NativeImages_v2.0.50727_64\mscorlib\a77d877c214d5c7b4adbe2b8a9da3cf2\mscorlib.ni.dllLoadedModule[26]=C:\WINDOWS\system32\ole32.dllLoadedModule[27]=C:\WINDOWS\SYSTEM32\CRYPTBASE.dllLoadedModule[28]=C:\WINDOWS\SYSTEM32\bcryptPrimitives.dllLoadedModule[29]=C:\WINDOWS\system32\uxtheme.dllLoadedModule[30]=C:\WINDOWS\assembly\NativeImages_v2.0.50727_64\System\572cf15f1c03f8129ef4af72c248a8ae\System.ni.dllLoadedModule[31]=C:\WINDOWS\assembly\NativeImages_v2.0.50727_64\Microsoft.VisualBas#\23718d30efe2e39a1745de518983bf11\Microsoft.VisualBasic.ni.dllLoadedModule[32]=C:\Windows\Microsoft.NET\Framework64\v2.0.50727\mscorjit.dllLoadedModule[33]=C:\WINDOWS\assembly\NativeImages_v2.0.50727_64\System.Drawing\aad149aedd73b35bee3208b976f1edf6\System.Drawing.ni.dllLoadedModule[34]=C:\WINDOWS\assembly\NativeImages_v2.0.50727_64\System.Windows.Forms\417bfcb305172fd47dc89df26eb16f4a\System.Windows.Forms.ni.dllLoadedModule[35]=C:\WINDOWS\SYSTEM32\CRYPTSP.dllLoadedModule[36]=C:\WINDOWS\system32\rsaenh.dllLoadedModule[37]=C:\Users\Michael\Desktop\CsvToEn1_0_0_3\Microsoft.Licensing.Runtime2.0.dllLoadedModule[38]=C:\Windows\Microsoft.NET\Framework64\v2.0.50727\diasymreader.dllLoadedModule[39]=C:\Users\Michael\Desktop\CsvToEn1_0_0_3\Microsoft.Licensing.Utils2.0.dllLoadedModule[40]=C:\Users\Michael\Desktop\CsvToEn1_0_0_3\Microsoft.Licensing.Permutation_fa20c_2.0.dllLoadedModule[41]=C:\WINDOWS\SYSTEM32\bcrypt.dllLoadedModule[42]=C:\WINDOWS\SYSTEM32\SspiCli.dllLoadedModule[43]=C:\WINDOWS\assembly\NativeImages_v2.0.50727_64\System.Configuration\d71b7bb54e4d6b831557c1636a169741\System.Configuration.ni.dllLoadedModule[44]=C:\WINDOWS\assembly\NativeImages_v2.0.50727_64\System.Xml\c05ddfb7d5242800072f6cefa2ea8dd7\System.Xml.ni.dllLoadedModule[45]=C:\WINDOWS\system32\CRYPT32.dllLoadedModule[46]=C:\WINDOWS\system32\MSASN1.dllLoadedModule[47]=C:\WINDOWS\SYSTEM32\VERSION.dllFriendlyEventName=Stopped workingConsentKey=CLR20r3AppName=CsvToEnAppPath=C:\Users\Michael\Desktop\CsvToEn1_0_0_3\CsvToEn.exeReportDescription=Stopped working HTH Cheers,Michael Link to comment
sindizzy 9 Posted July 15, 2013 Share Posted July 15, 2013 Thanks for the feedback guys. I'm still trying to track down why it's bombing on x64 machines. I have several theories and am trying to chase those down. Link to comment
sindizzy 9 Posted August 1, 2013 Share Posted August 1, 2013 Ok folks lets try this one. It's CsvToEn 1.0.0.4 and available at https://docs.google.com/folder/d/0B6RcZCcts8ceYWY4NTMzZjYtMmI2ZS00NmJiLWE5NTAtOGMyMGVmY2RhYmRi/edit?pli=1Make sure that you decompress it to a folder. Do not run from within the zipped file. I tested it on my Windows 8.1 Preview x64 machine and results were good. This one requires the .NET4 Framework so please download and install if you don't have it. ~AGP Link to comment
renmandfx 0 Posted August 1, 2013 Share Posted August 1, 2013 downloadedextracteddouble clicked to runand the cursor goes round and round.....but it never starts.Tried the diagnostic routine, no help.BUT... why did Adobe Dreamweaver start up after I double clicked on this file? Link to comment
Recommended Posts
Archived
This topic is now archived and is closed to further replies.