FlyData Report Hub

[Shawn Li, geändert vor 10 Jahren.]

FlyData Report Hub:

(1) Write SQL for relatinal database. Write SQL-Like definition block for Notes Domino, or, text file.

For example:

<GetPXData>

[path_start]
C:/LifeRay Home/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/db_report-portlet/test_data/px_data.csv
[path_end]

[first_column_title_start] yes [first_column_title_end]
[number_of_columns_start] 4 [number_of_columns_end]
[delimiter_start] , [delimiter_end]
[delimiter_included_start] no [delimiter_included_end]
[totalrows_start] all [totalrows_end]

[data_columns_start]
PX_Number | Name | Developer | In_Production
[data_columns_end]

</GetPXData>

(2) Define report block:

Follow the previous example:

############################
!!!!!!! Block Start !!!!!!!
############################
key = 42
default = no
enabled = yes

data_source_name = Structured_Text
sql_index = GetPXData
xsl_sheet = BLANK
xsl_sheet_readform = BLANK
jsp_file = BLANK
jsp_file_servlet = BLANK
report_table_id = GetPXData

report_title = PX DEV Data
report_category = PX DeV

total_show_rows = all

url_link = BLANK

link_column = BLANK

link_var_columun = BLANK

date_column = BLANK
date_format = BLANK

hidden_columns = BLANK

max_col_length_allowed = BLANK
truncated_columns = BLANK

############################
!!!!!!! Block End !!!!!!!
############################

(3) Restart Tomcat, no coding is needed, the portlet ( also, a servlet ) is ready:




These are some HTML graphs produced by system. You don't need to write a single line of code.


--
Shawn

[David H Nebinger, geändert vor 10 Jahren.]

What the heck does this mean? Is there a question here? Is this some sort of announcement of something you're selling or giving away?

[Shawn Li, geändert vor 10 Jahren.]

I just report what I did under Liferay system, did my post violate any rule here? Please let me know. Thanks.

[David H Nebinger, geändert vor 10 Jahren.]

No, I'm just trying to figure out what it is.

I mean, I have all kinds of portlets which do all kinds of cool things, but they are only cool to me. I don't post it here cuz it really does not provide any value to other forum readers. I can have images, screen prints, etc., but if I'm not giving any of it away it doesn't mean squat.

Now, if this was some sort of product you were selling or giving away, well then it may be relevant - "Look what you guys can do if you buy my tool!" sort of thing.

But there was nothing in your post that indicated what it was about.

[Shawn Li, geändert vor 10 Jahren.]

Thanks for your advice.

I will try to setup something on market place.

One of my purpose of posting it is to try to find out anyone interested and hope to have some group gathering in GTA area. I am still looking for liferay related user group in GTA. Unfortunately, there seems none.:-(

[Shawn Li, geändert vor 10 Jahren.]

David, actually this is more related to web application framework design sort of thing, which forum do you recommend to post? Thanks.