Apparition de certains problèmes avec HyperFile après avoir changé le mot de passe de l’administrateur local

Question:

HyperFile n’exécute plus de sauvegarde sur une autre machine depuis que j’ai changé le mot de passe de l’Administrateur local.

Réponse:

C’est dû au fait que lorsque vous installez un service Windows, il utilise le compte administrateur local (avec lequel vous êtes probablement connecté sur la machine) et stocke le mot de passe actuel. En raison de la nature des services Windows, ils sont capables de fonctionner même si personne n’a ouvert de session sur le serveur. C’est pourquoi ils ont besoin d’un compte système pour fonctionner en arrière plan et fournir les services qu’ils sont censés fournir. Ce compte/mot de passe est fourni au moment de l’installation du serveur HyperFile.

Donc si vous modifiez ultérieurement le compte administrateur local, les services qui ont été enregistrés comme PRIORITAIRES présenteront les anciens comptes/mot de passe en essayant de se connecter à une autre machine. Par conséquent, si vos tâches de sauvegardes automatisées qui ont été prévues dans le centre de contrôle HyperFile essayent d’écrire sur un autre serveur, même si vous avez changé le mot de passe du compte administrateur local, là aussi, les deux processus HyperFile ne réussiront pas à écrire à l’endroit indiqué, car ils essayent sur l’autre serveur avec l’ANCIEN mot de passe.

 

Solution:

Accédez à la console des services (Démarrer/Exécuter – services.msc).

Arrêtez les deux services suivants :

  • HyperFile Server
  • Manta Manager

Dans le deuxième onglet (Connexion), cochez « Utiliser ce compte » et précisez le compte de l’administrateur local (généralement « Administrateur ») avec le NOUVEAU mot de passe.

Redémarrez les services et vérifiez que les sauvegardes fonctionnent correctement (Centre de contrôle HyperFile / Serveur/ Tâches planifiées / Sélectionnez la tâche de sauvegarde / Cliquez sur  »Lancez » / Les resultats sont visibles dans l’onglet  »Sauvegardes »).

Comment exporter plus de 65536 lignes dans un fichier Excel ?

Très simple.

Excel était jusqu’à présent limité à 65536 lignes, jusqu’à Excel 2007.

Désormais avec les fichiers .xlsx, la limite est de 1 million de lignes.

Dans les produits NeoGroupe, si vous souhaitez exporter une table de plus de 65536 lignes, changez simplement l’extension du nom de fichier en XLSX.

Donc, si vous faites un clic droit sur une table, sélectionnez « Exporter vers Excel », puis ajouter .xlsx au nom du fichier « Export-20131212.xlsx » ce qui permettra d’exporter jusqu’à 1 million de lignes.

Alternativement, vous pouvez également exporter vers XML, qui lui ne connait pas de limitations autre la taille du fichier qui ne doit pas excéder 2 Go.

Comment combiner des filtres pour obtenir des résultats ?

Cette fonctionnalité est utile dans bien des cas et très simple à mettre en place.

Il suffit de faire un clic droit sur l’icône loupe située à droite du titre de chaque colonne et de sélectionner « Filtre » puis le type de filtre voulu; comme « est égal à », « contient » ou encore « ne commence pas par ».

Voici un exemple d\’utilisation:

Si vous voulez effectuer un filtre avec tous les noms commençant par « Rob » ET que ces personnes vivent à Paris, il vous suffit de faire un clic droit sur l’icône loupe de la colonne « nom » et de choisir « Commence par », de taper les 3 premières lettres « rob », puis de faire un clic droit sur l’icône loupe de la colonne « villes », de sélectionner « est égal à » et saisir « Paris ».

Ces fonctions de filtrage sont puissantes et flexibles , mais peuvent nécessiter un peu de temps si elles sont effectuées sur des bases de données de taille importante .

Mass changer functionality

We added a mass changer functionality to help manage more efficiently the different inventory items in a database.

WHEN ?

This is useful in case you need to :

  • Uniformize characteristics (for example Status, or Owner) after importing from various excel sources.
  • Change several items of owner, location, brand, status etc., all at once.
  • Move a list of items from one site to another.
  • And generally speaking whenever you need to apply the same changes to several item records at once, instead of modifying manually each and every record.

This is a great time saver and a significant improvement.

HOW ?

Go to the items inventory window and you will find a “LISTS” button that lets you manage lists OR go to the “LISTS” barcode from the main menu.

  • From the Inventory window, create a list (which just references existing items in your database) or select an existing list and you can then
    • Drag&drop items from the left list to the right list.
    • Select several items on the left and use the single left arrow button on the screen to add them to the right list.
    • Or use the double left arrow button to add all items on the left in the list on the right.
    • Then use the orange “mass changer” button, which will show you a yellow/orange screen in which you can select which field(s) to alter on all elements that are member of the current list.
    • Follow the screen instructions until completion.
  • From the main menu barcode, select / create the appropriate list of elements.
    • Add new items to the list by entering their barcode in the field at the bottom of the window
    • Or add new items to the list by simply scanning their barcode.
    • Then use the orange “mass changer” button, which will show you a yellow/orange screen in which you can select which field(s) to alter on all elements that are member of the current list.
    • Follow the screen instructions until completion.

USA Phone numbers handling

This is how NeoScreener handles phone numbers reformatting (all versions):

Here are the principles:

  • minimize user input so that they have only one rule to remember.
  • standardize numbers at maximum so that they are always stored in the DB in the same way (to allow recognition).
  • avoid to force the user to dial an outside line prefix.
  • take care of the old method of local/vs “long distance” in use in the USA.
  • dialing should be the same than when dialing from a cell phone (10 digits).

Hence we have the following rules:

  • a number is ALWAYS stored as a 10 digit number formatted as xxx-xxx-xxxx.
  • if a number starts with 011, then the formatting is REMOVED and you can input up to 18 digits. This is for international dialing.
  • if a number is within the same area code, there is one parameter that can be input in CTRL P to omit the dialing of the area code (though the number will still be stored in the DB WITH the area code).
  • if a 9 needs to be dialed out on lines to get an outside line, it can also be added as a parameter, line by line. This digit will be dialed by neoscreener ANY TIME that line is used (manual dial, callback from call card), but not shown anywhere on the screen. Remember all numbers are standardized as 10 digits.
  • on incoming calls, if callerid is provided with extra info (like a leading 1) you can have neoscreener suppress it automatically by using the “prefix to add or remove from callerid” and put in “-1” (without quotes) there.

So if “9” “917 673 89xx” works on the Vset, and just “917 673 89xx” works on NeoScreener (neoscreener adds the 9 without telling you), it means you never have to dial a leading “1” any more on your telco side.

Too many calls, too often…

If your station has an increasing success, you may find yourself confronted with a rapidly rising volume of incoming phone calls which will require some attention.

From our experience, a 12 lines system both merging incoming and outgoing calls reaches its limit when there are really a great number of concurrent calls on an almost constant basis, as with any system. If your telephony systems has constantly 12 lines active, then please read what follows:

Two limits are reached:

  • a single call screener operator does reach its own human limit and necessarily increases the level of operator errors, because he handles numerous cases (dial out, dial in, storing topics etc.)
  • it puts a high load on the system that becomes a single point of failure, as every call is tied to the unit.

Comments & considerations:

  • The operator does not really need to “see” 10 lines ringing while he has 2 lines already screened and probably on air, because he would likely not do anything else than pick the lines which are not in red (suspicious numbers).
  • Compared to a setup where he is presented with the next ringing-in call on a single-line telephone set, the only advantage of seeing the 12 lines altogether is limited to showing who is recognized and who is not in parallel, instead of in series.
  • Also a normal, trained call screener can handle about 50 calls per hour. So if your shows generate a higher level of calls than that, you may want to consider increasing the number of call screeners to process this flow of incoming inputs.
  • A call screener’s job is to prepare and select callers and topics that are appropriate for the current show, in order to present a “finished product” to the Talents, while the show is running. It is not only a matter of dialing numbers and answering lines.
  • Topic is also to be limited to a few words so that it is concise for the Talents who are in the middle of a show “storm”, and cannot spend time to read 256 characters of text while they are talking to another caller, and watching news, etc.

One solution:

SEPARATE SYSTEMS FOR INCOMING AND OUTGOING CALLS, using the NeoScreener database in between.

NeoScreener has been designed in 2007 to also talk to TAPI (Windows Telephony API) and we currently have installs that do talk to standard PABX/IPBX such as Avaya or Matra/Lucent Technologies.

So for example at France Inter (Ch#1 in France), we have a call screeners room fitted with 4 positions, each tied to a single-line telephone set from their business-grade PABX, each member of a group that answers the queue behind the on air general number of the station. Each position has a NeoScreener that talks to its telephone set and this room is used EXCLUSIVELY to RECEIVE phone calls, identify callers and create call cards within the NeoScreener database.

Hence those units do not talk to the Telos device and the only link with the studio is made by the database.

Callers are systematically called back from the studio installations which are the standard Producer/Talent setup of NeoScreener. The producer browses the list of calls, and dials them back in a single touch, and another touch to show that to the Talents. Studio is ONLY FOR CALLBACK.

Hence the load on the 12 lines system is reduced, as it handles only dialed out, ready-to-be-used, or on air calls.

Call screening is done elsewhere, on a separate telephony system that can be scaled up or down (sometimes only 1 position is used in call screening, sometimes 4 positions join the group that is answering the incoming queue). We mean from the incoming queue, 1 to 4 positions can be set concurrently to answer the next incoming call on the station’s number. NeoScreener talks to the PABX via TAPI.

This whole setup is meant to be when you start receiving a lot of calls on a regular basis and you do not want to discard / unprocess the calls that are past the processing ability of a single call screener. Indeed if you are handling talk shows and generate a lot of input, your on air team will want to select calls from a larger base of processed incoming calls than just 50 per hour.

Conclusion:

More calls = More call screeners needed = Off-load of the hybrids system needed.

Skype™ calls into NeoScreener

To allow Skype™ calls to reach your Telos or AEQ SIP/VOIP device, you only need to configure the Skype gateway, so that it converts your Skype™ traffic into SIP.

Method used:

  1. Subscribe to Skype Connect™.
  2. Create 1 or x skype accounts.
  3. Go to Skype Manager (//manager.skype.com).
  4. Make them Skype managers (admins).
  5. Create a SIP profile.
  6. Add channels (about $6 per month per channel to receive calls).
  7. Eventually add credit if you wish to dial OUT from that SIP Skype extension.
  8. Make the skype accounts users of the sip profile.
  9. Login as them to manager.
  10. Allow them to redirect their calls to the extension.
  11. This gives you a SIP extension user name and password, on sip.skype.com.
  12. Add this into the SIP params of the VX/Systel.
  13. Add one of those extensions to one Show.
  14. Load the show into one Room/Studio
  15. It works !
  16. Call from another skype account to one of the skype accounts that you created and the line will ring on the Systel or VX, and can be manipulated as usual by NeoScreener.
  17. Even the skype ID will be presented.
  18. Calls are in G711 for now.

NeoScreener headsets

NeoScreeener can be used as a softphone, replacing the Vsets with the following Telos models:

  • VX
  • IQ6
  • HX6

So the user can use the audio of the PC to actually screen calls replacing the handset by the audio device.

There are advantages to this: price, user comfort (they get to like the headsets use instead of handset quite quickly) and the ability to have personal headsets in case an installation is shared across several phone screeners, by means of a USB connectivity of the headsets.

You should pay attention to the quality of the headsets that you purchase for screening calls. We have seen some entry-level headsets exhibiting issues with the mike quality and also not having feedback reduction built in, so that the mike would take back what came through the earpieces, feeding the caller back with his own voice after 1.5 seconds, the sound travelling throug the structure of the headset/mike device. Also the audio driver / manufacturer application of the PC might provide feedback / noise reduction.

Recommended / tested headsets/mike are:

Brand  Model 
Plantronics Blackwire 500 series

NeoScreener directories (Client / Server)

This describes the NeoScreener file structure, in HyperFile client/server mode:

Exe’s are read from a central directory, then run locally from the HDD of each machine and data is served by a HyperFile server.

On the machine that acts as the server there are:

c:\NeoScreener (shared) : contains the application files & dlls – only on server machine

c:\NeoScreenerCache : contains the local copy of exe & dlls read from the central NeoScreener directory – on all machines

c:\HFServer : contains the HyperFile server and data files – only on server machine

c:\NeoScreener\Data : contains current data files if you used the neoscreener backup functionality in Utilities. Those files were extracted from the HF Server.

c:\NeoScreener\Backup : contains backups sets in zip files. Those were zipped from the \Data directory after extraction from the HF Server.

c:\NeoScreener\Configurations : contains a directory per machine name accessing NeoScreener. Each time NeoScreener is started, the machine copies its ini files and shortcuts named neo* in the desktop of All Users to that directory. This is for rebuilding a machine in minutes without having to look for configuration files.

c:\NeoScreener\Images : contains an images set for being used with Hotkeys.

c:\NeoScreener\Tmp : contains usually installation packages. Not mandatory on all installs.

C:\HFServer\BDD : contains the Databases managed by the Hyper File Server. those files cannot be copied, as they are locked by the server service (process).

There are ways in the HF Control Center to automate backups to another directory, but that is not necessary if you perform regularly backups from within NeoScreener.

NeoScreeer does not dial out on analog lines

NeoScreener does not dial out on analog lines. However, dialing from the Desktop Director works on the same lines.

Solution

You need to upgrade the Telos firmware of the Desktop Director.

It must be v2.01, and you probably have a v2.0 version or less.

In order to do this, you need to get an Eeprom from your Telos reseller, with the proper firmware.

Additionnally, you need to have the following minimum firmwares installed on the Telos 2×12 / Nx12 / Nx6 units:

Telos 2×12: v3.34

Telos Nx6, Nx12: v1.6.0r

Please refer to the Telos documentation to perform the firmware changes.