vb example for micros ISL 1

[microsguru2]

Does anyone have any vb sample code that parses the data received from a micros ISL script? (txmsg)​

 

[Moregelen]

Although at this point, its definitely time to stop and ask: are you using 3700, 9700, Symphony 1, or Symphony 2?

 

[hosehead78]

Ha ha. Should have been our first question. :-D

 

[microsguru2]

Wow! Thank you! 9700 is the system

 

[Moregelen]

The code above should still work, but any sample SQL I post would be pretty useless because they are all meant for the Sybase running on 3700. But yeah, that DLL should be there and allows you to use it to connect to databases.

SUB OPENSQL
	IF SQL_H = 0
		RETURN
	ENDIF
	VAR CON_STATUS : N9
	DLLCALL_CDECL SQL_H, sqlIsConnectionOpen( REF CON_STATUS )
	IF CON_STATUS = 0
		DLLCALL_CDECL SQL_H, sqlInitConnection("micros", "ODBC;UID=custom;PWD=custom", "")
	ENDIF
ENDSUB

I'm honestly not sure if it supposes anything other than a defined ODBC connection, but you could modify that above to fit your needs assuming you could get one setup.

 

[microsguru2]

I will definately give it a try. Thank you again for everything! Very much appreciated.

 

[hosehead78]

I work on 9700, so the info I have will work out pretty good for you.

 

[Moregelen]

I honestly get a bit antsy playing around in the 9700/Simphony and Symphony 2 databases. It isn't nearly as straight forward as the 3700 database, and they're damned easy to get lost in. Reminds me of the time I went to force close a few checks and got, 13,321 rows affected. Oh shit oh shit! Reverse query! REVERSE!... 29,432 rows affects. *Logs off and walks away; I'm DONE*

Yeah... turns out forgetting a where clause can have nasty consequences lol.

 

[Moregelen]

https://www.dropbox.com/s/oo430qh4c6y19qu/9700_MAN_SIM.pdf?dl=0

What you're looking at if you go the txmsg route starts on page 41.

 

[Moregelen]

Dang. 9700 documentation is so much better than 3700. I just realized it actually has a working code example.

 

[hosehead78]

Ha ha. Nice. I love the 9700 system and mainly self taught. I have no issues messing around with it. I've made a lot of scripts and custom stuff with it. Thankfully our loyalty cards are setup on another db that is handled differently. I'll post info on monday.

I am trying to get into Symphony and 3700 as well. Currently having an issue with the Symphony install.

 

[hosehead78]

And yea it is, but good luck finding the info any where else and from micros. I have a lab environment that helps out.

 

[Moregelen]

I've actually done more Symphony than 9700, but most of what I've done has been 3700, including the integrations I've written. 3700 is a breeze to work with. Some of the stuff I've done with Symphony 2 can be nerve wracking given the sheer number of sites that could be affected if I write the wrong line of code.. but extensibility is baller.

 

[hosehead78]

I will have to hit you up for some info on a Symphony install I am trying. The install is simply for testing, as micros is getting to that point to push 9700 sites into simphony. They say "it's very similar to 9700", but I don't know about that.

 

[Moregelen]

Well, when you compare Symphony 1 and Symphony 2, Symphony 1 IS very similar to 9700. Symphony 2 is where it goes off the rails and becomes a truly unique product, despite the EMC looking similar.

 

[hosehead78]

Hm. Ok. Make sense then. Also, the install I am trying is simphony v2.

 

[hosehead78]

I'll post the info tomorrow, sorry, short day and really early day tomorrow.

 

[hosehead78]

@rjdpa2, Here you go. Let me know if you have questions. The files are basic information on how the system works. Micros is calling a "Gateway" that listens for the Micros connection, once it gets the info it parses though the information based on the Message Specs. Then returns the requested info. The interface in Micros is setup to point to the "Gateway", This is basically a Windows box (it can be a server, XP, Windows 7 and such) with the interface client on it that listens.