Error message The conversion of a char data type

by cdeschamps March 9, 2009

Installation Problem on SQL Server error message:

The conversion of a char data type to a datetime data type resulted in a out-of-range datatime value

 



Solution:

Create a DWORD value US=1 on the registry

[HKEY_LOCAL_MACHINE\SOFTWARE\Target Skills\PlanningPME]

"US"=dword:00000001 

 

Keywords:

Filed Under: Installation

Manage several databases with PlanningPME

by cdeschamps March 5, 2009

CUSTOMIZATION OF YOUR SHORTCUT PLANNINGPME

A simple setting of your shortcut PlanningPME will allow you to:
- Manage several schedules installed on different databases
- Pre-define the display with the different filters while opening the planning

1/ Manage several schedules on different databases
Right click on your shortcut of PlanningPME and select “Properties”.
Then, go to the tab “Shortcut” and specify on the field “Target” the database you would like to connect to
The syntax is the same for each database:
The indent [-] or [/] begins each command.
You can not use spaces. They must be replaced by %20
Details of the commands to launch a given database:
- base=[Connexion string]
- schema=[schema of the Oracle database]
- us=[0|1] Put 1 for a database in english
 - fr=[0|1] Put 1 for a database in French
 - oledb=[0|1] Put 1 for a database SQL Server, MySQl or Oracle

Illustration with some examples:

1.1              MS Access

"C:\Program Files\Target Skills\PlanningPME\PlanningPME.exe" C:\Program%20Files\Target%20Skills\PlanningPME\PlanningPME.pp

1.2              Sql Server 

"C:\Program Files\Target Skills\PlanningPME\PlanningPME.exe" -base=Provider=sqloledb;Data%20Source=[name of the server];Database=[name of the database];Uid=[user Sql];Pwd=[password user sql] -oledb=1

Example:

"P:\Informatique\Versions\Béta V4.0.2.0\PlanningPME_REF\Vente\PlanningPME.exe" -base=Provider=sqloledb;Data%20Source=srv-sgbd;Initial%20Catalog=test10;User%20Id=ppme;Password=planning -oledb=1

srv-sgbd           =          Name of the server
test10               =          Name of the database
ppme                =          User SQL
planning            =          Password of the user SQL

1.3              My Sql

"C:\Program Files\Target Skills\PlanningPME\PlanningPME.exe" -base=Provider=MSDASQL;DRIVER={MySQL%20ODBC%203.51%20Driver};Server=[name of the server or IP Address];Port=3306;Option=16384;Stmt=;Database=[name of the database];Uid=[user my sql];Pwd=[Password user my sql] -oledb=1

1.4              Oracle

"C:\Program Files\Target Skills\PlanningPME\PlanningPME.exe" /base=Driver={Oracle%20dans%20OraHome92};DBQ=[name of the database]];UID=[name of the user];PWD=[user password]/oledb=1 /schema=[name of the scheme.] /us=1

2/ Pre-define the display of the planning

You can select some filters of the planning directly.Here are some commands:

-date=[date while opening the planning]
-planning=[type of planning]
-filter=[department]

For example, this example below will diplays the planning on the 01/01/2009 for the department « Administration » in a monthly view and the resource view.

"C:\Program Files\Target Skills\PlanningPME\PlanningPME.exe"
/date=1/1/2009 /filter=Administration/planning=Monthly

Keywords:

Filed Under: PlanningPME

Zoom on periodical tasks

by cdeschamps March 2, 2009

  Save time creating periodical tasks. The function “Recurrence” will help you manage task assignement monthly meeting, yearly appointments…

1. Creation of periodical tasks

When creating a task, in the window “Task”, click on the button “Recurrence”.

 Then, the following window appears:

You can select to create a weekly task, monthly...

On the planning board, the symbol will show you that a task is periodical:

2. Get tasks off the recurrence

You will first need to take the task off the recurrence before modifying it. You have two choices:

- Modification one by one with a right click on the task

 

- Modification of several tasks with a right click on the resource

3. Modification of periodical tasks

You can then modify the tasks and assign them to other resources or delete them. 

Keywords:

Filed Under: PlanningPME

Fill in an additional fields of the type Choice with existing data

by cdeschamps February 18, 2009

Fill in an additional fields of the type Choice with existing data

In PlanningPME, you have the possibility to add additional fields of the type Choice in the Tasks, Clients, Projects and Resources windows.

 

PlanningPME put at your disposal a field of the type "Choice" that appears as a combo box. The list of values can be filled in PlanningPME in the box "Values" or it can be fed by a script while opening PlanningPME.

Here is an example:

'Register PlanningPME.dll before -> c:\windows\system32\regsvr32 PlanningPME.dll

Set ppme = CreateObject("PlanningPME.Application")
ppme.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Target Skills\PlanningPME\PlanningPME.pp"
ppme.Connect

set dfs = ppme.GetDataFields(84) ' PpTask1

for i=0 to dfs.Count()

   if dts.Item(i).Field = "MYCHOICE" then

      dts.Item(i).Data = "Item1" & vbCrLf  & "Item2" & vbCrLf  & "Item3"

   end if

next i 

You just need to register this script with the extension .vbs and put it in the settings while launching PlanningPME (Menu Tools -> Options -> Integration) as shown below:

 

If you want to feed the values from an external database, you can open your own connexion and to browse the elements to add them...or just ask us for an integration.

Remove the licence and activate it on another workstation

by cdeschamps February 18, 2009

Remove the licence and activate it on another workstation

Before uninstalling PlanningPME from any workstation, it is mandatory to delete the software licence, in order to be able to re-use it on another computer.

1 - Delete the PlanningPME licence of an existing computer still active

You can delete the licence on your own. Open PlanningPME and go to the menu File -> Delete the licence. 

 

The name of your computer will then be removed from the list of registered computers we have for your company.

You can now register your licence again on a new computer.

 

2 - Delete the licence of a non active workstation

If your workstation is out of order and you cannot access to PlanningPME to delete the licence, you may want to temporarily rename the new computer so that its name matches exactly the name of the unavailable computer (Here in our example: TS-LAETITIA. See Chapter I). To change the name of your new workstation, you just need to "Start" the Windows® menu, select "Control Panel" then "System" then the tab "Computer Name" and click on "Change"

Once your workstation has got a new name, you can open PlanningPME, go to the menu File -> Delete the licence. 

When the licence is successfully deleted, you can change the name of your computer back to the previous one, and register your version of PlanningPME using File ->Registration via Internet

Keywords:

Filed Under: PlanningPME

Registration of the licences PlanningPME

by cdeschamps February 17, 2009

Registration of the licences PlanningPME

Once the installation done, you must register PlanningPME on each workstation. It is mandatory to register the software licences on each workstation with the same login and password. The registration of the licences requires two steps:

Step 1: Pre recording of the software

1- Open PlanningPME

2- Go to the Menu File -> Identification 

 

 

 

 

 

 

 

 

 

 

 

 

 

 3- Enter your login and your password. (The login and the password are the same for all your licences)and press "OK

 

 

 

 

 

 

 

 

 

4- Then, go to the menu File -> Registration via Internet 

 

 

 

 

 

 

 

 

 

 

 

 

5- You have the message: The licence has been pre-registered. You are then limited to 200 uses. 

 Step2: Final registration of your licences

At the receipt of your payment, we will send you an e-mail to give you unlimited access to PlanningPME. From each workstation, you will just need to go to "File" -> "Registration via Internet" once again to register your licence definitely. You will get the message: The licence has been registered.

 

 

You now have unlimited access to your planning. Licences are a one time fee. Only the support contract is a yearly cost.

 

Other articles to read on licences management:
Remove your licence and register it on another computer
You have exceeded the number of uses

Keywords:

Filed Under: PlanningPME

Ask for a demo online on PlanningPME

by cdeschamps February 9, 2009

Do you want to have a customized web demo on PlanningPME?

Our consultants are at your disposal. Advantages:

- save time

- optimize your planning 

We are using the remote control software Inquiero. Here is the procedure:

InQuiero is an advanced communication technology which facilitates an immediate connection between your PC and the PC of one of our consultants, in order to provide remote technical assistance. 

How can I get assistance online? 

From PlanningPME, go to the menu “?” -> “Help online”.

The following Windows appears: 

 

Add the “code de session”  (Session code) that we provide. Click on "Accepter" (Accept)

The following window shows that the connexion is being done:

Then, this window appears:

Click on "Accepter" (Accept)

You may have to download and activate a component “Active X” that will alow us to visualize your screen.

This Windows shows that the connexion is done. You can cancel it at any moment clicking on “Annulation”.

Keywords:

Filed Under:

Fast label recording in PlanningPME Web Access

by cdeschamps February 4, 2009
 
How to add tasks rapidly in PlanningPME Web Access?

  You would like to have a drop down list in PlanningPME Web Access while entering your tasks like in the picture below?

   instead of 

 Then, you need to create some groups and users in PlanningPME Web Access. To do so, first, go to the menu Parameters -> Groups. 
  
   

Then, create your group and do not select "Free Label Writing".

 

Create your users and assign them to this group.  When connecting to your session PlanningPME Web Access, you will have a drop down list for your tasks.
   
    

Import clients via VB scripts

by cdeschamps January 30, 2009

Do you want to import and update all your clients easily without having to enter all clients manually in PlanningPME?

This post is dedicated to our partners. In order to download the scripts, please contact your Target Skills contact to have the keys.

Save time imported all your clients data in PlanningPME clients card :

 

You can synchronise your clients from any clients database to PlanningPME via Visual Basic scripts.

Here is an example of cliets data you can import from a MS Access databse to PlanningPME:



It can also be an Excel file like this one below:

 

Interested in knowing more? Contact us and we will provide more information.

Keywords:

Filed Under: Integration | PlanningPME

Customized mission sheet to print a task

by cdeschamps January 28, 2009

Customized mission sheet to print a task

How to create a mission sheet?


1- Create the model of the mission sheet on a Word document.
We are going to use the following document : « Model mission sheet.doc"

2- From PlanningPME, go to the menu “Tools” -> “Options” -> « Advanced »
Select the model with the arrow:
 
3- Then, go back to the planning.
Select a task, right click on the mouse and select the mission sheet :
 
The following message appears : "Requested Object Not available"
  Press « OK ».

4- Set up of the merging
Open your Word model and go to the menu « Tools » -> « Mail Merge».

4.1 – Main document
Select « Form Letters ».

Select « Active Window »
Then, select your Word model.

4.2 – Data source
Select Open Data Source and  « Fiche.txt » in your  C: drive
Then, select « # » as a record delimiter.

5- Insert Merge Fields
You can now insert fields of PlanningPME in your document.


Select your fields in the list.
You now have created your mission sheet.

Example:
 
 


6- Create a mission sheet
Go back to the planning. Click right on a task and select the Word model.
Fields are synchronized from PlanningPME to your Word model.

Example :

 

You can save it or print it.

7- Print several mission sheets in a row
You can print a serie of mission sheets in a row. First, display the period of time you want to print (one day, one week…)
Put your mouse on one of the resource and right click. Select your model.


The mission sheets of the resource selected on the period displayed are printed directly.

8- Change the path of the txt file
If you have the message "Word could not open fiche.txt because it didn't contain a valid database", then, you need to change the Path of the text file fiche.txt. To do so, download this file and execute it. It will create
a string value Drive in the registry [HKEY_CURRENT_USER\Software\Target Skills\PlanningPME] . You can change the path specifying a letter.



9- Word 2003 and Word 2007

Word 2003 and Word 2007 have security levels that we must lower in order to export data from PlanningPME to Word.

Related post:  integration

Keywords: ,

Filed Under: Integration | PlanningPME

PlanningPME - Installation database Access

by cdeschamps January 27, 2009

PlanningPME - Installation database Access

1) Choose the server

- Create a PlanningPME folder on the server
- Share this folder in reading and writing
- Copy the file PlanningPME.pp on this folder

2) Installation of the software: 2 choices
1st choice: Install PlanningPME on the server and create a shortcut of the file PlanningPME.exe on each computer.
2nd choice: Install PlanningPME on each computer.
Installing PlanningPME according to the first choice, installing the future updates will be much easier.

3) Indicate the location of the database on each computer

Go to the menu File -> Location and precise the location of the database PlanningPME.pp

For reasons of performances, we advise you to map a network drive on the network path of the server and to precise this drive on the location of the database instead of the entire network path.
Example : the network path \\Server\PlanningPME is affected with letter P:

 

4) Validate the locks

Go to the directory "Tools" -> "Options" and select the tab "network".
Selecting the box "Network the program and control task modification by blocking simultaneous use", you can lock a task while using it in order no one to modify it.
 

Is your installation done?

Keywords: ,

Filed Under: Installation

Tip of the Week Excel Reports

by cdeschamps January 26, 2009
Do you want to make and update reports
to track the time of your employees easily?
 

A powerful feature of our planning software PlanningPME is the possibility to make reports via Excel Pivot Tables. 

Here is an example of reports:

All the data regarding resources, clients, projects, tasks, unavailabilities can be exported to Excel in order to have precise reports.

You can then have the number of days off for each employee, the time spent on each task, the number of days per client...

Do you know that you can save up to 10 templates in PlanningPME? Indeed, once your different templates created, you will just need to update them regularly selecting the dates in Pivot Table interface of PlanningPME.



 

Keywords: , ,

Filed Under: PlanningPME | Videos

Videos of our products

by cdeschamps January 23, 2009

Do you want to have a quick view of our different solutions?

Then, just relax and click on the different links below to have a clear understanding of our different planning solutions:


 

Video 1: scheduling software PlanningPME
   
 
 
 
Video 2: add on for visualization PlanningPMEHTML
 
 
 
Video 3: online planning solution PlanningPME Web Access

 

Multibase Installation PlanningPME

by cdeschamps January 22, 2009

  Multibase Installation PlanningPME

The installation of PlanningPME can be done on different databases such as MS Access, SQL Server, My-SQL, Oracle.
You can download the installation scripts from our website.

 

 


   
     
  Operating system : Microsoft® Windows® 98, Me, 2000, NT 4, XP, Vista
  Database : Access - SQL-Server - MySQL - Oracle
  Computer/Processor : Pentium 200 Mhz or superior version
  Memory : 32 Mo RAM
  Disk space : 10 Mo available for installation
  Installation : More information on planning installation

Keywords: ,

Filed Under: Installation

Add-On PlanningPMEHTML

by cdeschamps January 21, 2009

The planning needs to be visualized by all your team but you do not want to buy licences for each employee?

PlanningPMEHTML is a visualisation tool complementary to PlanningPME.

PlanningPMEHTML generates views of the planning for each department on your network.

The visualization is unlimited and you only need to purchase one licence PlanningPMEHTML for your entire office.

You will need to do the settings only once via this kind of panel:

   

Your different views of the schedule will be updated daily via a scheduled task in Windows.

Then, this is the kind of planning your employees can visualize:

 

To know more, we kindly invite you to read this page:

http://www.planningpme.com/visualisation-planning-tool.htm

 You will find in this page a video and some documentation.

Keywords:

Filed Under: PlanningPMEHTML

Unset Password in MS Access

by cdeschamps January 20, 2009

Unset Password in MS Access

I have the error message "Password Required" when I try to open PlanningPME with MS Access or the message "Invalid password" when opening PlanningPMEHTML or when I try to compact PlanningPME

    


On some versions of PlanningPME, a password protects the database PlanningPME.

 

Keywords:

Filed Under: PlanningPME | Videos

PlanningPME Web Access

by cdeschamps January 19, 2009

Looking for a web based application to manage the schedule of your employees?

With PlanningPME Web Access, you can have access to your schedule from anywhere at any time. No need to install anything on your workstation. 

 



Benefit from those features:

 

- Schedule appointments at a glance

- Have access to your planning with a login and a password

- Share the information with all your employees on the planning web

- Also find some PlanningPME WebAccess Tips

You can have a trial of our web application. Just contact us and your personal access will be activated shortly.

 

Scheduling software PlanningPME

by cdeschamps January 16, 2009

Target Skills Presents PlanningPME©,

A Fully Customizable and Easy-to-use Scheduling Management Tool

French software manufacturer Target Skills is attuned to the needs of small and large companies alike and is proud to present its software, PlanningPME©. This multilingual (French, German, English, Dutch, Italian, Spanish, Portuguese and Swedish) scheduling management tool is highly adaptable and, therefore, suitable for use by all types of companies. With PlanningPME©, your company can finally eliminate unnecessary paperwork and cumbersome scheduling boards. In addition, modifications will no longer result in endless cross-outs and corrections. 

The software enables companies to manage scheduling easily and provides an accurate global view of human and material resource use in real time in just one click. Target Skills has made a downloadable trial version of PlanningPME©available for free at www.planningpme.com. The website includes several pre-set schedules (by type or by sector) as well as a range of simple, detailed function cards.

 

The PlanningPME© tool is suitable for a variety of business situations due to the high level of adaptability that has been built in to the software. Work days and shifts may be personalized and additional fields may be added. It is also possible to import existing databases.

With its high performance levels and user-friendliness, PlanningPME© makes it possible for any company to organize and consult resources (employees, subcontractors, vehicles, machines, facilities, etc.) and business activities (tasks, appointments, customer projects, periods of unavailability) while eliminating the need to enter information more than once.

The tool offers a number of advantages, including a user-friendly graphical interface, a wide range of available functions such as searchable human and physical resource availability (tasks to complete, schedules, appointments, scheduled operations, calculation of hours worked, absences due to yearly vacation, etc.), and the use of filters, which enables you to display only the schedule of a particular customer or project. In addition, the dual schedule/agenda function makes it possible to manage long-term projects as well as one-off events.

The “synchronization” function may be used to generate an HTML version of a given schedule. Regardless of where they are located, employees and partners can consult and print schedules in real time. The constant updating of scheduling information and a unique “locking” feature that ensures a given user may not make changes to a task while another user is in the process of making changes eliminates double-bookings. 

PlanningPME runs in Access and offers compatibility with various Microsoft Windowsâ versions (Windows 95, 98, 98 SE, NT4, Millennium, 2000, XP). The software is also compatible with Oracle, MySQL, and SQL-Server. PlanningPME can also be used with the agenda feature in Outlook and with dynamic tables in Excel.

The software also offers local or remote network solutions subject to personalized feasibility studies by Target Skills.

Keywords: , ,

Filed Under: PlanningPME

Welcome to our new blog

by cdeschamps January 15, 2009

Target Skills is pleased to welcome you on its new blog.

In this blog you will find informations around our planning scheduling tools:

- Scheduling software PlanningPME

- Online web application PlanningPME Web Access

 

All your comments and suggestions are welcome.

Keywords:

Filed Under: