Thursday, October 16, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Plug-in and Platform Forums  MS SQL Server Database  Example MS SQLS...
 Example MS SQLServer datasase
 
pveechoud
4 posts
Joined
8/21/2007

Example MS SQLServer datasase
Posted: 23 Aug 07 7:08 AM

I installed SplendidCRM for a demo for a customer. Now, I'm looking for a database wich contains demo-data! I ask this question allready to the supportdesk of Splendid (And the reaction was very quick) but they send me a mssql dump. I cannot import this xml-file.

Can anybody supply me with a representative MSSQL-dump?

Thanks in advance!

support
1995 posts
1st
Joined
1/3/2006

Re: Example MS SQLServer datasase
Posted: 23 Aug 07 8:31 AM

The MySQL dump file can indeed be imported into SplendidCRM. 

Login as Admin, go to the Admin area and select Import Database.  This function was specifically added to import SugarCRM databases.

 

pveechoud
4 posts
Joined
8/21/2007

Re: Example MS SQLServer datasase
Posted: 23 Aug 07 9:01 AM
The dump can be imported but then I have to manually assign every field (element) to the attribute of the account-module. Is that by design ?
support
1995 posts
1st
Joined
1/3/2006

Re: Example MS SQLServer datasase
Posted: 23 Aug 07 10:38 AM

It sounds like you are trying to import an entire database using the Accounts Import operation.  You need to use the Import Database in the Admin area.  The Import Database operation does not give you the option to map any fields.

The only problem is that the SugarCRM data our support staff gave to you has lots of errors.  The SugarCRM folks don't respect the sanctity of the GUID.  '00000000-0000-0000-0000-000000ACTIVE' is not a valid GUID and will cause a cascade of errors.

We have tried to correct for some of these GUID issues, but it is difficult to catch them all.

  Plug-in and Platform Forums  MS SQL Server Database  Example MS SQLS...

Forum Home  Search       

Copyright (c) 2006-2008 SplendidCRM Software, Inc. All Rights Reserved.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2008 by Perpetual Motion Interactive Systems Inc.
SplendidCRM and SplendidCRM Software are trademarks of SplendidCRM Software, Inc. SugarCRM is a trademark of SugarCRM Inc. in the United States, the European Union and other countries. All other trademarks used in this web site are the property of their respective owners.