Macro data recovery in a CSV file

Hi all.

With a macro launched from smart properties, I would like to search a CSV or Excel file for the value of a custom property. Then retrieve the values of the other two columns of my file to assign them to two other custom properties.

Thank you all

Hello
We will need more details.
You say:

But how is your binder filled? What is the source?

1 Like

In my file I have 3 columns:

  • a business number
  • A description
  • a name

As input to my macro I have my deal number and I want to retrieve a description property and a name.

My file is extracted automatically with more than 3000 lines

Do you want to do it with SmartProperties or by macro?

1 Like

Hello;

Wouldn't it be easier to go through the " integration " tool:

Otherwise it is probably possible to create a macro to run via Smartproperties but we need more information:

Retrieve which value(s), in which file, under what conditions, and enter them in which properties. (with or without Configurations?, what to do in case of errors...)

1 Like

By a macro launched in smart properties if possible

The file contains 3 columns:

- one with my project number
-one with my project designation

  • one with my customer name

I fill in a plain text property of my project number and I would like to automatically find and create the Designation property and the Customer Name property so that they can then be displayed on my drawings.

Thank you

… Tu n’est pas très coopératif, ce n’est pas les réponses que j’attendais …
Et je ne vais certainement pas te faire 100% du boulot à ta place…

Pour utiliser un document Excel depuis Solidworks la méthode et celle-ci, pour commencer: