Form entries

Tagged: 

This topic contains 6 replies, has 2 voices, and was last updated by  SAAsh 10 months, 2 weeks ago.

Viewing 7 posts - 1 through 7 (of 7 total)
Author Posts
Author Posts
May 28, 2013 at 8:10 pm #10232

SAAsh

<p>Is it possible to export or download the form entries as a single file?
I can use the View Entries button to open a browser “View Form Data” session that list rows with column headings that allows entries to be highlighted and displayed in an area below the list. Each entry has a red “x” to the left of the entry’s “Date submitted” field which appears to delete that row.</p>

<p>I need to get all entries into Excel or a database. This is something that would seem to be an obvious feature or need. Am I missing something?</p>

<p>Any help is appreciated.</p>

<p>Thank you</p>

May 29, 2013 at 1:12 am #10239
Raju Nunna
Raju Nunna

Just above the form entries box, to the right you will find a link to “Export Data”.

May 29, 2013 at 3:17 am #10243

SAAsh

Not sure why I am not seeing anything that says anything resembling “Export Data.”

Is there a way to upload and embed images into these posts?

If so, I can better show what I am seeing?

Is it possible that this is related to us using the “free” version of Weebly?

May 30, 2013 at 2:09 am #10265

SAAsh

I did find a video at http://www.weebly.com/features.php that includes a list of features including “Easy Form Builder.” Near the end of the video they are showing the “View Entries” option and the list of entries with the “Export Data” option in the upper right corner as you mention along with a “View Form” option. Neither of those appear on the page I get when I select View Entries from the top of the Form widget/control.
The video mentions and shows some sort of “main page of the account” which I do not see when I access the Weebly options under Hostmonster’s hosting options. Hostmonster’s support isn’t aware of any issues or differences and asked me to submit a support ticket that they can forward to Weebly so not much immediate help.
I am wondering if this might also be due to only using the free Basic Weebly option rather than the Pro/Premium option.
I assume these entries are stored in a text or XML file somewhere within the Weebly site file structure.

Thanks for you help, Raju Nunna

May 31, 2013 at 11:31 am #10280
Raju Nunna
Raju Nunna

Sounds more like a Hostmonster issue. “Export Data” is available for Free Weebly sites also. You need to contact Hostmonster and have them resolve it. Weebly won’t be able to help because they do not have access to Hostmonster’s installation of Weebly.

May 31, 2013 at 12:08 pm #10284

SAAsh

Yes, Hostmonster admitted that their “version” of Weebly is not the same and then said there was nothing they could do about any differences nor could they contact Weebly for a workaround or to provide info on where the entries are stored and in what format.

One Hostmonster response support rep state that he was “sure I could copy and paste” entries into a spreadsheet. Obviously, he did not try doing so beforehand. Neither the table widget nor individual columns are resizable so many values — including name and email addresses — are truncated with ellipses to indicate more data exists. Selected, copied and pasted text includes the ellipses rather than the complete data value.

I suggested that they might post a warning or disclaimer on their Weebly site front-end or at least in a KB or FAQ for their customers. No response yet on that one.

All Very frustrating to someone who has been at this for 35 years and majored in “Data Processing.”

Anyway, thanks so much for your responsiveness and help.

SAAsh

June 2, 2013 at 12:47 pm #10301

SAAsh

*| IMPORTANT UPDATE *| Hostmonster support has responded to the issue of their installation of Weebly not providing the option to export form entries with a workaround which should be acknowledged. Their CS rep, Matt, found that the entries are available by viewing the source for the “View Form Entries” browser window (where the Export Entries option should appear). The entries are embedded in JavaScript and begin with: var form data = [{“weebly_id”: … and with each entry/row beginning with: {“weebly_id”:”attribute-value” and each attribute/field/column-value pair listed as “attribute-name”:”attribute-value” with a colon separating the attribute-name and value — both enclosed in double quotes and separated from other pairs by commas. Each entry/row is enclosed in curly braces ({}). You can copy and paste the entries into a text editor and save with a CSV extension and then open and parse in Excel using macros or VBA code (Not sure how Google docs/apps users could accomplish this other than custom scripts or other code to reformat the CSV). Not ideal but better than nothing. Again, just wanted to make sure Hostmonster’s support staff — “Matt” in particular — were given credit for their efforts.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.