hierarchical file export import issue

[feemish]

Hi,

More odd behaviour uncovered by yours truly.

In an attempt to globally change a component setting to solve this bug SD-5291;
http://community.sellerdeck.com/show...83&postcount=9
which hasnt been fixed in the latest release 14.0.2

I have exported an hierarchical file.
To check all was ok, I re-imported the same hierarchical file, and it imported fine.. no problem.

support told me how to make the change on the hierarchical file;

open this using Excel the file will be a hierarchical file of the .CSV format. In the file for every row titled Component you will need to change the column titled "Include no choice label" in the default file I've exported from the software its column "M".

However If i change just one product component row : field M ("Include no choice label") from "0" to "1" then save the file, then import the hierarchical file back into Sellerdeck, I start to see errors on import... see the attached error file (failed6.txt);

The error lists invalid product with invalid product names ???
bearing in mind the same products imported fine before I edited this single field!

Has anyone had any experience of anything like this before?

[feemish]

I got to the bottom of this weirdness eventually.

Within the exported hierarchical file there were some cells that had an invalid product page name.

this was set like a formula... beginning with an '='

the weird thing was that
a/ Sellerdeck exported it like this
b/ the exported file imported fine..(with the names starting '='!)
until you opened it and saved it using Excel.
Then it would no longer import without errors.

I had to manually change all the 'invalid' page names and it looks like it is all ok now.

[Duncan Rounding]

One way to minimise these issues is to firstly just open Excel (rather than double-clicking on the exported file) then go to Data - From Text, and then select your csv export file. That way you can set all the column data formats to Text rather than General.