Entering multiple records at once

4 posts by 4 authors in: Forums > CMS Builder
Last Post: November 30, 2009   (RSS)

By keith_s - November 27, 2009

I have set up a section editor that allows rows of data to be entered with each row containing about 10 columns (or fields). This is numerical data for a client.

The section editor is a multi-record type. The issue that I've run into is that when entering records, only 1 record can be entered at a time. This, of course, is not normally a problem since it is the standard way of entering data manually. Each record can be thought of as simply a row of numerical data in different columns. Is there any way possible to enter several new records ("rows") at once before "saving", like, for instance, MS Excel would allow you to do?

It would really save my client quite a bit of time entering data, but I think what I'm wanting to do is not possible realistically, but thought I'd ask.

Thanks,
Keith D Sellars
WebGraffix Media Solutions, LLC
http://www.webgraffix.com

Re: [webgfx] Entering multiple records at once

By Donna - November 27, 2009

Hi Keith,

Is it all the same information going into the field? Would setting a default value for those fields work?
Donna

--
support@interactivetools.com

Re: [Donna] Entering multiple records at once

By gkornbluth - November 29, 2009

I've been using Navicat http://navicat.com/en/products/navicat_mysql/mysql_overview.html to do some fairly complex data manipulation by exporting my table to an Excel spread sheet, manipulating the date, and then importing the excel spread sheet back as a MySQL table. They've got Windows, OSX and Linux versions.

Hope that helps.

Jerry Kornbluth
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php