test data

[webcat]

I'm not sure which forum topic to put this in, so please forgive me if it's not appropriate to this one!

I want to populate my database with something like 5000 sample records, which can just be gibberish, as long as it has all the fields....

Is there any application that can create sample data with given fields?

(or do I have to write something in basic that creates a comma delimited text file?)

I primarily use Mac OS X, but I would consider OS9 or WIn98 if required for this magic bit of software...

thanks for any info.

[avalon]

You can do this fairly easily in FileMaker with a script that goes:

Loop

New Record/Request

Set Field ["YourTextField", "Middle("nsdcjkwernmvdsjdfnewryhwu", Int(Random * 10), Int(Random * 14) + 1)"]

Set Field ["YourNumberField", "Int(Random * 10000)

etc etc through all fields

Exit Loop If ["Status(CurrentRecordCount) >

[webcat]

excellent! that saves a load of hassle!

Thanks!