Issue with XSL Export.

Question

Hi there,

I've been having some issues exporting XSL data for my form.

I have it so that it's writing to an xsl file successfully with each submit, however after each test submission, it's simply over writing the xsl file when I want to save each submission made.

Can someone point me in the right direction as to what I need to do?

The DB Save currently has this, which I wrote based off information I've found here in the forums:

<?php

$form->data["xlsData"][1]["title"] = $form->data["title"];
$form->data["xlsData"][1]["firstname"] = $form->data["firstname"];
$form->data["xlsData"][1]["lastname"] = $form->data["lastname"];
$form->data["xlsData"][1]["gender"] = $form->data["gender"];
$form->data["xlsData"][1]["address"] = $form->data["address"];
$form->data["xlsData"][1]["city"] = $form->data["city"];
$form->data["xlsData"][1]["state"] = $form->data["state"];
$form->data["xlsData"][1]["zip"] = $form->data["zip"];
$form->data["xlsData"][1]["phone"] = $form->data["phone"];
$form->data["xlsData"][1]["email"] = $form->data["email"];
$form->data["xlsData"][1]["cashcheck"] = $form->data["cashcheck"];
$form->data["xlsData"][1]["card"] = $form->data["card"];

?>

GreyHead · Accepted Answer

Hi superdmon,

There are a few ways to do this.

The best is probably to use the GSheet export and save the data in a Google Sheet - that will automatically add each new entry as a new row.

You can use with the CSV Export or the XLS export to export a single record but then you have to re-import that into the existing spreadsheet as a new row - there is no way that the exporter can do that. (I guess it might be possible with the MS Cloud services but I've never tried and I haven't seen that any other user has).

You can set up a separate form to export all of the saved records - or some sub-set (i.e. all since the last export) if that helps. Again this would either replace or need to be imported into the existing sheet.

Lastly, there is a MySQL plug-in for Excel that lets you link Excel directly with a database table if the database allows remote access. That might also work.

Bob

Forums

Issue with XSL Export.