question

Julian Sundermeier avatar image
0 Likes"
Julian Sundermeier asked Julian Sundermeier commented

Excel Import into arrival schedule

Hi everyone,

I get an error message when i import an arrival schedule from an excel sheet. The import-process itself works perfectly, cause i see the data from the excel sheet at the source properties (see picture below)

But when i'm going to run the model, this error occurs:

(time: 10.000000 exception: Exception Caught in Source::onTimerEvent(treenode involved, int code, char *strdata) object: /Source2

time: 10.000000 exception: Exception Caught in ObjectFunction235__project_library_FlexSimObject_behaviour_eventfunctions_OnTimerEvent object: /Source2 i: /Source2>variables/schedule/Arrival1 class: /Source2)

Can somebody help me? Is it necessary to do some more settings to the Source just import the Excel-sheet?

Choose One
excel importselected objectsarrival schedule
source-properties.jpg (246.8 KiB)
error-screen.jpg (322.5 KiB)
· 2
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.

Joshua S avatar image Joshua S commented ·

This is just something you might try, might not be the fix. Try selecting all the data you imported and change the data Type to "Assign Data Type".

0 Likes 0 ·
pic1.png (10.6 KiB)
Julian Sundermeier avatar image Julian Sundermeier Joshua S commented ·

Unfortunately, it doesn't fix anything and the error keeps popping up.

0 Likes 0 ·

1 Answer

Joshua S avatar image
2 Likes"
Joshua S answered Julian Sundermeier commented

So I got the same error when I imported a table and had numbers for the item names. when I gave each arrival item a string name in each cell of the "ItemName" column, the problem went away and the source created items as desired.

· 1
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.

Julian Sundermeier avatar image Julian Sundermeier commented ·

That's it! Not sure about the reason, but the problem is solved.

Thank you.

0 Likes 0 ·