Radicore Forum: How To » Field Alignment and formatting

Home » RADICORE » How To » Field Alignment and formatting (How to align and format field text)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Field Alignment and formatting [message #2745]

Tue, 19 July 2011 09:12

grim
Messages: 11
Registered: July 2011
Location: Surrey, UK

Junior Member

Hi, I am very new to Radicore. I was drawn to it because of its workflow capabilities. I have installed Radicore on one of my Linux servers and its working fine. I am investigating its features and trying to get my head round them!!

I have a question around formating. I am displaying some figures using pattern list 1. I would like to be able to display the date as dd/mm/yyyy and to right justify the content of some numeric fields.

I have made all of the list 1 fields right justify by adding text-align: right to tr.even td and tr.odd td in the stype_custom.css. I haven't managed to do it for a single column yet. Am I going about this the correct way or should I be doing the mod somewhere else?

With regards to the date format change, I am not at all sure where I should be making these changes.

Any help will be greatly appreciated.

Thanks and regards

Graham Jones

Report message to a moderator

Re: Field Alignment and formatting [message #2747 is a reply to message #2745]

Wed, 20 July 2011 05:54

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

For dealing with date formatting, both input and output, take a look at FAQ113.

For left/center/right aligning of text within a column you need to modify the screen structure file, as documented in Screen Structure File. You wil see here that the options currently supported are:

width
class
align
valign
char
style

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Field Alignment and formatting [message #2748 is a reply to message #2745]

Wed, 20 July 2011 12:14

grim
Messages: 11
Registered: July 2011
Location: Surrey, UK

Junior Member

Thanks for your swift response. Date format works like a dream. However, I had already tried editing the <screen>.list1.screen.inc and adding the align clause to the column without any effect. I have coded the following - am I correct?:

$structure['main']['columns'][] = array('width' => '10%', 'align' => 'right');

Thanks and regards

Graham Jones

Report message to a moderator

Re: Field Alignment and formatting [message #2749 is a reply to message #2748]

Wed, 20 July 2011 12:23

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

That is definitely the correct syntax. You can see a working example of this in 'mnu_role.list1.screen.inc' which is used in the 'List Role' task within the Menu System.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Field Alignment and formatting [message #2750 is a reply to message #2745]

Wed, 20 July 2011 12:39

grim
Messages: 11
Registered: July 2011
Location: Surrey, UK

Junior Member

I took a look at the role list and that does not display as directed in the mnu_role.list1.screen.inc either! I have tried with IE9 and Chrome, both with the same result.

Do you have any other suggestions that I might look at?

I see that you are from Sutton, I am just down the road from you in Lingfield - small world.

Thanks and regards

Graham Jones

Report message to a moderator

Re: Field Alignment and formatting [message #2751 is a reply to message #2750]

Wed, 20 July 2011 14:21

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

That code causes <COL ALIGN="RIGHT" /> to be inserted into the HTML output, and this has always worked in IE (certainly up to version 7) and Opera. This is in accordance with the HTML specification in section 11.2.4 and 11.3.2.

This does not work in Firefox due to bug#915, and I have just noticed that it no longer works in Safari.

It does not work in Google Chrome due to bug#12094.

I *DO* wish these browser developers would learn to read the W3C specifications and implement them properly!!!

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Field Alignment and formatting [message #2752 is a reply to message #2751]

Thu, 21 July 2011 11:25

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

If <COL ALIGN="RIGHT" /> does not work then <COL CLASS="right" /> should, as both are valid according to the HTML 4.01 specification. It would appear that <COL ALIGN="RIGHT" /> will not be supported in HTML 5, but <COL CLASS="right" /> is still there, so *should* be supported by *ALL* browsers.

Note that CLASS="right" indicates a CSS class with the following contents:

Code: [Select all] [Show/ hide]

.right {
  text-align: right;
}

This works in IE7, but not in IE8 (I don't know about IE9). It also does *NOT* work in Safari 5.0.5, Opera 11.50 and Firefox 5.0. Does anybody know a method of achieving this which *IS* supported by all browsers? Or is that too much to hope for?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Field Alignment and formatting [message #2753 is a reply to message #2752]

Thu, 21 July 2011 13:41

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

After playing around the only solution I have found that works in all the browsers at my disposal (IE7, IE8, Firefox, Opera and Safari) is to move the attribute from the <COL> element and add it to every <TD> element in the relevant column.

I have changed my code so that the 'align' and 'valign' attributes will be changed to 'class' instead. This means that:

Code: [Select all] [Show/ hide]

'align' => 'left|center|right|justify'

and

Code: [Select all] [Show/ hide]

'valign' => 'top|middle|bottom'

will be inserted into the XML file as if it were

Code: [Select all] [Show/ hide]

'class' => 'left|center|right|justify|top|middle|bottom'

This means that existing screen structure files will produce the desired results without having to be modified manually to change 'align/valign' to 'class'.

I will release these modifications at the end of the month, but in the meantime you can test them out in the online demo application.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Field Alignment and formatting [message #2754 is a reply to message #2745]

Thu, 21 July 2011 15:00

grim
Messages: 11
Registered: July 2011
Location: Surrey, UK

Junior Member

Thats great thanks. I was going to report back about using classes. I set one up called .aright but it didnt work as you say!!

If you would like me to test your change, please feel free to email me a copy of your changed file and I will install it on my server.

Thanks and regards

Graham Jones

Report message to a moderator

Re: Field Alignment and formatting [message #2755 is a reply to message #2754]

Thu, 21 July 2011 15:34

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

I've uploaded all the changes onto the Radicore server, so you can test them in your browser by running either the 'List Role' or 'List Subsystem' tasks in te online demonstration application.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Field Alignment and formatting [message #2758 is a reply to message #2745]

Fri, 22 July 2011 09:49

grim
Messages: 11
Registered: July 2011
Location: Surrey, UK

Junior Member

That works fine thanks.

How does one go about getting updates to Radicore? Do we just download the latest version and reinstall?

Cheers

Gj

Report message to a moderator

Re: Field Alignment and formatting [message #2760 is a reply to message #2758]

Fri, 22 July 2011 12:41

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Each release contains a copy of all the files, not just the ones that have changed since the previous release. You may re-install the whole kit and caboodle, or you may sort the zip file by date and extract only those files which have a change date which is greater than that of the release which you have currently loaded.

There is a file in the root directory called 'radicore-CCYY-MM-DD.txt' which contains a complete history of all changes. This may contain instructions on running an SQL script to update one of the databases.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Field Alignment and formatting [message #2897 is a reply to message #2760]

Sat, 10 March 2012 01:58

edortizq
Messages: 82
Registered: August 2008
Location: Ecuador

Member

edortizq@gmail.com

I have a database field VARCHAR(10) wich I need to show on screen with the following format:
"XXX-XXX-NNNN"
What should I do? alter the screen structure file? how?
Please let me know if there is some way to do it.
Thanks for advance!

Report message to a moderator

Re: Field Alignment and formatting [message #2898 is a reply to message #2897]

Sat, 10 March 2012 03:06

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Altering the screen structure file won't do what you want. That can only be used to specify where on the screen a field will be displayed.

If you want to change how a field is formatted before it is displayed then take a look at the _cm_formatData() method.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Field Alignment and formatting [message #2899 is a reply to message #2898]

Sun, 11 March 2012 00:57

edortizq
Messages: 82
Registered: August 2008
Location: Ecuador

Member

edortizq@gmail.com

Thanks!!!

Report message to a moderator

Previous Topic:	Printing Labels
Next Topic:	Use SQL REPLACE function in UPDATE SET

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Tue Jul 08 19:17:11 EDT 2025

Total time taken to generate the page: 0.20792 seconds