Sample Data

[Stef]

Hi all,

For our demo solution we need hundreds of fake Companies and contacts.
It will take hours of work and imagination to create them.

Does anyone know where I can find or download such a file?

TIA,
Stef

[grahamg]

Hi Stef

You could take sets of real data from your customers - import into Excel then sort every column. Data is realistic but after all the sorting would be impossible to trace back to real names/addresses. With tel/fax no's would suggest you chop the field so that a full number is never displayed.

HTH

Regards

Graham Greensall
Worxinfo Ltd

[Stef]

Thanks, Graham! But it's still too risky...

For example, a customer with another address can be traced very easily.
Most of the times you just have to google to find the right coordinates, or just type www.companyname.com...

We need the data for a demo of our Seefreight solution, and in this small world everyone knows everyone...

Best Regards,
Stef

[grahamg]

Understand. But you could produce a calc field taking (say) five characters from each of the next four rows then adding them together to produce a composite name.

Regards

Graham

[bcusick]

One way to do it: You can setup two arrays with different information - and then use the random function to pick from each of the lists. For example:

Code: Select all

var names = new Array('ABC','XYZ','SomeCompany','Example')
var prefixes = new Array('Corp', ', Inc', 'Ltd.', 'LLC', 'Corporation', 'Pty Ltd.')

var rand1 = 0
var rand2 = 0
var newName = ''

for(var i = 0; i < 100; i ++)
{
   rand1 = Math.floor(Math.random() * names.length);
   rand2 = Math.floor(Math.random() * prefixes.length);

   newName = names[rand1] + ' ' + prefixes[rand2]
}

The longer the lists, the more "random" it will appear. This technique will also work for fictional addresses and people's names. I hope this points you in the right direction.