Deliver Awesome UI with the most complete toolboxes for .NET, Web and Mobile development
Automate UI, load and performance testing for web, desktop and mobile
A complete cloud platform for an app or your entire digital business
Detect and predict anomalies by automating machine learning to achieve higher asset uptime and maximized yield
Automate decision processes with a no-code business rules engine
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premises data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
Personalize and optimize the customer experience across digital touchpoints
Build, protect and deploy apps across any platform and mobile device
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
I have an issue to using my own table in sitefinity, for example i want to upload data by SSMS and display it in sitefinity widget or edit the data in my own table through sitefinity.
What tools should i install? what skill should i have(may be MS LINQ)? or any others requirments should i have?
Anyone can give me simple example about this?
And secondly, if i used standard sitefinty widget(for example blog widget), the posts must be stored somewhere in database, but i don't know to extract it for reporting purpose for example.
You need to create Dynamic Module. It will automatically create table in DB and you will be able to edit information through Sitefinity backend. And show it for visitors in fronteng with autogenerated widget for this dynamic module
You can find more useful information here: http://docs.sitefinity.com/overview-dynamic-modules-and-the-module-builder
Thanks for the explanations and suggestions, it's very useful, i am exploring it for this moment.
I have tried using Module Builder for creating Dynamic Module (just say: myModule), Dynamic Content Type (just say:MyType), and Dynamic Content Items, and i can see that the table structure following the structure of my Dynamic Content Type plus an additional field "BASE_ID" that defined by Sitefinity.
At this point, i can insert or edit something like a post or a transaction using Sitefinity Backend (create Content Items), and the table is reflected the changes.
But i still can not insert rows directly to my table because i dont have the GUID number for filling BASE_ID field, and my table has relation to table SF_DYNAMIC_CONTENT too.
My purpose is to insert many rows (as a master table in my application) at once.
How to achieve this?
I think this link would be a good entry point for me, thanks a lot.
Hi Eddy. You need to do it through sitefintiy API or webservice.
As example, you can check this article www.sitefinity.com/.../importing-data-into-custom-modules
Hi Eddy, you need to add this using:
And i want to tell you small hint, what can help you with API
Go to Administration -> Module Builder -> Choose your module -> In the right sidebar click to "Code reference..."
On this page you will find many code samples for your module
I have a little problem when applying it.
So, when i used DynamicContent class, it seems there no SetString procedure, am I missing something?
here are my snipped codes:
public static void CreateStore(Store s)
DynamicContent storeItem = dynamicModuleManager.CreateDataItem(storeType);
// This is how values for the properties are set
storeItem.SetString("Title", s.Title, cultureName);
storeItem.SetString("Phone", s.Phone, cultureName);
Ok, thanks for the enlightenments, very helpful..