Importing One Column of Excel Job data as mtext contents

Civil 3D
1

So, as a newly joined member (and pure dynamo newb), I’m not allowed to upload attachments. So here goes anyways.

I’m trying to import an excel file containing one column (7items) of job related data. I have the items extracted to a list, how do I make an mtext item of those items in the list show in my dwg file.
I seem to have list.getitematindex working, from there it goes to list create (not sure if this is needed? ) and then to mtext.contents. That where the message: (portion extracted from the help file)

“This error message indicates that the node you are using is expecting a certain type of input(s) but has received a type of input it cannot use…”

My last node is mtext.create, which has all the requisite inputs seemingly satisfied, except for the text input (first input list item), because of the mtext.contents error.

My searching for mtext on this forum(s) gave me results which didn’t seem to answer my problem, some had python code blocks, which I’m not sure if I need or not.
I’m not using any additional packages in my graph.

I simply want to have one excel column of notes imported to my dwg using dynamo.

Thanks

2

Hi! welcome to the forum. The error message actually is givin g you a lot of information. It indicates that you are giving the node an input that is not of the type that you need to. For example, if you are sending your text to the layer 0, you need to make sure give 0 as a string and not as an integer. If you hover over a node input port, you will see the expected input type:

image
image436×571 25.3 KB
.

Without seeing your graph it is difficult to know what you have wrong. Anyway, I put up this small script as an example.

Script:

image
image1936×634 206 KB

Data:
image

Result:

image
image1841×945 75.2 KB

Attached script:
ForumMtextExample.dyn (40.5 KB)

3

Thanks David,
That worked for me. All my sample text was text strings, so changing the boolean to false made it work correctly. I had not used list flatten in my graph, so this helped me as well.
I’m sure I can get my formatting/text size figured out. This was just what I needed, Thanks again

rgrainer

4

Just manually bumped your “trust level” so you should be able to post attachments next time out; if not ping me and I’ll look into it again. :slight_smile:

5

Thank you for the bump. I’m sure I’ll be back.
rgrainer