Wednesday, December 03, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Mainstream Forums  Developers  Custom Module D...
 Custom Module Development...
 
murali
22 posts
Joined
6/8/2006

Custom Module Development...
Posted: 13 Jun 06 1:13 AM

Hello,

I would like to learn SplendidCRM in detail.  I think the best way to learn is to try and create a brand new module (tab), with a few fields that read/write to a custom table in the DB. 

Is there any tutorial (basic) on how to proceed creating a custom module and displaying it in a TAB?

TIA

support
2153 posts
1st
Joined
1/3/2006

Re: Custom Module Development...
Posted: 20 Jun 06 7:48 AM
The place to start to build a module is with the SQL code.  You will need some C# and ASP.NET files, but the core of SplendidCRM is data-driven.
 
Here are some of the generic steps:
  1. Create a table using one of the existing tables in SQL Scripts\BaseTables.  If your module will support custom fields, also make sure to create a table that ends in _CSTM.  If your module will support many-to-many relationships, then you will need to create a relationship module similar to ACCOUNTS_BUGS.
  2. Create the _Update and _Delete procedures using the spSqlBuildProcedures stored procedure.
  3. Create the views using one of the existing modules as a template.  You should create 3 views, one is the core view, followed by _List and _Edit.
  4. Create the script to add the module in Data\MODULES defaults.1.sql.
  5. Create the script to add the shortcuts in Data\SHORTCUTS defaults.1.sql.
  6. Create the script to add the list view data.  The files are GRIDVIEWS defaults.1.sql and GRIDVIEWS_COLUMNS ListView defaults.1.sql
  7. Create the script to add detail view data.  The files are DETAILVIEWS defaults.1.sql and DETAILVIEWS_FIELDS default.1.sql.
  8. Create the script to add edit view data.  The fiels are EDITVIEWS defaults.1.sql and EDITVIEWS_FIELDS defaults.1.sql.
  9. Create a new module folder in the web application.
  10. Copy all the files in a similar module to the new folder. Then rename the namespace in each file to match your new module name.  Products is a good module to copy as I have just created this module and it has all the core features.  I also typically rename all words in the old module to match the new module name.
  11. You will probably need to comment out the procedures to your new module until they are ready.  When the procedures are ready, you can navigate to _code\Procedures.aspx to generate the SqlProcs.cs file.  The goal is to automatically generate this file so that it is always perfect.
SRambaud
41 posts
Joined
8/9/2006

Re: Custom Module Development...
Posted: 23 Aug 06 6:09 AM
Hi,

the generic steps are very interested but there is one question : are those steps possibles with the opensource version (1.2 beta or higher) ?

Thanks

support
2153 posts
1st
Joined
1/3/2006

Re: Custom Module Development...
Posted: 23 Aug 06 10:48 AM

All is possible with the open-source version.  The SplendidCRM Professional provides you with the source code, which really amounts to lots of sample code on how to add data to the layout tables.

 

nyounaki
46 posts
Joined
12/11/2007

Re: Custom Module Development...
Posted: 08 May 08 3:32 PM

Dear Sir,

where can I find these kind of files: Data\MODULES defaults.1.sql.  I have splendidcrm 2.1 beta its (open source free of charge) can you clarify more on how create new module  to whom who has open source free of charge ?

 

thanks & regards

  Mainstream Forums  Developers  Custom Module D...

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.