Loading

Категории

Новости

Записи

HowTo's

Все посты

• 125 posts

  • 2010 (84)

  • July (1)
  • June (2)
  • May (1)
  • April (5)
  • March (44)
  • February (23)
  • January (8)

  • 2009 (16)

  • December (5)
  • November (4)
  • October (3)
  • September (1)
  • June (1)
  • January (2)

  • 2008 (9)

  • December (3)
  • November (2)
  • October (1)
  • August (1)
  • May (1)
  • January (1)

  • 2007 (8)

  • October (1)
  • September (1)
  • July (1)
  • June (1)
  • April (1)
  • March (1)
  • February (1)
  • January (1)

  • 2006 (3)

  • December (1)
  • June (1)
  • February (1)

  • 2005 (5)

  • August (1)
  • July (1)
  • May (1)
  • March (1)
  • January (1)

Import excel to web database

We are very happy to introduce Import from Excel functionality in My Task Helper. Previously you were only able to create your database from scratch. But now you can move from your Excel databases to online database in a few clicks.

Please, follow few simple steps:

Signup

Create database

Create form

Copy Excel data

Assuming you have Excel file. Copy it's content and paste to MTH.

IMPORTENT NOTE: if you have any carriage returns in your data cells it will break all import. Please, make sure to do not enter any tabulations or carriage returns in your Excel file. You will be able to do it in MTH then.

Import Excel

Press Import and you are on the go!

Records imported

Please, notice that your columns now represents form fields. All your data located on Records page.

Database widget

And you can easily integrate your data table to your own page with a few clicks.

Add more data to existent database

It is obvious that you should be able to update your data using Import at any time. You may want to add new records or update entries.

Add new records using Import

On Records page you should see Import link, using which you can add or update your data using Excel Import. Procedure is the same as when you migrating from scratch. Just copy your excel file content and paste to import text area. Remember that you should include also first row with column names. The order of fields doesn't matter, but presense of this fields on your form is important. Because if you don't have such fields they will be created. And if you renamed fields in Form Builder but not in Excel you will have twice more fields. Which is not what you want. But using this trick you can update your database structure along with adding or updating records.

Update records using Import

Also you can update existing records when key data matches. Choose column name (Unique field) to use as a key for comparing data. If your new record contains the same value in this column as one of your existing records, the existing record will be updated with the new data. If no match is found, a new record will be created.

Remember that you always can export your updated data back to Excel :)

The brief description of free online form builder My Task Helper.

Today online files storage spread all over the world. It is easy and very useful. For data storage you need only web browser. You have a choice, what web service to use.

We represent new system – My Task Helper My Task Helper – free web service for online databases creation. You can store any data (text, photos, movies etc). Build web form with any fields you need and start to create online database. If you have online business this web tool can help with data storage. Embed your database into web page and use it with your friends.

Main features:

• various fields types;
• form customization;
• free online storage;
• teamwork;
• import/export from Excel;
• search functionality;
• free service;

In this post I would like to describe the main system modules.

Form Builder

This module has been developed for form creation. You can add into the form the any fields you need. In this module users can change some field options: size (in pixels), description (instruction for users), auto-complete (list of values), validation (for entered data checking), default.

Widget Builder

It has been developed for web form customization. If you decided to embed your form or database to website use this module. You can change next form options: background color, text color, label placement, form name, form name font size, form name text color, show name(yes/no), form description, form description font size, form description text color, you can add logo into the form, logo width, logo height, form height, form width, form font size, form font-family etc. More about Widget Builder read in this blog post. Integrate your form using only copy/paste functions.

Records

In this page users can add records into them databases. You also have export functionality (export to Excel, export all files) and search function. With My Task Helper – free form builder, you can make online forms such as contact/registration etc in few easy steps. You can see My Task Helper form examples in the Howto's page. If you have a questions about system functionality please visit FAQ page or Contacts page.