Importing from Excel

dwshome2000
Posts: 2
Joined: Tue Oct 09, 2012 1:20 pm
Contact:

Importing from Excel

Postby dwshome2000 » Wed Apr 29, 2020 4:57 pm

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
User avatar
CintaNotes Developer
Site Admin
Posts: 4913
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Importing from Excel

Postby CintaNotes Developer » Thu Apr 30, 2020 5:55 am

Hello Dan,

I'll be able to tell what's wrong if you send me the XML to support@cintanotes.com, thanks!
Alex
dwshome2000
Posts: 2
Joined: Tue Oct 09, 2012 1:20 pm
Contact:

Re: Importing from Excel

Postby dwshome2000 » Sun May 03, 2020 12:24 pm

I sent the file on 4/30. Did you receive it?

Thanks for the help
Dan S
User avatar
CintaNotes Developer
Site Admin
Posts: 4913
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Importing from Excel

Postby CintaNotes Developer » Sun May 03, 2020 2:42 pm

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!
Alex
User avatar
CintaNotes Developer
Site Admin
Posts: 4913
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Importing from Excel

Postby CintaNotes Developer » Sun May 03, 2020 2:53 pm

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!
Alex

Return to “CintaNotes Personal Notes Manager”