question

michael.smith avatar image
0 Likes"
michael.smith asked Matthew Gillespie commented

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?

FlexSim HC 5.0.12
flexsim hcappointmentstable commands
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Matthew Gillespie avatar image
0 Likes"
Matthew Gillespie answered Matthew Gillespie commented

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
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

michael.smith avatar image michael.smith commented ·

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

0 Likes 0 ·
michael.smith avatar image michael.smith commented ·

@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 Likes 0 ·
Matthew Gillespie avatar image Matthew Gillespie ♦♦ michael.smith commented ·

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

0 Likes 0 ·