question

Sakamoto Ko avatar image
0 Likes"
Sakamoto Ko asked Sakamoto Ko commented

Export of Excel file from the Visio file created by FlexSimTemplate.vst fails

Hi.


I am investigating Visio Importer.

However, it does not work with the following error message.

1702895860086.png

Could you please check if you can export the vsdx file I created to an excel file?FlexsimTemplate.zip

Maybe I should change the field settings in the database export wizard, but I didn't know which data type to change each field to.

1702895883490.png


Thanks in advance.

FlexSim 23.0.11
visio
1702895860086.png (50.0 KiB)
1702895883490.png (27.3 KiB)
flexsimtemplate.zip (28.8 KiB)
· 8
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.

Kavika F avatar image Kavika F ♦ commented ·
Hey @Sakamoto Ko, because of the error presented, have you tried the solution provided by Microsoft? They talk about how you may have too many internal fields defined and need to either compact the table or create a copy of it.
0 Likes 0 ·
Sakamoto Ko avatar image Sakamoto Ko Kavika F ♦ commented ·

@Kavika F

Thanks for your reply.


I had seen this article before but did not specifically try it because I thought it was a solution for Access.

I changed the export destination to a new Excel file because I didn't think Visio could do the operations described in this article.


Then the s1001 error did not occur, but the s1004 error did.


In fact, the first error I saw was s1004.

I then repeated the export with these fields in isolation to determine the cause of this error.

Perhaps this operation caused the number of internal columns to be larger than 255.


However, the cause of the s1004 error is not yet known.

I am using the contents of Visio Importer (flexsim.com) to perform the operation.

Is this error caused by the field type set in each field, since it mentions "invalid SQL data type" ?



0 Likes 0 ·
Kavika F avatar image Kavika F ♦ Sakamoto Ko commented ·

@Sakamoto Ko, what kind of data are you trying to write in your SQL query? That error, like you said, refers to an invalid SQL data type.

0 Likes 0 ·
Show more comments
Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Sakamoto Ko, was Phil BoBo's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 Likes 0 ·

1 Answer

Phil BoBo avatar image
0 Likes"
Phil BoBo answered Sakamoto Ko commented

The Visio Importer tutorial was written with a much older version of FlexSim (version 3, from 2005) and Visio (Office10, from 2001). It may not work exactly the same with a newer version of Visio. You may need to adjust certain steps if you run into errors trying to follow the documentation.

The errors you are getting are on the Visio side, not the FlexSim side. We don't have any more information about what changed in Visio than you do. If you want it to work, then you've got to figure out what to do to make it work. If you can't figure out how to make it work, then just don't use that feature; it isn't critical.

See also: VISIO IMPORTER share model please

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

Phil BoBo avatar image Phil BoBo ♦♦ commented ·

@Sakamoto Ko

Looking at your screenshots again, the error message is pretty clear: "Too many fields defined".

I'm not sure why you added a bunch of information about the field types. The error is clearly about the amount of fields.

In the tutorial, it says to just add all the fields, but maybe newer versions of Visio have more fields by default than the export can handle, so you should only export certain fields.

The following fields are the ones that are needed:

PinX, PinY, BeginX, EndX, ShapeText, ShapeKey, Angle, Width, Height, PropRow_1 (or Prop_Row_1)

0 Likes 0 ·
Sakamoto Ko avatar image Sakamoto Ko Phil BoBo ♦♦ commented ·

Hello @Phil BoBo.

I will try to see if I can export based on the field information you gave me.

Thank you very much for your valuable information.





0 Likes 0 ·