Has anyone tried the Export function?

[highnote]

(Using Version 3.2 upgraded to 3.4)

I have not been successful in exporting listings to excel using the admin console.  None of the options and no pictures are exported.  Perhaps I overlooked something?

This is what shows up in the excel file: 

Pictures       Make/Model                    Year     Zip Code     Price, $     Mileage           Video
No pictures      Cadillac   STS               1997    78664       8,500        58000   
No pictures       Jeep Wrangler             2004    80015       15,500      42000   

Please let me know if anyone has seen the same thing or if it is working for you.
Thanks,
Lou

[apn3a]

You're right, that's all that shows up.  No pictures and no optioins.  Support needs to attend to this issue as well.

[highnote]

Thanks for the duplication.  I have emailed support.
Regards,
Lou

[Smart Girl]

Lou and Minas,

Thank you for attracting my attention to this issue. I will try to reproduce this and investigate the cause for this issue.

[highnote]

Dear iAuto Support,
It looks like the display form that the export function is selecting is the (abbreviated) Qsearch form.

Any progress on this bug?  It is critical to the functionality to include the successful export of the listing options and uploaded photos.  Additionally, I noticed there is no code to append the Seller information (name, contact info etc....), which is also critical for this functionality to be useful.

Thanks and best regards,
Lou

[highnote]

The root cause of this issue is the Export Function (system/modules/classifieds/admin/functions/export/index.php) selects and assigns an incorrect display form.  I fixed my configuration by changing the following instruction:
   $_REQUEST['form_display'] = $a['formassoc'];
   
I modified this instruction as follows:
   $form1 = get_form($a['formassoc']);
   $_REQUEST['form_display'] = $form1['full_form'];

The reason $a['formassoc'] is incorrect for export is because this is the associated form for the top-level search which is the short form designed to display a page of listings.   What we need is the full_form of the assoc_form instead of the just the assoc_form.

After making this change, the exported file now includes all of the listing items in the "details" form, but a few items that are still required for the export to be useful:
1) Make and Model are in one cell, but need to be broken into two cells (subsequent import of this exported data requires these to be separated.)
2) Weblink stores the caption instead of the actual Web address
3) The Gallery is not exported, but instead exports "No Pictures" into one single cell
4) The Seller Information is not part of the export (Seller ID, Name, Contact info etc…).
5) Seller Comments are not readable if user pressed enter for a newline.   (subsequent import of this exported data does not keep the newline and the sentences are all run together)
6) The listing ID should also be exported

-----------------------------------------------------------------------------------------------------------------------------
Note to others:
In my case, I have additional listing variables that I want to export that are not in the details display form.  In order to display all listing information I need for export, a new display form is required:

• In the Admin Console, Clone the Details display form and call it "Details-Export"
• Add a new group in the new "Details-Export" display form with any additional information you wish to export such as "Featured" or "ZipCode", as well as any options you may want to retain in the export that you don't want to be displayed in the normal Display Form.
• Make a note of the Form ID number assigned to the new form (mine was 99)
• Go to the Admin Console System Settings and Add a New System Setting: CARS_EXPORT_FORM_ID with a value of the Form ID number of the newly created Display Form (again, mine was 99)
• The new instruction to assign the display form should now be:   $_REQUEST['form_display'] = CARS_EXPORT_FORM_ID; instead of the new code above because we are using a different form as the full_form doesn't have all variables needed for export.
• Note that each time you modify your Details Display Form, you will want also modify the corresponding Export Display Form to be sure that any changes are exported as well.

   
Dear iAuto Support, we still need items 1-6 resolved above.
Best regards,
Lou

[Smart Girl]

Lou,

1. Negative. We cannot do this.
2. I need to check it.
3. How do you want to export images? We are definitly unable to insert images into the excel file.
4. We can do this.
5. I need to check it.
6. No problem, we can do this.

We can also propose fields to be chosen for export, so you will have the fieldes you have "checked" in admin section for export in excel file.

[uojorgensen]

Is this fixed? I need to export the pictures in excell as well to be able to help my dealers send info feeds to places like autotrader.com