Importing from Excel

[dwshome2000]

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

[CintaNotes Developer]

Hello Dan,

I'll be able to tell what's wrong if you send me the XML to support@cintanotes.com, thanks!

[dwshome2000]

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

Thanks for the help
Dan S

[CintaNotes Developer]

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!

[CintaNotes Developer]

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!