Fri 8 Jan ’10
10:27am

Adrienne L. Travis

I keep harping on this point with extension developers, and you may have seen it, so I’m sorry in advance if so: is the license fee *per EE installation* (backend) or *per front-end site* (if using MSM or other multiple-domain method)?

Thanks!

Mon 15 Feb ’10
8:02pm

dumbguy

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you?

Mon 15 Feb ’10
8:19pm

dumbguy

great… :)

okay, i downloaded the plugin, but how do I install it? I am using EE2, but it doesnt show up in CP, I have uploaded it in thirdparty folder…

Wed 17 Feb ’10
12:38am

Ben

Will this work with a PHP 4.3 and MySQL 4.0 environment?

Sun 21 Feb ’10
10:35am

Brendon Carr

Has anyone given this a try as a means to update just a part of a single entry (i.e., to make a leaner Stand-Alone Edit Form)?

Wed 24 Feb ’10
5:05am

Lewis Jones

Hi Adam,  Very much looking forward to the EE2.0 version of External SAEF.  Related to Brendon’s question, it seems to me the Update Entries function is designed to update just one column of the table.  Shouldn’t this work for an edit form already?  Anyway, about to give it a try!

Wed 24 Feb ’10
9:36am

2ways

Hmmm… yes, not sure what I meant either.  I was thinking about the built-in SAEF tag, but realise now it won’t work the way I thought it would.

Could you use it in a two-stage process, where you used a regular form to post information to another page (almost like a preview page, but it would never need to be visible), then take the output of the form values from there to use in the update tags to update the database?  Would require php, but would still be more flexible than the built-in SAEF for editing.

Anyway, just musing.  In all likelihood, I’ll be waiting for your super-duper EE2.0 External SAEF module.  Any time frame on that?  Thanks.

Wed 24 Feb ’10
12:12pm

2ways

Hey, you’re the one setting the pricing!  I’ll pay just about anything for a stand alone edit form that works.

The site I’m building is all about trying to keep users on the front end and away from the control panel.

The two-stage solution sounds pretty reasonable, actually.  It also means radio buttons and checkboxes would behave more consistently than they do with the SAEF.

The next issue to tackle is a SAEF file upload plugin that works and formatting buttons for SAEF forms.  I know they are supposed to work, but I can’t seem to get them to.

Sorry for the off-topic rant.  Thanks for the comments.

Wed 24 Feb ’10
2:39pm

2ways

Thanks, Adam.  To be honest, I gave up a while back and can’t remember the exact errors that were troubling me, though I might have another go now. 

I know other people seem to think the issues were solved, but I just couldn’t get the file uploads to work or formatting buttons to appear at all. 

On the edit side of things, the SAEF has trouble with just about everything other than text and textarea fields.  I managed to get radio buttons working with an if-then check to see what to display and I did an ugly fix of the select boxes by appending the currently selected value at the top of the list.  Checkboxes appear to be a lost cause for editing because they only appear in the data stream when they are ticked, which means if you untick it, it won’t tell anyone it’s been unticked.

The file upload doesn’t seem to have any chance of working with an edit form in the current configuration.  By working, I mean being able to view what you’ve uploaded (other than a file path), deleting the current file, and uploading another.

Part of my problem is that I am on EE2.0 where the SAEF stuff is not as well tried in the community, so less forum traffic.  Also, I am hardcoding everything instead of using {custom_fields} because I want to have control over the styling.  Mind you, I went back to have a go using {custom_fields} and found I still couldn’t get it working.

Thanks for pointing me to that thread.  Still don’t know how it all works with EE2.0.  Sorry for the long reply.

Wed 3 Mar ’10
10:45am

2ways

No problem.  Don’t stress on my account.  Will enjoy it when it comes!

Oh yeah.  Call me Lewis.  I never really like being someone else online, and I didn’t realise my posts would all be from 2ways.

Thanks for your work.

Wed 7 Apr ’10
2:01pm

Craig Allen

Hi Adam, looks like this will be very handy in a website I’m planning to start work on soon. I noticed a typo in the docs. You have written ...

“For EE v1.x, create in the /third_party directory a directory /select_entries, then place the pi.select_entries.php in there.”

That should read “For EE v2.x”.

I guess though that someone would have to be pretty thick to not work that out for themselves!

Wed 7 Apr ’10
7:46pm

unruthless

Hi Adam, I’m evaluating External Entries for a project, and functionality-wise it looks like it’ll be a good fit. Before integrating it, though, I have two concerns related to security, and I was hoping to get your input on both:

1. Having our database credentials in plaintext in a template seems like bad security practice. A possible workaround for people using this plugin to access tables in the same database as ExpressionEngine’s tables: the hostname + database name + username + password to this database are already stored in /system/config.php file, in the variables $conf[‘db_hostname’], conf[‘db_name’], $conf[‘db_username’], and $conf[‘db_password’]. Any way for this plugin to just use those credentials, rather than having to specify database connection info at the template level?

2. For INSERT, UPDATE, and DELETE queries, there doesn’t appear to be any escaping of query data happening. Am I missing something, or shouldn’t there be some mysql_real_escape_string action happening?

Happy to take this discussion offline, and thanks for releasing this plugin.

Wed 7 Apr ’10
9:27pm

unruthless

Hi Adam, thanks for the quick response!

Regarding (1), I just took another look at the source code, and you’re totally right—for my project, we won’t need to include the db info in the template, so we’re good.

Regarding (2), fantastic to hear you’ll be adding escaping to those queries. Can you give me a rough timeline, so I know whether it makes sense for me (given a looming project deadline) to wait for your patch or attempt to patch it on my own?

Thanks again,
Ruthie

Thu 8 Apr ’10
2:33pm

unruthless

Adam, looks like you missed one needed escape on line 480 - other than that, looks great. Way to use EE’s built-in escaping rather than writing your own, quite elegant.

I’ll be setting this up on my project today, and will let you know how it goes. Thanks!

Fri 14 May ’10
2:22pm

carvingCode

Adam - Can’t get it (ee 2.2.3) installed in EE2.0.2PB1.  It doesn’t display in the ‘addons->pluugins’ list.  I have it inside ‘third_party/external_entries’.  Any ideas?

Fri 14 May ’10
3:24pm

carvingCode

Yes, using the ‘third_party’ dir installed with EE.  This is a fresh install and external_entries is the only 3rd party addon installed.  Odd.

Fri 14 May ’10
5:24pm

carvingCode

OK.  Must have had a bad install of EE.  Couldn’t install other plugins either.  Deleted/reinstalled EE and all is well.  Am testing external_entries for db project that, instead of building out as an EE module, may do everything within EE itself.  If external_entries is all its cracked up to be (which I’m sure it will be), I’ll be registering it.

Tue 15 Jun ’10
2:49am

Peter R Mansfield

I’m using v1.6.8. I want to select data from another database called ‘sympa’ on my server. I can do it with an ordinary php file but when I copy the php code into an EE template and when I use the equivalent External Entries code, regardless of what SQL statement I use I get this output:

MySQL ERROR:
Error Number: 1146
: Table ‘sympa.exp_global_variables’ doesn’t exist
Query: SELECT variable_name, variable_data FROM exp_global_variables WHERE site_id = ‘1’ AND user_blog_id = ‘0’

For some reason the SQL statement I write is being replaced by the statement above that is rubbish. Any suggestions?

Tue 15 Jun ’10
10:32am

Peter R Mansfield

Adam, Yes I get the error with all combinations including a new template with PHP off and nothing but:
{exp:external_entries:select
  hostname=“localhost”
  username=“myusername”
  password=“mypassword”
  database=“sympa” 
  table=“subscriber_table”
}
{select:user_subscriber} - {select:reception_subscriber}

{/exp:external_entries:select} 

If I delete <table=“subscriber_table”> then I get a blank page except if I turn EE debug info on - but that does not indicate any problem. I’ll let you have access to my site if you want to see it for yourself.

Tue 15 Jun ’10
9:07pm

Peter R Mansfield

Adam, I’ve had a brainwave this morning (South Australian time). I can get the php code equivalent for what I am trying do to work properly by adding mysql_close($connectiontoexternaldatabase) then mysql_connect() and mysql_select_db() to reconnect to my EE database.

Tue 15 Jun ’10
9:25pm

Peter R Mansfield

Adam, Sorry I submitted my last post before I saw your request to download v2.3. I’ve now done so: It has made no difference that I can see. I don’t get anything other than the MySQL error message I reported above.

Tue 15 Jun ’10
10:09pm

Peter R Mansfield

Adam, I can do what I want to do faster with your plugin. Also the problem I am having could be a problem for other people. So please register at http://www.healthyskepticism.org and I will give you SuperAdmin status. If there is delay, it will be because I’m dong my day job. I’m a GP (family physician).

Fri 18 Jun ’10
10:34am

Lee

Hi Adam, could I use this to delete entries from specific, or all channels that are 3 days older than now?

Best wishes
Lee

Fri 18 Jun ’10
10:40am

Lee

Or by a cron?

Fri 18 Jun ’10
8:21pm

Peter R Mansfield

Adam, I’ve worked it out. External Entries works perfectly if System Preferences ›  Database Settings > Database Connection Type = Persistent. If Database Connection Type = Non Persistent then it works only if there is additional output PHP that re-establishes a connection with the EE database.  I suggest you add a few lines to your plug in to do that or ask customers to ensure that their Database Connection Type is set to Persistent.

Mon 21 Jun ’10
7:35pm

Peter R Mansfield

Adam, So there must be something unusual about my system. We have Debian setup to be very secure so perhaps there is something in that that caused the problem. Since we have a treatment that works we don’t need to investigate the exact cause of the problem. If anyone else gets similar symptoms I recommend ensure that the database connection type is persistent. All’s well that ends well. Thank you for some very useful plugins!

Wed 23 Jun ’10
12:36pm

Vee Van Dyke

Hey Adam - I am getting an error when I try to use the select command: here is the error.

A PHP Error was encountered

Severity: Notice
=============================
Message: Undefined variable: DB

Filename: external_entries/pi.external_entries.php

Line Number: 49
=====================
I am using 2.3 on EE 2. Any ideas what might be causing this?

Here is the page that is throwing the error:
http://www.wildernessfamilycoop.com/admin/delivery_dates/

Thanks!
Vee

Wed 23 Jun ’10
1:05pm

Vee Van Dyke

I figured it out….

I changed lines 49 and 50 in the plugin to
$DB = $this->EE->db;
$TMPL = $this->EE->TMPL;

FROM
$DB -> $this->EE->db
$TMPL -> $this->EE->TMPL

Works great now, BTW.

Mon 28 Jun ’10
6:29pm

JonnyTurner

Hi Adam, I’m trying to extract data from an external database and insert it into custom fields in my EE2 database. This is so I can create an advanced search (for a car site). Will your plugin do this?

I can successfully display results from a table and also insert into the database from standard text but not on the same page.

Mon 28 Jun ’10
7:33pm

JonnyTurner

Hi Adam, thanks for the very quick reply and advice!

I’ve set up the embed as described and can display the data results in the embedded template. Then I copied the insert example above to insert the {embed:stock_model} into new rows to create new entries but I get a couple of errors - one being:

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

I tried the update example as you initially mentioned and had the same error. Not sure where I’m going wrong with it. 

Thanks for the help.

Fri 2 Jul ’10
7:14pm

lukemcr

I’m looking for a quick way to just run a count from an external database using external_entries:select: something like SELECT COUNT(*) FROM table and having it spit out a number.

{select:count} and {select:total_results} aren’t really doing it for me. Is this really easy, or am I missing something?

Thanks a lot.

Fri 2 Jul ’10
7:54pm

lukemcr

Well, what I want is just a single number - the number of entries in a particular table in an external database. {select:total_results} loops through the table one time for each row, and displays the row count one time for each row.

Also, it’s capped at 100. I’m trying to get the post count from an external vBulletin database with 5 million + posts, so that doesn’t quite work.

FWIW, here’s my tags:

{exp:external_entries:select
  hostname=“127.0.0.1”
  username=“user”
  password=“password”
  database=“database” 
  table=“post”
}
{select:total_results}
{/exp:external_entries:select}

Fri 2 Jul ’10
8:02pm

lukemcr

Great, thank you. I’d love to be able to run the equivalent of

SELECT COUNT(*) FROM posts

in an external database, and display the results in EE.

Fri 2 Jul ’10
9:55pm

Chad Crowell

FYI Adam I am getting the same exact issue that Peter had before, and the persistent/non-persistent setting does fix it.  Seems like an update should be in order to allow non-persistent connections since EE recommends that.

Mon 5 Jul ’10
1:33pm

Jaycee

This plugin would be extremely useful to me if it allowed me to execute select queries that joined 2 or more tables. I have instances where I would want to associate data outside the EE database with entries in the EE database in a many-to-many relationship, so I’m using a linking table to store the cross references. Is there any possibility of using this plugin in such a case?

Tue 13 Jul ’10
4:06am

Kurt Deutscher

Hi Adam,

I’m having the same issue as Dr. Mansfield above. I would love for things to work without having to have the database connection Persistent in EE.

Any chance you have a version of this that works without a persistent connection type?

Fri 16 Jul ’10
8:59am

Peter R Mansfield

Adam, Sorry about the delay. I tested v2.3.3 with the code you wrote on my test page except I added connection =“persistent”. It does not work with my site having a persistent or a non persistent connection. Also it makes my utilities > plugins page be a blank screen.

Tue 20 Jul ’10
8:20pm

tree

Adam, Peter:

line 89 is missing the opening paren. that should solve peter’s problem (it did mine).

hope that helps!

teresa

Tue 20 Jul ’10
8:39pm

JonnyTurner

Hey guys,

I’m getting ‘Access denied for user’ when using select to connect to external database. I know the credentials are correct so is this a setting in EE 1.6.9 or external entries? It’s working fine in EE2.1 but had to downgrade the CMS to super search.

Tue 20 Jul ’10
8:58pm

tree

Hi again, Adam,

Here’s an odd one:

My html input elements aren’t being parsed inside and exp:external_entries_select. The greater than/less than signs are converted to entities. paragraph and label tags are fine, except for the closing paragraph tags that follow offending input tags.

If you know off-hand what the problem is, that’s great. I’ll dig through the plugin code some more to see if I see anything, as well…

thanks!

Tue 20 Jul ’10
10:01pm

JonnyTurner

Hi Adam, definitely fixed the blank page but not the access error unfortunately. I’ve used the same plugin from my EE2 version (where it works) and also the same code. Completely stumped on this one.

Tue 20 Jul ’10
10:19pm

tree

Another bit of info re my input tag non-parsing problem, above.

The template contains includes external_entries has “allow php” set to yes, on output. That template is embedded in another template that allows php on input… and that template is included in a template that does not allow php. Changing the top-level template does not fix the problem. When i echo the value of $params[‘allow_php’], it is always “n”....

Surely, I’m just missing something….

Tue 20 Jul ’10
10:52pm

tree

In response to my input vs allow php problem…..

Right! Got it.

I needed to set “allow_php” in the external_entries tag. I WAS missing something….

sorry for all the noise, but if it helps someone like me in the future, woot!

Tue 20 Jul ’10
10:55pm

tree

oh yeah, i could more _carefully_ read documentation ...

thanks again, and i’ll shut up now :)

Thu 22 Jul ’10
1:27pm

JonnyTurner

Hi Adam, yeah that would be extremely appreciated. I’ve emailed across the login details. I’m using the same build as you’ve mentioned above, installed the 2.3.4 plugin and also created a new db but with same probs.

Mon 9 Aug ’10
3:43pm

Frank Harrison

Hi. I’m wondering if this might be the solution to my problem. I need a way to:

1) Delete all entries that have a particular value in a custom field
2) Copy the value from a particular custom field onto the Status for all entries in a weblog, if they don’t already match

I’d be looking to do one of these actions (preferably the second) each night with a cron job, and the weblog might eventually have 10,000 or more entries to search through. Each night though only 10-50 entries would actually have changed/need updating.

Is this do-able with this plugin?

Thanks, Frank

Mon 9 Aug ’10
5:14pm

Frank Harrison

Thanks Adam. I think I MAY have found a way to do it with EE’s built in queries, but will definitely give this a go otherwise. Cheers!

Tue 17 Aug ’10
12:49pm

luvd

When external_entries:insert is used in a {if} ... {if:else} ... {/if} structure, the inserts are both executed.

For example:

{if logged_in}
  {exp:external_entries:insert table=“mytable” debug=“n” allow_php=“yes”}
  {insert:myfield}ABCD{/insert:myfield}
  {/exp:external_entries:insert}
  logged_in = TRUE
{if:else}
  {exp:external_entries:insert table=“mytable” debug=“n” allow_php=“yes”}
  {insert:myfield}EFGH{/insert:myfield}
  {/exp:external_entries:insert}
  logged_in = FALSE            
{/if}         

Although EE only shows either “logged_in = TRUE” or “logged_in = FALSE”, there are 2 records inserted in mytable: one containing the value “ABCD” and one containing the value “EFGH”.

Tue 17 Aug ’10
2:49pm

luvd

The same result when using two separate conditionals.

Note hower that, when the parameter debug=“y” is set on the 2 external_entries:insert tags, that only one SQL-statement is displayed. But when both tags have debug=“n”, they are both executed.

Tue 17 Aug ’10
3:09pm

luvd

Using EE 2.1.0

Tue 17 Aug ’10
6:49pm

luvd

That seems to work. Thx.

Fri 20 Aug ’10
8:13am

Victor

Could you provide examples of using .load and .live ?

Fri 20 Aug ’10
6:47pm

unruthless

Hi Adam, how would you go about using data output by this plugin within an EE conditional? I’m trying to do something like the following:

{exp:external_entries:select table=“Events” search:event_id=”{segment_3}” limit=“1”}

This event is of type {select:event_type}.
This means that this event is a ...
  {if select:event_type==”“}(no idea){/if}
  {if select:event_type==“community”}community event!{/if}
  {if select:event_type==“special”}fundraising event!{/if}

{/exp:external_entries:select}

The {segment_3} works fine, since I guess EE parses URL segment variables before parsing plugin code.

But for whatever reason, the second paragraph always outputs “(no idea)”, even when the first paragraph correctly outputs “community” or “special”.

I’ve tried doing this using PHP conditionals rather than EE conditionals, but keep getting errors like “Notice: Use of undefined constant special - assumed ‘special’ in [redacted]/system/core/core.functions.php(634) : eval()‘d code on line 31”.

Wed 1 Sep ’10
9:00pm

jonhorton

Hi Adam,
I really like the capabilities of this plugin, but i’m having a few issues.
I’m trying to use the select function to pull data related to the currently logged in member_id:

{exp:external_entries:select table=“exp_member_data” search:member_id=”{member_id}” debug=‘n’}
{select:m_field_id_11}
{/exp:external_entries:select}

However, I don’t think {member_id} variable is parsing properly.  I’ve tried the parse=“inward” parameter, but that doesn’t change anything.

I’ve found that if I replace {member_id} with <?php global $SESS; echo $SESS->userdata(‘member_id’);?> and enable php on input, it works properly. 

Is this the best way to access member variables?

Thanks!

Wed 1 Sep ’10
9:37pm

jonhorton

Unfortunately that doesn’t work, as my query now shows like this: member_id = ‘1{/exp:member:custom_profile_data}’

According to the documentation, {member_id} is a global variable, and should be available without the custom_profile_data tags. Am I wrong in this?

It’s interesting to note that when I turn debugging on, and just using {member_id} variable, that the SQL shows the correct member_id.  Seems like that should work, but it’s hanging somewhere.

Wed 1 Sep ’10
10:22pm

jonhorton

Adam,

THANK Y OU! :)

I was putting the custom_profile_data tag in the wrong spot - inside of the external entries plugin, instead of wrapping external entries with the custom_profile tag .  Your example fixed all of my problems, and I no longer have to use php.

This plugin is awesome, Thanks again for your help!

Thu 2 Sep ’10
2:59pm

jonhorton

Allrighty, back with another weird issue!

I’m using a module called Redeemer which is a coupon redemption system.  It checks the entered coupon code and if valid returns a response.  If invalid, it returns an invalid response. I’m trying to use external entries in conjunction with redeemer to automatically update a custom member data field if the coupon is valid.

{if valid}
{exp:member:custom_profile_data}
  {exp:external_entries:update table=“exp_member_data” search:member_id=”{member_id}” debug=“n”}
      {exp:math_plus calculate=”{reward-points} + {coupon-points}” }
          {update:m_field_id_11}{math_plus_result}{/update:m_field_id_11}
      {/exp:math_plus}
  {/exp:external_entries:update}
{/exp:member:custom_profile_data}
{/if}
{if invalid}
  Sorry, your code is not valid
{/if}

If the coupon returns a valid response everything works fine.  When the coupon is invalid, the external entries plugin still runs and tries to update the database.  I receive a php error: Notice: Undefined variable: sql in /home/fintronx/fintronx.com/admin/plugins/pi.external_entries.php on line 593

Is there an obvious reason as to why the external entries plugin runs even though it’s wrapped with an if statement that’s not true?

Thu 2 Sep ’10
3:07pm

jonhorton

I also forgot to mention that I’m running EE 1.6.9

Thu 2 Sep ’10
3:17pm

jonhorton

Back again.  I may have found the culprit. (i’m a php novice, so hopefully this is right!)

$sql=”“; wasn’t defined for the Update and Insert functions in pi.externalentries.php around line 512 and 632.

Once i defined sql, i no longer receive the error, and everything is functioning as it should.

Fri 3 Sep ’10
7:16am

Paul

Yes, it’d be great to see an example of “using .load and .live” - how to use a form to submit data to an external database “seamlessly” using Ajax.

Wed 8 Sep ’10
9:34pm

Bob Romanko

Hi there Adam, and greetings from Alaska!

I’m evaluating External Entries 2.3.5, and have it installed with EE 1.6.8.  I can’t seem to shake this 1146 error:

MySQL ERROR:

Error Number: 1146

Description: Table ‘resp_db.exp_template_groups’ doesn’t exist

Query: SELECT exp_templates.template_name, exp_templates.template_id, exp_templates.template_data, exp_templates.template_type, exp_templates.edit_date, exp_templates.save_template_file, exp_templates.cache, exp_templates.refresh, exp_templates.no_auth_bounce, exp_templates.enable_http_auth, exp_templates.allow_php, exp_templates.php_parse_location, exp_templates.hits, exp_template_groups.group_name FROM exp_template_groups, exp_templates WHERE exp_template_groups.group_id = exp_templates.group_id AND exp_template_groups.site_id = ‘1’ AND exp_templates.template_name = ‘header’ AND exp_template_groups.group_name = ‘_includes

(by the way…this error only shows up in Chrome.  Firefox and IE8 only give blank pages)

The code in the registration template is pretty straightforward…pretty much off the example:

{exp:external_entries:select
  hostname=“my_hostname”
  username=“my_username”
  password=“my_password”
  database=“resp_db”
  table=“resp_users”
  orderby=“dsc_name”
  sort=“asc”
  limit=“15”
  debug=“yes”
}

<table>
<tr><th>Full Name</th><th><UVa ID</th><th>Email Address</th><th>Employee ID</th></tr>
<tr><td>{select:dsc_name}</td><td>{select:a_code}</td><td>{select:email}</td><td>{select:emp_id}</td></tr>
</table>

{/exp:external_entries:select}

I saw Peter Mansfield’s posts regarding this same error, and tried also connection=persistent, since my EE install is set to non-persistent, and it made no difference.

My EE install is using the same MySQL server as my external database, so the server name is the same as my EE install, but the database name is different, of course.

Please let me know if you need any clarification, and thanks so much!

- Bob

Fri 10 Sep ’10
3:57pm

Bob Romanko

Hey Adam….I’m squared away.  I tried the repair/optimize, but no joy, so I just moved my table into my EE database and removed the parms no longer needed.  It’s working great now.  My next step is to include a checkbox next to the rows to allow users to check off which rows to delete.  Hmmm…..will have to kick around in the examples ‘n such to see the best way to pull that off!  Thanks for your help.

Mon 20 Sep ’10
6:58am

aaronlax

I am working on implementing this as a front end form for inserting new weblog entries…I have successfully created a form that uses the .post function to send field data to my external_entries template used to process the changes.
I have exp:external_entries:insert used for tables exp_weblog_entries, and exp_weblog_data
I also have exp:external_entries:update in there to update exp_weblogs (total_entries and last_entry_date)

My problem is that my actual display of the entries added to the database this way dont show up unless I go into the CP and manually update ONE of the entries

So: i can add any number of entries using external_entries and then update ANY one of those entries through the CP and only then will they show up inside of a weblog tag on the front end
I have checked and double checked all the database entry areas, time fields, etc and I cannot find anywhere there is anything inconsistent.

Do you know if there is anywhere else that needs to be updated/refreshed so this update through CP process wont be needed?

Mon 20 Sep ’10
12:44pm

aaronlax

Adam, thanks for the quick response!  I actually had gone ahead and simply updated the weblog_data -> entry_id field to auto increment without having any issue…
other entry post processes seem unaffected by the change and it also cured the sync issue of this process.
I have all the caching for the templates turned off, and flushing the cache manually through the utilities does not make a change either.  Only through re adding or re saving an entered entry does the system recognize the external_entries added posts.

My initial thought was that there is a count or some other field somewhere that gets updated letting the system know to recognize the added entries, or a cache somewhere else…

if you want to contact me through email directly i can show you the code im working with to execute this, and although I wish i could just rely on the SAEF, if this works your module will allow me to string together a number of different functions this specific client has requested to help ease workflow for their users
so close!!

Mon 20 Sep ’10
5:31pm

aaronlax

I adjusted that auto increment back like you suggested, i was concerned about that anyway so your way makes sense.
I could put the plugin in to an embedded templste…but at this point I keep thinking that i shouldnt have, and ive spent so much time getting this solution staged it would feel like a step backwards…if only in admittance of defeat..hah!

Mon 20 Sep ’10
6:06pm

aaronlax

I hear ya, I am going to give this one more try through to see if i can’t do it all using your module!
I’ll keep you updated!

Thu 23 Sep ’10
5:26pm

aaronlax

I got it!  Apparently in an unrelated issue query caching was turned on even though the setting in the CP indicated otherwise…
I have gotten the update, and insert functions working, with a combination of ajax and _POST functions
I am now working on the delete entry functions, my initial attempt using the same php code to bring in post data has failed, is there a php_allow parameter available here or do you believe there is another issue?

Thu 23 Sep ’10
5:34pm

aaronlax

Scratch that last post, sorry for cluttering up your board with questions. I got everything working flawlessly, if you want me to post examples for your other users of clean usage of this module with jQuery and Ajax for posting, editing, and deleting entries, let me know!

this module rocks!!

Thu 23 Sep ’10
5:39pm

Paul Shand

@aaronlax - I’d love to see some examples of what you did here.

Thu 23 Sep ’10
5:44pm

aaronlax

Yeah, makes sense.  I’ll put up an example end of day (EST), have to finish this stuff!

Sun 3 Oct ’10
8:05am

timmo26

@aaronlax - any joy on the examples, would be great to see some!

Sun 3 Oct ’10
11:35pm

aaronlax

Hey guys, sorry for the delay, had to finish the client project then get something generic on our side so I could share!  I posted a blog entry at:
http://www.wearepapertiger.com/blog/entry/expression_engine_front_end_publishing_using_external_entries

Feel free to leave comments there with any questions, and thanks again Adam for working with me on this!

Thu 7 Oct ’10
11:41am

crossfade

I’m wondering about the following…

The easiest way to pass variables in Expression Engine (or at least an easy way) is through the URL segments.

I’m testing out External Entries, but it seems that the segment_n etc values are not available at the time external entries is “doing its thing”.

Is there a work around to allow this to be the case?

for example, if I have template_group/data1/data2/data3 and want to insert these data values into a table, it doesn’t work, because external entries runs before those variables are parsed.

Any ideas?

Thu 7 Oct ’10
12:14pm

crossfade

Thanks for the quick response and the suggestion.

I seem to be hitting a really weird problem.

I tried the php method and it “sort of” works.  Actually, it is “sort of” working just using the segment without php now that I’ve set the field to be text rather than numerical, in that the {segment_3} is being parsed, but as a completely different thing.

It’s actually being parsed as “images”, which is nowhere in the URL segments at all.

Even more intriguing is that with debug set to “y” it appears to be working correctly.  But when I set debug to “n” it runs and inserts a different value into the table than the debug info shows.

I tried the embed method first, because that was the first thing I thought to do, and it gave the same result.

I’ll keep trying and see if I can get to the bottom of it

Thu 7 Oct ’10
1:00pm

crossfade

Sorry, just to clarify what I meant…

With debug set to “y” it does as it is meant to do.  It outputs the SQL on the template.

And the SQL it outputs on the template in debug mode is correct.

ie. UPDATE exp_channel_data SET field_id_x = “correct data”

However, when I then set debug to “n”, the actual SQL executed is:

UPDATE exp_channel_data SET field_id_x = “images”

(Well, that’s what I assume the SQL is, because what gets entered into the table is the word “images”)

However, I have found a fix, although it completely baffles me as to why this works.  If I use segment_3 to pass the data through, then it works.  If I use segment_4 it doesn’t.

I was passing entry_id as segment_3 and the data as segment_4

I swap them around and have data in segment_3 and entry_id in segment_4 and it works fine.

I’ll play around a bit and keep you updated.

Fri 8 Oct ’10
3:14am

al

hi there,
I have just bought your plugin, and i think its great. However its missing one key thing - ability to grab the autoincrement value straight after an insert. The only way to get around it is to run a separate select straight after grabbing the last entry id. However because it is a separate query, you will run into concurrency issues for high volumn sites. The last id entry that you are selecting might not be for the record that you have just added.

Mon 11 Oct ’10
11:04am

denza

Hi,
Are supported nested methods?

For example:

{exp:external_entries:select EXTERNAL DB}
  {exp:external_entries:insert LOCAL DB}
      ...
  {/exp:external_entries:insert}
{/exp:external_entries:select}

Mon 11 Oct ’10
4:26pm

denza

With parse=“inward” there are PHP Errors was encountered:

Message: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
Filename: external_entries/pi.external_entries.php
Line Number: 165

Message: Undefined variable: fields
Filename: external_entries/pi.external_entries.php
Line Number: 172

Message: Invalid argument supplied for foreach()
Filename: external_entries/pi.external_entries.php
Line Number: 172

The same issue when both methods are separate (and without parse=“inward” )

Thu 25 Nov ’10
1:05am

crossfade

Hi,

Just a couple of things.  First is a feature request.  The “orderby” and “sort” functions of external entries do not allow for ordering via multiple conditions via the use of the pipe character as the normal expression engine channel entries tag does.

So, for example, I have a list of people and I want to order them by gender, surname and first name.  But currently have to do this in a very complex way.  I’m not sure how difficult this would be to implement, but it’s a feature request to consider anyway :-)

The second is a question regarding the use of form fields within the external entries select tag.  For some reason, when I use form fields (ie. <input type=“text”> etc.) within the tags, all the html from that point onwards starts being parsed as plain text.  I’m not sure why this would be the case, and was wondering whether there was a way around it.

Thanks!

Thu 25 Nov ’10
4:29am

crossfade

Just another question :-)

Does external entries ignore “if” statements?

Or more correctly, is it parsed prior to the if statements in a template?

What I’m experiencing is that if the external_entries tag is on a template, it runs regardless of whether the if statements that surround it are true.

By the way, in the “debug” mode it seems to be outputting correctly, but with debug set to ‘n’ it doesn’t

Tue 30 Nov ’10
5:24am

ContextDesign

I’ve been playing around with External Entries, trying to accomplish something like this, but it’s not working:

<? $yesterday = {current_time} - 86400; ?>

{exp:external_entries:update table=“exp_weblog_titles” search:entry_id=“888” debug=“y” allow_php=“y”}
{update:entry_date}<? echo $yesterday; ?>{/update:entry_date}
{/exp:external_entries:update}

With debugging on, it shows the correct MySQL query, but with it off, it resets the entry_date to 0. Using {current_time} works, but I’m trying to offset the time.

Using 1.6.9, if it makes a difference.

thx!

Tue 7 Dec ’10
1:33pm

Ciaran Mc Donnell

Hi Adam

When I try to add an entry it doesn’t work. I enable debug and try and enter the query manually to the database but i expects values like channel_id, entry_date, year etc. Do i need to include these values when using exp:external_entries:insert?
I am using EE version 2.1

Thanks

Thu 9 Dec ’10
1:31am

PixelGrinch

I am swapping from custom fieldgroups to the gipsy plugin. I am now in the process of copying the data over to the new gipsy fields but have a problem with my uploaded images. How can I save the tag eg. {filedir_3}, raw into the new field. At this stage it always rewrites it and replaces it with the actual value of the web address to the image .... Is there any way to do this essentially suppressing expressionengine to expand the tag.
I need this:
{filedir_3}17344760.jpg
instead of this:
http://www.somedomain.com/images/uploads/17344760.jpg
Thanks!

Thu 9 Dec ’10
6:44pm

PixelGrinch

Gipsy is a Custom Field Add-On also. I guess it just caused confusion! Let’s forget about Gipsy.

current content of custome field {report_scan} is
{filedir_3}17344760.jpg.
I am trying to copy this exact value into field_id_224 using the following entries operation:

{update:field_id_224}{report_scan}{/update:field_id_224}

Now I am sitting here and the value in the updated field is not
{filedir_3}17344760.jpg, it actually is now:
http://www.somedomain.com/images/uploads/17344760.jpg

I understand that expressionengine converts every tag into its value and {filedir_3} happens to be the directory where I uploaded the image to, through the EE CP,
http://www.somedomain.com/images/uploads/ !

if I ever decide to rename {filedir_3} I am completely SOL. Another issue using https breaks the SSL by mentioning unsecure items on the page.

Maybe it makes more sense now and the question remains how can I retain the original value of

{filedir_3}17344760.jpg and copy it into field_id_224?

Thanks.

Fri 10 Dec ’10
3:23am

PixelGrinch

I found a solution to my problem I described above.
It required the use of an embedded template. In my case:

{embed=“includes/tester” fname=”{report_scan}” entryid=”{entry_id}” }

the call of the embed was made within the weblog:entries tag. through the embed I passed on the entry_id and the unwanted expanded content of the custom field.

the content of the embedded template is this:

{exp:weblog:entries weblog=“reports” entry_id=”{embed:entryid}” status=“not whatever” dynamic=“off”}

{exp:external_entries:update table=“exp_weblog_data” search:entry_id=”{entry_id}” debug=“n”}
{update:field_id_224}{filedir_3}<?php echo end(explode(’/’,’{embed:fname}’)); ?>{/update:field_id_224}
{/exp:external_entries:update}
{/exp:weblog:entries}

I basically passed on the expressionengine expanded {filedir_3}. I then stripped out everything but the filename and extension, then added {filedir_3} in front of the filename and extension within the entries:update tags.

Thanks ...

Mon 3 Jan ’11
8:30pm

peishu

Hi Adam,

I am trying to update a table by using a form. Here is the processing page once the form is submitted:

{exp:external_entries:update table=“exp_matrix_data” search:row_id=”{segment_3}” limit=“1”  debug=“no” allow_php=“y” parse=“inward”}
{update:col_id_1}<?php echo $_POST[‘student_first_name’]; ?>{/update:col_id_1}
{update:col_id_2}<?php echo $_POST[‘student_last_name’]; ?>{/update:col_id_2}
{update:col_id_3}<?php echo $_POST[‘student_nickname’]; ?>{/update:col_id_3}
{/exp:external_entries:update}

Everything works fine unless the form contains a blank field. If the field is left blank and submitted, the php code gets inserted into the database.

For example, if I leave student_nickname blank on the form,  then

<?php echo $_POST[‘student_nickname’]; ?>

gets inserted into the database. Other fields still get inserted/updated properly.

There are no errors when debugging, nor does the code show up as being inserted when debugging.

PHP parsing is set to Input on the update template.

I hope this makes sense.

Thanks!

Peishu

Wed 5 Jan ’11
3:39am

peishu

Adam,

I figured out the problem.

Peishu

Mon 10 Jan ’11
6:28pm

peishu

Adam,

I found the problem, but do not have the solution. It appears that when I UPDATE a field by removing the content and making it empty, the database will not update with an empty field. 

Updates with characters and spaces work.

Peishu

Mon 17 Jan ’11
5:18pm

heaversm

Hi - I wanted to do something like this:

I wanted to do something like this:

{exp:external_entries:update table=“exp_custom_stats” search:stat_name=“site_views” debug=“n” allow_php=“y”}
{update:stat_count}stat_count++{/update:stat_count}
{/exp:external_entries:update}

How would I increment the stat_count variable?

Tue 18 Jan ’11
3:07am

heaversm

Hi Adam,

Thanks for the tip. I’ve done what seems should work, but with no luck. I can get the value to increment, but I can’t seem to get it to commit to the DB. If I hard code a statistic value, it works, but when I replace it with the echoed php variable, it doesn’t work. Here’s the code:

{exp:external_entries:select table=“exp_custom_stats” search:stat_name=“site_views” limit=“100” allow_php=“y”}
      {select:stat_name} : {select:stat_count}
  <?php
      $site_views = ‘{select:stat_count}’;
      $site_views++;
      echo “$site_views”;
    ?>
{/exp:external_entries:select}

{exp:external_entries:update table=“exp_custom_stats” search:stat_name=“site_views” debug=“n” allow_php=“y”}
{update:stat_count}<?php echo “$site_views”; ?>{/update:stat_count}
{/exp:external_entries:update}

Sun 30 Jan ’11
5:17pm

heaversm

Hi Adam - regarding my comment above - is there no way to do this without an embed template? The problem with using an embed is it executes immediately before the rest of the template is parsed, and I want this to execute on a javascript onclick command.

Mon 31 Jan ’11
10:53pm

heaversm

Thanks - I’ve attempted this many times, but nothing seems to submit to the database. I’m checking my syntax and my passed variables - everything’s right but it’s not increasing the value. This is my setup:

Initial template increments the variable

{exp:external_entries:select table=“exp_custom_stats” search:stat_name=“tv_views” limit=“1” allow_php=“y”}
  <?php
      $stat_val = ‘{select:stat_count}’;
      $stat_val++;
      echo “$stat_val”;
  ?>
{/exp:external_entries:select}

the javascript function:

$(’.stat_increment’).click(function(){
  $(’.stat_loader’).load(’/index.php/ajax/download_increment/’+<?php echo “$stat_val” ?>,function(){
      alert ($stat_val);
  });
});

And the ajax/download_incremement template:

<?php $new_val = {segment_3}; ?>

{exp:external_entries:update table=“exp_custom_stats” search:stat_name=“tv_views” debug=“n” allow_php=“y”}
  {update:stat_count}
  <?php echo “$new_val” ?>
  {/update:stat_count}
{/exp:external_entries:update}

Mon 21 Feb ’11
9:54pm

Marc Tanis

I know it would require some hacking, and I’m not asking you to support this, but would it be a major overhaul to manipulate this plugin to work with a MS SQL Server? I can do all the code manipulation. I know Codeigniter can handle this and Just wanted to see if this sounded like a plausible feat with this plugin

Wed 9 Mar ’11
5:20pm

Pv Ledoux

Hi there!

I’m trying to do this:

  {exp:external_entries:Update table=“exp_channel_data” search:entry_id=”{segment_3}” debug=“n”}
      {update:field_id_38}y{/update:field_id_38}
      {update:field_id_39}{screen_name}{/update:field_id_39}
  {/exp:external_entries:Update}

But screen_name is not parsed. Do you know how I can do that?

Thanks!

Regards,

Thu 10 Mar ’11
8:04am

Pv Ledoux

Thanks Adam, that works!

Wed 6 Apr ’11
12:51pm

JonnyTurner

Hi Adam, is there a way to pull unique records only e.g. SELECT DISTINCT etc?

Wed 6 Apr ’11
9:51pm

JonnyTurner

Absolute star!  I’m getting ‘undefined variable: distinct’ line 385. I’ve had a look but I’m not really good at php.

Sat 16 Apr ’11
1:29am

Anthony

Could you please give me a quick tutorial on how to use the select function with checkboxes to sort through columns of a database? I want to dynamically provide search results from an external database by checking and unchecking checkboxes using your plugin. Much appreciated.

Wed 20 Apr ’11
9:40pm

ThreeLoop

How would you go about adding a switch class to every second row?

Thu 21 Apr ’11
2:20am

ThreeLoop

I came across a weird bug. when I add the conditions of my search to the {exp:external entries:select} tag. It seems to base filtered search results on the order in which the search paramater is listed.

Here’s a test page:

[Removed]

If I filter for “A” it lists all fields that match “A”. If I then check “B” (which is the second search parameter) it then correctly filters to fields that match both “A” and “B”,

However, if I select a checkbox, and then select a checkbox previous to that checkbox in the search parameter order, then it doesn’t filter the results correctly and only filters for the first parameter. Any help would be much appreciated as I am on a time contraint.

Fri 6 May ’11
12:31pm

Casey

I want to purchase this but I’m not sure if it’s possible to do what I’m trying. I need to change the member group_id when the template is called. Is it possible to update member data? I wasn’t able to get it working, but I’ll keep trying if you tell me it’s possible.

{exp:external_entries:update table=“exp_members” search:member_id=”{member_id}” debug=“no” limit=“1”}
{update:group_id}3{/update:group_id}
{/exp:external_entries:update}

Sat 7 May ’11
8:47am

Valon Sopi

Hello crew,

I’ve tried updating EE1.6 to 2.x // however there’s many glitches during the updating part.

My reasoning was to use an add-on that would allow me to import all previous data (close to 2000) into a brand new installation of EE (given that I create the similar custom fields, etc.)

My specific question — Would this add-on allow me to do that? Meaning: Allow me to import 2000+ entries from an older DB into a brand new installation of EE2.x? /// And are there any specific steps I need to take to achieve this — Or is this all covered in the documentation : )

(Apologies for not reading through a lot, as I’m quite restless trying to find the ideal solution)

Cheers.

— Valon.

Sat 7 May ’11
11:43am

Valon Sopi

Hey Adam.

Thanks tons for the reply and the suggestion for DataGrab.

Yes. EE Tech Support is great, however I’ve decided to go with a fresh install as many of the modules I’ve used on 1.x will no longer be valid on 2.x anyways. Also, a fresh install just feels much better : )

Cheers man!

— Valon.

Sat 21 May ’11
3:43am

Dave

1) Does External Entries work with nested queries “WHERE field IN (Select field FROM table)”? 
2) Would the nested query be escaped?
3) Does External Entries have a WHERE clause?  Especially for tables not in EE.
4) How can I do complex queries with External Entries?
Thanks

Fri 17 Jun ’11
2:28pm

Baba Ganoosh

How do I do MySQL LIKE search with this component?

Thanks

Fri 17 Jun ’11
6:43pm

Baba Ganoosh

Sorry I could not wait, I made minor modification to the code to support like

function _insert_filters($filters)
  {
      $i=”“;
      $sql=”“;
      foreach($filters as $filter_field => $filter_value)
      {
        $i++;
       
        $val = strtolower($filter_value);
       
       
        $is_like = false;
       
        if ( ($index = strpos($val, ‘like:’)) !== false)
        {
          $filter_value = substr($filter_value, 5);
          $is_like = true;
        }
       
        if ($i > 1)
        {
          $sql .= ” AND “;
        }
       
        if ($is_like)
        {
          $sql .= ” $filter_field LIKE ‘$filter_value’ “;
        }
        else
        {
          $sql .= ” $filter_field = ‘$filter_value’ “;
        }
      }
      return $sql;
  }

I am sorry if this is redundant.

Cheers,

Mon 27 Jun ’11
3:07pm

vickster

Adam:

I’ve read through this whole thread and it seems my problem is identical to Peter Mansfield’s, but I’ve set the db connection to persistent - both in the cp and in your code - and it makes no difference. I’ve also repaired and optimized the EE database tables. Any other idea what might be going on?

The specific error is:
MySQL ERROR:

Error Number: 1146

Description: Table ‘EXTdbNAME.exp_global_variables’ doesn’t exist

Query: SELECT variable_name, variable_data FROM exp_global_variables WHERE site_id = ‘1’ AND user_blog_id = ‘0’

I’m using the following code in it’s own template:
{exp:external_entries:select
hostname=“blah”
username=“blah”
password=“blah”
database=“DBNAME”
connection=“persistent”
table=“Listing”
sort=“asc”
limit=“4”
}

{select:title}
{select:display_url}
Thumb-Id: {select:thumb_id}

{/exp:external_entries:select}

Tue 28 Jun ’11
9:57pm

ContextDesign

Still having the same troubles as months ago:

I’ve been playing around with External Entries, trying to accomplish something like this, but it’s not working:

<? $yesterday = {current_time} - 86400; ?>

{exp:external_entries:update table=“exp_weblog_titles” search:entry_id=“888” debug=“y” allow_php=“y”}
{update:entry_date}<? echo $yesterday; ?>{/update:entry_date}
{/exp:external_entries:update}

With debugging on, it shows the correct MySQL query, but with it off, it resets the entry_date to 0. Using {current_time} works, but I’m trying to offset the time.

Using 1.6.9, if it makes a difference.

thx!

Thu 30 Jun ’11
9:55pm

ContextDesign

Thanks Adam. It’s always the simple things that trip me up ; )

cheers!

Fri 1 Jul ’11
7:02pm

vickster

Adam: sorry there is no EXT in front of the database name. That must have been my typo when I was removing the db ids. The weird thing is when I got your message I looked at the page in the browser and it worked! I have no idea why, but I then tested some php in the same template, then went back to the original external entries code and it gave me the same original error again.

I can’t figure out why. I’ve tried every php setting on Preferences (right now it’s set to off), I’ve cleared the cache, restarted the computer. I thought this might be why it worked before, even though I’m testing on a remote server.

Still perplexed

Fri 8 Jul ’11
2:16am

ThreeLoop

I’m having an issue with one of the forms on my site that deals with external entries.  I’m not sure if it’s an external entries problem or not as I don’t think it is, but maybe someone does know how to fix it. When I submit a form and pass get variables to a page containing external entries and embed the $_GET variables as parameters in my search I get the errors below. I do this in other areas of my site without any issues. Thoughts?

“
Message: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given
Filename: external_entries/pi.external_entries.php
“
“
Message: Cannot modify header information - headers already sent by
“

Tue 12 Jul ’11
1:53pm

vickster

orderby=“random” does not appear to work (no results are returned when I use it). I can orderby a field, but in the instructions you said orderby works as it does for ee tags. Is there another way to return random entries/rows?

Tue 12 Jul ’11
2:32pm

ThreeLoop

is there a way to display certain entries based on ID,? Say I want entry_id 2, 3, and 4 to display.

Wed 13 Jul ’11
12:19pm

opalescence

I figured out the problem.

Sat 30 Jul ’11
9:00pm

Casey

Hi, I really like this plugin. Thanks.
Is there any reason you can think of why this works:

{if group_id == ‘3’}
<?php
$member_id = ‘{embed:memberid}’;
$groupid = ‘5’;
$data = array(‘group_id’ => $groupid);
$sql = $this->EE->db->update_string(‘exp_members’, $data, “member_id = ‘$member_id’”);
$this->EE->db->query($sql);
?>
{/if}

But this does not:
{if group_id == ‘3’}
{exp:external_entries:update table=‘exp_members’ search:member_id=’{embed:memberid}’ debug=‘n’ limit=‘1’ parse=‘inward’}
  {exp:channel:entries channel=“orders” status=“Open” author_id=“CURRENT_USER” limit=“1”}
      {order_items}
     
      {if entry_id == ‘404’ || entry_id == ‘405’ || entry_id == ‘406’}
        {update:group_id}6{/update:group_id}
      {if:else}
        {update:group_id}5{/update:group_id}
      {/if}
     
      {/order_items}
  {/exp:channel:entries}
 
{/exp:external_entries:update}
{/if}

Sun 31 Jul ’11
12:25am

Kurt Deutscher

We just trying to post weblog entries from a second install of EE (different database) within the same hosting account. This is for a client with 40+ sites, and we have some content in the older EE 1.7.x that we need duplicated in a site within an EE 2.2.x install that share the same hosting account.

We can get either the title or the content of the entry to display, but not both at the same time. Also we need to use entries with a status of “open” and that works fine with the titles.

How on earth do we do do the equilivent of a weblog/channel tag?

This was our last attempt, but it’s not displaying a thing:

External Entries (Select) Debug is on. Errors:

  No errors!

External Entries (Select) SQL: SELECT * FROM exp_weblog_titles INNER JOIN exp_weblog_data WHERE ( exp_weblog_titles.status = ‘open’ ) AND ( weblog_id = ‘376’ ) LIMIT 6;

and our tag:

{exp:external_entries:select
  hostname=“localhost”
  username=“xxxxxx”
  password=“xxxxxx”
  database=“xxxxxx” 
  table=“exp_weblog_titles INNER JOIN exp_weblog_data”
  search:exp_weblog_titles.status=“open”
  search:weblog_id=“376”
  limit=“6”
  debug=“yes”
}

<h1>{select:title}</h1>
{select:field_id_21}

{/exp:external_entries:select}

Wed 10 Aug ’11
1:54am

icebreaker

The link to the article on the use of JQuery load() by Aaron Lax is broken—he may have moved on. It could be useful with an example where e.g. a click on a row could trigger a status change without having to leave the template showing the list of entries.
(Perhaps using external entries for this is an overkill).

Fri 9 Sep ’11
4:23pm

Jaxbulls

I’m having an issue with the latest version on EE 1.7.1 where {if no_results}text{/if} does not work if there are no results.

It also breaks any other other {if no_results} within a {exp:external_entries:select} to not work.

I have an exp:query inside of an external_entries:select and the exp:query cannot display no_results but if i move it outside of the exp:external_entries:select it works again.

Is there any way this could be fixed?

Sun 18 Sep ’11
8:44pm

Dmitry

hi Adam! Thanks for the awesome work!
My problem is that i am getting questions marks when trying to store russian characters in DB. I would usually set mysql_set_charset(‘utf8’);  in php, that would solve it.. But i’m lost what should i do within exp:external_entries:select tag. Can you help?

Mon 19 Sep ’11
8:31am

Dmitry

Thanks Adam, i tried this with different syntax, but no luck so far..

Fri 28 Oct ’11
7:53pm

Gavin

Adam, I was wondering how best to exclude table values. One of the columns who’s values I want to display is an “Initials” column, but during testing a whole lot of “TEST"s were entered.  My various attempts at this using various combinations of != have proved to be failures. Advice?

Sat 10 Dec ’11
6:35pm

David Slattne

Hi!

EE has defenitely got some very nice and needed updates on the filemaneger and Assets is also a very sweet eh… well ‘asset’ for handling files and images.
The only working way of having people upload images is the let them batchupload but after that I defenitely want to be able to treat each and every image as if they were separetely posted as entries.
This is what I hope for External_entries to help me with. Every time the filemanager gets synced thera are new rows in the exp_files table. Listing the contents of the file_names column was not very hard following your examples.
But now I would like to have External_entries automatically create a new entry in for each file_name just listed. And this is where my smartlessness hits my coding in all its glory.
Is there a way to accomplish this you think?

And if so… How do I avoid reduntant imports next time this template loads. Should I have it take note of the highest file_id from the exp_files table and keep it until next time?

/regards David S, Sweden

Sat 7 Jan ’12
1:21pm

Ruslan Ka

Hi Adam, just want to clarify few points before buying the plugin.
Will I be able to go through the entries of the particular channel and change particular value in all of them ?
And will you be able to assist me with syntax for it?

Sun 8 Jan ’12
7:49am

redkeycode

Can you provide just one simple example where (using EE 2x) I just allow the user to submit a variable and I use that variable in my SQL.  So on 1st page they have a form box that says, enter a color.  hit submit - with that color the DB sql (custom table) gets back (select hat where color = “user input”)

Mon 9 Jan ’12
3:39am

redkeycode

Sweet - thanks for quick reply!

Thu 2 Feb ’12
11:55pm

casey

I was curious if it’s possible to submit queries via json as parameters?

Mon 13 Feb ’12
10:21pm

Marco Vazquez

Hello, I’m having issues with the nesting options. Could you provide an example of how to use a field from the first query as a variable for the next query?
Hope I can explain myself:
{exp:external_entries:select parse=“inward”
  // Data for the server, tableA
  search:fieldA=“6”
  limit=“5”
}

{exp:external_entries:select parse=“inward”
  // Data for the server, tableB
  search:fieldB=”{idFieldTableA}”
  limit=“1”
}

{/exp:external_entries:select} 

{/exp:external_entries:select} 

The idea is to get the items from a Table and each one of them, has an Image that is assigned on another Table using the Item ID .  Something like a JOIN.

What is happening is that the system is able to read the variables for each item but when displaying the info is using the value from only the first Item found.
Please, any help will be great!

Mon 13 Feb ’12
11:45pm

Marco Vazquez

Hi Adam,
I’m using inward in both calls.  Should it be only on the outer call? I have tried both combinations.

Thanks

Tue 14 Feb ’12
12:34am

Marco Vazquez

I’m a newbie and haven’t used embedded template but I will try in a few.  I guess that the process will be more complicated as I need also to create a pagination system for the results of the query…  And here, I think it will require the declaration of some global variables….

The funny thing is that I used php to hold the variable and when I display just the variable it shows the # that should be.  As soon as I use the variable as part of the query, it shows only the value of the first result of the outer call.

Also, tried a if conditional for other values and it only uses the value from the first item.

Tue 14 Feb ’12
1:00am

Marco Vazquez

This is what I have with PHP (still without using embedded templates)
—————————————————-
{exp:external_entries:select
  // Server info // Table A
  search:strItem_type=1
  limit=“15”
  parse=“inward”
}
<?php $propertyID = “{select:strItem_id}”; ?>

  {exp:external_entries:select allow_php=“yes”
  // Server info // Table B
  search:strUploads_itemid=”<?php   echo $propertyID; ?>”
  search:strUploads_type = “primary”
  parse=“inward”
}
<?php   echo $propertyID; ?>

{/exp:external_entries:select}
{/exp:external_entries:select}
—————————————————-
And $propertyID is showing the right value… weird isn’t? Or is there something that I don’t see…

Tue 14 Feb ’12
6:20pm

Marco Vazquez

Thanks a Lot Adam,
I did what you suggested and It works without using php
—————————-
{exp:external_entries:select debug=“n”
  // Server / TableA
  search:strItem_type=“1”
  limit=“15”
  parse=“inward”
  allow_php=“yes”
}

{embed=“query/displayItems”
  queryid=”{select:strItem_id}”
  strItem_status=”{select:strItem_status}”
  strItem_title=”{select:strItem_title}”
  strItem_address=”{select:strItem_address}”
  strItem_city=”{select:strItem_city}”
  strItem_state=”{select:strItem_state}”
} 
——————————————-
In query/displayItems:

{exp:external_entries:select allow_php=“yes” debug=“n”
    // Server / TableB
  search:strUploads_itemid=”{embed:queryid}”
  search:strUploads_type = “primary”
  limit=“1”
  parse=“inward”
}

{embed:strItem_title}
{embed:strItem_address}
{embed:strItem_city}
{embed:strItem_state}

{/exp:external_entries:select} 

Now, I need to figure it out how to control pagination but this thing was starting to make me think that the Force is not longer with me…

Thanks a lot!

Tue 28 Feb ’12
1:09pm

Tahir

Hi Adam,
Just downloaded External Entries and gave it a try.  I just tried to close the status of an entry using above example code.  The Plugin seems to have done its magic but if I go to Edit Entries in the back-end and open the entry , the Status field is blank whereas EE exp_channel_entries table reflects the change as expected.  Need some light on this.  I badly need this plugin and have already started to experiment.  Any response would be highly appreciated.

Thanks for such a great addon.

Thu 8 Mar ’12
10:57pm

Marco Vazquez

Hello again,

I’m trying to sort the query by Random but i’m getting a warning for a variable that doesn’t exist: $sort_array.
I’m using:
orderby=“RAND ()”

and the line that shows the warning:
$sql .= $orderby_array[$key] . ” ” . $sort_array[$key] . “, “;

For now, it’s ok because I modified the code by commenting out the variable part:
$sql .= $orderby_array[$key] ; //. ” ” . $sort_array[$key] . “, “;

Any ideas?

Thanks

Mon 26 Mar ’12
12:02am

graphicmachine

I have been working with the following code to update all the records that a member has made to reflect their latest info.

{exp:user:edit return=“site/updatemain”}
     
{exp:external_entries:update table=“exp_channel_titles” search:field_id_4=”{member_id}” debug=“y”}
{update:field_id_4}{grantee_number_a}{/update:field_id_4}

{/exp:external_entries:update}

There is a permission error that is being thrown though which prevents the update from happening.
This is for a person within the member group.
Any suggestions?

Thu 29 Mar ’12
4:07pm

pesto9

Looking at using this plugin for a project, was wondering if it could be used to synchronize channels? We need to pull a .csv into a staging channel with DataGrab, then either add new items or update product quantity, etc info based on SKU if item already exists.

Sat 31 Mar ’12
2:51pm

graphicmachine

Here is the error I received when trying to run the script.

The following errors were encountered
You are not authorized to perform this action

Thu 5 Apr ’12
4:26pm

Marco Vazquez

Hello everyone,
I’m probably missing it from the previous posts but:
- How can you search in a range using the plugin?

SELECT * from table where ( table.field1 >= 1 && table.field1 <=5)

Thanks!

Mon 23 Apr ’12
10:48pm

Marco Vazquez

Any suggestion?

Tue 24 Apr ’12
8:36pm

Marco Vazquez

Just in case if someone could find it useful…
Searching with a defined range :

Added a new parameter:
range=“SQL Range criteria”

In the external_entries.php file:
in the $params block of code:
$range = $DB->escape_str( $TMPL->fetch_param(‘range’) )

And in the Select () function, In the get and insert the search parameters block:
if (isset($range)){
  $sql .= $range;
}

I know is not elegant but is working.

Thu 24 May ’12
1:43pm

ChiefAlchemist

Wow Adam, this looks great so far. Makes ya wonder why it’s not in the EE core.

What can you tell me about this plugin and Ajax? Can I use it write backend queries and such and then return the results to the front end? Or at least return a success message? Maybe this would be outside the scope of this plugin?

Fri 19 Oct ’12
8:08am

Paul Steven

Can you show me an example of the syntax for deleting a record from a table based on 2 column values.

I tried the following with no success

{exp:external_entries:delete table=“collections” search:id=“1” and search:libraryitemid=“18”  debug=“n”}

And I tried

{exp:external_entries:delete table=“collections” search:id=“1” and libraryitemid=“18”  debug=“n”}

Fri 5 Jul ’13
2:35pm

Jenny Harle

I’m trying out your plugin on my current project and it’s really handy. Getting the autoincrement on insert it a must-have for me, though. Any idea when that might be implemented?

Thu 22 Aug ’13
12:29pm

Stephan Bourdon

Hi,

I bought a copy of external entries on 8/8. It has been working flawlessly for until today, where suddenly the following error appeared:

A PHP Error was encountered
Severity: Warning
Message: Missing argument 2 for External_entries::_insert_filters(), called in /opt/www/independent/web/www.indikeit.com/system/expressionengine/third_party/external_entries/pi.external_entries.php on line 721 and defined
Filename: external_entries/pi.external_entries.php
Line Number: 136

Can you give any suggestions on how to fix this?

Thanks in advance and Best Regards,

stef

Thu 3 Oct ’13
11:08am

johnny

HI Adan

We are using your plugin to connect to Sugar and Integrate to EE and it’s working much faster than SugarEE plugin made just for that.

Do you have any code sample or where we can start to look to paginate results from the result of a query ?

Thanks

Thu 3 Oct ’13
11:31am

johnny

Hi Adan

Also, any way we can cache the results of a query?

Thanks

Fri 4 Oct ’13
11:39am

Johnny

Hi Adam,

Your add-on runs very well. But we have a issue when trying a {exp:external_entries:insert}.
We have a EE template contains php code and then embed this template in {exp:external_entries:select} so it runs well.

But if we embed this template in {exp:external_entries:insert}, it didn’t run. Just so only EE embed tag.

Could you help us resolve this issue!

Thanks

Fri 5 Sep ’14
5:56pm

Josh

Adam, I’m getting a PHP error with your add-on. The error is:
A PHP Error was encountered

Severity: 8192

Message: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

Filename: external_entries/pi.external_entries.php

Line Number: 101

I’m using external entries version 2.6 and ExpressionEngine version 2.7.3
MySQL 5.5.38
PHP 5.5.9

Mon 2 Feb ’15
6:11am

fishing shirts

I added to the send email plugin since I had the same HTML character entities problem.

Tue 3 Mar ’15
4:05pm

Rob

Oh man! This plugin is so promising, but I get a lot of PHP errors thrown still. When I turn on debug, I get the message “Nothing was found to insert.”

So far I am just trying to insert into channel_titles but as the channel_data insert is a separate operation, I don’t think lack of channel_data for now would be a problem. I’m using External Entries 2.6.3 and EE v2.8.1.

My code looks like:

{exp:external_entries:insert debug=“yes” table=“exp_channel_titles”}
        {insert:site_id}1{/insert:site_id}
        {insert:channel_id}1{/insert:channel_id}
        {insert:author_id}1{/insert:author_id}
        {insert:ip_address}{ip_address}{/insert:ip_address}
        {insert:title}Sample Data{/insert:title}
        {insert:url_title}sample_data{/insert:url_title}
        {insert:status}open{/insert:status}
        {insert:entry_date}{currrent_time}{/insert:entry_date}
        {insert:year}{currrent_time format=”%Y”}{/insert:year}
        {insert:month}{currrent_time format=”%m”}{/insert:month}
        {insert:day}{currrent_time format=”%d”}{/insert:day}
    {insert:edit_date}{currrent_time}{/insert:edit_date}
    {/exp:external_entries}

Severity: Notice
Message: Undefined variable: conni
Filename: external_entries/pi.external_entries.php
Line Number: 300

A PHP Error was encountered
Severity: Warning
Message: mysqli_query() expects parameter 1 to be mysqli, null given
Filename: external_entries/pi.external_entries.php
Line Number: 300

A PHP Error was encountered
Severity: Warning
Message: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given
Filename: external_entries/pi.external_entries.php
Line Number: 301

A PHP Error was encountered
Severity: Warning
Message: Invalid argument supplied for foreach()
Filename: external_entries/pi.external_entries.php
Line Number: 309

A PHP Error was encountered
Severity: Notice
Message: Undefined variable: sql
Filename: external_entries/pi.external_entries.php
Line Number: 863

A PHP Error was encountered
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/o2xsmith/public_html/oscp/codeigniter/system/core/Exceptions.php:170)
Filename: core/Common.php
Line Number: 442

I’ll try updating to latest ExpressionEngine later and trying again.

Tue 31 Mar ’15
11:34am

Proform

Although I feel compelled to add that one can hold that existing restrictions on mixed use development should be eliminated (along with the state) and simultaneously say, “You’ll take away my car when you pry my cold, dead foot off the gas pedal

Wed 15 Apr ’15
7:59am

http://www.youtube.com/watch?v=7IgJTEaVrIA

Thank you for another essential article. Where else could anyone get that kind of information in such a complete way of writing? I have a presentation incoming week, and I am on the lookout for such info.

Fri 22 May ’15
12:19pm

graphic designers

Technology always keeps us wondering about things that could be achieved through some highly tech methods and I’m glad to read about this topic.

Mon 26 Oct ’15
4:15am

halong bay cruise

I had read your writing and it is helpful for my adventure,so, I want you and me together discover it : au co cruise reviews | bai tho junk boat

Mon 2 Nov ’15
7:49pm

jason

doublersonsalaire
http://www.doublersonsalaire.fr
doublersonsalaire
great post!

Tue 3 Nov ’15
10:53am

Jason

I had read your writing and it is helpful for my adventure,so, I want you and me together discover it

Sat 7 Nov ’15
10:57am

Jason

I never really like being someone else online, and I didn’t realise my posts would all be from 2ways. projectfreetv.io

Mon 9 Nov ’15
9:17am

Jason

I never really like being someone else online, and I didn’t realise my posts would all be from 2ways how to lose weight fast

Sat 14 Nov ’15
1:11pm

Jason

I never really like being someone else online, and I didn’t realise my posts would all be from 2ways istvan loh

Sat 14 Nov ’15
7:49pm

JOSEPH

I never really like being someone else online, and I didn’t realise my posts would all be from 2ways hen party ideas essex

Sat 14 Nov ’15
8:31pm

JOSEPH

I never really like being someone else online, and I didn’t realise my posts would all be from 2ways24 hr london plumber

Sun 15 Nov ’15
7:44am

JASON

You’ll take away my car when you pry my cold, dead foot off the gas pedal best coffee maker under $100

Sun 15 Nov ’15
11:43am

JASON

You’ll take away my car when you pry my cold, dead foot off the gas pedal Lamar Hunt Jr

Sun 15 Nov ’15
5:18pm

jack

I had read your writing and it is helpful for my adventure,so, I want you and me together discover it .  Roll Top Baths

Sun 15 Nov ’15
7:08pm

JASON

You’ll take away my car when you pry my cold, dead foot off the gas pedal Freestanding Baths

Mon 16 Nov ’15
4:31pm

jack

Related to Brendon’s question, it seems to me the Update Entries function is designed to update just one column of the table.  Shouldn’t this work for an edit form already?  Anyway, about to give it a try!  ShowBox Official website

Wed 18 Nov ’15
8:55am

JASON

Has anyone given this a try as a means to update just a part of a single entry home

Sat 21 Nov ’15
7:06am

JASON

Has anyone given this a try as a means to update just a part of a single entry getfreestuffonlinenow does geniux work

Tue 24 Nov ’15
4:33pm

JACK

Has anyone given this a try as a means to update just a part of a single entry   24hr London Plumber London

Wed 25 Nov ’15
11:28am

JASON

Has anyone given this a try as a means to update just a part of a single entry   watch star wars episode 7

Wed 25 Nov ’15
12:46pm

JASON

Has anyone given this a try as a means to update just a part of a single entry cheap angels tickets

Thu 26 Nov ’15
10:53am

Jason

Has anyone given this a try as a means to update just a part of a single entry atunbi wedding photography

Thu 26 Nov ’15
4:22pm

jack

okay, i downloaded the plugin, but how do I install it? I am using EE2, but it doesnt show up in CP, I have uploaded it in thirdparty folder…  details

Thu 26 Nov ’15
4:29pm

jack

I am using EE2, but it doesnt show up in CP, I have uploaded it in thirdparty folder… derek iwasiuk

Thu 26 Nov ’15
7:57pm

jack

I am using EE2, but it doesnt show up in CP, I have uploaded it in thirdparty folder… vacation 2015

Sat 28 Nov ’15
4:37pm

jack

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you เดรสแฟชั่นเกาหลี

Sun 29 Nov ’15
9:09am

jason

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you how to enlarge the penis

Mon 30 Nov ’15
8:30am

jason

ust curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you check domain age

Wed 2 Dec ’15
8:39am

Jason

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you about pure forskolin

Wed 2 Dec ’15
8:42am

Jason

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you lymph nodes in humans

Sun 6 Dec ’15
12:17pm

Jason

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you Sboyes.net

Mon 7 Dec ’15
3:42pm

Jason

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you Visit This Webpage

Tue 8 Dec ’15
2:15pm

Jason

Tratamiento del exceso de peso con la ayuda de la medicación, toda la información en el sitio www.pastillasparadelgazar.com

Wed 9 Dec ’15
7:08am

Jason

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you Emma

Mon 14 Dec ’15
11:19am

Jason

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you buy soundcloud plays

Sat 19 Dec ’15
10:47am

Jason

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you   aura reading

Sat 19 Dec ’15
4:10pm

Jason

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you   http://www.survivetheenddays.news/how-to-survive-the-end-days/

Mon 28 Dec ’15
9:51am

Jason

I am using EE2, but it doesnt show up in CP, I have uploaded it in thirdparty folder… Erect On Demand

Mon 28 Dec ’15
10:08am

Jason

I want is just a single number - the number of entries in a particular table in an external database. {select:total_results} loops through the table one time for each row, and displays the row count one time for each row. psychic medium

Tue 29 Dec ’15
9:53am

Jason

The site I’m building is all about trying to keep users on the front end and away from the control panel. download torrents

Tue 5 Jan ’16
12:39pm

Jason

The site I’m building is all about trying to keep users on the front end and away from the control panel. official site

Tue 5 Jan ’16
1:40pm

Jason

The site I’m building is all about trying to keep users on the front end and away from the control panel http://pirateruncomptefb.com

Sat 9 Jan ’16
8:25pm

Jason

Hey, you’re the one setting the pricing!  I’ll pay just about anything for a stand alone edit form that works.  entrar no facebook

Sat 9 Jan ’16
9:13pm

Jason

The site I’m building is all about trying to keep users on the front end and away from the control panel
http://ecuadorcoffee.blog.com/2016/01/04/coffee-press-the-original-coffee-maker/

Wed 13 Jan ’16
8:48am

Jason

The site I’m building is all about trying to keep users on the front end and away from the control panel. 1920x1080 Wallpaper

Sat 16 Jan ’16
9:53am

Jason

The site I’m building is all about trying to keep users on the front end and away from the control panel ShareIt for PC

Sun 17 Jan ’16
9:39am

Jason

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you best binary option robot

Wed 20 Jan ’16
10:35am

Jason

In all likelihood, I’ll be waiting for your super-duper EE2.0 External SAEF module.  Any time frame on that?  Thanks. Hua Hin weather

Wed 20 Jan ’16
10:48am

Jason

I gave up a while back and can’t remember the exact errors that were troubling me, though I might have another go now.  Hua Hin weather

Thu 21 Jan ’16
9:07pm

Jack

Very much looking forward to the EE2.0 version of External SAEF.  Related to Brendon’s question, it seems to me the Update Entries function is designed to update just one column of the table. Printing VIP

Sat 23 Jan ’16
7:32pm

Jack

I am utilizing EE2, yet it doesnt appear in CP, I have transferred it in thirdparty envelope http://www.wrestlefeed.com/sports/wwe-raw

Sun 24 Jan ’16
5:25pm

Jack

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you   Los codigos Web

Tue 26 Jan ’16
4:30pm

Jack

I am using EE2, but it doesnt show up in CP, I have uploaded it in thirdparty folder… showbox for pc

Wed 27 Jan ’16
10:29am

Jack

Hey, you’re the one setting the pricing!  I’ll pay just about anything for a stand alone edit form that works. car decals miami

Wed 27 Jan ’16
11:51am

Jack

Hey, you’re the one setting the pricing!  I’ll pay just about anything for a stand alone edit form that works Laksamon Yodseranee

Mon 8 Feb ’16
10:16am

Jack

Just curious - the trial version is not encoded. So how does the licensing work? Just on Trust that people who downloaded will come back and pay you Ibcbet

Sat 13 Feb ’16
10:00pm

joseph

Hey, you’re the one setting the pricing!  I’ll pay just about anything for a stand alone edit form that works.  gaining game

Tue 16 Feb ’16
8:29am

gmod free download - play garry's mod for free

I am preparing my assignment paper and gathering information on this topic. Your post is one of the better that I have read. Thank you for putting this information into one place.

Wed 17 Feb ’16
8:37am

Jason

I’m flattened for your blogs writings and blogs as well.

Wed 17 Feb ’16
8:42am

Jason

I’m flattened for your blogs writings and blogs as well. http://tricheclashofclansastuce.com

Thu 18 Feb ’16
8:35pm

Jason

I’m flattened for your blogs writings and blogs as well.  Quit Marijuana The Complete Guide

Sun 21 Feb ’16
3:10pm

mimi

How can I use this external entries on my site of britax b safe infant car seat things?

Wed 2 Mar ’16
7:02pm

pesihu

Hi Adam,

I getting this error using EE 2.10.3, and PHP 5.6.10 and External Entries 2.6.4 in the CP and when excecuting the tags:

A PHP Error was encountered
Severity: 8192
Message: Non-static method External_entries::usage() should not be called statically, assuming $this from incompatible context
Filename: external_entries/pi.external_entries.php
Line Number: 9

Fri 11 Mar ’16
2:09pm

Denis Lubojanski

For the best electric razors you can contact here.

Mon 21 Mar ’16
11:06am

nims

good Lets have a fast look in the top mobdro apk download all supported formats Mp4, Flv etc., Avi Mobdro great.

Fri 25 Mar ’16
3:57pm

jack

I absolutely love this site. Continue the great work!
Visit my blog
Click here
Video downloader

Wed 30 Mar ’16
4:06pm

Pretham

Good to know the Mobdro apk android latest version now updated it’s new movie collection. Thank you.

Wed 30 Mar ’16
4:10pm

Jordan

playview app download for android.

Sat 2 Apr ’16
1:31pm

reyansh

good the program is installed. Ongoing to menu discover installed xender, click one and it can begin sharing. Xender Blog Inspite of each one of these attempts however you discover any issue in Xender nice.

Thu 7 Apr ’16
5:07pm

Mobdro Apk

excellent work nice article.Thank’s for the post.
Mobdro App Download for android and ios devices.
OG Youtube Downloads for watch best youtube channels on android and ios devices.

Tue 26 Apr ’16
7:12pm

musicparadisepro.net/

Awesome post about external entries.

Sat 7 May ’16
10:16am

eharmony sign in

i lkie this post

Sun 8 May ’16
10:12am

karie

Awesome work nice web page. for watch larest cartoon series download free Cartoon HD Store for your children’s.

Sun 15 May ’16
7:49am

copaamerica

This post is extremely good and helpful. Thanks with this post, I am waiting for the next post.<a >copaamerica</a>

Sat 21 May ’16
11:09am

Jane

I’m just guessing at what it looks like! I’ve been lucky so far, but send me free magazines!

https://itubeapp.net

Mon 23 May ’16
11:14am

netspend login

nice

Fri 27 May ’16
4:32am

Vidmate PC

as the experts have said that PlayviewApp.download is the best site to get playview updates

Tue 7 Jun ’16
10:07am

Trevor

http://www.bestelectricrazors4u.com/

Sat 11 Jun ’16
1:44am

Knarou75

I want to say as manger of docs you have really done perfect installation and it is ready to download <a >francais triche clash of clans</a> any time so you are the best.

Thu 16 Jun ’16
6:08am

Share it

SHAREit for PC Download is a free file sharing app which enable to transfer files

Tue 21 Jun ’16
8:34am

Playview

Saw this site http://playviewappdownloads.com/ and install the application

Tue 21 Jun ’16
12:47pm

Denis

Have a look at this amazin site on the best smoker grills. http://bestsmokergrills.com/

Fri 24 Jun ’16
5:59am

vani

ood Video tutorials and training video selfies with amazing filtration for better Vine video tutorials YouCam Perfect APK Android A incredibly simple to apply program can help youcam perfect app latest nice.

Sat 2 Jul ’16
7:56am

meet

good iphone app signer that’s quite convenient method. Kodi for iPhone it can even now conveniently come to be performed with somewhat of patience. Kodi nice.

Sun 24 Jul ’16
9:41pm

jiune

SHAREit For Windows PC- Connect & Transfer on the App Store at http://brownstacks.com
showboxdownloadsapp.com

Sun 24 Jul ’16
9:55pm

ptrasor

The diet pill, Phen375, is a highly popular weight loss supplement a fat burner that also acts as an appetite suppressant daddynutrition.com

Thu 28 Jul ’16
7:09pm

Milor

Whatsapp Messenger now work on windows with whatsapp apk and whatsapp web , check the link here appsfreeforpc.com

Tue 2 Aug ’16
6:50pm

Cinema Box Apk

Download Cinema Box .Apk File and Install Cinema Box App on Android

Sat 13 Aug ’16
6:11am

ami

good which the distributed articles is normally ended up permanently. Charlotte Crosby Snapchat On top rated of that he possesses an incredibly straightforward and intuitive software. nice.

Sun 18 Sep ’16
12:54pm

drevin

to enjoy the online movies we have uber cool apps on app stores but Cinemabox android is the perfect choice when we need movies or shows or serials.

Tue 25 Oct ’16
7:17am

fatihin nurul

sosial, Science Citation Index Sosial diterbitkan pada tahun 1972 dan en1975 indeks Penawaran untuk seni dan humaniora. contoh undangan pernikahan undangan pernikahan unik

Wed 26 Oct ’16
3:02am

fatihin nurul

faktor dampak sesuai dengan rasio antara jumlah kutipan yang undangan pernikahan simple undangan pernikahan elegan

Wed 26 Oct ’16
3:03am

fatihin nurul

diterima oleh jurnal selama dua tahun dan jumlah artikel yang Daftar Harga Besi H beam Yang Dijual Dari Pabrik Ke Agen sentra besi baja

Wed 5 Dec ’18
9:27am

Nivedita Soni

Thank you for this information. I read your blog and I am satisfied with your writing contents. It has a lot of tiny information which is really helpful to understand easily. Keep sharing more news. Also, you can check the Daily horoscope

Mon 17 Dec ’18
4:09am

Na ta

If there are many sad stories, share it with the people you trust. Sharing helps people get closer together and you also relieve some of that sadness. Red Ball 5

Fri 21 Dec ’18
9:10am

skratch

Thanks for sharing this amazing read! I loved the article
please continue the good work and writing such amazing pieces, also you can check best DJ Courses in delhi

Thu 17 Jan ’19
3:35am

ariana pham

The article is very useful for us, please to be updated daily
QWOP

Thu 31 Jan ’19
3:45pm

robi

a very cool data transfer application is only share it which is best in the market.

Wed 6 Feb ’19
4:16pm

ddd

I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page! 192.168.l.l

Fri 22 Feb ’19
8:41am

تردد قناة mbc

Hi Adam,  Very much looking forward to the EE2.0 version of External SAEF.  Related to Brendon’s question, it seems to me the Update Entries function is designed to update just one column of the table

Fri 22 Feb ’19
8:45am

samehfr

The article is very useful for us, please to be updated daily
https://www.satnilesatnews.com/

Fri 22 Feb ’19
8:45am

samehfr

Thanks for sharing this amazing read! I loved the article

Thu 28 Feb ’19
10:00am

Tomas wilson

Hi Adam,  i agree that we are Very much looking forward to the EE2.0 version of External SAEF.smile street extraction

Thu 28 Feb ’19
10:04am

ian mugoya

well If there are many sad stories, share it with the people you trust. commercial flooring near me

Fri 1 Mar ’19
11:14am

Mickey James

Really plugins need to updating. rs 99 domain service grab for biggest option.

Wed 6 Mar ’19
2:23pm

hulio J.

Hi Adam,  i agree that we are Very much looking forward to the EE2.0 version of External SAEF.smile street extraction

Thu 28 Mar ’19
1:00pm

noemi

]https://www.explosederire.com/”] explosederire.com[/url]

Mon 8 Apr ’19
8:07am

Joshua A. Price

Thanks for your post! Are you really sure about what you say? I read something different on an other blog! I’ll share the link. maid service

Wed 8 May ’19
8:47pm

jams

Thanks for the blog post buddy! Keep them coming…
Air Conditioning Home Service and Install

Thu 9 May ’19
3:27pm

ian mugoya

The entries are unmatched and prove to be useful in this areas as we know it. pool deck resurfacing.

Sat 11 May ’19
12:10am

jamsmalik

useful information on topics that plenty are interested on for this wonderful post.Admiring the time and effort you put into your b!.. barber shop salt lake city

Wed 22 May ’19
5:06am

Cassandra D. Everhart

I see something truly special in this post. www.orlandotowingpartners.com/internationaldrive32819

Thu 23 May ’19
8:39pm

jamsmalika

This article gives the light in which we can observe the reality. This is a very nice one and gives in-depth information. Thanks for this nice article.
international freight transportation

Fri 24 May ’19
9:39pm

jamsmalik

Wow what a Great Information about World Day its very nice informative post. thanks for the post.
news blog

Fri 14 Jun ’19
10:27am

Sophie Miller

Ich danke Ihnen für die Information! Ich war auf der Suche nach und konnte nicht finden. Du hast mir geholfen! burger king menu

Fri 21 Jun ’19
3:54pm

jamsmalik

I really enjoyed reading this post, big fan. Keep up the good work and please tell me when can you publish more articles or where can I read more on the subject?
Adwords Consulting

Thu 8 Aug ’19
3:50pm

jamsmalik

I read a article under the same title some time ago, but this articles quality is much, much better. How you do this..
taroko gorge tour

Tue 27 Aug ’19
1:54pm

John1999

Very helpful information.
home cinema London home cinema Manchester

Mon 2 Sep ’19
2:32pm

osama shk

Thank you so much for sharing this great blog.Very inspiring and helpful too.Hope you continue to share more of your ideas.I will definitely love to read.
925 platinum

Thu 5 Sep ’19
3:02pm

assad

Nice blog and absolutely outstanding. You can do something much better but i still say this perfect.Keep trying for the best.
visit the website

Mon 11 Nov ’19
11:24pm

geof

This will in turn will create huge losses to business people and to the government.https://www.essaybaron.com/home/assignment-help-services/urgent-assignment-help-instantly

Tue 19 Nov ’19
6:01am

James H

Thanks for the plugin and information. I am going to try this on a test website. House Cleaning Service Elgin Il

Sat 23 Nov ’19
3:49pm

timi

This is a common case with owners who have other means of financially supporting their business ventures. It allows the micro business to continue regardless of the profits.

Sun 22 Dec ’19
12:31pm

liyooo

Thanks for sharing the info, keep up the good work going…. I really enjoyed exploring your site. good resource…
instagram video downloader

Mon 6 Jan ’20
11:33pm

Stanley Malong

Heard about this plug in and after reading this I have to try it now. Thank you. I’ll get to it once I have time because I’m about to go get my hedges trimmed, which I’ve been meaning to do all 2019. If you want to click here to see what I mean. i can’t wait to get around to this tonight. Thanks again.

Thu 9 Jan ’20
11:47pm

John Maxon

I will have to implement these into my businesses.

John owner of

Duct Cleaning in Cincinnati
Grease trap pumping Cincinnati Ohio
Grease Trap Pumping South Bend Indiana
Excavation Contractor Evansville
Excavation Contractor Sterling Heights Michigan

Wed 12 Feb ’20
3:29pm

osama shk

Only aspire to mention ones content can be as incredible. This clarity with your post is superb and that i may think you’re a guru for this issue. High-quality along with your concur permit me to to seize your current give to keep modified by using approaching blog post. Thanks a lot hundreds of along with you should go on the pleasurable get the job done.
divorce attorney colorado springs

Tue 18 Feb ’20
1:09pm

osama shk

I’ve been searching for some decent stuff on the subject and haven’t had any luck up until this point, You just got a new biggest fan!..
read the article

Wed 19 Feb ’20
10:05am

osama shk

Nice blog and absolutely outstanding. You can do something much better but i still say this perfect.Keep trying for the best.
cheapest hair dryer

Fri 28 Feb ’20
6:13pm

LeslieDove18

Thank you for making such entries that can help other people. I highly recommend this site to other people. I also recommend this game called dragon mania legends wiki for those people who wants to relax and just have a good time.

Wed 4 Mar ’20
4:53pm

osama shk

It is imperative that we read blog post very carefully. I am already done it and find best dentist post is really amazing.
florence residences floorplan

Tue 17 Mar ’20
5:21am

Rianne Knox

Its difficult to find informative and accurate info but here I found…  Visit me at tulsafireandwaterrestoration.com

Tue 17 Mar ’20
5:00pm

osama shk

An fascinating discussion is value comment. I think that it is best to write extra on this matter, it won’t be a taboo topic however generally people are not enough to talk on such topics. To the next. Cheers
エンゲージリング

Sat 21 Mar ’20
8:40pm

osama shk

This is highly information, crisp and clear. I think that everything has been described in systematic manner so that reader could get maximum information and learn many things.
マリッジリング

Sun 22 Mar ’20
7:10pm

osama shk

I got what you mean , thanks for posting .Woh I am happy to find this website through google.
婚約指輪　猫

Sat 28 Mar ’20
3:14pm

Fredericton SEO agency

Very interesting post! Thanks for sharing :)

Wed 15 Apr ’20
9:34am

magnum options scam

magnum options scam is quite different from traditional liquid currency, primarily being the fact that it is a digital version of cash which is backed neither by a physical commodity nor by any central agency or government

Wed 29 Apr ’20
9:42am

Sophie Miller

Je vous remercie de l’information! Je cherchais et ne pouvait pas trouver. Vous me aidé! <a >College Admission Scores</a>

Tue 12 May ’20
7:51pm

Mark Salvatore

I found this informative so I must say thank you for creating such valuable read. =)

Regards from Mark Salvatore of
Excavation Contrcator Plano TX

Thu 14 May ’20
4:50am

Ricky Luck

Chain Link Fencing Ogden UT You have given such a great information that would be very helpful to me

Mon 18 May ’20
2:46am

Sylvia Weisen

<a >Grand Forks Towing</a>

Thank you

Mon 18 May ’20
2:47am

Sylvia Weisen

a href=”http://grandforkstowingservice.com/”>grand forks towing</a

Mon 1 Jun ’20
4:12am

TdSmith

www.poolcleaningnaplesfl.com

Thu 18 Jun ’20
3:48am

Pauline M

Thanks for sharing!
house painter fremont ca

Wed 24 Jun ’20
12:12am

Rob john

This was such a great post, I am going to add you to my RSS. Looking forward to hearing more.

Akron Junk Removals 
Akron Auto Glass Pros 
Akron Landscapes 
Akron Concrete Pros 
Flagstaff Junk Removals 

Sun 28 Jun ’20
3:38pm

Frank D

Great article !

<a >Pest control</a>

Sun 28 Jun ’20
3:41pm

Detroit

<a >home inspector</a>

Wed 1 Jul ’20
2:53am

Lake Charles Deck Builders

Thanks for sharing this - great stuff!

Composite Decking Lake Charles LA

Wed 1 Jul ’20
4:50am

Carl Towns

My thoughts exactly on the MySQL . I’ll share this with my colleagues at lawn care midland tx, pest control midland tx, movers midland tx, seo lexington ky

Tue 18 Aug ’20
3:08am

jennylee

Hi Adam, is there a way to pull unique records only e.g. SELECT DISTINCT etc?
pedicure campbell

Tue 18 Aug ’20
3:10am

henrywang

Thank you for this article. It is really helpful for Super Auto Dent

Tue 18 Aug ’20
10:43am

seantal

Thank you for sharing this. I used this for pool and spa cleaning in Los Angeles

Tue 18 Aug ’20
10:44am

chrisgay

Thanks Adam, i tried this with different syntax, but no luck so far with my la pool leak detection

Thu 20 Aug ’20
2:12am

dannylee

Great, thank you. I’d love to be able to run the equivalent of
SELECT COUNT(*) FROM posts
in an external database, and display the results in EE.
digital marketing agency ho chi minh

Thu 27 Aug ’20
10:07am

Wayne Ogilvie

Thank you for updating External Entries to v2.6.4, hoping all the bugs are already fixed. Looking for drywall contractors in your area? Visit our page drywall contractor omaha

Wed 2 Sep ’20
5:37pm

Erick

Thanks for all the techies like you guys that are building plug ins because I’m not very of use for that. On the other hand Im able to help any Excavating projects in the Kelowna area!! These plug ins regulates the flow of my site Thanks!

Tue 29 Sep ’20
11:29am

Love Franches

Very informative post. I really do hope and pray this stuff works! Check our owassoconcreteservices.com

Fri 2 Oct ’20
12:13pm

richard patterson

How can you generate controllers from these classes with JPA? pressure washing near me

Tue 6 Oct ’20
5:06pm

Wilson Hoire

This is a really good blog for coding! Are you looking for an electrician? Click this link for my favorite electrician Sudbury!

Sun 18 Oct ’20
3:26am

Kimberley J. Morrison

When adding that code I’ve got an error on the code line. I didn’t resolved it yet.

https://www.concretecontractorstulsapro.com/

Mon 19 Oct ’20
4:09am

ester cawater

I will follow your External Entries v2.6.4 steps in my upcoming project. lake norman roofing contractor

Mon 19 Oct ’20
7:58am

Looney Hans

glad i found this awesome site!! will recommend it to my friends breast augmentation little rock ar

Mon 19 Oct ’20
8:54am

zane roundtree

most thorough External Entries post I’ve come across for Beginners. sandblasting in my area

Tue 20 Oct ’20
7:34am

Sam Smith

i love this website. learned alot. great content hair extensions boise id

Thu 29 Oct ’20
1:52am

lizbee

great job guys! newborn photographer pittsburgh

Thu 29 Oct ’20
1:53am

colin

thanks for giving this opportuniy.  newborn photography philadelphia

Thu 29 Oct ’20
1:54am

Daisy

this is great! love it newborn photography cincinnati

Mon 2 Nov ’20
8:46am

Jennie Kim

hair extensions san antonio sorry im not a spam just a huge fan of this site :)

Sat 7 Nov ’20
6:25pm

doug

Very useful information!
radon testing fort collins co
demolition company las vegas nv
demolition company orlando fl

Thu 12 Nov ’20
10:05am

garry harrell

Can’t wait to implement and learn more about external entries. kitchen renovation cost

Thu 12 Nov ’20
2:32pm

Franchise Attorney

Awesome read you’ve got there Franchise Law, I’ll have to pass it on! Macley Family Medical

Mon 16 Nov ’20
6:13am

steven brockman

it’s extremely clear, straightforward about external entries. < a href=“https://www.stpetecarpetcleaningservice.com/”>couch cleaning company</a>

Mon 16 Nov ’20
6:14am

Jade Re

concise explanation of external entries post. <a >couch cleaning company</a>

Mon 16 Nov ’20
6:16am

Yu Wan

I will follow your steps in my upcoming external entries. couch cleaning company

Wed 18 Nov ’20
6:32am

William

This kind of update is the one we are waiting for a long time. Contact us if you need licensed electrician in cedar rapids and we are glad to help you with your electricity problems

Wed 2 Dec ’20
9:44am

Jamil

Can you tell me how can we implement it on our site where we have a list of pool builders near me?

Fri 4 Dec ’20
9:56am

norman garland

I’m pasting here the sql script to generate the table used in the post. airport shuttle

Sun 13 Dec ’20
4:29pm

Wilson

electriciansarnia.com is the website of an excellent electrician

Thu 17 Dec ’20
10:15am

federico pickens

The way you explain on External Entries is commendable. landscaping companies Port St. Lucie

Thu 17 Dec ’20
3:03pm

Javier McLaughlin

We snow removal services in Saskatoon, feel free to contact us for more services.
Moose Jaw snow clearing

Sat 19 Dec ’20
10:06am

Sammy Jarred

Buffalo Painting Pros is a professional painting company based in Buffalo, New York. We offer painting services for both interior and exterior of your residential buildings and commercial buildings.

Wed 23 Dec ’20
2:30pm

Max Patriote

Thank you for your contribution to make this world a better place.
Learn more about plancher de garage.

Thu 7 Jan ’21
1:06pm

James

I never really like being someone else online, and I didn’t realise my posts would all be from 2ways.
Thanks for your work.

Wed 20 Jan ’21
7:16am

paul graham

Been using ExpressionEngine since version and ExpressionEngine should be as big as WordPress in my opinion. new lawn