[rt-users] Upgrade: RTFM Article, Content CustomField not displaying

2013-08-16 Thread Anthony Gladdish
Hi,

When viewing/editing an RTFM Article, Content CustomField is not displaying.

This is after installing a fresh copy of RT 3.8.17 + RTFM 2.4.5 and pointing at 
copy of database, and upgraded as per steps in: 
http://www.bestpractical.com/docs/rt/3.8/UPGRADING.html from 3.8.2.
I chose not to run optional perl etc/upgrade/split-out-cf-categories in 3.8.5 
step.

CustomFields already exist; I don't need to create new ones. The data in 
database has not changed during database upgrade.

Test system ( RT 3.8.17 + RTFM 2.4.5 ):

For both menus:
Menu: RTFM - Configuration - Custom Fields
Menu: Configuration - RTFM - Custom Fields

Lists record #32 from the CustomFields table. Applied 
column is empty.
Lists record #31 from the CustomFields table. Applied 
column is empty.

Clicking on each CustomField, Applies to is RTFM Articles.

I think it should be referencing CF records from 
FM_CustomFields table instead?

Works fine with RT 3.8.2 + RTFM 2.4.1.

Is this a bug or have I missed something?

Thanks,
Anthony


Re: [rt-users] MySQL issue - Windows vs. Linux - Table name case seems

2013-08-16 Thread Cena, Stephen (ext. 300)
Just an update for everyone:

I'm using Ubuntu 12.04LTS as the MySQL test bed to move my RT databases
to. While this link:

http://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html

provided by Maciej Dobrzanski did help, I noticed a small issue. For
some reason, 2 is not a valid option on Ubuntu. 0 and 1 both work, but 2
seems to get ignored. I've been trying to work out if its me or the
database server. The RT database is small enough than I can manually fix
the tables names, but just wanted to give a heads up if anyone else
goes through this.


Stephen Cena
QVII
MIS/IT Dept
850 Hudson Ave.
Rochester, NY. 14620
585-544-0450 x300
s...@qvii.com
Thank you for helping us help you help us all.


Re: [rt-users] Regex

2013-08-16 Thread Andy Harrison
Putting specific numbers in your expressions like that really hamstrings
you if things don't match up to the exact counts you specify.

To match your city, just do this:

/^\s*(\w.*?),\s+\w{2}\s+\d{5}/

Start of line, optionally followed by 0 or more spaces, (start capture)
followed by a word character, followed by a non-greedy match of any number
of characters (stop capture) up to a comma, followed by 1 or more spaces,
followed by two word characters, followed by 1 or more spaces, followed by
5 digits.


-- 
Andy Harrison
public key: 0x67518262




On Fri, Aug 9, 2013 at 7:37 PM, Bryon Baker bba...@copesan.com wrote:

  Sorry back to the drawing board does not work if the city is two words.**
 **

 ** **

 Bryon Baker

 Network Operations Manager

 *Copesan** - Specialists in Pest Solutions*

 800-267-3726  •  262-783-6261 ext. 2296

 bba...@copesan.com cstep...@copesan.com

 www.copesan.com

 *Servicing North America with Local Care*

 ** **

 *From:* Bryon Baker
 *Sent:* Friday, August 09, 2013 6:05 PM
 *To:* 'rt-users@lists.bestpractical.com'
 *Subject:* RE: Regex 

 ** **

 Update this is what I came up with seems to work Thoughts?

 Tries to anchor begin of line but found it is white space.

 /\s{10}([\w{2},]+),\s*(\w{2})\s*(\d{5})/

 ** **

 Ok this question is to the regex experts

 I have this email content and I want returned to me the City.

 ** **

 116 Walker Ave.
 Berlin Circle Plaza
 West Berlin, NJ 08091
 Store Contact: MICHAEL OCONNOR - SOPASM
 Phone: (856)719-0335
 Fax : (856)719-2216

 ** **

 Thanks in advance for you expert help.

 ** **

 Thanks

 Bryon Baker

 Network Operations Manager

 *Copesan** - Specialists in Pest Solutions*

 800-267-3726  •  262-783-6261 ext. 2296

 bba...@copesan.com cstep...@copesan.com

 www.copesan.com

 *Servicing North America with Local Care*

 ** **