I created a spreadsheet and using VBA wrote a macro to read the data and create a .txt file in the same format as the Cintanotes export. Using Notepad++ open the .txt file and save as .xml, then import to Cintanotes.
It works fine for about 3 notes, but if you have more than three or four notes in the xml, you get a error "Error parsing start element tag"
I can't see any differences in the Excel created xml file verses a xml file generated by the cintanotes export, and don't know the meaning of the error message.
Any help?
Thanks
Dan S
Importing from Excel
-
- Posts: 3
- Joined: Tue Oct 09, 2012 1:20 pm
- Contact:
- CintaNotes Developer
- Site Admin
- Posts: 5005
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Importing from Excel
Hello Dan,
I'll be able to tell what's wrong if you send me the XML to support@cintanotes.com, thanks!
I'll be able to tell what's wrong if you send me the XML to support@cintanotes.com, thanks!
Alex
-
- Posts: 3
- Joined: Tue Oct 09, 2012 1:20 pm
- Contact:
Re: Importing from Excel
I sent the file on 4/30. Did you receive it?
Thanks for the help
Dan S
Thanks for the help
Dan S
- CintaNotes Developer
- Site Admin
- Posts: 5005
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Importing from Excel
Hello Dan,
Yes I received the file but haven't had the chance to study it yet.
Will analyze it and send you the results within 2 days. Thanks for your patience!
Yes I received the file but haven't had the chance to study it yet.
Will analyze it and send you the results within 2 days. Thanks for your patience!
Alex
- CintaNotes Developer
- Site Admin
- Posts: 5005
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Importing from Excel
Ok just took a look and the problem was immediately obvious.
You have unescaped double quotes in note titles in lines 373 and 441.
Generally whenever you have symbols like &, ', " in XML attributes, you need to write them as """ etc.
Hope this helps!
You have unescaped double quotes in note titles in lines 373 and 441.
Generally whenever you have symbols like &, ', " in XML attributes, you need to write them as """ etc.
Hope this helps!
Alex
Return to “CintaNotes Personal Notes Manager”