Why aren't my Profile objects copied to the Data Warehouse?

re: Why aren't my Profile objects copied to the Data Warehouse?

jrmcdona — Tue, 12 Sep 2006 19:06:56 GMT

Hello and thanks for the post!

In our profiles database under the Addresses table, our u_address_id coumn is an nvarchar(50) and the values in the record looks like this: 017a1da3-b66e-47c7-997f-7a40eaf6bc69

1. SHould this be a GUID datatype?
2. hOW So this will cause the addresses to not be imported?

I am looking the UserObject table and the u_user_id is stored with the brackets and is an nvarchar(50) so I assume this is correct.

Thanks!
Jordan

re: Why aren't my Profile objects copied to the Data Warehouse?

jrmcdona — Tue, 12 Sep 2006 19:16:38 GMT

I meant to ask what is the best means of fixing this? thanks!

re: Why aren't my Profile objects copied to the Data Warehouse?

akfaulkner — Thu, 14 Sep 2006 04:22:43 GMT

Hey Jordan,

You need to change the Address Id to have brackets around the Guid:

{017a1da3-b66e-47c7-997f-7a40eaf6bc69}

This is needed to copy these values to the Data Warehouse. A small VB Script would work great to update all the values. You could also do a easy C# program to perform that conversion.

Hope this helps!

-Alan