[FIXED] CSV import -> No sponsor

Coscast · 2010-10-19 14:43:49

Hi,

If i select a sponsor in admin->add video->csv import
The Sponsor is not written into the database and because of that not shown below the video.

I tried to fix it by myself by adding

adv = '".$this->db->escape($sponsor)."',

But that seems to be the wrong sponsor. I see below the video the same banner as on the right side of the video

symtab · 2010-10-19 16:04:47

Fixed.

Coscast · 2010-10-19 17:46:11

Yes works now.

But i wondered, why there is no Sponsor added in Adminpanel->Video

There is no Sponsor shown.

I looked into the database and mentioned that there are two columns: "sponsor" and " adv"

Does the manage video page pull the "adv" column?

To clarify: The first 1000 videos where added by "hand" in Adminpanel without massimport. After the conversion was done, we added a sponsor for the video in Adminpanel->Manage with that really awesome button on the right Those Sponsors where added to the "adv" column.

Is that intended or is it just a small "bug". Also i don't like to call it a bug, but what for ist the "adv" ?

symtab · 2010-10-20 08:36:27

In Admin->Video->Manage the Coins Icon (with + and -) is for Advertising (the per video advertising feature). It does not represent the sponsor, its for the adv column in the database.

From what i understand you added a sponsor in admin, then with the coins icon you added that sponsor to the videos? (one by one, and you actually selected the advertising from the list that popups after you click the coins icon)? If this is correct, then its how its supossed to work.

Should I add the posibility to assign a sponsor directly from Video -> Manage or Video -> Edit?

Coscast · 2010-10-20 14:47:34

Yes,thats correct.

We did it like that. Added a video in AdminPanel via URL Upload. Then we went to the manage page and added a sponsor to that Video. One by one.

What i would like to see:

When someone in Admin Panel adds a Video via single upload function, let them select a sponsor from the Sponsors list. Like in the csv upload. But it should be possible to have no Sponsor.

MY Reason for that: My wife uploads videos one by one, she selects videos from a csv/txt sponsor file and uploads them via Admin Panel . It's simply because she wants more control. Don't get me wrong, csv upload is a great function and i use it, but she does not. Women....... you know HAHAHAHA

symtab · 2010-10-20 16:57:32

It works this way right now...the only difference is that you assign a advertising banner (which can be part of a sponsor) and not a sponsor directly. This is better also for speed, the per video advertising part loads adv, sponsor, user, category so it has to do 4 database queries (none with cache, but still). How about if i add a field where you can select the sponsor in the video edit page?

Coscast · 2010-10-20 18:05:48

No, leave it like it is. Selecting the sponsor via this ajax button is better than a dropdown in edit video. It's one ( two? ) click more if i have to go into the edit video

symtab · 2010-10-20 19:29:44

Ok, but you dont select a sponsor now. You assign a advertising banner to the video, not a sponsor. I will keep this in my mind and add a feature to actually change the sponsor if needed, later.

mfeat50 · 2010-10-26 15:17:54

For some reason the banners are not showing up under the videos when i select the sponsor on the mass csv import page.

I added the sponsor on the add sponsor page. I checked the view banner and it shows up.

What am i doing wrong?

recap:

I go to adv-add sponsor
I list the name of the sponsor
I list the name and description
I create a new adv banner
click create
sponsor was created

I then go to the mass csv import page and I select the sponsor in the sponsor properties and input all other required info then import videos
the videos get put on the site but there is no sponsor banner under them.

Last edited by mfeat50 (2010-10-26 17:42:07)

symtab · 2010-10-26 19:34:36

Hmm...seems like a bug. I thaught i already fixed this bug. I will fix it tomorrow morning again and upload the fixes to your server.

symtab · 2010-12-25 01:33:49

Is this still happening in BETA3 for you? (works on my testing box).

mfeat50 · 2010-12-25 03:32:08

I do not have this issue with beta 3. The banners show up just fine.

Thank you!!

Adult Script Pro Community Forums

#1 2010-10-19 14:43:49

[FIXED] CSV import -> No sponsor

#2 2010-10-19 16:04:47

Re: [FIXED] CSV import -> No sponsor

#3 2010-10-19 17:46:11

Re: [FIXED] CSV import -> No sponsor

#4 2010-10-20 08:36:27

Re: [FIXED] CSV import -> No sponsor

#5 2010-10-20 14:47:34

Re: [FIXED] CSV import -> No sponsor

#6 2010-10-20 16:57:32

Re: [FIXED] CSV import -> No sponsor

#7 2010-10-20 18:05:48

Re: [FIXED] CSV import -> No sponsor

#8 2010-10-20 19:29:44

Re: [FIXED] CSV import -> No sponsor

#9 2010-10-26 15:17:54

Re: [FIXED] CSV import -> No sponsor

#10 2010-10-26 19:34:36

Re: [FIXED] CSV import -> No sponsor

#11 2010-12-25 01:33:49

Re: [FIXED] CSV import -> No sponsor

#12 2010-12-25 03:32:08

Re: [FIXED] CSV import -> No sponsor

Board footer