Marketcircle    Forums  Hop To Forum Categories  Daylite  Hop To Forums  Troubleshooting    Database merge
Go
New
Find
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Apprentice
Posted
I have been running two offline databases whilst installing a new server, I have put one database onto the new server and sychronised the other to this database, expected them to now be one.
However, when I synchronise it seems to be finding the original database used before we went off line? How do we choose which database we want to synchronise with.
Or can we merge the two databases together - any help will be appreciated. Jean
 
Posts: 11 | Registered: August 22, 2006Reply With QuoteEdit or Delete MessageReport This Post
Apprentice
Posted Hide Post
As far as I am aware there is no way to merge two (or more) databases together at this point. You will not be able to synchronize two databases into one.

When it found the original database before you went offline, did you try looking at the configurations inside of OpenBase Manager? From there, you can activate or deactivate any current databases. Use precaution when inside OpenBase Manager.

HTH.
Rachel


----------------------------
Rachel McCuistion

RTI Consulting
(970) 639.2039 (512) 913.8976
rticonsulting.net info@rticonsulting.net

Certified Daylite Partner
Salesforce Technology Partner
Parallels Partner Network
ProjectWizards Merlin 2 Partner
 
Posts: 14 | Location: Austin, TX | Registered: March 18, 2008Reply With QuoteEdit or Delete MessageReport This Post
Pro
Posted Hide Post
If one could export ALL data from the program, the one could then import that data into an existing database. Unfortunately, at this point Daylight locks one's data in the program, at least some of it, like relationships and links.

I do remember someone on the Marketcircle team mentioning that they were considering offering a way to read an openbase database, and thus being able to export it in it's entirety. Even if they gave us the password to the database, it would be a help, as one could export to excel or filemaker to massage the data.

I urge Marketcircle to follow through on this and "unlock" these databases. It's my data. Why can't get at it the way I want?
 
Posts: 101 | Registered: February 29, 2008Reply With QuoteEdit or Delete MessageReport This Post
Apprentice
Posted Hide Post
Thanks Rachel, I have tried in OpenBase manager, but it needs a password which we do not have? it would help if we could get into the openbase manager as Jack says.
Thanks guys
 
Posts: 11 | Registered: August 22, 2006Reply With QuoteEdit or Delete MessageReport This Post
AJ
Marketcircle Team
Picture of AJ
Posted Hide Post
The challenge with this is the links. We have yet to find a clean, easy way to do this.

Just to re-affirm, your data is NOT locked in Daylite. You can access *ALL* your data using our free Developer API. You can also access the data using F-Script wrapped in AppleScript (or F-Script alone).

Here is an AppleScript example that dumps the Contact table to your Desktop as PropertyList XML in Contacts.plist.

  

tell application "Daylite"
	eval "
	
	document := (NSApplication sharedApplication) firstDayliteDocument.
	
	databaseConnection := (document objectContext) databaseConnection.
	
	rows := databaseConnection rawRowsForRawSQL:'SELECT * FROM Contact' eliminateNSNulls:true.
	
	rows writeToFile:('~/Desktop/Contacts.plist' stringByExpandingTildeInPath) atomically:true.
	"
end tell



Keep in mind that contact information is spread across multiple tables.

All this info is in the Dev Kit.
 
Posts: 891 | Location: Toronto | Registered: May 03, 2006Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

Marketcircle    Forums  Hop To Forum Categories  Daylite  Hop To Forums  Troubleshooting    Database merge

© Copyright 2006 Marketcircle Inc. All rights reserved.