Skandinavian characters are not supported ;o(

Sep 29, 2009 at 8:28 AM

Hi James,

Nice tool you have created, I have some comments after testing it.

The command line example in your instruction file needs to be altered.

If I use this command
deleteprojects -url https://server/pwa/ -file c:\\temp\\oldprojects.txt -deletewsssites

It returns this error
'deleteprojects' is not recognized as an internal or external command, operable program or batch file.

To get it to work, I changed the command line to this
Bulkprojectdelete -url https://server/PWA/ -inputfile c:\temp\oldprojects.txt -verify

After running the verification another issue occured with projects containing Danish characters Æ, Ø and Å.
In the log file below, the Danish characters in project names are replaced with an '?'

Connecting to Project Server to retrieve project list...
Reading input file...
Found: MSP-superbrugere_Udgivet
Found: H119-06 Bregningevej, Bjergsted Byvej_Udgivet
Found: 004-1-TEST02-Projektlederskabelon_Udgivet
Found: Thisted omfartsvej - shunt_Udgivet
FAILED to find: VVM-unders?gelser - projektering_Udgivet
FAILED to find: Forunders?gelser - Projektledelse_Udgivet
FAILED to find: VVM-unders?gelser - Areal_Udgivet
FAILED to find: Forunders?gelser - Projektering_Udgivet
FAILED to find: VVM-unders?gelser - Trafik_Udgivet
FAILED to find: VVM-unders?gelser - milj?_Udgivet
FAILED to find: Anl?g - broer og tunneler_Udgivet
Found: Projekt til besigtigelse - Ekspropriation_Udgivet
FAILED to find: 003-5-UDSTYR-projekt til anl?g - Ekspropriation_Udgivet
FAILED to find: 006-1-TEST02-Anl?g - St?jsk?rme_Udgivet
FAILED to find: Anl?g - Ledningsarbejder_Udgivet
FAILED to find: Anl?g - Jord og afvanding_Udgivet
FAILED to find: 006-1-TEST02-Anl?g - N?dtelefoner_Udgivet
FAILED to find: Projekt til anl?g - Ark?ologi_Udgivet
FAILED to find: 003-5-UDSTYR-Anl?g - broer og tunneler_Udgivet
FAILED to find: 06812-F-GROV-Anl?g - Jord og afvanding_Udgivet
FAILED to find: projekt til anl?g - Ekspropriation_Udgivet
FAILED to find: Projekt til besigtigelse - Grovplanl?gning_Udgivet
FAILED to find: Anl?g - Bel?gning_Udgivet
FAILED to find: Projekt til besigtigelse - Ark?ologi_Udgivet
FAILED to find: Projekt til anl?g - Projektstyring_Udgivet
FAILED to find: Anl?g - Entreprisestyring_Udgivet
FAILED to find: Anl?g - Trafikledelse_Udgivet
Found: Projektledelse - projektledelse_Udgivet
Found: 6630fg_Udgivet
FAILED to find: Anl?g - Belysning_Udgivet
23 projects listed in the input file were not found.
7 projects will be deleted from draft and published dbs
   (out of 361 projects on the server.)
!!! No deletions performed! Verifying only.
Execution Complete.

If it is possible to support Æ, Ø and Å then this tool is of great value to us.

Kind regards
Mads Nielsen

Coordinator
Sep 29, 2009 at 2:08 PM
mads_nielsen wrote:
...The command line example in your instruction file needs to be altered.

...To get it to work, I changed the command line to this
Bulkprojectdelete -url https://server/PWA/ -inputfile c:\temp\oldprojects.txt -verify

After running the verification another issue occured with projects containing Danish characters Æ, Ø and Å.

 

 

Mads,

Thanks for the feedback. I'll look into supporting a wider character set. I don't think this will be too difficult. If that won't take long I will create a new release with that support and the updated document. The Home page for this project should have the correct syntax right now, though.

 

James Fraser

Coordinator
Sep 29, 2009 at 7:27 PM

It was, in fact, a simple single-line change. The only place that wasn't set to handle extended characters was a call opening the text file. I'll have an updated version uploaded in the next few hours.

The problem only shows up when using an ASCII file (called ANSI in Notepad). If you save the file as Unicode or UTF-8, everything works. But I've fixed the ANSI case and will update the code on this site soon.

 

Hope this helps...

James Fraser

 

Coordinator
Sep 30, 2009 at 12:12 AM

 

Both issues mentioned were resolved in the 1.0.1 Release package. I just deleted 150 projects with this version on a test server, but I'm leaving it marked as Beta until I can test it on a couple more servers.

 

James Fraser