ryant17 0 Posted June 20, 2013 Share Posted June 20, 2013 Hello everyone, I woule LOVE it if someone could take a look at my coding and see if they can figure out why I am getting an error message (Could not import notes, error COMMIT_FAILED) when I try to import a .enex file. Basically, I have a Excel Spreadsheet with 10,000 rows of data. I am attempting to import each row of data as a seperate note into Evernote. The catch is that I created a template in Evernote, so that all of my imported notes have the same style and lists and check boxes etc. So, I exported the template out of Evernote, and inserted it into Sheet 2 of the Excel file with all of my data. A macro was built, which takes the data from each row in Sheet 1, and populates it into the template. So in essence, after the macro is done running, Sheet 3 will have 10,000 rows of data, which is the data from sheet 1 combined with the exported template. Then, I have a separate excel file that runs a macro to export in information into a .enex file, which I can import into Evernote. MY PROBLEM: This process works, as I can export the Note title and blank templates out and into a .enex file, BUT when i use the data that has been run thru the macro, and then proceed to export it as .enex and upload into evernote, it gives me a error message. This makes me believe there is some kind of error in the code from the CopyData macro, or just a slight XML error somewhere that ruins the .enex format. There are 5 files attached.1 - Excel File 1 - CopyDataMacro (This file takes my raw data, and populates it into my template.)2 - Excel File 2 - Evernote Import Macro (This has the blank template that I had originally created in Evernote and exported out.)3 - Excel File 3 - Evernote Import Macro (This has the template with the macroed data that will not import into Evernote.)4 - evernote-import.enex This file uploads into evernote with no problem.5 - evernote-import2.enex This file gives me an error message when trying to import. Again, I would be very grateful if someone could help me out here, as I am not much of a programmer. Thanks! (Actually, the forum won't allow me to upload excel or .enex files, link below is to my dropbox) https://www.dropbox.com/s/550kme6bbox95ov/Evernote%20Import%20Macro%20with%20data%20that%20does%20not%20import.zip Link to comment
Recommended Posts
Archived
This topic is now archived and is closed to further replies.