Export to .CSV Error

[T.J]

Hi,

Trying to export the catalog to an .csv file for use in excel, this has worked before but now i get this error:

"A databse error occured while resequencing sections and products: Field 'Product.sReportDescription' cannot be a zero-lenght string"

Looking at the csv it looks like all the section info has exported but not the actual product info. If its any help the following has changed since last export.

Installation of MoleEnd's site map report.
Catalog was initly a 30 day trial of Business but is now licensed copy of catalog - the keycode was entered on the front screen that tells you how many days are remaining

To be honest doubt the report has anything to do with it..

Any help would be most welcome, with 2000+ products to move about being able to export is vital

Many Thanks
Liam

[Jan]

I get that error every now and again, it seems to be related to top level products in my case, did you ever switch on the 'enable extended products in customer reports' because this is the field that it is complaining about.

You can fix this up in three ways.

1) Open the actinic database and set the sReportDescription to NULL where it is blank, you can use this SQL to do this

UPDATE Product SET Product.sReportDescription = Null
WHERE (((Trim([Product].[sReportDescription]))=""));

2) Find the problem product (or products) and delete it, if you double click on the product the same message will appear. The easiest way to find this is to look in the database directly.

3) Make sure that every product has something in the extended report description field.

Be very careful if you decide to change the database, make a backup of the database before you change anything, if you are not sure what you are doing contact Actinic support instead - messing about with the database is a dangerous thing to do and if you get it wrong you could damage your site.

Regards,

[T.J]

Hi Jan,

Thanks for the reply. Tried running that SQL code as a qury in access - It prompts about running a query that will update data and then updates a whole massive 0 records :-(

Looked in the database and every product has the report description field blank, assume this is not the way it should be?

Not had the 'enable extended products in customer reports' option selected in the past although i have played with it this morning in the hop that it would help.....

Starting to ponder the concept of copying and pasting "null" in to every product in access, either that or just going mad and climbing the walls :-)

Cheers
Liam

[Jan]

If you don't use the sReportDescription then you could try this

UPDATE Product SET Product.sReportDescription = Null

to make sure that they are all Null and then if that doesn't work you could try

UPDATE Product SET Product.sReportDescription = " "

to set them all to a single space,

then if that doesn't work try
UPDATE Product SET Product.sReportDescription = "-"

The sReportDescription field will show up in your reports whether you have asked for it or not so whatever you do, don't put any rude words in there in desparation :-)

Regards,

[T.J]

Hi Jan,

Guess this will teach me to mess with access on a monday but none of those SQL querys have solved the problem :-( The last one has added a hyphen "-" to the field for every product so i can't see where its getting the error from. Think i'll give up and go to lunch instead!

Cheers
Liam

[Jan]

Try compressing your database first to see if it has somehow become corrupt (housekeeping/compact databases)

Try changing the field on the database to allow blank values, to do this go to the access database and open the product table in design view, find the sReportDescription field and set the field
property 'Allow zero length' to Yes.

Regards,

[T.J]

Hi Jan,

Sorted!!!!! Managed to track it down to two products, both had "-" in the field but for some reason the catalog wasn't seeing it. Opened the catalog in access, deleted the rows with those products and problem solved. Thanks for all your help, would still be struggling without it.

Cheers
Liam

[Jan]

Great news, my next suggestion was going to be to call in a psychic. ;-).

Don't forget to rerun the query to set the values back to NULL or else you will end up with little -'s appearing on your packing list and invoice reports for everything.

Regards,