RE: Data file names

From: Abelyan, Armen \(NBC Universal\) <Armen.Abelyan_at_nbcuni.com>
Date: Fri, 8 Jun 2007 15:17:59 -0700

Danny,

 

I see what you mean by not knowing if it is TV or Film. We are in the
same situation. I'll tell you this, let's keep it the way it is now,
because you will not be able to provide asset type for 100% of assets
any way. I created a manual process here to fix it, we'll see if that
works for us and decide later.

 

As far as new feed goes, we are ready to except it as long as the format
(number of fields and position) match to what we've agreed on. Actually
on that note I would like you to go over your codes and make sure we get
that format for all feeds (except project_report*). I attached the
document for your consideration.

 

Thanks

Armen

 

________________________________

From: Danny Song [mailto:danny_at_mediadefender.com]
Sent: Friday, June 08, 2007 3:04 PM
To: Abelyan, Armen (NBC Universal)
Cc: Jay Mairs
Subject: RE: Data file names

 

Hi. Armen.

 

I undertand your situation.

I can add another field to distinguish between TV and film.

But I don't know if it is TV or film only looking at the asset name and
it was not provided to us.

I found that the string '(TV)' is manually typed into our system for
some of TV shows.

So, can you provide us the category for each asset?

 

And one more thing, the geo location data is ready to transfer.

The file includes ip,country,region and city for each network.

The name convention for this file is
"MD_networkname_supply[demand]mmddyyyy_location.csv"

 

Thank you.

Danny

 

 

________________________________

From: Abelyan, Armen (NBC Universal) [mailto:Armen.Abelyan_at_nbcuni.com]
Sent: Friday, June 08, 2007 11:45 AM
To: Danny Song
Cc: Jay Mairs
Subject: RE: Data file names

Danny,

 

Yes I noticed that, however due to the fact that we load millions of
rows of data into our relational database we noticed that parsing
strings from names to identify type we get significant performance hit
on servers. So if it is at all possible we would like to get type data
in a separate field.

 

Thanks

Armen

 

________________________________

From: Danny Song [mailto:danny_at_mediadefender.com]
Sent: Friday, June 08, 2007 11:19 AM
To: Abelyan, Armen (NBC Universal)
Cc: Jay Mairs
Subject: RE: Data file names

 

Hi. Armen.

 

Please look thru the asset names in the file.

If it is a TV show, we put '(TV)' at the end of the title.

 

Thank you.

Danny.

 

________________________________

From: Abelyan, Armen (NBC Universal) [mailto:Armen.Abelyan_at_nbcuni.com]
Sent: Friday, June 08, 2007 10:43 AM
To: Danny Song
Cc: Jay Mairs; Huynh, Michelle (NBC Universal)
Subject: RE: Data file names

Hi Danny,

 

I have a question about titles (project_reports*) file. We get all
asset names and ids from project_reports* files and have no way to
identify if that title is "TV" or "Film". Is it possible for you to
include asset_type in the project_reports* file? You can add this as
last field in the feed.

 

Thanks

Armen

Received on Fri Sep 14 2007 - 10:56:27 BST

This archive was generated by hypermail 2.2.0 : Sun Sep 16 2007 - 22:19:49 BST