Articoli Project Management
Plan Academy
Plan Academy Project Controls Training & Courses
- Updating Primavera P6 with Data from Excelby Faraz Khan on 23 Luglio 2024 at 18:14
Importing data from Excel can be challenging due to various factors, such as selecting the appropriate columns and formatting them…
- Construction Project Management: 10 Strategies to Master in 2024by Rama Al Jaber on 9 Luglio 2024 at 17:31
Effective project management is crucial for the success of any endeavor. As we move further into 2024, construction managers are…
- Sustainability Highlights in 2024: 10 Projects to Keep Your Eye onby Rama Al Jaber on 26 Giugno 2024 at 14:25
We’re seeing a profound shift towards sustainability in the Construction Industry in 2024. Mega projects around the world are setting…
- Streamline Your Project: Importing Data from Excel to Primavera P6 Effortlesslyby Faraz Khan on 11 Giugno 2024 at 14:52
Preparing a schedule in Primavera P6 has traditionally been a time-consuming task, requiring manual data entry without the flexibility of…
- Primavera P6 Courses: 7 of the Most Popular Online Courses of 2024by Rama Al Jaber on 4 Giugno 2024 at 13:14
In the dynamic world of project management, mastering tools like Primavera P6 is essential for success. With numerous training options…
- Schedule Delays in Construction Projects: 7 Key Factorsby Faraz Khan on 14 Maggio 2024 at 17:30
Schedule delays are an ever-present challenge in construction projects, causing frustration, financial strain, and even legal disputes. Understanding the root…
- Primavera P6 Skills Assessment: Test for This When Hiring Schedulersby Rama Al Jaber on 30 Aprile 2024 at 14:55
The demand for skilled Primavera P6 planners and schedulers is on the rise. But with hiring comes its own set…
- 6 New Features in Primavera P6 Professional Version 23.12by Rama Al Jaber on 16 Aprile 2024 at 17:53
Oracle’s Primavera P6 Professional has long been a trusted project management software by industries worldwide to streamline processes and enhance…
- ALICE CORE: Unleashing Efficiency in Constructionby Rama Al Jaber on 2 Aprile 2024 at 13:55
In the ever-evolving world of construction project management, staying ahead of the curve is paramount to success. With the emergence…
- Construction Sustainability Highlights 2023: Embracing the Futureby Michael Lepage on 10 Febbraio 2024 at 0:12
In the ever-evolving landscape of construction, sustainability has become more than just a buzzword—it’s a driving force shaping the industry’s…
- Gantt Charts: Mastering the Backbone of Construction and Engineering Project Managementby Rama Al Jaber on 9 Febbraio 2024 at 23:12
Gantt charts serve as the indispensable backbone of project controls and scheduling especially in the realm of construction engineering. The…
- New Features in Primavera P6 Version 22.12 That Will Change The Gameby Michael Lepage on 12 Maggio 2023 at 16:34
Let’s talk about some of the most important new features in Primavera P6 version 22.12 that just dropped. There are…
- Creating Scenarios in Primavera P6? Here’s a Better Alternativeby Michael Lepage on 25 Aprile 2023 at 14:34
We have been creating scenarios in Primavera P6 the same way for so long – and it completely sucks! Here’s…
- 7 Tips To Help You Create An Effective Project Status Reportby Michael Lepage on 11 Gennaio 2023 at 15:45
Put plainly, project status reports are difficult to write. It is a fact that project managers in different industries can…
- 5 Ways To Completely Revamp Your Project Productivity Styleby Michael Lepage on 30 Novembre 2022 at 16:06
We all want to be and feel productive everyday. Somedays you feel like Thor, knocking off the tasks like he…
- P6 Schedule Comparison Tools: Which One Should You Use?by Michael Lepage on 10 Novembre 2022 at 16:12
Comparing two Primavera P6 schedules is one of the most fundamental things that we should be able to as a…
- 4 Common Construction Bidding Errors And How To Avoid Themby Michael Lepage on 19 Ottobre 2022 at 16:00
Independent contractors are constantly seeking out and proposing bids in hopes of landing a construction job. Whether it is a…
- Physical Percent Complete in Primavera P6 – the Missing Guideby Nader Khorrami Rad on 5 Ottobre 2022 at 15:06
There are three different methods of calculating the actual progress of activities: Duration Percent Complete, Units Percent Complete, and Physical…
- Units Percent Complete in Primavera P6 – the Missing Guideby Nader Khorrami Rad on 28 Settembre 2022 at 15:04
This article belongs to a series of articles about units percent complete fields of Primavera P6. As explained in the…
- Duration Percent Complete in Primavera P6 – the Missing Guideby Nader Khorrami Rad on 21 Settembre 2022 at 14:34
There are many different methods for calculation of actual progress in Primavera P6. These methods involve using many fields and…
- Critical Path Analysis in P6 – 5 Things I Wish I Knew Earlierby Michael Lepage on 14 Settembre 2022 at 15:00
When I first started learning planning and Primavera P6, I thought I had it all figured out. But it wasn’t…
- 70 Project Scheduling Terms That Every Planner Needs To Knowby Michael Lepage on 1 Settembre 2022 at 16:15
The number of project scheduling and planning terms out there can be overwhelming. Interpreting and communicating a plan can become…
- What is a Level of Effort Activity in Primavera P6? [FAQs]by Michael Lepage on 17 Agosto 2022 at 15:36
A “Level of Effort” Activity in Primavera P6 is a special activity type with unique qualities for duration. Primavera P6…
- What is High-Level Resourcing?by Michael Lepage on 3 Agosto 2022 at 15:03
We all know how versatile Primavera P6 is as a planning, scheduling and project resource management tool. P6 can handle…
Project Management
Notizie sulla certificazione PMP
OnlinePMCourses Online Project Management Video Courses to Build Your Project Career
- How to Do a Project Handover… and When to do it!by Mike Clayton on 25 Luglio 2024 at 4:55
In this video, I consider the question, ’when should you handover your project deliverables?’ and look at how to do it. The post How to Do a Project Handover… and When to do it! appeared first on OnlinePMCourses.
- Boost Your Team’s Success with 10 Effective Team Communication Tipsby Mike Clayton on 22 Luglio 2024 at 4:55
A great project team is a start. With great team communication, everything seems so much easier. So, we look at how to create it. The post Boost Your Team’s Success with 10 Effective Team Communication Tips appeared first on OnlinePMCourses.
- What is Shu Ha Ri? or is it ShuHaRi?by Mike Clayton on 18 Luglio 2024 at 4:55
Shu Ha Ri – or ShuHaRi – is a term widely used in the Agile community. In this video, I answer the question, what is Shu Ha Ri? The post What is Shu Ha Ri? or is it ShuHaRi? appeared first on OnlinePMCourses.
- How and Why to Choose the Best Project Management Softwareby Mike Clayton on 15 Luglio 2024 at 4:55
Project management software can be the solution to missed deadlines, stressed colleagues, and maybe even a lost client. How to choose it? The post How and Why to Choose the Best Project Management Software appeared first on OnlinePMCourses.
- How to Manage Quality Assurance in Your Projectby Mike Clayton on 11 Luglio 2024 at 4:50
Quality Assurance (QA) is pivotal for ensuring that project deliverables meet predefined standards and stakeholder expectations. The post How to Manage Quality Assurance in Your Project appeared first on OnlinePMCourses.
- Realtime Resource Planning and Optimization: How to Make Your Project a Successby Mahendra Gupta on 8 Luglio 2024 at 4:55
There are many reasons why projects fail. One that many organizations underestimate is resourcing. So, let’s take a look! The post Realtime Resource Planning and Optimization: How to Make Your Project a Success appeared first on OnlinePMCourses.
- What are Heads of Terms? …aka Heads of Agreement, Memorandum of Understanding, Term-sheetby Mike Clayton on 4 Luglio 2024 at 4:55
In this video, I answer the question, What are Heads of Terms? …or Heads of Agreement, Memorandum of Understanding, or Term-sheet? The post What are Heads of Terms? …aka Heads of Agreement, Memorandum of Understanding, Term-sheet appeared first on OnlinePMCourses.
- Political Acumen: How to Win the Game of Project Politicsby Mike Clayton on 1 Luglio 2024 at 4:50
Any seasoned Project Manager will quickly learn that there’s no escaping project politics. So, you need political acumen in your toolkit. The post Political Acumen: How to Win the Game of Project Politics appeared first on OnlinePMCourses.
- Project Team Leadership 101by Mike Clayton on 27 Giugno 2024 at 4:55
In this project team leadership video, I tackle the absolute fundamentals of leading a project team, that every project leader needs to know. The post Project Team Leadership 101 appeared first on OnlinePMCourses.
- The One Minute Manager Applies the Principles to Project Managementby Mike Clayton on 24 Giugno 2024 at 4:50
The One Minute Manager is a well-deserved best-seller. How does it work for Project Management? Could you be a One Minute Project Manager? The post The One Minute Manager Applies the Principles to Project Management appeared first on OnlinePMCourses.
Articoli Project Management
Primavera P6: ridurre il DB locale PPMDBSQLite per velocizzare l’esecuzione dell’applicazione
Ciao come va? Se sei arrivato fino a qui potresti avere bisogno di velocizzare l’esecuzione dell’applicazione Oracle Primavera P6.
La breve guida è riferita alle installazioni con il DB locale di Primavera PPMDBSQLite.db e alla versione P6 Professional R16.2 (x64) anche se questa procedura può funzionare anche con altre versioni.
Per le problematiche riferite a DB Oracle Server in rete chiedete supporto al vostro amministratore IT.
Veniamo al problema, in pratica per ordine e per velocizzare P6 ho rimosso molti progetti dal Primavera ma la dimensione del DB non è mai diminuita.
Come vedi sotto, nel corso del tempo avevo fatto delle copie de DB e si può vedere come la dimensione sia sempre aumentata, seppure abbia a volte cancellato intere annualità di progetti.
Questo penso che sia il problema per cui quando copio un Progetto, o quando ne importo uno grande il processo di import non mi va mai alla fine, o fallisce oppure devo spegnere il programma e riavviare.
Così come altri database, sqlite non riduce le dimensioni dei datafile automaticamente quando vengono cancellati i dati. Quantomeno non lo fa per default.
Per risolvere il problema prima effettuati una copia di sicurezza de DB stesso, chiudi P6, e poi connettiti al database con la console di amministrazione, ovvero lanciando il comando:
sqlite3 NomeDB
sqlite3 PPMDBSQLite.db
Una volta connesso, va lanciato il comando
VACUUM;
che comprime il datafile
Alla fine si esce dalla console con il comando
.q
Purtroppo probabilmente non hai quel comando disponibile sul PC, il comendo sqlite3 deriva da una installazione sqlite stand alone che esula dall’istallazione di primavera P6 che ha il driver del DB già al suo interno.
Per cui ho installato il pacchetto:
sqlite-tools-win32-x86-3290000.zip
(1.71 MiB) A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff.exeprogram, and the sqlite3_analyzer.exe program.
(sha1: f009ff42b8c22886675005e3e57c94d62bca12b3)
Dal sito
https://www.sqlite.org/download.html
A.C:\Users\ofgod>cd \Users\ofgod\Downloads
C:\Users\ofgod\Downloads>cd sqlite-tools-win32-x86-3290000
C:\Users\ofgod\Downloads\sqlite-tools-win32-x86-3290000>sqlite3.exe \TEMP\PPMDBSQLite.db
SQLite version 3.29.0 2019-07-10 17:32:03
Enter “.help” for usage hints.
sqlite> VACUUM;
sqlite>
sqlite>
sqlite> .q
C:\Users\ofgod\Downloads\sqlite-tools-win32-x86-3290000>
Ora il file è quasi la metà come dimensione e spero siano stati ricostruiti anche gli indici.
Adesso P6 lavora meglio ed è veloce come ala prima installazione vuota dello stesso applicativo.
Buon lavoro, ricorda prima di fare questa operazione esporta e svuota progetti non più recenti da P6,
Chiudi P6
Fai una copia di sicurezza del PMDBSQLite.db
Lancia sqlite3 e poi i comandi interni ricordando il ; dopo lo statemend VACUUM.
Buon lavoro
A.D.D.
Devi effettuare l'accesso per postare un commento.