Macro Alias Manager

This macro helps managing aliases inside FreeCAD Spreadsheet workbench. It is able to:
 * create aliases based on first column (A column)
 * delete aliases placed on a column
 * move aliases from one column to another one
 * create a "part family", that's it, create different files for each column in a range. It will add to the original name a suffix based on first row (1)

More information might be found on FreeCAD forums: Macro for Spreadsheet Alias setup and Part Family Generation

And most updated versions of the macro can be downloaded from GitHub: https://github.com/pgilfernandez/FreeCAD_AliasManager



How to use
- pending -

Limitations
- pending -

The script
__title__  = "alias manager" __author__ = "Pablo Gil Fernandez" __version__ = "01.00" __date__   = "20/11/2016" __Comment__ = "This macro helps managing aliases inside FreeCAD Spreadsheet workbench. It is able to create, delete, move aliases and create a 'part family' group of files" __Wiki__ = "https://github.com/pgilfernandez/FreeCAD_AliasManager" __Help__ = "https://github.com/pgilfernandez/FreeCAD_AliasManager" __Status__ = "stable" __Requires__ = "FreeCAD 0.16"
 * 1) ==                                           alias Manager                                                ==
 * 2) ABOUT
 * 3) version v1.0
 * 4) Macro developed for FreeCAD (http://www.freecadweb.org/).
 * 5) This macro helps managing aliases inside FreeCAD Spreadsheet workbench. It is able to:
 * 6)        - create aliases based on first column (A column)
 * 7)        - delete aliases placed on a column
 * 8)        - move aliases from one column to other one
 * 9)        - create a "part family", that's it, create different files for each column in a range. It will add
 * 10)          to the original name a suffix based on first row (1)
 * 11) More information might be found on FreeCAD forums: http://forum.freecadweb.org/
 * 12) LICENSE
 * 13) Original work done by tarihatari (https://github.com/tarihatari/FreeCAD_Macros)
 * 14) Improved by Pablo Gil Fernandez
 * 15) Copyright (c) 2016 tarihatari & Pablo Gil Fernandez
 * 16) This work is licensed under GNU Lesser General Public License (LGPL).
 * 17) To view a copy of this license, visit https://www.gnu.org/licenses/lgpl-3.0.html.
 * 1) More information might be found on FreeCAD forums: http://forum.freecadweb.org/
 * 2) LICENSE
 * 3) Original work done by tarihatari (https://github.com/tarihatari/FreeCAD_Macros)
 * 4) Improved by Pablo Gil Fernandez
 * 5) Copyright (c) 2016 tarihatari & Pablo Gil Fernandez
 * 6) This work is licensed under GNU Lesser General Public License (LGPL).
 * 7) To view a copy of this license, visit https://www.gnu.org/licenses/lgpl-3.0.html.
 * 1) Copyright (c) 2016 tarihatari & Pablo Gil Fernandez
 * 2) This work is licensed under GNU Lesser General Public License (LGPL).
 * 3) To view a copy of this license, visit https://www.gnu.org/licenses/lgpl-3.0.html.
 * 1) This work is licensed under GNU Lesser General Public License (LGPL).
 * 2) To view a copy of this license, visit https://www.gnu.org/licenses/lgpl-3.0.html.

from PySide import QtGui, QtCore from FreeCAD import Gui import os import string App = FreeCAD Gui = FreeCADGui

class infoPopup(QtGui.QDialog): def __init__(self, parent=None): self.dialog = None self.dialog = QtGui.QDialog self.dialog.resize(360,400) self.dialog.setWindowTitle("About...")
 * 1) ===== Info popup window ================================
 * 1) ===== Info popup window ================================

info = QtGui.QTextEdit(" INFORMATION This macro helps managing aliases inside FreeCAD Spreadsheet workbench. It is able to create, delete, move aliases and create a 'part family' group of files. USAGE set aliases: based on first column (A column), it will create aliases for the range given. If an alias is already set for any other cell the command won't work, it will be needed to clear them before setting them again.Clear aliases: it will clear all aliases inside the given range of cells (only one column).Move aliases: it will clear and set aliases from a given column to a new one.Generate part family: it will create different files for each column in a range. It will add to the original name a suffix based on first row. If an alias is already set for any other cell the command won't work, it will be needed to clear them before running the command. LICENCE Original work done by tarihatari (https://github.com/tarihatari/FreeCAD_Macros) Improved by Pablo Gil Fernandez  Copyright (c) 2016 tarihatari & Pablo Gil Fernandez  This work is licensed under GNU Lesser General Public License (LGPL). To view a copy of this license, visit https://www.gnu.org/licenses/lgpl-3.0.html. ")       info.setReadOnly(True)        info.setAlignment(QtCore.Qt.AlignLeft | QtCore.Qt.AlignTop)

okbox = QtGui.QDialogButtonBox(self.dialog) okbox.setOrientation(QtCore.Qt.Horizontal) okbox.setStandardButtons(QtGui.QDialogButtonBox.Close) okbox.setFocus

grid2 = QtGui.QGridLayout grid2.setSpacing(10) grid2.addWidget(info, 0, 0) grid2.addWidget(okbox, 1, 0)

self.dialog.setLayout(grid2)

QtCore.QObject.connect(okbox, QtCore.SIGNAL("rejected"), self.close) QtCore.QMetaObject.connectSlotsByName(self.dialog) self.dialog.show self.dialog.exec_

def close(self): self.dialog.close


 * 1) ===== Main code ========================================
 * 1) ===== Main code ========================================

alphabet_list = list(string.ascii_uppercase)
 * 1) ===== Global variables ==============================================

class p: def aliasManager(self): try:

mode = self.d1.currentText column_from = self.d2.currentText column_to = self.d3.currentText row_from = self.d4.value row_to = self.d5.value
 * 1) ===== Variables ==============================================

if mode == "Set aliases": for i in range(row_from,row_to+1): cell_from = 'A' + str(i) cell_to = str(column_from) + str(i) App.ActiveDocument.Spreadsheet.setAlias(cell_to, '') App.ActiveDocument.Spreadsheet.setAlias(cell_to, App.ActiveDocument.Spreadsheet.getContents(cell_from)) App.ActiveDocument.recompute
 * 1) ===== Mode - Set ==============================================

FreeCAD.Console.PrintMessage("\nAliases set\n")

elif mode == "Clear aliases": for i in range(row_from,row_to+1): cell_to = str(column_from) + str(i) App.ActiveDocument.Spreadsheet.setAlias(cell_to, '') App.ActiveDocument.recompute
 * 1) ===== Mode - Clear ==============================================

FreeCAD.Console.PrintMessage("\nAliases cleared\n")

elif mode == "Move aliases":
 * 1) ===== Mode - Move ==============================================

self.d3.setDisabled(False) for i in range(row_from,row_to+1): cell_reference = 'A'+ str(i) cell_from = column_from + str(i) cell_to = column_to + str(i) App.ActiveDocument.Spreadsheet.setAlias(cell_from, '') App.ActiveDocument.recompute App.ActiveDocument.Spreadsheet.setAlias(cell_to, App.ActiveDocument.Spreadsheet.getContents(cell_reference)) App.ActiveDocument.recompute FreeCAD.Console.PrintMessage("\nAliases moved\n")

elif mode == "Generate part family": doc = FreeCAD.ActiveDocument if not doc.FileName: FreeCAD.Console.PrintError('\nMust save project first\n') docDir, docFilename = os.path.split(doc.FileName) filePrefix = os.path.splitext(docFilename)[0]
 * 1) ===== Mode - Generate part family ==============================================

def char_range(c1, c2): """Generates the characters from `c1` to `c2`, inclusive.""" for c in xrange(ord(c1), ord(c2)+1): yield str.capitalize(chr(c))

fam_range = [] for c in char_range(str(column_from), str(column_to)): fam_range.append(c)

for index in range(len(fam_range)): # set aliases for i in range(row_from,row_to+1): cell_reference = 'A' + str(i) cell_from = str(fam_range[index-1]) + str(i) cell_to = str(fam_range[index]) + str(i) App.ActiveDocument.Spreadsheet.setAlias(cell_from, '') App.ActiveDocument.recompute App.ActiveDocument.Spreadsheet.setAlias(cell_to, App.ActiveDocument.Spreadsheet.getContents(cell_reference)) App.ActiveDocument.recompute sfx = str(fam_range[index]) + '1'

# save file suffix = App.ActiveDocument.Spreadsheet.getContents(sfx) filename = filePrefix + '_' + suffix + '.fcstd' filePath = os.path.join(docDir, filename) FreeCAD.Console.PrintMessage("\nSaving view to %s\n" % filePath) App.getDocument(filePrefix).saveAs(filePath)

# Clear last aliases created: for j in range(row_from,row_to+1): cell_to = str(column_to) + str(j) App.ActiveDocument.Spreadsheet.setAlias(cell_to, '') App.ActiveDocument.recompute

# Turn working file to original naming: filename = filePrefix + '.fcstd' filePath = os.path.join(docDir, filename) FreeCAD.Console.PrintMessage("\nSaving original view to %s\n" % filePath) App.getDocument(filePrefix).saveAs(filePath) FreeCAD.Console.PrintMessage("\nPart family files generated\n")

else: FreeCAD.Console.PrintError("\nError or 'TODO'\n")
 * 1) ===== If errors ==============================================

except: FreeCAD.Console.PrintError("\nUnable to complete task\n") self.close

def close(self): self.dialog.hide

def __init__(self): infoIcon = ['16 16 3 1', '  c None', '+ c #444444', '. c #e6e6e6', '    ......    ',                '   ..........  ',                '  ......++.... ',                ' .......++.....',                ' ..............',                '.....+++++......',                '....+++++.......',                '.......++.......',                '.......++.......',                '.......+........',                '......++........',                ' .....++.+.....',                ' .....++++.....',                '  .....++..... ',                '   ..........  ',                '     ......    ']
 * 1) ===== GUI menu ========================================
 * 1) ===== GUI menu ========================================

# Hide/show "to column" label and spinbox based on mode type def disableWidget(currentIndex): if self.d1.currentText == "Set aliases": iN3.hide self.d3.setEnabled(False) self.d3.hide elif self.d1.currentText == "Clear aliases": iN3.hide self.d3.setEnabled(False) self.d3.hide else: iN3.show self.d3.setEnabled(True) self.d3.show

self.dialog = None self.dialog = QtGui.QDialog self.dialog.resize(400,140) self.dialog.setWindowTitle("Alias manager") iN1 = QtGui.QLabel("mode:") iN1.setAlignment(QtCore.Qt.AlignRight | QtCore.Qt.AlignVCenter) self.d1 = QtGui.QComboBox self.d1.addItem("Set aliases") self.d1.addItem("Clear aliases") self.d1.addItem("Move aliases") self.d1.addItem("Generate part family") self.d1.setCurrentIndex(0) # set default item self.d1.currentIndexChanged['QString'].connect(disableWidget) iN2a = QtGui.QLabel("column:") iN2a.setAlignment(QtCore.Qt.AlignRight | QtCore.Qt.AlignVCenter) iN2b = QtGui.QLabel("from") iN2b.setAlignment(QtCore.Qt.AlignCenter | QtCore.Qt.AlignVCenter) self.d2 = QtGui.QComboBox for i in range(0,26): self.d2.addItem(alphabet_list[i]) for i in range(0,26): for j in range(0,26): self.d2.addItem(alphabet_list[i] + alphabet_list[j]) self.d2.setCurrentIndex(1) # set default item

iN3 = QtGui.QLabel("to") iN3.setAlignment(QtCore.Qt.AlignCenter | QtCore.Qt.AlignVCenter) iN3.hide # set initial state hidden self.d3 = QtGui.QComboBox for i in range(0,26): self.d3.addItem(alphabet_list[i]) for i in range(0,26): for j in range(0,26): self.d3.addItem(alphabet_list[i] + alphabet_list[j]) self.d3.setCurrentIndex(2) # set default item self.d3.setEnabled(False) # set initial state to not editable self.d3.hide # set initial state hidden

iN4 = QtGui.QLabel("from row:") iN4.setAlignment(QtCore.Qt.AlignRight | QtCore.Qt.AlignVCenter) self.d4 = QtGui.QSpinBox self.d4.setValue(2.0) # set default item self.d4.setSingleStep(1.0) self.d4.setMinimum(1.0)

iN5 = QtGui.QLabel("to row:") iN5.setAlignment(QtCore.Qt.AlignRight | QtCore.Qt.AlignVCenter) self.d5 = QtGui.QSpinBox self.d5.setValue(4.0) # set default item self.d5.setSingleStep(1.0) self.d5.setMinimum(1.0)

# Info button self.d6 = QtGui.QPushButton("") self.d6.setFixedWidth(40) self.d6.setIcon(QtGui.QIcon(QtGui.QPixmap(infoIcon))) self.d6.clicked.connect(self.popup)

okbox = QtGui.QDialogButtonBox(self.dialog) okbox.setOrientation(QtCore.Qt.Horizontal) okbox.setStandardButtons(QtGui.QDialogButtonBox.Ok|QtGui.QDialogButtonBox.Close)

grid = QtGui.QGridLayout grid.setSpacing(10)

# Mode grid.addWidget(self.d1, 0, 0, 1, 3) # column, column from grid.addWidget(iN2a,   2, 0, 1, 1) grid.addWidget(iN2b,   1, 1, 1, 1) grid.addWidget(self.d2, 2, 1, 1, 1) # column to       grid.addWidget(iN3,     1, 2, 1, 1) grid.addWidget(self.d3, 2, 2, 1, 1) # from row grid.addWidget(iN4,    3, 0, 1, 1) grid.addWidget(self.d4, 3, 1, 1, 1) # to row grid.addWidget(iN5,    4, 0, 1, 1) grid.addWidget(self.d5, 4, 1) # + info grid.addWidget(self.d6, 6, 0, 1, 1) # cancel, OK       grid.addWidget(okbox,   6, 1, 1, 2)

self.dialog.setLayout(grid)

# # Set Tab order (not needed anymore because of enabling/disabling spinboxes) # self.dialog.setTabOrder(self.d3, self.d1) # self.dialog.setTabOrder(self.d1, self.d2) # self.dialog.setTabOrder(self.d2, self.d4) # self.dialog.setTabOrder(self.d4, self.d5) # self.dialog.setTabOrder(self.d5, self.d3) QtCore.QObject.connect(okbox, QtCore.SIGNAL("rejected"), self.close) QtCore.QObject.connect(okbox, QtCore.SIGNAL("accepted"), self.aliasManager) QtCore.QMetaObject.connectSlotsByName(self.dialog) self.dialog.show self.dialog.exec_

def popup(self): self.dialog2 = infoPopup self.dialog2.exec_ p