[Archived] QuoteWerks Support Forum - New Forum: https://tickets.quotewerks.com/support/discussions
[Archived] QuoteWerks Support Forum - New Forum: https://tickets.quotewerks.com/support/discussions
Home | Profile | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 QuoteWerks
 General
 Changing Picture File Location
 Forum Locked
 Printer Friendly
Author Topic  

dtheurer
New Member

USA
12 Posts

Posted - 01/15/2018 :  18:23:22  Show Profile  Visit dtheurer's Homepage
Is there a way to do an update on the default location of the file that has the pictures in it. We would like to move the file to a different folder and don't want to have to go back through each one of the products individually to update the main folder name.

dtheurer@inmtn.com

MattPrestige
QuoteWerks Genius

United Kingdom
531 Posts

Posted - 01/15/2018 :  18:24:19  Show Profile  Visit MattPrestige's Homepage
Are you familiar with Access/SQL Query updating?

QuoteWerks MVP for 7 years
Remote QuoteWerks consultancy for companies globally.

matt@prestigequoting.com
www.prestigequoting.com
Go to Top of Page

qw_Cat
Technical Support

USA
28 Posts

Posted - 01/22/2018 :  12:07:15  Show Profile
You could do this either in the database, or you could export your product list and open it in Excel, delete all columns except for the ManufacturerPartNumber and PictureFileName, do a find & replace of the folder name, then re-import with an "Update existing products, but do not append new products" matching the Manufacturer Part Number Fields.


Best Regards,


Cat Ward
QuoteWerks Technical Support Manager
QuoteWerks Technical Support, Level 4
QuoteWerks Team Member Since April 2015
Go to Top of Page
  Topic  
 Forum Locked
 Printer Friendly
Jump To:
[Archived] QuoteWerks Support Forum - New Forum: https://tickets.quotewerks.com/support/discussions © Aspire Technologies, Inc Go To Top Of Page
Snitz Forums 2000