Jump to content

(Archived) XML Help? Importing data from Excel into Evernote


Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...