QAS Batch and Cleaning T_ADDRESS

Hi Matthew.

We are going through a process of putting all our existing data through QAS, using an ODBC connection.

Unfortunately, there isn’t a straight forward way to do this.

Our site has over 700,000 records so we are doing it in batches of 10,000 records.

We have put very specific rules over how we are identifying a ‘valid’ address, so some of it is manual.

I can send you a document that we’ve been following to get this done.  We use it, also, to push our weekly feeds from other parties, through the QAS process.

Hope this helps!

Anna Duric
System Application Administrator, Ticketing & CRM
the Arts Centre

T + 61 3 9281 8464
F + 61 3 9281 8282
M   0419 928 184
E   anna-maria.duric@theartscentre.com.au
W  http://www.theartscentre.com.au

Hi,

I'd be keen to hear from anybody who uses QAS Batch to clean their data. It's pretty straightforward for data we're exporting in, but how do people use it to clean up their data already in Tessitura. What are the exact steps you use?

Do you clean up the address table in segments? Do you export it as a file and then re-import it? Given that the data is changing in the address table is changing all the time, I just wanted to make sure that I run it as carefully as possible.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Matthew.

We are going through a process of putting all our existing data through QAS, using an ODBC connection.

Unfortunately, there isn’t a straight forward way to do this.

Our site has over 700,000 records so we are doing it in batches of 10,000 records.

We have put very specific rules over how we are identifying a ‘valid’ address, so some of it is manual.

I can send you a document that we’ve been following to get this done.  We use it, also, to push our weekly feeds from other parties, through the QAS process.

Hope this helps!

Anna Duric
System Application Administrator, Ticketing & CRM
the Arts Centre

T + 61 3 9281 8464
F + 61 3 9281 8282
M   0419 928 184
E   anna-maria.duric@theartscentre.com.au
W  http://www.theartscentre.com.au

Hi,

I'd be keen to hear from anybody who uses QAS Batch to clean their data. It's pretty straightforward for data we're exporting in, but how do people use it to clean up their data already in Tessitura. What are the exact steps you use?

Do you clean up the address table in segments? Do you export it as a file and then re-import it? Given that the data is changing in the address table is changing all the time, I just wanted to make sure that I run it as carefully as possible.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!