Appointments Table

Question

question

michael.smith asked Jul 13, '16 Matthew Gillespie commented Jul 14, '16

Appointments Table

I'm updating a model via SQL import, at present the data is being read in and placed in the correct Global Table, I have some pre sorting to get the right appointment data in and as a short term measure it is being held in number of global tables. I'm trying to access the appointment data to copy that information across however the structure although it allows viewing as a table will not let me write the data to it using table commands. Before I write a script to write to the nodes directly is there a better way?

Software Version:

FlexSim HC 5.0.12

flexsim hc appointments table commands

Answer 1 · 2016-07-13T15:37:39Z

Matthew Gillespie answered Jul 13, '16 Matthew Gillespie commented Jul 14, '16

Using the table commands is working fine for me:

appointments.fsm

The tricky thing about the Appointments table though is that there's a subnode of each Appointment Time node where the time string is converted into minutes and stored. You'll also have to update that subnode since the code uses the number and not the string when making patients. Or you can just open the Appointments Table window and click OK and it will update all the subnodes.

appointments.fsm (47.4 KiB)

· 3

michael.smith commented · Jul 14, 2016 at 12:54 AM

Thanks, I'll recheck what was going on. From that I will write everything in and then write the subnode.

0 ·

michael.smith commented · Jul 14, 2016 at 02:33 AM

@Matthew Gillespie I've got this working now but is the PCI a Num or String field? It appears to be a String can you confirm?

0 ·

Matthew Gillespie ♦♦ michael.smith commented · Jul 14, 2016 at 03:52 PM

Yes, it's a string field so you can use expressions.

0 ·

question