Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Print to file?


This topic is 5840 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.