Excel-Analysis loses Excel-spreadsheets and create new one

[MA_9965308]

Dear Creo community,

i would like to control the lengths of my parts in an assembly with an excel spreadsheet.

That works with an excel analysis and relationships for a while.

But if I save and reopen the assembly and want to edit the Excel analysis, a new Excel spreadsheets is created with the existing lengths. The name is different.

Changes in the new Excel table have no effect on the model. Neither do changes in the linked Excel spreadsheets. Not even after editing the analysis and regenerating the assembly. if I want to edit the Excel again, a new Excel spreadsheets is created with the old lengths.

In the company we use Windchill. The Excel Excel spreadsheet is not saved in Windchill but on the desktop.

Do you have any idea how I can fix the link between Creo and Excel spreadsheets?

Do I need to save the Excel spreadsheet in Windchill? How would that work?

With best regards Morian

[tbraxton]

You can define a path using a config option and place your excel file in this location.

When you save an Excel analysis or create an Excel Analysis feature, the system saves the complete path to the .xls file. When you retrieve an Excel analysis or when an Excel Analysis feature is regenerated, the system searches for the .xls file in these locations in the following order:

• The original location of the file from which it was selected for the analysis

• The current working directory

• The directory specified by the configuration option excel_analysis_directory.

[MA_9965308]

Thanks @tbraxton for your answer. 

I found this logic in the manual. Can you tell me how to create this Config option?
What happend if it does not find any .xls file with this right name? 

Even if i save the File in my current work space (Creo_Work_dir)  it does not keep the link.  I got an Workspace in Windchill where i save my parts an Assemblys but i dont know how to upload an .xls file.
Does anybody know?

Greeting Morian

[tbraxton]

You can avoid the Windchill issues by launching a standalone Creo session (not linked to Windchill). 

The config option is defined in a config.pro file.

https://support.ptc.com/help/creo/creo_pma/usascii/index.html#page/fundamentals%2Ffundamentals%2Ffund_five_sub%2FAbout_config_pro_options.html%23wwconnect_header 

There are issues with Windchill and Excel analysis documented, refer to this document which may be relevant to your situation.

https://www.ptc.com/en/support/article/CS32944?&language=en&posno=1&q=cs32944&source=search 

[mbuonfiglioli]

The Excel Analysis (later called "excel.A") feature files are uploaded as Attachments, and you can find in Content tab;

But is there a problem, because, when you create the first time the excel.A creo will look every time the same file, and even if you solved the problem of setting the correct path in the option, when you will save as your Creo model containing the excel.A, the system as first behavior, when you will try to modify or edit the excel.A, it will search for the file (later called "base.F)" you stored I.e in the working directory, and if you do not remove form that folder, or rename, the excel.A will work good;

Now is arriving the very big problem, when you will try to upload the 3d Model the system will fail, saying (Correctly), that the base.F conflict with the one existing in Windchill.

Now I fonund a temporary solution to this:

Pointing that you solved before and put the base.F, in reachable folder (in may case working directory), excel.A will not fail:

1. and you will not need to reattach all the relation/parameters in new file, you set the creation of the called Datum file analysis result (later called "Datum.F)", in the excel.A, this will generate a new file excel in session.
2. Now you must do upload, this will upload the Datum.F, but not the base.F (This will fail).
3. After go in workspace edit attribute, make Windchill believe that you changed something and Upload from workspace.
4. Now go in 3D model and suppress excel.A, and check-in.

The result in Windchill should be the 3d Model, containing in the attachments the Datum.F that is the result of your updated analysis.

Remember that you must not rename or deleted the base.F from your set folder.

I call this a temporary solution because is not possible that another solution more linear exist.

[SP_10114936]

@MartinHanak can you provide solution to this?

Please explain this article.

https://www.ptc.com/en/support/article/CS32944?&language=en&posno=1&q=cs32944&source=search

[mbuonfiglioli]

The solution is the one explained above, in terms of practice, you need to have a first initiated local excel file in your preferred folder, and never rename it.

After you need to maintain suppressed the excel analysis, and you will need to resume only when you need and after suppress it again.

This to avoid to make system to automatically recreate a new file in the attachment of Windchill, because this will fail, because another file already exist with the same name.

The solution described by me have the scope to save the result of the analysis when the model / Analysis change, without the needs of overwriting the excel file.