Form fields lenght setting (Select fields) and massive table import

Applications Forms
#1

Dear all,

I’m testing Scripcase and I found it so nice.
I’ve a complex form to build up and several “Select” data type field.
This field are displayed correctly but they are too long for the total width of form (3 columns display). It means that quite half form is out of the screen and user need to scroll it orrizontally to see other fields. How can arrange the fields lenght or position in detailed way ?

I need to upload data from external CSV file into tables. Is there an easy way that end user can do using a button or something similar ? How have I to develop the application who reads a csv file ?

I have a screenshot but I don’t know how paste it here.
Many thanks
Giovannino

#2

Re: Form fields lenght setting (Select fields) and massive table import

Edit the css of the field, you can limit the width of the object …

Grid already exports in csv format, or if you want a different format we can do a code wuickly, its easy.

use http://imageshack.us/ to upload imagens :slight_smile:

#3

Re: Form fields lenght setting (Select fields) and massive table import

Thanks for prompt reply.
I’ve tried different width i.e. 300, 200, 100 on specific field with type “select”. It seems that it doesn’t care about my modification. It’s about automatic overall setting

http://img811.imageshack.us/img811/1644/fieldlenght.jpg

For second question was about IMPORT data FROM a CSV file.
Is there a standard application or way to do that.
The application is about assets management and sometime user has huge quantities of data to upload.
Avoiding the use of manual entry (i.e. 50 PCs with similar data but different inventory serial number) how can I help user from within SC application. ?

Many thanks
Giovanni

#4

Re: Form fields lenght setting (Select fields) and massive table import

Seems like for your second question you are looking at importing data to your database so that you can use the grid or form to display the data to the user.
If this assumption is correct then you need a php program that would read your input CSV file and load the new records to the database table.
You can also use a Database utility to do the load if no edits to your input data are necessary.

I hope this is what you asked.

#5

Re: Form fields lenght setting (Select fields) and massive table import

If is mysql, mysql already have native functions to import data from sql, csv or other files format.

See more at http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Just create a blank application to execute the command using Exec(…) like a shell.