Initially populate Global List from database

Question

question

Xabier A asked Jul 09 2020 at 3:48 PM Xabier A commented Jul 10 2020 at 1:48 PM

Initially populate Global List from database

My concern is how to populate a Global List with labels from the information of a database.
I have been able to do with a global table and also in a Global List with an itemflow element, but no way to add rows/lines in a Global List without creating an item. The problem is that the items appear in the model
Is there another way to populate (add rows/lines) a Global List without creating an item?
(Ah! I am also going to repopulate the Global List during the simulation)
Any help will be appreciated.
GlobalList.fsm
Thanks in advance.

Software Version:

FlexSim 20.1.2

flexsim 20.1.2 global list

globallist.fsm (29.9 KiB)

· 9

tannerp commented · Jul 09 2020 at 4:13 PM

@Xabier A,

What kind of information are you storing in the list? I think lists are great for storing items, locations, etc., but in your case, you might be able to just store the information you need in a Global Table. Have you looked at that?

If you want to stick with the list, you could consider using the "Initial Content" to add things to the list at the beginning of the model. But again, these entries would generally be items or objects of sorts and not just information.

0 ·

initial-content-list.png (15.5 KiB)

tannerp commented · Jul 09 2020 at 4:15 PM

To answer your question about adding rows/lines without creating an item: you can use an On Reset trigger for the model. Just another idea.

0 ·

on-reset-model-trigger.png (45.4 KiB)

Xabier A commented · Jul 09 2020 at 5:01 PM

Thanks for the answer.

What I know to do in Flexsim is: create a source schedule with a table that I push to a list that is used by an operator to do the pickings from a rack (pull). The info is bay and level.

I know how to populate a global table with the info from a database.

My problem is, or I create a global list and populate it with the info of the database to use the rest of the code(my first question). Or another one that is how to do pickings with the info of a global table from a process flow.

Remember that I am going to repopulate the list during simulation.

Thanks in advance

0 ·

tannerp Xabier A commented · Jul 09 2020 at 5:35 PM

This idea of order picking is commonly modeled using Process Flow.

I created an example that populates a list using Process Flow tokens. You can make this as elaborate as you want, assigning bay, level, slots, types, etc. to the items. The key is that the items are pushed to a list.

Then, the operator pulls the items from a list (you can pull based on certain bays, slots, etc. using the list query feature) and unloads them at a queue or other destination.

This is a basic model, but is this what you're after?

globallist (1)_1.fsm

0 ·

globallist-1-1.fsm (54.2 KiB)

Xabier A commented · Jul 09 2020 at 9:29 PM

Thanks for the effort.

Sorry, this is the example I have already "coded" (something similar). I have already done this example, is what I have tried to explain previously.

What I need is the first step: how to populate the list (the one you use in your example) with the information from a database. For this issue, in the model I have provided, I have tried to create a row/line to insert into a global list using flexsim in several ways but no one works properly. The only one that works is the one that creates an itemFlow, inswrts it in the list but draws it in the model. My problem to solve is:

1.- How to insert a row/line into a global list with the information brought from a database using flexscript. (See the tries in the model). Remember that Iam going to populate it during simulation time.
2.- If the previous one doesn't work, I have successed populating a global table with the information of a database but I can't link it to a list (I have read that is not possible).

Thanks again.

0 ·

Joerg Vogel Xabier A commented · Jul 10 2020 at 6:43 AM

If your list value is an item, you need an item in your model. Then you must create one. If your database has got an ID for every product, then you can push this ID as a value onto a list. But then this is not automatically an item. It is still an ID. If you want to get an item, then you create one in your model by this ID.

0 ·

Xabier A Joerg Vogel commented · Jul 10 2020 at 6:50 AM

"you can push this ID as a value ", I think that this is what Iam asking for, try to push "something" to a List but Iam not able.

Sorry for my lack of knowledge.

0 ·

Show more comments

Joerg Vogel Xabier A commented · Jul 10 2020 at 11:06 AM

Another approach consists of pushing tokens onto the list. Later if you have items in your model you can push items. The label structure is the same.

0 ·

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2020-07-10T08:30:50Z

Joerg Vogel answered Jul 10 2020 at 8:30 AM Joerg Vogel commented Jul 10 2020 at 9:01 AM

If you want a total independent list similar to a table, you can do this with push arguments. The value can be anything. A number is just fine.

List(“myList”).push(1,0,“aText“,2.345)

1 = the value, as standard you find often here item, but it can be anything

0 = partition ID

“aText” = first push argument as string

2.345 = second push argument as floating number

You need to Add Fields in your list as Push Arguments

· 2

Xabier A commented · Jul 10 2020 at 8:40 AM

I appreciate a lot the efffort and the attention paying to this topic.

The added code I have also try but I do not "arrive" to the labels, thats my problem.

0 ·

1594370367068.png (22.6 KiB)

Joerg Vogel Xabier A commented · Jul 10 2020 at 9:01 AM

But there are different types of fields you can add:

But you won't be able to change the caracter of the list anymore - a push arguments stays a push argument and it won't be a label.

1 ·

push-arguments.png (25.8 KiB)

list-add-push-argument.png (9.3 KiB)

question