Sample Data

Share business templates, ideas, experiences, etc with fellow Servoy developers here

Sample Data

Postby Stef » Tue May 03, 2005 10:28 am

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
Stef
 
Posts: 208
Joined: Wed May 28, 2003 2:19 pm
Location: Kasterlee, Belgium

Postby grahamg » Tue May 03, 2005 10:57 am

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
grahamg
 
Posts: 723
Joined: Fri Oct 03, 2003 3:15 pm
Location: Midlands UK

Postby Stef » Tue May 03, 2005 11:04 am

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
Stef
 
Posts: 208
Joined: Wed May 28, 2003 2:19 pm
Location: Kasterlee, Belgium

Postby grahamg » Tue May 03, 2005 11:28 am

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
grahamg
 
Posts: 723
Joined: Fri Oct 03, 2003 3:15 pm
Location: Midlands UK

Postby bcusick » Thu May 05, 2005 6:24 pm

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.
Bob Cusick
bcusick
 
Posts: 1190
Joined: Wed Apr 23, 2003 11:27 pm
Location: Thousand Oaks, CA USA


Return to Sharing Central

Who is online

Users browsing this forum: No registered users and 1 guest