Micros 3700 v4.9 - Change Revenue Centre Feature Advice Needed Please 7

[JonnyB82]

Hi,

I haven't had the need to use the Change Revenue Centre Feature within Micros 3700 until now.

Just wondering if there are any Micros Sys Admins out there that use this feature that I could pose a couple of questions to?

Many Thanks
Jon

 

[pmegan]

You have to set it up as a SIM interface in the configurator, Devices | Interfaces. Most of the options aren't used for a simple SIM, but there are some 3rd party interfaces that will fail if any of the interfaces are missing entries, so I usually fill them in just to avoid problems down the road.
[ul]
[li]Name: Change RVC or something similar[/li]
[li]Outgoing name: RVC (doesn't matter, this isn't used but should be filled in)[/li]
[li]Network Node: select your Micros server[/li]
[li]SIM Interface: Checked[/li]
[li]Log Transaction: Unchecked[/li]
[/ul]

Save the text from Moregelen to the \micros\res\pos\etc folder as Pms#.isl (replace # with the interface number from the configurator)
Copy the file to these folders (you may not have some, it depends on your 3700 version)
[ul]
[li]\MICROS\Res\CAL\Win32\Files\Micros\Res\Pos\Etc[/li]
[li]\MICROS\Res\CAL\WS4\Files\CF\Micros\ETC[/li]
[li]\MICROS\Res\CAL\WS4LX\Files\CF\Micros\ETC[/li]
[li]\MICROS\Res\CAL\WS5\Files\CF\Micros\ETC[/li]
[li]\MICROS\Res\CAL\WS5A\Files\CF\Micros\ETC[/li]
[/ul]

Create a key on one of your touchscreens.
[ul]
[li]Category: SIM/PMS Inquire[/li]
[li]Interface: the one you just created[/li]
[li]Inquire number: 1[/li]
[li]Legend: Change RVC[/li]
[/ul]

That should do it. Wait a few minutes for the SIM to copy down to the workstations and you should be able to try it out.

 

[JonnyB82]

Thanks very much pmegan

I will give that a go tomorrow when I get in to the office.

Is there anything I need to be aware of if applying to our live system?

Thanks
Jon

 

[Moregelen]

I would hide the key somewhere only your super users can get to while testing it. Unless you add in the line pmegan provided, it doesn't bother to check if the user has permission to change revenue centers; it will just happily change it.

 

[pmegan]

It doesn't seem like there's anything to be worried about. It looks like a whole lot going on, but there's nothing that can do much damage. Definitely test it out before opening though.

The only thing that might give you a problem is this part:

if con_status = 0
	DLLCALL_CDECL sql_h, sqlInitConnection("micros", "ODBC;UID=custom;PWD=custom", "")
endif

Some dealerships have moved away from the old standard custom/custom access. If your's is one of them you'll get a logon error. That's just a matter of contacting your dealership and getting the correct credentials.

 

[JonnyB82]

Thanks,

I have just tried login on to the DB via dbisql from our server, the credintials above seemed to connect fine.

 

[pmegan]

Gave Moregelen a well deserved star for the SIM he whipped up here.

 

[Moregelen]

Ah - thanks ;P

Its actually becoming a bit of an issue though... Customer wants X to do Y? SIM!!!!

Coworker: You know you could just make a macro?

Me: Yes, but... SIM....

Coworker: You know you're the only one who can support the SIM if you go the SIM route, right...

Me: But.. but...

Plus, I found myself writing a C# program the other day while in a SIM writing mind set. Ugh. I totally forgot the whole principle of objects. Was smacking myself...

 

[wewantphil]

I starred this too.
I do not need this particular function but the solution provided is an excellent example of advanced SIM authoring .... using native SIM functions, calling out to DLLs, calling SQL statements directly against the DB (plus PMegans security check, so also Security Authorization), checking environment variables, using global and local vars, and best of all: comments documenting the logic. TekTips is a rare forum for this kind of information sharing, especially for such a specialized scripting language such as Micros SIM.
Major KUDOS (whatever those are) to Moregelen and Pmegan

Question: Do you guys know if you can call Managed C# .Net code DLLs this same way you called the MDSSysUtilsProxy.dll? AFAICT that DLL is unmanaged C++ ?

 

[Moregelen]

The Micros system uses stdcall, so you're going to have to use a C++ DLL.

I looked into doing it with C#.. at least it has pushed me to sharpen my C++ skills...

 

[wewantphil]

a shame, considering that Micros has been refactored to .Net as of the 3700 system (we used to have as 2700, so have been with them all along, since the MS DOS days)... I know they have an extensive API you can call from the out side in, too bad you cannot do the same thing from the inside out...

 

[Moregelen]

Well, you can always write it to use sim messaging. It does mean having to create a service to sit there and listen for TCP messages and respond to them, but it can sort of do what you want. It is considerably more limited, while also providing considerably more capabilities... a weird statement but... on the one hand I can make it interface with basically nearly any interface. On the other hand, I can't even open a COM port and print a QR code without writing a native assembly to do it. Fun times!