I'll be honest. I'm very frustrated with the Export/Import function. I can't seem to get anything new to import.
Can someone lead me in the right direction? |
Here is an easy example that I just cannot get to work.
Created new, blank, database.
Installed the Inventory and Purchasing apps.
Turned on Variations in Inventory Settings.
Added "Test Parent Category 1" and added "Test Child Category Name 1" and "..Name2" so I could clearly see what was getting exported where.
Selected all the Product Category lines, including the ones that were there by default.
Selected Export under the Actions button.
Selected 'Name' & 'Parent Category' and 'Child Category' fields for export.
Added a few more lines in then downloaded Excel file that follows the same formatting. Such as 'Audio' as a parent and 'Accessories' as a child.
Went to Import Records and loaded the file.
When I click on Test it gives this error between rows 10 and 14
I would think it would create any records that did not exist.
Here is a copy/paste from my Excel file.
id name parent_id child_id product.product_category_all All All / Expenses All / Saleable product.cat_expense Expenses All product.product_category_1 Saleable All __export__.product_category_610_217caa7f Test Parent Category Name 1 Test Parent Category Name 1 / Test Child Category Name 1 Test Parent Category Name 1 / Test Child Category Name 2 __export__.product_category_611_ae2b53cf Test Child Category Name 1 Test Parent Category Name 1 __export__.product_category_612_be458137 Test Child Category Name 2 Test Parent Category Name 1 Audio Audio / Accessories Audio / I/O Audio / Installation Mixer Audio / Digital Mixer Audio / Personal Monitor Accessories Audio I/O Audio Installation Mixer Audio Digital Mixer Audio Personal Monitor Audio
Please use a meaningful title.