Dealing with manufacture part numbers containing comma

[erik.buerV95QJ]

Hi again.

It seems Fusion has some different behavior for dealing with part numbers containing commas.

When we export a design from Fusion, we use the CSV BOM export in the CAM exporter.

I have a part, containing a comma in the part number.
When we export the BOM, the CSV is essentially broken, as there is an additional comma in the MPN, that offsets all fields afterward.

We tried a workaround by adding quotes around the MPN, but these somehow did not end up being included in the CSV either. For our MPN attribute.

See the MPN field in the example below:
,Qty,Value,Device,Package,Parts,Description,ASSEMBLY_NAME,BOARD_NUMBER,BOARD_VERSION,BREAKDOWN_VOLTAGE,CAPACITANCE,COLOR,DESCRIPTION,DIELECTRIC,DNM,FORWARD_VOLTAGE,HEIGHT,MANUFACTURER,MANUFACTURER_NAME,MOUSER_PART_NUMBER,MOUSER_PRICE-STOCK,MPN,NOBOM,NOPNP,PART_NUMBER,POWER_RATING,RATED_CURRENT,RATED_DRAIN_CURRENT,RATED_DRAIN_SOURCE_VOLTAGE,RATED_GATE_SOURCE_VOLTAGE,RATED_POWER,RATED_REVERSE_VOLTAGE,RATED_VOLTAGE,RATET_VOLTAGE,RESISTANCE,REVERSE_STAND_OFF_VOLTAGE,SPICEPREFIX,TOLERANCE,TYPE,VGS_TH,VOLTAGE_IN,VOLTAGE_OUT,VOLTAGE_RATING,WORKING_VOLTAGE

44,1,"PCA9685BS,118","PCA9685BS,118",QFN65P600X600X100-29N,U5,"PCA9685 - 16-channel, 12-bit PWM Fm+ I2C-bus LED controller",,,,,,,,,,,,,,,,PCA9685BS,,,,,,,,,,,,,,,,,,,,,,

When exporting the BOM from the schematic view, Output -> Bill of Materials, we get quotes around all fields, which is good. However, our MPN with commas, now has two sets of quotes in the CSV (the one we added, and the one added by the exporter).


This is a bit annoying and has led to us not procuring the correct components for manufacturing runs in the past, so a fix would be appreciated.

Thanks.
-Erik

[m.neujahr_at_moe]

Hellp @erik.buerV95QJ ,

perhabs this idea may help:

• The "bom.ulp" can be edited and the separator-char can be changed to be not a "comma"
  

You find the "bom.ulp" via "run" in command-line and open it with your preffered editor

[erik.buerV95QJ]

Thanks for the tip.

This is a decent workaround.
As we use Fusion at our company, it's a bit of a hassle to have everyone edit this ULP, or redistribute the ULP for exporting.

Perhaps we can run this script from our pcb export .scr script.

[jorge_garcia]

Hi @erik.buerV95QJ,

Make the change and then save the ULP to some other name, you can then share that to the rest of the company so they will all use the modified ULP.

Let me know if there's anything else I can do for you.

Best Regards,