Import Equipment List

Stardraw Forums

Back

Home
»
All Stardraw Products
»
Stardraw Design/Documentation Applications
»
Import Equipment List

Import Equipment List

Author	Message
Rob Robinson	Rob Robinson posted 6 Years Ago Post Details Share Post
Group: Administrators Posts: 2.3K, Visits: 8.9K	For those following this thread, the issue appears to be that after generating the Equipment List, user edits performed in Excel, probably a Sort action without all relevant columns being selected, caused mismatches between the Product Instance GUIDs and the other data used to describe those products. The fix was to validate that the right GUID was associated with the right product details. Kind regards, Rob Robinson Stardraw.com
	Reply Like 5
Jean-philippe Langevin	Jean-philippe Langevin posted 6 Years Ago Post Details Share Post
Group: Forum Members Posts: 12, Visits: 52	i am just going to import equipement list then select my list i tried indiferent locations in drawings or in product it still does the same thing ... i also have a new probleme i started over and created a other version... ( same project ) here i exported a working equipement list..one to modify and one for back up that i havent touched at all.. then modified infos and added more product into the sheet ... dans then when i got to importing again, it says could not find product with guid of (........) that is basicaly all my product. then i tried loading the untouched back up and it gives me the same problem ! weird isn't it ? i will email you the project and the 3 problematic files from jean-philippel@momentfactory.com thank you for you quick support !
	Reply Like 5
Rob Robinson	Rob Robinson posted 6 Years Ago Post Details Share Post
Group: Administrators Posts: 2.3K, Visits: 8.9K	Thanks for your post. Can you tell me exactly what you were doing when the 'object reference' error was displayed? For example, were you in the Reports view and, if so, which report was selected? Can you also email us the .S07 project file and .XLS equipment list so that we can reproduce your actions and attempt to reproduce the same issue? The files can be emailed to techsupport@stardraw.com Thank you. Kind regards, Rob Robinson Stardraw.com
	Reply Like 6
Jean-philippe Langevin	Jean-philippe Langevin posted 6 Years Ago Post Details Share Post
Group: Forum Members Posts: 12, Visits: 52	Hi i have been modifiying My equipement list through Open office since yester day.. and importing it in SD Design 7.3 ( demo version ) from time to time yesterday everything was fine. And today i receive a french message saying : La référence d'objet n'est pas définie aèa une instance d'un objet. which basicly means : The jobject's references is not refferenced to any object instance.. i am not sure what would cause this issue.. i have not touched the guid... thank you. PS : i am liking the product so far but i have found a few anoying glitches.. i might like to report them as well ...we are looking here at moment factory to buy a few liscences in febuary for are system architects and integrators
	Reply Like 6
JWAIII	J JWAIII posted 6 Years Ago Post Details Share Post
J Group: Forum Members Posts: 8, Visits: 59	Got it. Thank You.
	Reply Like 53
Rob Robinson	Rob Robinson posted 6 Years Ago Post Details Share Post
Group: Administrators Posts: 2.3K, Visits: 8.9K	A GUID (globally unique ID) is created by Stardraw Design 7 to uniquely identify each product instance in the project. W‌hen you export an Equipment List, the first column in the generated spreadsheet is the GUID for each product instance in your project. S‌ince the GUID is system-generated, you should not edit‌‌ or copy GUIDs - leave them exactly as they are. I‌f you want to add product instances by importing from the equipment list, copy the Manufacturer, Model Number and Description fields for the products you want, but leave the GUID field blank; on import a new product instance will be created in the project and at this point a GUID will be assigned. N‌ote that to add a product in this way, the Manufacturer, Model Number and Description values must exactly match a product or UDP that is already in the library. I‌ hope this is helpful but if I've missed the point please do feel free to email the pr‌oject file (.s07) and equipment list (.xls) files to techsupport@stardraw.com. Kind regards, Rob Robinson Stardraw.com
	Reply Like 54
JWAIII	J JWAIII posted 6 Years Ago Post Details Share Post
J Group: Forum Members Posts: 8, Visits: 59	I’ve tried to import and get a message about guid field not having the right format.
	Reply Like 54
Rob Robinson	Rob Robinson posted 6 Years Ago Post Details Share Post
Group: Administrators Posts: 2.3K, Visits: 8.9K	Reference materials will be coming soon. In the meantime do you have any questions about specific aspects of the functionality of Import Equipment List? [Edit] A topic has been added to the Help file; check the index, under Import Equipment List. There is also a movie called "Import Equipment List", #26 at https://www1.stardraw.com/stardraw/sd7/movies Kind regards, Rob Robinson Stardraw.com Edited 6 Years Ago by Rob Robinson
	Reply Like 52
JWAIII	J JWAIII posted 6 Years Ago Topic Details Share Topic
J Group: Forum Members Posts: 8, Visits: 59	Is there a tutorial or instructions on importing an Equipment List?
	Reply Like 55