Activity on Arrow and Non-Continuous PDM are wrong.

Dear Rafael,

What do you recommend that the tool makers do to improve their tools?

With kind regads,

Samer

Samer,

For a start they should stop fooling the user by stop providing wrong values for float after resource leveling, if incapable of showing true values then better no provide these or stop providing the resource leveling functionality, is misleading, is an abominable error, is wrong.

To provide a standardized database for purpose of exporting/importing where all software can communicate the basic fields, most fields will be common among all software and a few particular of each software so they can still be exported/imported then the software can handle some by use of functionality such as formulas or at times will just be reference values that will keep record of the non-common values. This would require some sort of standard, a practice our federal government tried and stopped, at the end a few nailed the majority.

I also would like from owners to stop forcing the contractor to use software for their own planning by brute force, let the contractor use its own selection. Forcing hundreds of contractors to use the Owner selection is undemocratic, goes against the basic principles of free enterprise, it is morally wrong. Perhaps Contractor’s trade associations, the PMI (if relevant for something), the whole Planning Planet Community and a few others should raise the voice against this practice. The argument that must be standardized is no excuse; the end does not justify the means.

About the rest, the market and user needs should dictate. I believe in free enterprise although some of our institutions seems like not.

Best regards,
Rafael

Dear Rafael,

Amazingly enough, amongst 100 economies in the world, I have read that there are 51 companies! So the definition of free enterprise is changing, like everthing else in the world. When you see specification clearly stating the specific brand, then the only reason for that is someone is pushing to use this brand.

I think that if the tool makers outline clearly how the black box is getting the results in the help section, things would get simpler to verify and to use. You end up gaining experience with what works with the software to operate it, not what is the correct theory of doing things and how to verify the correct answer.

With kind regards,

Samer

Sammer,

Your request has been exposed by many forever. Yes you are right; even some third party developers have complained about the software developer not being clear what each field means.

About exposing the details of their particular algorithm I understand why they can be reluctant to expose them, these took years and thousands of dollars (a few Euros) to be developed and tested, why expose them for free to others.

From:

http://en.wikipedia.org/wiki/Algorithm

- "Algorithms, by themselves, are not usually patentable. In the United States, a claim consisting solely of simple manipulations of abstract concepts, numbers, or signals does not constitute "processes" (USPTO 2006), and hence algorithms are not patentable (as in Gottschalk v. Benson). However, practical applications of algorithms are sometimes patentable. For example, in Diamond v. Diehr, the application of a simple feedback algorithm to aid in the curing of synthetic rubber was deemed patentable. The patenting of software is highly controversial, and there are highly criticized patents involving algorithms, especially data compression algorithms, such as Unisys’ LZW patent."

Best regards,
Rafael

Rafael,
I admire your vision and everyone is whishing the same. The question is who is capable to do what we wish for? A computer programmer/ software developer is doing what they can do by trial and error but nobody is perfect. Even the most powerful software still having bugs but they will not know the problem until someone discovers or encounter while using it. Any software developer or companies spend a lot of moneys for a project and completed for sure they need something to comeback and the only way of doing it is to release their products and have it tested for long period of time. If bug has been discover for sure an action from their side will be made and release patches to fix it. But that’s not an easy fix and something will come out again and again until another products or upgrade will be release again. If you read the brief history of planning and scheduling started from manual to computer to nothing until someone tried to give a try again but until now still not perfect. The old computer was running in a punch card now multi-terabyte and more enhancement and more innovative modern technology still coming.

We should thanks we are now living in much easier and modern technology compare to what we have before. From manual to abacus to calculator now computer and more to come. An organization/ institution has nothing to do with what we have. They support what they believe which has been reviewed by the expert and decided by the top rank management.

In regard to owner nominating there preference, what wrong with that? They just want to justify what they are paying for. If they believed that will do the job and a contractor agreed then what’s the problem? They did not force them; the contractor was the one begging. If the contractor dictating what they want then what will happen? Whose client will bind to that kind of agreement?

w/ Kind Regards,
Rodel

Rodel,

Scheduling software is an essential part of the Means and Methods of the Contractor, here at this side of the Atlantic Means and Methods are supposed to be by the Contractor under the traditional forms of contracts. The interpretation is binding by common law, here the law take precedence over the written words of the contract.

Also it is a known fact Contractors are not free to negotiate contract conditions under bidding for government jobs, is take it or leave it. Here under public bidding is considered immoral and illegal to brand specify, but very frequently this is not followed precisely by our institutions. This leads to favoritism and even kickback by suppliers, is against our credo calling for free enterprise.

Contractors as well as all taxpayers give a substantial amount of money to government agencies, is not the agency money contractor’s are begging, the money belong to the people, we don’t have to knee down to the agencies and thank them.

Why Contractors are to be forced to use such rubbish software as Primavera P6, why not MS Project, Asta Powerproject, Spider Project or any other? Because is convenient to a Program Manager at the expense of hundreds or thousands contractors.

In the USA and its territories we have very different laws to what you have at Queensland, we are claiming for our laws be respected even if “common law”.

Private jobs are another thing, but even under private contracts there are some interpretations that protect the contractor right to keep control of the means and methods.

The attitude of some Owners that Contractors got to beg is wrong, is unprofessional. When a Contractor is invited to a close bid is because he is good, shall not be because he knee down and kiss the foot of a particular manager. I would suspect, and believe me have seen it with my own eyes, the manager wants him to beg is probably looking for some kind of kickback, maybe a home remodeling at his vacation home, or just a new emergency generator in hurricane prone areas. Incredible, what a mind set, "the Contractor got to beg".

Best regards,
Rafael

Rafael,
My apology, wrong choice of words, it should be request and not beg. I know you understand what I mean.

Here in Australia we have freedom and respect our rule.

Best Regards,
Rodel

Rodel,

With your clarification no apology is needed, yes both parties got to respect each other, both have their needs and this is why I advocate for a solution that can satisfy both. Our Federal Government tried a solution by means of a standardized database file to allow the transferring of data but seems Primavera advocates got out with it. Maybe Primavera subtlety boycotted the intent. I believe they should have been left out.

By the way, I perceive more freedom in the UK than in the USA. I would not be surprised if this also is the case in Australia.

Best regards,
Rafael

Dear RAfael,

Open bidding is a different issue. The committee assigned by the Owner determines what is best for the project and it qualifies a short list of qualified tenderers. Hence, the playing field should be leveled to all players.

In a standard management system, say ISO, you need to verify the results and later validate it. The verification of the computations done by a computer software can be made by another software or by hand. And in both cases, by a different person. This is the minimum acceptable management standards that should be the norm in the future.

With kind regards,

Samer

Rafael,
Yes you’re absolutely correct, we have freedom of speech, freedom of religion and secular government, freedom of association. Australian values are Australians respect women, other people’s beliefs, democracy, and our mates and we always give each other a fair go.

w/ kind regards,
Rodel

Hi all

vendor lock-in is a well known practice in the software industry, and the most famous case is sun (now oracle) open office versus Microsoft office, sun created an open file format (ODF) to make exchange files between competing office suite possible, Microsoft riposted by creating a competing file format OOXML, and even managed to make it an ISO standard, the hick is even microsoft is not interested to fully comply to it’s own standard, see the link bellow for further information
http://arstechnica.com/microsoft/news/2010/04/microsoft-office-15not-2010to-be-fully-ooxml-compliant.ars

but the question is what’s the benefit to Oracle and Microsoft to adopt an open exchange format for scheduling software ! Nothing, after all, they are interested that you buy their packages, not to make your life easy to change to another product.
Now the real question why the others vendors( asta, deltek, spider,sciformat, x-planner) are not adopting a standard format. Perhaps they are happy about their niche market.
Independent vendor should be more creative, for example, spider, perhaps something like free spider viewer, where you can load your program and print view all the reports you want,

best regards.
Mimoune

Mimoune,

Over 34% of construction is done by government agencies, if government agencies require for your software to comply with an open file format for data exchange any software that misses to comply will eventually lose over 34% of the contractors, perhaps over 70% as only 30% exclusively bid on private jobs.

http://www.census.gov/const/www/c30index.html

Total................................846,233..........100.00%
...Private...........................553,491............65.41%
......Residential...............250,776............29.63%
......Nonresidential.........302,715............35.77%
...Public.............................292,742...........34.59%
......State & local............264,724............31.28%
......Federal..........................28,018................3.31%

In millions of dollars, a market of about 846 Billions per year in the USA alone.

It will have no effect trough private job biddings, we all will benefit from the right posture of our Government agencies that will make many options available, then also the private job market will benefit.

Of course there is no benefit for them if the requirement is not enforced, particularly to Primavera who in this way is forcing everyone to follow their whim. In any case if Primavera does not complies then let them be out, better many options than a single and rubbish one.

Best regards,
Rafael

Samer,
verification of the results produced by one software using other software is impossible. Different softwares use different algorithms and have different modelling capabilities.
If you will download Spider Project and will try to create the same project as construction example in Demo in P6, you will find that in P6 it is just impossible.
Best Regards,
Vladimir

Dear Vladimir,

Why can’t you save the activity list with relationship, durations in Excel and then load it into another software. Excel can be the intermediate medium between softwares. Just an idea.

With kind regards,

Samer

Samer,
Spider can export the schedules directly to P6 and MS Project, save as a set of CSV files, send any table to Excel, etc.
I talk about another problem - where we can export activity volumes of work, resource assignment productivities, team assignments, cost components, resource and material production, project financing, etc?
Do you know such fields in the Primavera database?
So yes, we send what can be understood - durations, relations, total costs. But a lot of information is lost.
And besides P6 cannot simulate shift work.
So P6 will not verify Spider schedule, and besides Spider optimizes resource constrained schedules, level not only renewable resources but also materials and costs.
P6 produce some resource constrained schedule and cannot level materials and costs.
And what P6 can verify?

Best Regards,
Vladimir

Vladimir,

There is no need to go as far as to the sophisticated algorithms, even in the basic computations they do differ. Continuous PDM vs. Non Continuous PDM vs. AOA traditional Computations can yield different results for early dates. Even the planning unit plays a role.

The best that can be done is getting an approximation, everyone, including the government must start by accepting this.

At least in one issue most software agree, is in showing incorrect float after resource leveling, incredible but true, all wrong in the most basic computation that even with a 2 activities job it can easily be shown.

Well perhaps this can be a justification to use whatever you want, anyway they got it wrong, so why so much insistence in not letting the team responsible for the management of the resources and workforce that actually will be doing the job choose his tools.

Best regards,
Rafael

Dear Vladimir,

When you start going into that level of details, it becomes more than a Scheduling tool. It becomes a management tool. IMHO you need an audit on the process.

If you do any kind of computations, you need verification. If you are doing a process, then a standard audit procedure is acceptable.

With kind regards,

Samer

Samer,

I agree, because of the difference in computed values only one software is right, this is Spider Project, all the rest are wrong.

Is simple use Spider Project as the Standard for the audit, any software that yields different results is wrong.

Best regards,
Rafael

Dear Rafael,

It seems that the Spider team has created a great tool since it stood your indepth analysis and output requirements. But the question is: How do you verify the results?

With kind regards,

Samer

Samer,
Spider Project is designed for usage as the corporate planning tool. It means that the schedules that are created with the use of Spider Project, if properly organised, will be based on the corporate norms and dictionaries.
Spider Project reference-books include such parameters as norms for material requirements per volume unit of typical jobs, unit costs for typical jobs, resource productivities on typical assignments, resource crews for typical works, etc. Besides the schedules are usually created using the library of typical project fragments that describe the technologies of achieving low level results.
Audit is easy if it is enough to verify corporate norms.

Do you have some proposal for an audit of some middle scale (like 10,000 activities, 500 resource types) project where estimates were based on expert judgements? How long will it take?

I don’t understand what do you mean by scheduling system VS management system. Project schedule shall be based on the corporate standards and give all necessary information for management decisions.

Hi Mimoune,
the standard format means the same data set?
But they are different. Please look at my earlier posts.
A set of fields in Spider Project is different.
We can import almost everything but export only those fields that will be understood by other packages.
Best Regards,
Vladimir

Sammer,

I have compared many times sample jobs modeled within Primavera SureTrak, MS Project and Spider Project.

They essentially converge on very simple models up to a point where the more sophisticated resource leveling algorithm enter into play, the good thing is that by displaying the resource usage diagrams you can see Spider Project worked within the constraints and consistently yielded better results than the rest. Not to mention the display of true values of float after resource leveling only Spider Project can provide.

By the way have you ever tested the 2 activities sample job that shows how wrong Primavera SureTrak, Primavera P3, Primavera P6, Power Project, MS Project and many other are at displaying the correct value for float after resource leveling? No ISO standard needed, just 5 minutes of your time. A similar exercise you can do with other sample jobs.

Do not expect Vladimir to tell you line by line the algorithm(s) rules, yes there are several. I believe some of them, if not all, cannot be applied to MS Project because MS Project places a constraint on the activity start as each is delayed, denying the algorithm to un-status the activity for better results, the same might happen with other software because of available functionalities such as true modeling for shifts.

Best regards,
Rafael

Dear Vladimir,

I was checking 5000 activity Schedules each for 5-6 Contractors on a monthly basis. Each schedule should not take more than 4-6 hours to check if the activities, logic, durations, scope changes, resources, percentages, or schedule changes have been done. I always know more about the site than any other person for the simple reason that I spend at least 12 hours daily on sites not in the office site. So all my reviews are actually very clear, quick, and with the latest information since I have direct contact with all the supervisors and teams in addition to the management teams.

You can also run variance reports like claim digger to get a variance list once you get the baseline approved.

Softwares today do much more than Scheduling; reflecting the project planning, monitor progress, and provide trends and forcasting.

With kind regards,

Samer

Vladimir

an example of common format is SDEF, it is requested from contractor who deal with us army corps of engineers to submit their schedule in that format.

http://www.cecer.army.mil/facts/sheets/cf-26.pdf

and yes i know each software has different capabilities, but you can always agree on a common ground, the most basic informations( activity id, activity description relationships etc) it is in the benefit of everybody, specially independent vendors (asta, spider, deltek).

and you can keep saying that spider is the best thing invented after CPM method, but as long as it is not used by planners, it will stay always an underdog player,
unless spider management begin to think out of the box, and ask themselves how to make this product sells and used !?
i don’t know, but a free viewer will make no harms, and make people like Rafael happy ;)

best regards
Mimoune

edited : me silly i did not know you have already a viewer, when you purchase a spider license.

mimoune

The viewer is free to anyone just that to my knowledge only registered user can download it and then distribute it for free, otherwise Spider Website would be slowed down by everyone downloading the viewer.

What happens is that Spider Project Development Team is very prolific and dynamic and a few times a month they upgrade the software (usually very minor upgrades), so the viewer must also be upgraded.

Fortunately it takes me about 2 minutes to download a full file of the new version. It is not like P6 about 30mb of P6 and 600MB of an external database requiring about 3 installation CD’s, the database engine usually a Microsoft Database, by logic deduction because Oracle is no good at database development. They have not figure it out a more efficient database that requires no PhD to administer. I call P6 the mother of all inefficient software; they are very good at being inefficient. Why do you think it makes many PP members to laugh at it?

Thanks for the reference to SDEF, this was precisely to the standard I was referring. And like Vladimir already said it will not make all software to perform equally. The idea of this standard is to allow for the government to specify a standard that is open and not vendor specific. This to my view, although might close some options to the Contractor, it is an acceptable compromise, at least better than a single option.

Vladimir,

Can I distribute 20,000 or 60,000 copies of the viewer to any government agency for free so 20,000 or 60,000 reviewers can take a look at all the data in my submitted files? If not enough maybe more?

If your answer is yes then Government agencies should consider start requiring free copies of the viewer, as many as they wish.

Best regards,
Rafael

Hi Rafael,

I just wondering how well you are in database? Have you used all of them before? I remember during my school days when Database was introduce using different programs language like Basic, C language, Pascal, Fortran, Cobol, Dbase, Foxpro...etc… and I believed oracle is the first commercial product released. IBM, Informix and Sybase entered the Arena until Microsoft bought Sybase and now the only 3 major databases exist which was by IBM (Informix), Microsoft and Oracle.

How can you say that “Oracle is no good at database development”? How good are you in database management system? Are you a programmer developer which I believed who works on database management system all the time? I think is the software or program application deals with the database so the question should be how good or efficient the software is and not the database.

w/ kind regards,
Rodel

Hi Samer,
when the schedule is based on the estimates and expert judgement the verification process includes the verification of the estimates.

For an example:
1) If the crew assigned to an activity is full and reasonable,
2) If the productivity of assigned resources is correct,
3) If the crews and productivities are the same for all activities of the same type in the whole schedule,
4) If all necessary materials were assigned and material consumption corresponds with the quantity of work to be done on each activity,
5) If material consumption norms (consumption per activity volume unit) are the same for all activities of the same type,
I can add to the list cost verification, etc.

It is very time consuming and the work will be much easier if you may be sure that all data are based on the norms that are listed in the separate tables.

Best Regards,
Vladimir

Hi Mimoune,
Thank you, I will look at the format you suggested.
As I wrote earlier Spider Project schedules can be exported to xml, MS Project, P6, text, Oracle, SQL Server.
The data formats were described in Spider Project Help.
I don’t see problems with this.

In my country Spider Project is widely used in all industries, for all large programs for more than 15 years. At the moment we also have customers in 28 other countries and branches in 5 of them. So many thousands planners from thousands companies are using Spider Projects for many years.

I did not say that “spider is the best thing invented after CPM method”. Where did you see it? More than that – I don’t know what do you mean by CPM method. Spider supports many methods and we suggest our customers to apply SDPM method that is more powerful and reliable.

Best Regards,
Vladimir

Rafael,
there are no restrictions of Spider Viewer usage for our customers. They can install them on any number of computers and supply their clients, customers, subcontractors for free.

Best Regards,
Vladimir

Dear Vladimir,

Updating and reviewing the Schedules is a lot of work if you are sitting in the office. For a person that is at site all the time, it is very easy. Because they already saw all the information and know the full details.

Usually it takes me between 30-60 seconds to review each page. So for a 10,000 activities/35 activity per page = 300 pages = 5 hours approximately. Say 6 hours with the report writing and other interruptions.

With kind regards,

Samer

Dear Vladimir,

You asked me about what procedure that I propose for internal audits. I found this article that I posted yesterday under Contracts:
"
Applying Internal Controls Skills on Construction Projects*

Alexia Nalewaik, CCE MRICS. *This article first appeared on the website of RICA Americas
http://www.ricsamericas.org/member-articles.html and is reprinted ...
www.icoste.org/ICMJ%20Papers/Nalewaik3.pdf
"

This is a good start showing the direction.

With kind regards,

Samer

Rodel

I know nothing about database, is just that P6 is so inefficient and by watching how more powerful software can do better without the use of Oracle or MS databases that I am deducting part of the limitation is on the external database engine.

I find it intriguing that Oracle uses a Microsoft Database as the default option in one of their products, P6. Therefore I believe is because of their inability to provide an equivalent. My limited knowledge then tells me Microsoft Databases are better than Oracles. I cannot understand how a supposedly excellent company as Oracle has such a bad product.

Best regards,
Rafael

Dear Samer,
I looked at the paper that you advised and did not find the answers to my questions.

I think that did not understand what do you mean by audit.
Being on site does not help to audit the quality of the project schedule that may cover long period.

Best Regards,
Vladimir

Vladimir,

I believe Sammer is looking for a way to test the math computations used by Spider Project.

I believe that perhaps because of the way the algorithms are defined the only way is to run as many simulations you can. Covering all possibilities even in the best of today supercomputer can be impractical.

Kind of similar to Monte Carlo Simulation need, the CPM model is so sophisticated and the combinatorial possibilities are unlimited that it is not possible to write a mathematical equation that will give us the result for whatever a scheduler want to model.

Vladimir, seems like a few are scratching their heads because with Spider you can work with the database tables using the concept of Reference Book, something similar to a “shell”, an interface that runs over the other to make it user friendly. I know nothing about database but can play basketball with Spider Project Tables and without injury as no matter how I tried I have not been able to corrupt a single file.

Somewhere I heard the term relational database. Do databases have sex with each other?

Best regards,
Rafael

Rafael,
math computations are useless if they are based on the data that are not reliable.
The first step of the schedule verification is the verification of its initial data. If they are not reliable then all schedule improvements do not make any sense.
Best Regards,
Vladimir

Vladimir,

Start with the premise the first step passed. Then how the other steps must follow?

Best regards,
Rafael

Then the network - if there are activities without predecessors/ successors, if there are constraints like Start no Earlier Then.
And only then the schedule itself - if resources were levelled, if it can be improved.

Hi Rafael,
I’m puzzle on how you judge something when you don’t know anything about it?
It’s seems that spider is really a very promising planning tools where you can integrate in any other system without any problem. Unfortunately I haven’t got luck to use them yet but I’m looking forward that chance will come someday.
Is spider having an open database?

You mention about relational database. Relational database consist of a collection of tables that store matches data by using common characteristics found within the data set. The invention of this database system has standardized the way that data is stored and processed. The resulting groups of data are organized and are much easier for many people to understand. The concept of a relational database derives from the principles of relational algebra, realized as a whole by the father of relational databases, E. F. Codd. Most of the database systems in use today are based on the relational system.

Just for curiosity sake, if you will have a pleasure to select a planning tools which one is your preference? A planning tool with open database and its structure where you can use other simple application for your convenience, an open database where you can add, edit and modify data directly on the tables or a planning tool with close database but data is available using import/export function for the use of other simple application for your own convenience to add, edit and modify data?

Best Regards,
Rodel

Hi Rodel,
since the schedule model is valid only if the data date is common for all schedule objects there is not much difference between the options that you suggested.
In any case the model shall be updated in the discreet moments and open database has no advantages against import/export function.
Best Regards,
Vladimir

Thanks Vladimir,
I believed there is a big difference between the two options. An open database has exposed all table structures which an advantage for the use of integration and interfacing of one software to another. The data exchange is not limited and matching fields against its table can be improvised. Using import/ export function has a limitation of data, unknown structures and limited input interface.

Best Regards,
Rodel

Vladimir

no you did not wrote that" spider is the best thing invented after after CPM", i only meant is that the software is as good as it is actually used, what’s the point of a fantastic tool if it is used only by a small number of people.

Rafael

P6.7 include by default oracle database, but if you upgrade from p6.2, you can keep, your Microsoft Database, but to be honest installing oracle express edition is not so intuitive, specially if you screw up the first installation and you want to do a re-installation, it is a nightmare, because even when you remove the first installations, some files simply stay, and if you want to install again, the system will tell you, that oracle database are already installed, the only solution some manual deleting. and a lot of googling.

Rodel

from my understanding, spider use a kind of embedded proprietary database, the advantages, it is installed with the software, no need to configure anything, and you can export, import any imaginable data, but unfortunately there is no driver available, thus no live ODBC queries.

and if i had to choose,in case of stand alone usage, i would prefer something like SQlite, small footprint, embedded with the software, and has good driver.

for enterprise usage, it is clear, a kick ass oracle 11 database.

but using full database system for a standalone usage is ....

best regards
Mimoune

Rodel,

I judge something at times based on observation, I have worked with several scheduling software without the need of a PhD in Databases. To me it should be on the background, bringing it to the user level is unnecessary. With Spider I can transfer data among file tables at will without the need of specialized training.

I can make my opinion without asking the “experts” on a product I do not know the inner workings, I can make my opinion by comparing the result with similar products. I can compare my experience with a Jeep Cherokee, a very bad experience with my experience with my 2 Toyota 4runners and my wife Toyota Highlander, all Toyota great products I only know how to drive and how to check basic liquids.

The same I can do with Primavera P6, a horrible experience, with SureTrak and P3, not bad, Spider Project, even better. Without any knowledge about databases I can tell you my experience with P6 lead me to reach an opinion of my own, that it is rubbish. Is relevant to PP community all members express their experiences for the knowledge of the rest.

The time for training in my profession is more productive if a course on Foundation Design, Structural Engineering, Pre/Post Tensioned Concrete Structures, Water and Wastewater Treatment Plant, Storm sewer Design, Structural Steel Structures, Concrete Structures, Structural Dynamics, Construction Codes and Project Management among many others, but databases for what, I see no need.

Here at PP many of us are Project Managers in varied field such as Construction, Oil and Gas, Nuclear and many others, we are managers in need of a workable tool that does not require of us any specialized knowledge on database administration to keep us in control. Outsourcing some decisions is not only expensive but many times counterproductive. I found a scheduling tool that do not requires from me any knowledge about databases all I ask is for Government Agencies and Owners to allow the Contractor to use the software of their choosing. If by brute force then why not MS Project or an Abacus?

Best regards,
Rafael

Mimoune,
I live in Russia and in my country Spider Project is most popular and widely used professional PM tool.
All large programs here are managed with Spider Project and we are involved in the management of some of them (with total budget exceeding $60bln).
We are happy with this.
We support our partners and users in other countries (28).
But it is your choice - what software to select. It depends on your requirements. I think that the wide choice is better than no choice.

Why do you need ODBC driver? Is there some special purpose or just in case ...

Best Regards,
Vladimir

Mimoune,

That you can use Spider Project without the need to link it to external databases it does not mean it cannot do it. The great difference is that for most of the operations other software requires for you to use a link to an external database Spider can handle 99% with Reference Books functionality, is easier, makes no sense going the hard way.



Best regards,
Rafael

Hi Mimoune,

Thanks for the information. I understand what you’re saying and I agree with your thought. The simplest and easy accessible is the better. But we are now on the age of modern science where every system requires full interface, common control and one system that operate everything in one single station .One of the selling advantage of every a company now is a good system that produce everything with compatibility to clients system. Data exchange is now very important especially in the electronic and computer world like now.

Best Regards,
Rodel

Hi Rodel,
I would like to understand your requirement using the specific examples. What limitations do you mean?

Spider Project can save the project into its own format or into database (all tables, codes, etc. are open). Saving into database we call export. Project can be opened from the own file or from the database (we call this import).

We have customers that use Spider together with their ERP systems and did not meet problems. But maybe you mean using the PM software some specific way?

Best Regards,
Vladimir

Rafael,

I respect your opinion and we are happy for you. You love something that makes you happy then it’s you to enjoy it.

Like what I mention, I haven’t use Spider and looking forward to have a chance in the future. I used Artemis where I began to have interest in database, Microsoft Project, P3, P3e (P4), P3e/c, P5, P6 and I don’t have problem with all of them. If I got a chance of using Spider I will love it for sure.

For you info, P6 database doesn’t require any PhD like what you mentioned. It is simple and very easy to understand. It is an open database where integration and interfacing is very possible to any system which I believed one of the selling points of Primavera. SQL is very popular everywhere and very common to all system. It can be accessed directly through SQL or any Open Database Connectivity (ODBC).

Rodel,
unfortunately it is not that easy.
And Primavera does not recommended to write to P6 database directly.
Best Regards,
Vladimir

Hi Vladimir,
I’m not saying that Spider has problem and like what I said I have no idea what Spider capable of.

My examples is for those planning tools which don’t have capability of direct exchange of data to avoid double input, use automation and interfacing to another system.
Ex: A schedule data is link to another system that been published electronically without worrying that the data is out of date.

An up to date program that can be accessed to another system in different format where contractor can view electronically on their own system like fabrication schedule look ahead and target completion. It may be on tabular format or table format for each activity with correct data online and many others.

Vladimir,

Well I’m not a computer programmer or developer but I’m one of the fortunate that found it very easy.

Best Regards,
Rodel