Flat file import error

[garyhay]

The section description on line 549 contains a comma not in quotes. This is the first line that fails to import

[alexwren]

If you remove all the image refs for small, large and section images then it imports and still causes the error (hence it must not be to do with images).

You should be able to do the same.

I am doing this now on a fresh PC as I don't have the images here.

Alex

[alexwren]

The section description on line 549 contains a comma not in quotes. This is the first line that fails to import

Do you mean

"Books","You've bought the kit, now get the knowledge! The best titles for those who are serious about improving their growing technique.",,"2499.jpg",,,,,,,,,,,,,,,,,,,"books.html"

If so this looks ok to me - it also import ok. The problem lines (this is excel row numbers) are 602 - 604, 606 - 612.

Alex

[alexwren]

Do you think that there is a specific orer in which section data should be imported i.e. should sections be inmported before their sub-sections or vice versa?

Also one assumes that although adding a product creates the section, specifiying the section data in a further line just overwrites with any new data?

[Nadeem]

Hi Alex

I just send you an email with a fixed flatfile import for the csv. I had to remove some section which are not being used. Also I had to remove the filename for the images, otherwise actinic will not import, if a image file does not exist then actinic will not import the file. Once i had removed these, Actinic imported the file correctly.

Kind Regards

[garyhay]

I removed the section images and can now import all lines with only missing .jpg errors which should be okay as you will have these.

I also moved the first column to the end of the spreadsheet

[alexwren]

Hi Alex

I just send you an email with a fixed flatfile import for the csv. I had to remove some section which are not being used. Also I had to remove the filename for the images, otherwise actinic will not import, if a image file does not exist then actinic will not import the file. Once i had removed these, Actinic imported the file correctly.

Kind Regards

Hi Nadeem,

Thanks for your help.

You have removed all my section lines which means I now don't have any section images, descriptions or page names. Is there anyway we can get these back in as they are kind of important to my mission...

[garyhay]

The lines I can't import with section images dont have a short description the field is blank?

[alexwren]

I removed the section images and can now import all lines with only missing .jpg errors which should be okay as you will have these.

I also moved the first column to the end of the spreadsheet

Hi Gary,

Just to recap you have removed all the section images and you can now import without getting the "An unexpected error occured whilst trying to carry out the import. Please check your settings and try again" message?

Also do all sections listed at the bottom of the csv have descriptions and page names (some don't have images yet) as this is my real problem (rows 602 - 604, 606 - 612 are the ones that are not importing properly)

Alex

PS I have used the "section description" field not the "short description" as this works for 90% of my import

[garyhay]

The short description is for the product.

[garyhay]

Can you send your error log

[alexwren]

Hi Gary,

This is the thing - the error log is empty as the error message is a pop up window.

See attached screenshot

Alex

[Nadeem]

Hi Alex,

Are you still getting problems, as the error message suggest you might have excel opened with the csv file, while Actinic is still trying to import. Are you still gettings problems?

Kind Regards

[alexwren]

Hi Nadeem,

Thanks for getting back to me.

I still get this error message...

I don't have it open with any other files. It seems to me that it is one of the section lines that is causing the problem as when you remove them the file imports fine. Can you try importing in 6.1.5 (remove all image refs first). Note the missing data for (rows 602 - 604, 606 - 612).

Do you think there is something wrong with the data or the format of my import file? Maybe I am missing some fields but to be honest it used to work ok!

Cheers again for your help.

[Nadeem]

Hi Alex

I have just send you another version of the .csv file which the image name taken out, as well as the section rearrange so the last section should not have any spaces.

Please check it

Kind Regards