import hierarchical file

[feemish]

Hi,

v10 win7pro

I am trying to get my head around hierarchical files and importing them.

Following the advice in the help files I have added a simple product to the store and then exported the products from actinic File : Export

The catalog is exported as an hierarchical file. It shows up as a microsoft office excel comma seperated values file. Double clicking this file opens it in excel and I can see the file with my sample product listed.

TO check this is ok, I then go to actinic and delete the products from actinic, and then import this file. File:Import: import hierarchical file all goes well and the products are added to the store.

However, if I make any changes to this file, and I mean 'any' changes... not like adding lines but editing say a description, save it as the same format and then try and import it again, it fails.

The error is ; no fields were found in the first line of the file. Please enter a file with valid fields.

Can anyone see where I'm going wrong?

[Jenny]

have you had a look at the sample import files within the original files.
That always seems to be a good starting point.
Jenny

[feemish]

Yes, I've had a good look at them.

The sample hierarchical files in the site folder:common show up as plain .txt files.

However, when you 'export file' from actinic it is produces a microsoft office excel comma seperated values file.

I want to export my products, make some mass edits and reimport them.
I dont want to start from scratch with a blank file!
So I am exporting the products first.

its very odd, as if you export the products, as I say, it produces a .csv file.
That file can then be imported back into an empty shop without problem.

However if you edit it, the error I mentioned before happens.

[Jenny]

You can save it to the right format but I usually find when it saves, it tries to change format and you have to force it back to what you want.

[feemish]

are you talking about the 'export' file from actinic.

Are you talking about forcing it to save as a plain txt file?
How do you do that?

thanks

[Jenny]

yes I now see your problem. I had been working on flat files for my client.
Sorry not got a solution at this mo.
Jenny

[Duncan Rounding]

Are you still having a problem then importing your hierarchical file back into Actinic Mark?

[feemish]

yes, I am.

[Duncan Rounding]

This should solve it: http://community.actinic.com/showthread.php?p=271434

[feemish]

Thanks for pointing me to that Duncan.