Community
Showing results for 
Search instead for 
Do you mean 
Reply

Export Notes database export errors

New Member
Posts: 2
Country: USA

Export Notes database export errors

How do I export the notes database with out the rich text formatting?   

 

We also have an issue where someone pasted an image into Notes.  How can we remove any images from the Notes database?

 

 

Act! Premium Version 19.2.146.0, Update 3

We have SQL Management studio installed.

Administrator
Posts: 425
Country: United_Kingdom

Re: Export Notes database export errors

Hi gentechsci,

There are a few a ways of exporting notes data, but it really depends on what output format you're looking for.

I will say that exporting notes into a spreadsheet is not particularly easy, as the data isn't really the right sort of data for a spreadsheet.

You should just be able to edit the note and highlight and delete the image to remove it.
New Member
Posts: 2
Country: USA

Re: Export Notes database export errors

Is there an easy way to identify the notes that have images in them?
Administrator
Posts: 425
Country: United_Kingdom

Re: Export Notes database export errors

Not that I'm aware of, unfortunately.

There's no way to search notes based on contact type - it may be possible to do a keyword search on the image name if you know what the image is.

Our tech support agents do have access to a tool which can scan for notes/histories that are larger than 2MB in size; as these can cause issues with Synchronization, sometimes. However small image files will likely not bring the note over 2MB and these wouldn't be picked up.
Silver Contributor
Posts: 1,813
Country: USA

Re: Export Notes database export errors

the swiftpage tool will remove (delete) notes that have an image.

 

We have two additional tools

1) will remove just images from notes or histories

2) truncate excessively long notes or histories to keep database size down.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider