welby Posted November 17, 2008 Posted November 17, 2008 Hi, could someone offer some advice? I have a karaoke database consisting of two tables. One table for the CD titles and the other table for the track listings. They have a relationship so I can create a report based on the cd title with the relevant track listings. Then I will add a common header to the report and then print to file, each and every record to a separate file, taking it's name from the cd title field. The reason for doing it this way is that I want to create a file that is acceptable for a Local Freedb database file that I can ID3 tag locally on my pc (NOT for submission to freedb.org) as such: # xmcd # # Track frame offsets: # 150 # 210627 # # Disc length: 2952 seconds # # Revision: 1 # Submitted via: xmcd 2.0 # DISCID=270b8617 DTITLE=Franske Stemninger / Con Spirito DYEAR=1981 DGENRE=Classical TTITLE0=Mille regretz de vous abandonner TTITLE1=L'arche de no EXTD=Copyright © 1981 MCA Records Inc.nManufactured f EXTD=or MCA Records Inc. EXTT0=Des PreznYez EXTT1=Schmitt: A contre-voix n(excerpt) PLAYORDER= This will be the header information: # xmcd # # Track frame offsets: # 150 # 210627 # # Disc length: 2952 seconds # # Revision: 1 # Submitted via: xmcd 2.0 # and the body will come from the database as: DISCID=270b8617 DTITLE=Franske Stemninger / Con Spirito DYEAR=1981 DGENRE=Classical TTITLE0=Mille regretz de vous abandonner TTITLE1=L'arche de no EXTD=Copyright © 1981 MCA Records Inc.nManufactured f EXTD=or MCA Records Inc. EXTT0=Des PreznYez EXTT1=Schmitt: A contre-voix n(excerpt) PLAYORDER= I can't think of any other way of doing this so I am stumped about the way to print to file for each and every cd title as a separate file in filemaker 9. Any help appreciated. Thank you
Søren Dyhr Posted November 18, 2008 Posted November 18, 2008 You could do it via this: http://www.kevinfrank.com/download/kf-fast-summary.zip ....and then, when the stuff is collected, via this: http://www.filemaker.com/help/Script-Steps54.html --sd
Recommended Posts
This topic is 5840 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now