BOM Header Modifications?

[oneilldm]

I'm exporting a BOM to a CSV file.

I need to tweak the header a little bit.

For example... I would like to change the "ITEM" column name to "FindNumber".

Also, I need to add a line of text before the column names.

Is there a way to do this?

Thanks

 

[mcgyvr]

Export Bom to excel, make modifications above, export to csv

 

[oneilldm]

Thanks but... we are already doing that.
I'd like to take that step out if I can.

 

[mcgyvr]

I'm sure that could be done with a macro also if you do that all the time.

What exactly are you trying to do with this csv file?

 

[oneilldm]

I'm sure we could do it with a macro... but I'm trying to eliminate a step.

The database we are importing to... is looking for a specific format.

We don't have any control over the database code so I was hoping to tweak the output directly from Inventor.

 

[mcgyvr]

"I'm sure we could do it with a macro... but I'm trying to eliminate a step."

???How would a macro add steps???
You can write a macro that makes the process simply pushing one single button in Inventor and it would prepare the csv file exactly how you wanted it.

 

[oneilldm]

oops... I was thinking macro in Excel. Sorry about that.

Yeah... we would use this quite often.