TypedList xml schema generator

Posts   
 
    
Rogelio
User
Posts: 221
Joined: 29-Mar-2005
# Posted on: 04-Oct-2006 02:36:12   

Frans,

I sent to support AT llblgen DOT com an email with a zip file that contains a VB project that allows llblgen Pro users to create xsd from typedlist that are declared inside the DBSpecific.dll. The xsd file will allow the users to design reports (Crystal Report, XtraReports or other report generator that allow to specify xsd file), then at run time pass the typedlist as the datasource.

Rogelio

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 04-Oct-2006 08:32:21   

I edited the e-mail address in your message to avoid spamers.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39590
Joined: 17-Aug-2003
# Posted on: 04-Oct-2006 10:55:44   

Thanks Rogelio, I received it simple_smile I'll upload it later today simple_smile

Frans Bouma | Lead developer LLBLGen Pro
sailu_tp
User
Posts: 6
Joined: 09-Sep-2006
# Posted on: 04-Oct-2006 14:32:45   

Hi Rogelio I am interested in knowing more about Xsd generator. Could you please list the steps how should we go about this and what are the major benefits of this. Thanks, Sailu

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39590
Joined: 17-Aug-2003
# Posted on: 04-Oct-2006 18:34:24   

The xml schema generator is now available for both 1.0.2005.1 and 2.0 users in the 3rd party section of the downloads in the customer area.

Frans Bouma | Lead developer LLBLGen Pro
Rogelio
User
Posts: 221
Joined: 29-Mar-2005
# Posted on: 04-Oct-2006 22:22:53   

sailu_tp wrote:

Hi Rogelio I am interested in knowing more about Xsd generator. Could you please list the steps how should we go about this and what are the major benefits of this. Thanks, Sailu

I develop the typedlist's xml schema generator for the following:

  • I do not want CR to access the database directly.
  • My applications have a business layer that allow me to request and process data. I do all the data calculation in the business layer services, this allow me to switch painless from CR to other report generator. As my applications have a business layer, I want all my data request go throught it.
  • I use typedlist because it is easy to design using the LLBLGen Pro designer. Typedlist inherits from datatable, then it can be used as datasource for CR.
  • To design the report with CR without being online with the datasource (the push method) you need a schema of the data, that is the reason of the typelist's schema generator.

To use the utility you have to: - Compile the VB project. - I added a bat file that you can copy and edit for each LLBLGen Pro project that you want to generate the xml schema (read the readme.txt file that is include qith the zip). - Create your typedlist using the LLBLGen Pro, generate your code and compile it. - Use the shortcut to the bat file, the utility should shows the list of typelists that are in your DBSpecificxxx.dll. Pick the name of the one you want the xml schema generated and click save schema. Save the xml in the directory you like. - Open VS and create or open your CR's report and choose create a new connection then select ADO.Net(XML), open the xml schema (from the directory you saved it) and design your report. - At run time fill your typedlist, create a new instance of your CR's report and assign the typedlist as datasource of your CR document.

tedh
User
Posts: 34
Joined: 14-Dec-2006
# Posted on: 20-Feb-2007 23:14:44   

Otis wrote:

The xml schema generator is now available for both 1.0.2005.1 and 2.0 users in the 3rd party section of the downloads in the customer area.

I tried to find the xml schema generator in the customer area but was not successful. Can you please be a bit more specific?

Thanks

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39590
Joined: 17-Aug-2003
# Posted on: 21-Feb-2007 00:12:03   

In the v2.0 3rd party section, download "TypedList XSD schema generator" simple_smile

Frans Bouma | Lead developer LLBLGen Pro
iDave avatar
iDave
User
Posts: 67
Joined: 14-Jun-2010
# Posted on: 08-Nov-2010 03:09:10   

Hallo,

My apologies for bringing this old thread but I'm wondering if this tool or similar is still available for v3.0?

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 08-Nov-2010 09:59:54   

Haven't been ported to v.3.0.

iDave avatar
iDave
User
Posts: 67
Joined: 14-Jun-2010
# Posted on: 06-Dec-2010 17:39:46   

Walaa wrote:

Haven't been ported to v.3.0.

Wondering... Any estimate day to have this tool ported to actual version? Or maybe, it will be expected for v3.1? Just curious, I'm not pushing you guys, I know there're priorities. wink

Regards, Dave

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 07-Dec-2010 08:30:09   

Hi Dave, as this is a community contribution, it's -generally- ported/extended by the community, either the original developer or others. You just need to know the changes in the new template system and give it a spin modifying the templates.

David Elizondo | LLBLGen Support Team
iDave avatar
iDave
User
Posts: 67
Joined: 14-Jun-2010
# Posted on: 16-Dec-2010 23:31:05   

daelmo wrote:

Hi Dave, as this is a community contribution, it's -generally- ported/extended by the community, either the original developer or others. You just need to know the changes in the new template system and give it a spin modifying the templates.

Thanks David, I would like to give it a try but don't have the original contribution... :-\

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 17-Dec-2010 09:37:35   

You don't have access to v.2.0 download section, do you?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39590
Joined: 17-Aug-2003
# Posted on: 17-Dec-2010 10:32:19   

All v3 licensees have access to v2.x and v1.x downloads.

Frans Bouma | Lead developer LLBLGen Pro
iDave avatar
iDave
User
Posts: 67
Joined: 14-Jun-2010
# Posted on: 17-Dec-2010 19:59:33   

I was looking in the wrong section... confused

Thanks all!