Enterprise

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.

This group provides an area to share information about Drupal in the enterprise. Areas for discussion might include the integration of Drupal with traditional enterprise applications such as ERP and CRM; the use of Drupal as an enterprise web content framework; Drupal's place within the enterprise architecture; or even the use of Drupal as an enterprise architecture tool.

Other Drupal groups of interest to the enterprise include High Performance and Best Practices in Security.

Souvent22's picture

Module "Black-Hole" revival

There are a "LOT" of contrib modules out there. Even more so, there are a great deal of good modules that have been neglected. Lets be honest, a developers time is precious, and we all get spread thin and a bit scattered sometimes, and we leave our children (modules) to the way side for other things (like "bill-paying" modules/development so we can eat from time to time :) ).

Read more
Boris Mann's picture

Help fund backport of watchdog external logging for Drupal 5

Khalid Bahey is well on his way to getting a patch into Drupal 6 for spitting out logging of watchdog entries so that:
1. They can be routed to a different source other than the database, from a flat file to syslog support. The watchdog table can crush many sites.
2. Actions can be taken depending on the messages. Get notification via email, IM, pager, etc. depending on the severity levels of messages in your watchdog.

This will be a fantastic feature for Drupal 6....but really, we need it today for Drupal 5 as well. I've spoken with Khalid and he's willing to backport both the patch as well as the supporting modules. The plan of attack is:

Read more
shird05's picture

Accepting Pseudo Logins via encrypted parameters

I am wanting to set up a site where people will be getting to the site from another, external site. When they click on the link from the external site, it will take them to my Drupal site where I want to grab a "userid" and customize the site based on what they want. So an example of this is the following:

site1 they sign up for an "online course" (or courses). They are given a link that would look similar to: http://site2.com/?userid=12345&course=45678

Read more
Darren Oh's picture

GnuCash

I first started experimenting with Drupal because it worked with PostgreSQL, and GnuCash had a PostgreSQL backend. I hoped to make them work together. I still think it would be a good idea. More on this later.

Read more
Souvent22's picture

Quickbooks Module Introduction

I am sorry for the poor quality of the screen cast. I've never done one, and I used "wink" to do it. I'll probabley update the "how to" later down the road.

So, I made a screen-cast of my quickbooks module. It's very pre-alpha, and the screen-cast is not the best. But I did it quickly. I've been getting a few inquiries, and I figured this would be the easiest way to explain it. I'll be releasing it to the cvs by the end of this week so hopefully I can some collaboration on it.

Link to video: http://earnestberry.com/node/7/play

Currently what it does:
- Brings in customers

Read more
Souvent22's picture

PayFlow Pro Support

Hello. So, I have done e-commerce support for PayFlow Pro. This module will probably be released soon and I currently did one implementation in E-Com v. 1-2, and I am polishing off one for v3 (all 4.7+ for now). I'm prob. going to port to 5.0.
This has been tested to work on both Windows AND Linux (windows creates/uses a COM object, linux uses the pfpro binary).

I'm posting to see who is interested in PayFlow Pro support to get a few people started to kick up some bugs from the program (test it) so that it is rock solid.

FYI About the General Arch. of the Module

Read more
Anonymous's picture

Trellon is Hiring Drupal Gunslingers

Have a strong desire to help great progressive organizations make the world a better place? Looking to work with a fantastic team of Drupal developers and build out some really cutting edge sites? Can you write code better than a thousand monkeys with a million years on their hands?

Trellon is a development shop based in Washington, DC and we are looking for a few good programmers to work with our talented team of Drupal developers on some big projects. We’re offering a 1 – 2 month contract to build out a couple of client sites.

Read more
Souvent22's picture

EDIFACT, XML and Drupal; exciting but daunting

So we recently met with a client we going to take on about their system and where they want to go. They are a well established B2B company that deal with many business. They are not a large company, but they do a fair amount of business. Currently, their systems are very old and outdated, however, they work.

Read more
Souvent22's picture

SQL Speed Optimization on Large Datasets

So, you want to speed up your large site? Well, start by cleaning up your SQL if you're accessing large tables. We are running Drupal on top of MS-SQL for a client. We have one table that has 7.5 millinon rows in it. Now, I had mentioned what I am about to talk about in another post before, but I know have some hard numbers to base it off of.
So anyway, this table had 7.5+ million rows, and the page was loading mighty slow. Running it 10 times, Devel query showed where I was bleeding...more like gushing time:

<

ol>

Read more
keithinstone's picture

Five subscribers

We are now at 5 subscribers: I think I invited one of you but the other 3 found this group on your own.

Read more
Souvent22's picture

SQL Changes List

Ok, I'm just going to start listing the SQL statements that I find that need changing here. Trying to release patches for them all and keep up is getting out of hand:

Watchdog
- Line 123, remove the u.uid, it is not needed since the w.* already gives you that column.

(more to come soon)

Read more
Souvent22's picture

ODBTP Anyone one?

So, I was checking out ODBTP < http://odbtp.sourceforge.net/ > and considering making a drupal driver for it. This would allow many database to now be supported through ODBC. I also hear that ODBTP is just as fast as a native driver and the speed of ODBC really depends on the implementation of the vendor of ODBC. Just seeing if anyone had any experience with it and/or thoughts?

Read more
Souvent22's picture

The Time Draws near for Stored Procs...across the board

Ok, i'll be the one to call the pink elephant in the room.....stored procedures do exisit. There I said it. :). With MySQL 5 starting to support them, Postgres has had them, and the push latley to start using a wider array and more robust DB's (oracle, mssql, DB2), it is time I think to start thinking about a database abstraction layer to handel stored procedures. I'm thinking perhaps something like this:

/**
* @param $proc_name Name of the stored proc.
* @param $args Argements to send to the proc indexed by the variables name. e.g. array('name' => 'Jim Smith');

Read more
Souvent22's picture

Let the DB Revolution Begin (MS SQL)

Ok, so I finally got around to it. Drupal 5.0 (6.0-dev) MS SQL support. I am hoping this thread can be a sort of 'behind the scenes' working group with official patches posted to Drupal.org.


NOTE: This has been tested with:

  • PHP 5.1.6
  • SQL Server Standard 2005
  • ntwdblib.dll v. 2000.80.194.0 (you will need this updated version and not the one that comes with your php install)

With that said, on to the patch. It is definalty a hefty one at 51KB. So, a quick over-view of what it does.
First, a few files have been added:

<

ul>

Read more
Souvent22's picture

Oracle, 5.0, and the Trigger that killed it All

So I have 2 Oracle installations running great on 4.7.3, and 4.7.4.

So I thought 5.0 would be easy to tackle....totally wrong.

I was on the phone with Oracle late tonight. I'll try and keep this rant short. But, the reason that Oracle will work with 4.7 and not 5.0 is that in 4.7, you have to run your SQL statements manually, and in 5.0 Drupal does this for you. This is a really nice feature. However, that's where the problem comes in:

Currently, the Oracle implementation use sequences and triggers to simulator auto_increment and serial fields. The problem is that you can not create a trigger from PHP, you much run a trigger DDL from Oracle's SQL+ (or if you have Java). For some reason, it's a bug in the oci8 module.

Read more
Souvent22's picture

QuickBooks is Coming to Drupal, but May Need a bit 'o Help

Quickbooks is coming to drupal soon, but I may need help from the community.

I currently have a module that uses SOAP and the RDS (Remote Data Sharing) server from Intuit (a program that runs locally on your machine locally and runs. It acts as a "proxy" b/t you and your quickbooks file, and accepts SOAP requests and pulls the information from quickbooks for you and returns the information in XML format). The module is pretty simple in form currently.

  • On a users "My Account" form, an admin user is presented with a drop down of current customers from Quickbooks. The admin then selects what "customers" the registered user can view.
Read more
Anonymous's picture

Podcasting

So, I have been doing my monthly round up of really cool sites, and have been coming across a number of candidate Web sites using podcasting and / or multimedia solutions.

While I am not ready to tack any modules onto Drupal.org, I wanted to write about some low cost ways podcasting and multimedia can be added to a campaign budget. As I see it, the main benefit of adding audio and video in a campaign context is it is a direct appeal from a candidate to potential voters and donors and really gives people a chance to present themselves in the best light. Every campaign I know of has video of speeches and debates that probably should be shown in some context, and there are a number of really cheap ways to pull all this information into a site without a lot of effort.

Read more
Souvent22's picture

Patch for Multi-Threaded Cron Jobs Created

So, we have a few modules that we are running for a new client. We're running drupal on about 60K worth of hardware, not including the Oracle database sitting on it's own nice slice of hardware (about 4 tearbytes of data).

So we get data once a week, millions of rows of data (60 million+). The module that we made for the client has a cron job that runs through and makes some updates (this is along with a Database-side PL\SQL script, and a sprinkle of java. A nice orchestra of apps that work beautifully togather). Well, this takes days to do. Literally days, and we noticed a problem when the "aggregator" failed because it through an error trying to read a certain RSS feed. We were not aware of this for about a week. This cost us and our customer prescious time because since aggregator had filed, the clients custom module never got to run!!! Futher more, I concluded that if I put the custom module first, it would eat up all the cron run time. On top of than, we were seriously "under" utilizing our hardware. This was just totally unaccepatble. Thus comes "Mutli-Threaded Cron" runs.

What this does bascially is fire each modules cron run in it's own "sandbox" if you will. So that each modules cron run has the FULL use of PHP's time out, and does not have to worry about another modules cron run failing. The multi-threaded cron also gives more detailed information about each modules cron run. This will better help site admins control the PHP time out variable (which can now also be set dynamically), and see what modules are taking hte most time to run, the least time, and which ones are currently failing.

I believe this is a BIG improvment over the current cron implementation.
Some items I would like to implement next:

  • Emailing the admin if these is a "cron run fail" escalation (say in a 20 min. period, there are 10 failure, email me), etc.
  • Being able to set each modules individual PHP execution time variable. (be nice to give search.module more time than aggregator module)
  • "Throttle" the cron runs. Meaning, I only want to have 5 cron "threads" running at any given time. So it needs to wait until a few have finished before running more cron threads.

You can review the patch and a detailed discussion of it here: http://drupal.org/node/87528
I'll be discussing more options for mutli-threaded cron runs on my blog: http://www.eb3it.com

Below is a snipped from my blog:

So, I have started an ambitous patch. For those who do not want to read the explination, and just gain knowledge by reading the patch:

Read more
Souvent22's picture

Alternative DB Handbooks Started

I have started some "step-by-step" handbooks on running drupal on alternative databases (those that are non-standard-drupal).
So far, I have just started Oracle. When I have time, I will try and do the MS SQL one also. I'd love some crituqes on getting this polished off and included in the Drupal.org handbooks.

http://eb3it.com/oracle_handbook

Read more
Souvent22's picture

Database Consolidation

Ok, today I am going to start to consolidate all of these diff. db support tasks into my sandbox for a pre-release and discussion setup. Right now, there are about 5 different, and very good, threads about Oracle and MS-SQL support. However, there is still no central place for everyone to consolidate their code and work on the DB's. This needs to happen so no one goes off and re-invents the wheen. So, today I am going to sift through the threads, integrate as much as the code togather as I can, and commit them to my sandbox.

I personally currently have an Oracle installation and a MS-SQL installation working very well.

Read more
Subscribe with RSS Syndicate content

Enterprise

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: