CRM Software - CABC | Maximizer | Maximizer Add-ons | Services | Support | Store | News

    Buy Maximizer Products and Services On-Line at CRMshop.co.uk
CABC    Maxtalk  Hop To Forum Categories  Maximizer CRM Software  Hop To Forums  Maximizer Support    Importing Notes
Go
New
Find
Notify
Tools
Reply
  
Importing Notes
 Login/Join
 
Member
Posted
Hello. How do I import the dates associated with notes into Maximizer. I have my notes stored in an excel spreadsheet so I'll be importing as a csv. Thanks? Ben
 
Posts: 32 | Registered: February 10, 2006Reply With QuoteReport This Post
Master
Posted Hide Post
Hi, Ben.

When importing from CSV you can import the note text but not the date. Your best bet would be to convert the CSV data to XML and then import that (assuming that your version of Maximizer is recent enough to support XML imports).
 
Posts: 728 | Registered: July 14, 2000Reply With QuoteReport This Post
Member
Posted Hide Post
Thanks for your reply. How do I convert data to xml? I've never come across this before. I'm running Maximizer 8, soon to be 9. Appreciate your assistance.
 
Posts: 32 | Registered: February 10, 2006Reply With QuoteReport This Post
Master
Posted Hide Post
Hi, Ben.

One way to convert Excel data into an XML file would be to create a merge template in Word, merge the data from the Excel spreadsheet, and then save the merged document as a text file with a .XML extension.

The real trick is determining what the XML file should look like. As a simple example, if you had a CSV file that looks like this...

"FirstName","LastName","MrMs","NoteDate","NoteTime","NoteText"
"Bob","Loblaw","Mr","2006-02-10","12:09:30","This is a note."

...after converting to XML it would look something like this...

<?xml version="1.0"?>
<AllData   xmlns             = "http://www.maximizer.com/maximizer/xmlimportexport/3.0"
           xmlns:xsi         = "http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation= "http://www.maximizer.com/maximizer/xmlimportexport/3.0  MXISchema.xsd">

   <Individual>
      <FirstName>Bob</FirstName>
      <LastName>Loblaw</LastName>
      <MrMs>Mr</MrMs>
      <Note>
         <Date>2006-02-10T12:09:30</Date>
         <Text>This is a note.</Text>
      </Note>
   </Individual>

</AllData>

To see more XML tags, try exporting some address book entries to XML and then look at the resulting file.
 
Posts: 728 | Registered: July 14, 2000Reply With QuoteReport This Post
Member
Posted Hide Post
hello Gord !!!

i just have a quick question.

any idea what the reason would be why Ëxporting CSV files is very slow on maximizer 9?
it wasnt that slow on Maximizer 8 !

thanks mate!

cheers.


Plan your Work Den Work Ur Plan
 
Posts: 21 | Location: Down Under | Registered: May 02, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

CABC    Maxtalk  Hop To Forum Categories  Maximizer CRM Software  Hop To Forums  Maximizer Support    Importing Notes

© CABC Ltd 2002 - 2010. All Rights Reserved.
Maximizer is a trademark of Maximizer Software inc.