szwp

Hello Don,

Since you are limited to what the API is returning, there is really nothing else you can do. Your logic is sound.

Thanks for your hard work.

Title: <blank>

Post Status: publish

Post Type: post

Amazon ASIN Number: 073901983X (or 149609249X)

Split ASINs? checked (not needed)

Product Location: Above Post Content checked

Additional Items: Show Amazon Description? checked

Category/Taxonomy for post: <any Category; in my case it is a Book Reviews>

Action -> Click on Create Amazon Product Post & Return Here

Go to Post -> All Post

Click View to view the newly created post. You will find:
– the book title
– description next to the book picture
– Price
– Buy from amazon.com button

– the description repeated showing underneath the Buy from amazon.com button

Hope this helps!

I wouldn’t worry about it. It works for a single ASIN and maybe you want to gray it out if Split ASINs option is checked. It is not worth the effort as it I don’t believe it has a clean solution. It is going to lead to more issues or limitations (e.g. 10 ASINs max?, etc). More likely, one will be editing each post separately anyway. I feel the ROI on this one is very minimal and not worth the effort.

Thanks for your hard work.

Hello Don,

I tested the update and it works. There are other potential challenges I discovered while test it. I will create separate entries so you can track them.

Thanks for your heard work and quick reply.

I wrote my own code to display the details on the page. I used dbview plugin to display the information in a table and used s2member to control user access.

Anyone?

Problem that I was trying to solve:

A dbview that has has the following 3 Columns:

Export Users, Event ID, Event Name

Note, Export Users is not a field in the database, but “Event ID” and “Event Name” are.

Make the column in dbview “Export Users” a “clickable link”, when clicked, the value of “Event ID” column is passed to a backend PHP code

Solution
———-
I created a dbview with the the following select statement:
select event_city As “Export Users”, id As “Event ID”, event_name As Event, …

In the select statement, I selected the field event_city as my dummy field in the dbview and called its column “Export Users”. This column will be clickable as shown below in the code.

Place this PHP in dbview under the column “Export Users”

"<a href='$value'>$name</a>"; <== make the field in the table a hyperlink
$myevent=$row['Event ID'];
return "<a href= '/mydirectory/myphpfile.php?event_id=$myevent'>Export Users</a>";

In your PHP file get the value using $_GET 

e.g. function myphpfile.php() {
	$event_id= $_GET['event_id']; <== use $_GET to get the value passed from dbview
....
...
}

That’s it. By the way I did not use shortcode I called the PHP directdly.

No worries.

The code I pasted was stripped. Here it is hope it shows this time ??

‘”$name“;

return DBView::link($value, “DoDAttendeeList”, $value);’

Works great. Thank you for your hard work.

I reactivated W3 Total Cache, disabled Minify and cleared W3TC cache. dbview works.

Thanks for the plugin. Now I will have a chance to test it.

Take care.

I deactivated the plugin W3 Total Cache and the table is showing. I found a discussion at the following URL that triggered the thought to just disable the plugin to test dbview. Here the link: https://www.ads-software.com/support/topic/thickbox-doesnt-work-with-w3-total-cache

Do you have a suggestion which parameters in W3 Total Cache are impacting the dbview plugin?

Is there a way to give us the option to pass arguments as parameters to the shortcode so we can display additional details such as company name, email address, etc?

Otherwise, can you please point me to the code and I will do the changes myself.

Thanks for the link. As I mentioned, since I made my own modifications to the plugin to fit my needs, I did not update it to the newer version that’s why I am not experiencing the issue. Since this is an important feature of the plugin, I am sure the author will fix it.

I am not sure why it is not working for you. I am using an older version of the plugin so maybe things have changed since. Just to verify proper use, I recommend you go to the Events Category section and copy the shortcut as it is shown in the list and paste it on your page. In my case I missed type the entry and/or missed to include the []