Import not working

njw
Posts: 2
Joined: Wed Dec 14, 2011 6:39 am
Contact:

Import not working

Postby njw » Wed Dec 14, 2011 6:50 am

I am trying to import a set of data into Cintanotes from Excel. I have created an xml file, using an XML file exported from Cintanotes as the template, but the import routine will not import it. It completes as "Success" - Note import completed. Imported notes: 0. Skipped duplicates: 0.

I have created some dummy records in Cintanotes, exported them and then imported them into an empty database successfully.

I am using Cintanotes 1.5.2. The data I am trying to import is shown below, and it loads into Microsoft XML Notepad 2007 without any problems:

Code: Select all

<?xml version="1.0"?>
<notebook version="152">
<note title="" date="2011-12-13" time="13:52:14" source="" link="" tags="Project Management Deliverables">
  <![CDATA[- Pr Integ Pl / Pr Bud Mgmt / Pr Comm Mgmt- Pr Scope Mgmt / Pr Quality Mgmt / Pr Risk Mgmt- Pr Schedule Mgmt / Pr HR Mgmt / Pr Procurement Mgmt]]>
</note>
<note title="" date="2011-12-13" time="13:52:14" source="" link="" tags="Project Management Metrics">
  <![CDATA[- Product reliability- Product performance- Product useability- Fault density- Zero defect- Severity classes]]>
</note>
<note title="" date="2011-12-13" time="13:52:14" source="" link="" tags="Poetry">
  <![CDATA[.. is about questions and not answers]]>
</note>
<note title="" date="2011-12-13" time="13:52:14" source="" link="" tags="St Petersburg">
  <![CDATA[... a rational city, a planned city following the principles of the Enlightenment.]]>
</note>
<note title="" date="2011-12-13" time="13:52:14" source="" link="" tags="Acmeism poetry">
  <![CDATA[... consistent with A that Akhmatova and Mandelstam chose to remain in Russia whilst others quit...]]>
</note>
</notebook>


Any help would be greatly appreciated as Cintanotes looks like the solution to a longstanding problem!

Many thanks
User avatar
CintaNotes Developer
Site Admin
Posts: 4747
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Import not working

Postby CintaNotes Developer » Wed Dec 14, 2011 7:45 pm

Hello!

I was able to import the data specified without problems, using CintaNotes 1.5.3 .
Most probably you've had the wrong encoding - it must be UTF-16 LE.
To get the encoding right, you can for example paste this data into Notepad
and save with "Unicode" encoding.
Alex
njw
Posts: 2
Joined: Wed Dec 14, 2011 6:39 am
Contact:

Re: Import not working

Postby njw » Thu Dec 15, 2011 12:29 pm

Many thanks Alex. That solved the problem. :D

Return to “Bug Reports”