Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview


Multiexcerpt
MultiExcerptNameFeature Overview

Using Commerce Vision's Data Import module, site administrators can import a variety of data to selected tables of the web database. Existing data can also be exported for review. 

Product metadata, store location, and user data can all be imported with ease, once the profile has been created.


Example of Output


 


Warning
titlePrerequisites

Don't have any Import Profiles set up? See our guide on Setting Up Data Import and Export - Setting Up to get started.

 


Importing Data

  1. In the CMS, navigate to Advanced Settings → Data Import
  2. Locate the profile you wish import data for and click 'Run'.
  3. The Required Fields are listed at the top of the page. Your CSV import file must be in this format. 
  4. Click 'Download Blank CSV File' if you wish to download a template with the correct format and column headings.
    • Note - If your site is on version 3.87+, you can also export the existing data for this profile (see below). 
  5. Select optional functions:
    1. Replace Table - this will delete ALL records in the table and replace it with the data in your CSV file. Use with caution!
    2. Ignore headings on first line - this will skip the first line in the file; tick this if your document has a header row.
  6. Either click 'Select' to browse to your import file, or (if your browser supports it), drag and drop the file into the dialogue box. 
  7. Click 'Import Now'.
  8. Your file will be imported and feedback (error and success messages) will be displayed in the dialogue box. 

 


Exporting Data

For sites on version 3.87+, the existing data for a profile can also be exported, allowing for easy manipulation prior to re-importing. 

  1. In the CMS, navigate to Advanced Content → Data Import.
  2. Click 'Run' against the required profile.
  3. When the import page loads, click 'Export Existing Data'. 
     
  4. Your data will download to a .csv file, or if more processing time is required, will be emailed to you as a link (to protect your site's speed and performance). 
  5. Modify your data as required, then follow the steps for 'Importing Data' above.

 

 



Related

...

help

Content by Label
showLabelsfalse
max5
spacesKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("import","cms","= "data" ) and type = "page" and space = "KB"
labelsimport data CMS

 

 



Additional Information


Multiexcerpt
MultiExcerptNameAdditional Info

  

Tip

To have a new profile created or an existing one updated, get in touch with our Support Team. Refer to our guide

...

Data Import and Export - Setting Up for more information.



Multiexcerpt
hiddentrue
MultiExcerptNameFeature Title

Data Import and Export



Minimum Version Requirements


Multiexcerpt
MultiExcerptNameMinimum Version Requirements
**.**.**


Prerequisites


Multiexcerpt
MultiExcerptNamePre reqs

--


Self Configurable


Multiexcerpt
MultiExcerptNameSelf Configurable

Yes


Business Function


Multiexcerpt
MultiExcerptNameBusiness Function

Administration


BPD Only?


Multiexcerpt
MultiExcerptNameBPD Only

No


B2B/B2C/Both


Multiexcerpt
MultiExcerptNameB2B/B2C/Both

Both


Ballpark Hours From CV (if opting for CV to complete self config component)


Multiexcerpt
MultiExcerptNameBallpark Hours From CV (if opting for CV to complete self config component)

Contact CV Support


Ballpark Hours From CV (in addition to any self config required)


Multiexcerpt
MultiExcerptNameBallpark Hours From CV (in addition to any self config required)

Contact CV Support


Third Party Costs


Multiexcerpt
MultiExcerptNameThird Party Costs

n/a


CMS Category


Multiexcerpt
MultiExcerptNameCMS Category

 CMS Category