About Xavier

7 years+ .net consulting

Free MSI Wrapper for SSCM, …

Description

This simple tool allows you to wrap a folder and build an MSI package from it.
You can also create a desktop shortcut to the selected exe or other file in this folder.
You can also run an exe after msi installation and install per user or per machine (all users).

you can change :
– product version (defaut 1.0.0.0)
– “upgrade code” which is the application identifier
– although its name could confuse, “product code” is different for any version so is more like a version identifier
– desktop shortcut icon (drag and drop icon image on the icon picture box)

Misc.:

This Winform software is coded with C# dotnet 4.5  and uses WixSharp and wix toolset binaries Nuget packages

How to use : 

Click on browse  to pick up the folder  to turn into msi (or drag and drop it !), then choose your desired options and click on “Build msi” to save the new created msi package. all simple !

Download :

Binaries  (msi Installer package) : Link

proxy socks via tunnel SSH avec Synology, Putty et C# .NET

Suite à l’excellent tuto (qui date un peu mais excellent quand même ! ) : http://www.geeknewz.fr/tuto-proxy-socks-via-ssh-sur-synology-15567

Voici la même chose, mais automatisée en C#: n’oubliez pas de remplacer YOUR_SYNOLOGY_DNS_OR_IP_HERE  par l’adresse ou le dns name de votre synology

et aussi le mot de passe admin de votre syno à la place de YOUR_SYNOLOGY_PASSWORD_HERE

on peut légèrement modifier le code pour ne pas mettre en dur le mot de passe et l’entrer à chaque nouvelle connexion (Console.ReadLine()… et supprimer:

Sony NWZ-E430, NWZ-E350, NWZ-E460 Service Menu

If anything goes wrong during the process, press the reset button on the back of the device in order to reset it.  Unfortunately there is no guarantee that the reset will work.  So please use this at your own discretion. 

NWZ-E460
1. Make sure you are on the main menu.
2. Put the player on Hold
3. Press the following keys in order:

E460sm

4. If done right the machine will turn off and back on and load a colour bar, press any button to get off the colour bar and into the service menu.

NWZ-E350
1. Go to the main menu of the player
2. turn Hold ON
3. now press these keys in order

E350SM

The player should restart and go into the service menu, turn Hold OFF and then find the Audio settings menu.

To exit the Test mode, go the main selection screen then press
up –> down and select EXITTEST then press right and select SURE, finally press the play/pause button, turn the power off and release the test mode

I am not responsible if your player stops working or if you encounter any errors.

NWZ-E430

E430sm

SummerTime Cover (Ella Fitzgerald)

(Isabelle singing, xav à la gratte)

upgrading the synology DS 107 firmware to 4.2 or more

synology DS107 latest official firmware is (and should officially remain) 3.1 ( DSM_DS107_1613.pat )

But..
you can upgrade it to 4.2 firmware!

how to ?
1) connect to your diskstation web interface: (typically : http://diskstation:5000/webman/index.cgi)

2) activate TELNET/SSH in Control Panel/Network Services/Terminal

3) if you don’t have Putty (free Telnet Client), download it to access diskstation with telnet : http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

4) run putty.exe , and for host, write : diskstation, select telnet and click “Open”

puttytelnetsyno

then a console window should open:

type ‘root’ and then your diskstation usual password (the same as to connect on the web interface) then press ‘enter’ key

puttyconsole

note: the password will not show when you type

5) type

cd ..
cd etc.defaults

(press ‘enter’ key at the end of each line)

6)Edit the file synoinfo.conf. This can be done using the built in editor vi. Simply type:
vi synoinfo.conf

to start the editor.
Now… vi is not exactly the most typical editor so you might end up with some troubles here. A quick guide is:

  • The vi editor has a command mode, and and input mode.
  • You switch to input mode by pressing the i key.
  • When you are in input mode everything you type is inserted as normal into the document.
  • You go back into the command mode by pressing escape.
  • The cursor keys navigate the document.
  • The x key will delete characters under the cursor when you are in command mode.

You need to change the first line from:

into

Now, to save the file, make sure you are in command mode (Press escape if in doubt.) and type:

:wq

This tells vi to write and quit. If you messed something up just type:

:q!
and the editor will quit without saving. Then start over by typing vi synoinfo.conf again. (Usually you can just press the cursor up key, and then enter, to reissue the command.)If you need more help with vi it might be helpful to read the Mastering the vi editor guide.

7) Now you can exit the telnet session again if you want. Just type exit and the connection will close.

8) DON’T REBOOT YOUR SYNOLOGY NOW! (or you will have to reinstall the old DS-107 firmware with this assistant)
Now your Synology device will think its a DS109J model. This enables you to download the firmware for the DS-109j and apply it using the web interface just as usual. The firmware can be downloaded from Synology download site

update DSM 4.2 : install directly DSM 4.2 from synology web interface ; Download link :
http://global.download.synology.com/download/DiskStation/DSM4.2/3211/DSM_DS109j_3211.pat

You will first have to install firwmare 3.2 ; the updgrade file is called DSM_DS109j_1955.pat (link : http://ukdl.synology.com/download/DiskStation/DSM3.2/1955/DSM_DS109j_1955.pat)
then you will have to install firmware 4.0 ; the updgrade file is called DSM_DS109j_2228.pat (link : http://ukdl.synology.com/download/DiskStation/DSM4.0/2228/DSM_DS109j_2228.pat)
then you can install 4.2 : link : http://ukdl.synology.com/download/DiskStation/DSM4.2/3211/DSM_DS109j_3211.pat

To install these firmwares, don’t use synology assistant, but use synology web interface (in Control Panel /DSM update) with Manual update

If you install latest DSM version (4.2 beta) : don’t forget to update audio,download station, itunes server and other packages packages in web interface (beta channel update) after installation:

synoupdatepkg

———— DONE 🙂
synoupgrade
note : you synology is now like a DS109j

this trick may work with few modification on other x-07 – and maybe other – synology diskstation but you’ll have to check which processor you have inside your syno:
http://forum.synology.com/wiki/index.php/What_kind_of_CPU_does_my_NAS_have
or
http://xpenology.com/forum/viewtopic.php?f=2&t=538

other useful links:

http://www.timo.dk/wp/2011/08/07/upgrading-the-synology-106e-firmware-to-to-3-1/

http://www.robvanhamersveld.nl/2013/01/21/install-and-test-synology-dsm-in-a-virtual-machine/

umbrella (mandy moore cover)

Master Data Services Excel Add-in Query updater

Hi

This small tool allows you to Load, Edit, and save MDS queries with operators that are not available in current mds add-in
232951
you can download the source code (.Net C# 4.0 Client Profile, VS2010) of my tool here (FREE) HERE
OR

https://github.com/xavave/MDS2012ExcelQueryTool

OR

binary only: HERE

very easy to use:

Load your already generated query

then choose a new Operator and edit the criteria

and then save the updated query

you can use all these operators:
[Description(“”)] NotSpecified,
[Description(“=”)] IsEqual,
[Description(“<>”)] IsNotEqual,
[Description(“LIKE”)] Like,
[Description(“NOT LIKE”)] NotLike,
[Description(“>”)] GreaterThan,
[Description(“< “)] LessThan, [Description(“>=”)] GreaterThanOrEqual,
[Description(“< =”)] LessThanOrEqual,
[Description(“MATCH”)] Matches,
[Description(“NOT MATCH”)] NotMatches,
[Description(“REGEX”)] ContainsPattern,
[Description(“NOT REGEX”)] NotContainsPattern,
[Description(“IS NULL”)] IsNull,
[Description(“IS NOT NULL”)] IsNotNull,
[Description(“IN”)] In,
[Description(“NOT IN”)] NotIn,
[Description(“DIRECT DECENDANTS”)] DirectDecendants,
[Description(“ALL DECENDANTS”)] AllDecendants,

More info on sql mds 2012 MSDN blog