Pb Export Exel with SmartBom

Out of category
1

Hello
I just discovered (finally!) that SmartBom could save me a lot of time to make our bills of materials in excel.

Pb: when I generate the excel file I don't get anything...

As I'm testing, I have everything on my desktop (project, table template, excel template file)
I couldn't find an answer in the help or in the training.
I think I'm doing things the right way but I can't do it.
Do you have an idea or a solution?

Thanks in advance

2

With a few screenshots it would be easier to guide you.
2022 version of Smartbom, here are my export parameters for my nomenclature:

image
image1920×1080 174 KB

In 1 you choose your project (if several or if not new project)
In 2 Project management.
In 3 you choose the rules (for us no rules for me it slows down the export)
In 4 choices of project options
In 5 Checked General Options= Use the project rules then in Excel Export:
In 6 the choice of the folder where the Excel template file is located
In 7 The name of the Excel template file
In 8 the cell or start the export for us in B6 (because file with Macros for sorting FI and Fab...) for import into our in-house ERP.
Below 8 are the options related to your Excel export.

1 Like
3

Hello

I think your problem is related to this: Nothing happens when exporting from SmartBom

I'll let you do the manipulation and get back to me if the problem persists.

Kind regards

4

Thank you
I did as you did...

image
image1684×866 133 KB

5

And it works?

6

Hello

We did the manip but I still have the pb

7

No it doesn't work

8

Have you tried the @fmarchand manip?
In the general and project option options you have checked this:

image
image1920×1080 141 KB

In the BOM creation tab, have you put the prop columns to be retrieved?
Example:
image
image1450×235 15.4 KB

9

I tried the manipulation but without success
and yes:

image
image1014×211 27.1 KB

image
image749×109 8.64 KB

Maybe a pb of Excel version?
We are with MS Office Standard 2019

10

Hello

Are you on an Office x64bits?

Can you check if you have this registry key: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0

Kind regards

11

Hello

The key is there

image
image723×241 20.1 KB

12

Hello

Does it work if you do an excel export from SOLIDWORKS?

For example, a family of parts or "save as" on a bill of materials.

Kind regards

13

It works, yes.
The IT department just told me that I had an x32 on my workstation

14

so the problem probably comes from there

15

I confirm: it comes from there!
Office x64 installed and it works.

Thank you for your help.

2 Likes