INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Data Master - Is There A Way To Find Field Names?  (Read 3473 times)

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20063
Data Master - Is There A Way To Find Field Names?
« on: September 06, 2004, 06:55:33 am »

I Am Hoping There Is A Way To Find A Field Name (In Visual Basic 6)

I Would Like To Take Blank Lables And Filling Them With A Lable Name Of What The User Has On His System.

Currently There is about 64 Fields In My Database Other Users May Have Created Other DataFields So Gettting Field Data From The Users System Would Be Better Than Just The Data Fields That Are Supplied From A New Install Of Media Center.

What I Am Tinkering With Is A Program That Will Take All Data Fields From A Users Database And Upload That Info To A Server, Then Allow Other Users To Access That Info To Fill Fields (ID3 Tags) With This Data.





Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20063
Re:Help! - Is There A Way To Find Field Names?
« Reply #1 on: September 06, 2004, 09:00:57 am »

A Sample Of How It Would Work Is:

Looks Up A Artist And Song Name If Found Will Find All Users Who Submited Data For That Song.

Data From A User Can Be Submited Once

Users Can Update Data For That Artist - Song

Lets Say 100 Users Submit Data For A Song

The Program Will Take The Field For "Genre" And Find The Field That Has Been Submited The Most. So If Genre = (Submited Pop 70 Times) And Genre = Rock (Submited 30 Times)  The Program Would Come Back With The Data Submited The Most And Allow You To Save It To Your Copy Of The Song (Manual Or Auto Batch).

If A Box Is Checked That Info Will Be Saved Only.

Data Will Be Saved To The Server In XML Format

This Program Includes Data From Fields Cover Art, Lyrics, Notes, Bios Etc....
Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

RhinoBanga

  • Citizen of the Universe
  • *****
  • Posts: 1703
  • Developer
Re:Data Master - Is There A Way To Find Field Names?
« Reply #2 on: September 06, 2004, 01:48:40 pm »

I Am Hoping There Is A Way To Find A Field Name (In Visual Basic 6)

You mean like Label1.Name ?

Are you hard coding the fields in the tabs or are you using arrays?

Wouldn't a listview with checkboxes be a better solution?
Logged

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20063
Re:Data Master - Is There A Way To Find Field Names?
« Reply #3 on: September 06, 2004, 02:15:33 pm »

I Want To Pull The Field Names From MC If It Is Possible, I Don't Really Want To Hard Wire The Fields.

I Want To Fill Label1 Or A Listvew (ListView May Be Better, Yes)

The only problem with Listview is maybe the # Bytes each field Could Hold And Can It Hold Multible Lines (Like For Lyrics, And Notes) I Don't Think ListView Can Hold A Book Of Info For Each Field (Not Sure Yet)

As Of Now I Am Tinkering With This as an Idea.

Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

RhinoBanga

  • Citizen of the Universe
  • *****
  • Posts: 1703
  • Developer
Re:Data Master - Is There A Way To Find Field Names?
« Reply #4 on: September 06, 2004, 02:39:35 pm »

I Want To Pull The Field Names From MC If It Is Possible, I Don't Really Want To Hard Wire The Fields.

Use the MJFieldsAutomation object to iterate the fields.

Quote
The only problem with Listview is maybe the # Bytes each field Could Hold And Can It Hold Multible Lines (Like For Lyrics, And Notes) I Don't Think ListView Can Hold A Book Of Info For Each Field (Not Sure)

The way most people do it is that they show the data in the listview and when you double-click on a sub-item it pops up another text box.
Logged

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20063
Re:Data Master - Is There A Way To Find Field Names?
« Reply #5 on: September 06, 2004, 02:44:01 pm »

I see, Maybe i can play with this a bit more next weekend

thanks
Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20063
Re:Data Master - Is There A Way To Find Field Names?
« Reply #6 on: September 08, 2004, 12:01:25 pm »

I got it working thanks for walking me thru it in a pvt message.

Thanks RhinoBanga Your The Best!

Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20063
Re:Data Master - Is There A Way To Find Field Names?
« Reply #7 on: September 12, 2004, 09:00:14 am »

Just Updated the pictures

Note the User ID is basicly the Users Drive Volume Name And Serial # to make sure a user does not submit data for this artist and Song more than once.

it should allow the user to update his own data in the future however.

Here is info for the file that would be passed from the server to the program (it prob will be encripted later)

<People></People><Places></Places><Events></Events><Playback Range></Playback Range><Access Rating></Access Rating><Album Artist (auto)>Al Green</Album Artist (auto)><Volume Name>F:</Volume Name><Complete Album></Complete Album><Album Type>Single artist (incomplete)</Album Type><Removable>0</Removable><Day></Day><Month></Month><Year></Year><Date (filename friendly)>19740101-000000</Date (filename friendly)><Filename (name)>Al Green - Sha-La-La (Makes Me Happy).mp3</Filename (name)><Filename (path)>F:\My Music\1974\</Filename (path)><Artist - Album (Year)>Al Green - Sounds Of The Seventies 1974 (1974)</Artist - Album (Year)><Year - Album>1974 - Sounds Of The Seventies 1974</Year - Album><Dimensions>? x ?</Dimensions><Content ID></Content ID><Content Distributor></Content Distributor><Content Type></Content Type><Text></Text><Album Gain>-11.911650437575121</Album Gain><Mix Album></Mix Album><Tempo></Tempo><Mood></Mood><Situation></Situation><Bios>Artist: Al Green

Al Green Was The First Great Soul Singer Of The '70s And Arguably The Last
Great Southern Soul Singer. With His Seductive Singles For Hi Records In The
Early '70s, Green Bridged The Gap Between Deep Soul And Smooth Philadelphia
Soul. He Incorporated Elements Of Gospel, Interjecting His Performances With
Wild Moans And Wails, But His Records Were Stylish, Boasting Immaculate
Productions That Rolled Along With A Tight Beat, Sexy Backing Vocals, And Lush
Strings. The Distinctive Hi Records Sound That The Vocalist And Producer
Willie Mitchell Developed Made Al Green The Most Popular And Influential Soul
Singer Of The Early '70s, Influencing Not Only His Contemporaries, But Also
Veterans Like Marvin Gaye. Green Was At The Peak Of His Popularity When He
Suddenly Decided To Join The Ministry In The Mid-'70s. At First, He Continued
To Record Secular Material, But By The '80s, He Was Concentrating Solely On
Gospel. During The Late '80s And '90s, He Occasionally Returned To R&B, But He
Remained Primarily A Religious Performer For The Rest Of His Career.
Nevertheless, Green's Classic Early '70s Recordings Retained Their Power And
Influence Throughout The Decades, Setting The Standard For Smooth Soul.Green
Was Born In Forest City, Arkansas, Where He Formed A Gospel Quartet, The Green
Brothers, At The Age Of Nine. The Group Toured Throughout The South In The
Mid-'50s, Before The Family Relocated To Grand Rapids, Michigan. The Green
Brothers Continued To Perform In Grand Rapids, But Al's Father Kicked The Boy
Out Of The Group After He Caught His Son Listening To Jackie Wilson. At The
Age Of 16, Al Formed An R&B Group, Al Green And The Creations, With Several Of
His High School Friends. Two Creation Members, Curtis Rogers And Palmer James,
Founded Their Own Independent Record Company, Hot Line Music Journal, And Had
The Group Record For The Label. By That Time, The Creations Had Been Re-Named
The Soul Mates. The Group's First Single, "Back Up Train," Became A Surprise
Hit, Climbing To Number Five On The R&B Charts Early In 1968. The Soul Mates
Attempted To Record Another Hit, But All Of Their Subsequent Singles Failed To
Find An Audience.In 1969, Al Green Met Bandleader And Hi Records Vice
President Willie Mitchell While On Tour In Midland, Texas. Impressed With
Green's Voice, He Signed The Singer To Hi Records, And Began Collaborating
With Al On His Debut Album. Released In Early 1970, Green's Debut Album Green
Is Blues Showcased The Signature Sound He And Mitchell Devised - A Sinewy,
Sexy Groove Highlighted By Horn Punctuations And String Beds That Let Green
Showcase His Remarkable Falsetto. While The Album Didn't Spawn Any Hit
Singles, It Was Well-Received And Set The Stage For The Breakthrough Success
Of His Second Album. Al Green Gets Next To You (1970) Launched His First Hit
Single, "Tired Of Being Alone," Which Began A Streak Of Four Straight Gold
Singles. Let's Stay Together (1972) Was His First Genuine Hit Album, Climbing
To Number Eight On The Pop Charts; Its Title Track Became His First Number One
Single. I'm Still In Love With You, Which Followed Only A Few Months Later,
Was An Even Greater Success, Peaking At Number Four And Launching The Hits
"Look What You Done For Me" And "I'm Still In Love With You."By The Release Of
1973's Call Me, Green Was Known As Both A Hitmaker And An Artist That Released
Consistently Engaging, Frequently Excellent, Critically-Acclaimed Albums. His
Hit Continued Uninterrupted Through The Next Two Years, With "Call Me," "Here
I Am," And "Sha-La-La (Make Me Happy)" All Becoming Top 10, Gold Singles. At
The Height Of His Popularity, Green's Former Girlfriend, Mrs. Mary Woodson,
Broke Into His Memphis Home In October 1974 And Poured Boiling Grits On The
Singer As He Was Bathing, Inflicting Second-Degree Burns On His Back, Stomach
And Arm; After Assaulting Green, She Killed Herself With His Gun. Green
Interpreted The Violent Incident As A Sign From God That He Should Enter The
Ministry. By 1976, He Had Bought A Church In Memphis And Had Become An
Ordained Pastor Of The Full Gospel Tabernacle. Though He Had Begun To
Seriously Pursue Religion, He Had Not Given Up Singing R&B And He Released
Three Other Mitchell-Produced Albums - Al Green Is Love (1975), Full Of Fire
(1976), Have A Good Time (1976) - After The Incident. However, His Albums
Began To Sound Formulaic, And His Sales Started To Slip By The End Of 1976,
With Disco Cutting Heavily Into His Audience.In Order To Break Free From His
Slump, Green Stopped Working With Willie Mitchell In 1977 And Built His Own
Studio, American Music, Where He Intended To Produce His Own Records. The
First Album He Made At American Music Was The Belle Album, An Intimate Record
That Was Critically Acclaimed But Failed To Win A Crossover Audience. Truth
And Time (1978) Failed To Even Generate A Major R&B Hit. During A Concert In
Cincinnati In 1979, Green Fell Off The Stage And Nearly Injured Himself
Seriously. Interpreting The Accident As A Sign From God, Green Retired From
Performing Secular Music And Devoted Himself To Preaching. Throughout The
'80s, He Released A Series Of Gospel Albums On Myrrh Records. In 1982, Green
Appeared In The Gospel Musical Your Arms Too Short To Box With God With Patti
Labelle. In 1985, He Reunited With Willie Mitchell For He Is The Light, His
First Album For A&M Records.Green Tenatively Returned To R&B In 1988 When He
Sang "Put A Little Love In Your Heart" With Annie Lennox For The Bill Murray
Comedy Scrooged. Four Years Later, He Recorded His First Full-Fledged Soul
Album Since 1978 With The Uk-Only Don't Look Back. In 1995, He Released Your
Heart's In Good Hands, An Urban Contemporary Record That Represented His First
Secular Album To Be Released In America Since Truth And Time. Though The Album
Received Positive Reviews, It Failed To Become A Hit.Al Green Was Inducted To
The Rock And Roll Hall Of Fame In 1995. - Stephen Thomas Erlewine
</Bios><Preference>None</Preference><Custom 1>Billboard Top Hits</Custom 1><Custom 2></Custom 2><None></None><None></None><None></None><None></None><None></None><None></None><None></None><None></None><None></None><None></None><None></None><None></None>
Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

TAFKAFEX

  • Guest
Re:Data Master - Is There A Way To Find Field Names?
« Reply #8 on: September 18, 2004, 01:17:36 pm »

....it should allow the user to update his own data in the future however...

King,
Sounds great. Thanks. Will spend some time on this.
Logged
Pages: [1]   Go Up