Hi everyone,
Does anyone know if there are any (preferably 'out-of-the-box') mechanisms in TNEW that record Attributes to constituent records? All the custom form options seem to point towards creating CSIs, but I'd be interested to know if there are any other data capture routes available.
We're still a relatively new adopter of TNEW, so any help or advice would be gratefully received!
Many thanks in advance and very best wishes,
Martin
Following. I would love to learn more about how to create a procedure. I take registrations for our dance academy on TNEW, and it would be nice to have the attributes for 300 kids go directly into their account versus me manually entering all of them from a CSI.
I don't have TNEW where I am now but I have a bunch of simple and more complex stored procedures that use the TNEW parameters that I'd be happy to walk you through. depending on the complexity we could throw one together for a test.
Actually the more complex ones that I have were made for dance registrations. They are pre professional and can write War and Peace on what their experience is to date.
That would be amazing, although I'm a complete newcomer when it comes to procedures - I don't know the first thing about them.
I would also be happy to provide some assistance if you and Heath Wilder cannot find a time that works or you want an additional take on that. Also, hi again!
John A. Moskal II
I wonder if we could have a meeting in the Database Administrators group with a stored procedures tutorial?
that is a most excellent idea! I will work with the other DB co-chairs to make something happen!
I like it.
Considering my work is a complete theft* of JAM2.0's work ... I concur
There are sections to the SProcs for incoming TNEW data that are pretty uniform. Easy to Colour code in a copy-pasta style guide.
There are also advanced oddities like what if the cheeky monkeys in Edumacation want 42 fields (and some on them are varchar(8001))insiders tip you can chain sprocs one after another to capture all those Pokemon Parameters.
Protips like:
* by theft: I asked on slack and he took pity on me a gave me code