User Tools

Site Tools


public:tutorials:using_the_master_entry_excel_for_importing_data

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
public:tutorials:using_the_master_entry_excel_for_importing_data [2012/08/22 17:12] – davepublic:tutorials:using_the_master_entry_excel_for_importing_data [2025/05/22 21:53] (current) – external edit 127.0.0.1
Line 11: Line 11:
  
   - Open the Excel file and fill in as much data as possible.  The only column that must be filled is Column A ("ModelNumber").  The fields are directly related to the fields on the Master Entry Sheet in Speed-Quote.   - Open the Excel file and fill in as much data as possible.  The only column that must be filled is Column A ("ModelNumber").  The fields are directly related to the fields on the Master Entry Sheet in Speed-Quote.
-  - When the excel is filled, select the rows of data you want to export by clicking/shift-clicking on the row numbers and then run the "ExportToSpeedQuote" macro.  How you access the macro will depend on which version of excel you are running.  Please check the Excel help system for more instructions. +  - When the excel is filled, select the rows of data you want to export by clicking/shift-clicking on the row numbers and then run the "ExportToSpeedQuote" macro.  How you access the macro will depend on which version of excel you are running.  Please check the Excel help system for more instructions.\\ {{:public:tutorials:excel_xml_selectrows.jpg|}} 
-  -  +  - You will be asked what you would like the database to be called in Speed-Quote.\\  {{:public:tutorials:excel_xml_dbname.jpg|}} 
-  - +  - Select a place to save the XML file on your computer and the file will be exported.  If you have problems please contact [[mailto:[email protected]|SpeedQuote Tech Support email]] 
 +  - To import the XML file please see our online help at:   
 +    * [[http://www.apptastic.com/manual/databasemanagement.htm|Database Management Overview]] and 
 +    * [[http://www.apptastic.com/manual/importmasterdatafromxml.htm|Import Master Data From XML]]
public/tutorials/using_the_master_entry_excel_for_importing_data.1345655543.txt.gz · Last modified: (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki