Log In

Log In



Not registered yet?


Reset password Activation link
Forums
Tag "Excel"

Field Names in Table View

Publication date: August 8, 2018

Is there any way to have the field names stay on the screen (or freeze like in Excel) so that I can see the field names as I step down through the records?

How can I import data from xml files?

Publication date: August 8, 2018

How can I import data from xml files?

Download feature

Publication date: August 13, 2018

Great application. Everything I need. However, it would be great to have a download as pdf or excel feature on the table, instead of export.

RE: Duplicate entries in database

Publication date: August 13, 2018

Dear Sir or Madam:

I am finding duplicate entries in my database after entering a search term. To recreate the issue, set your search for “ALL” “like” “drugs” in the three search lines. Hit enter. You should see 657 rulings.

I transcribed all of the rulings into an excel file and have been finding dozens of duplicates. What I’m noticing is that anything above 500 tends to be a duplicate. I have confirmed that I have not accidentally entered the information twice (though I’m sure this is still a possibility, generally speaking). The database itself is reporting duplicates after a search.

For example, ruling #39 (of 657) and ruling #514 (of 657) are the same. I’ve confirmed that this ruling is listed a single time in the database, but it shows up twice in the list when I enter the above search terms.

Can you help me out with this?

Thank you,
S.Matt Read
GREY2K USA

Import from excel

Publication date: August 13, 2018

I am stuck with this message
" Please, wait while previous import finishes, then you’ll be able to start new one." It has been over an hour since I tried to import an excel spreadsheet. Can you assists me?

Formatting Inquiries

Publication date: August 13, 2018

Hello Igor and team,

Thank you for your previous help… much appreciated.

I have a couple of questions if you don’t mind.

Q1 (attached screenshot) – when trying to export PDF in the Record table that I made in Arabic, I get the letters all scrambled up. I tried using the Language icon in the records builder to switch the language to Arabic, but no luck. The Excel seems fine and so does the Print option. Only extorting to PDF seems to not work.

Q2 (attached screenshot) – when reviewing the Record table with a picture inserted, the picture doesn’t take a bigger size. Clicking on it opens the original size, but I’m trying to have a single records sheet printed with the picture bigger and more visible. I edited the image size in Forms > Upload > Advanced Options, but no matter the size I set, it only affects the Embedded Table Preview, not the Record that I created. Is there a way to make the pictures bigger in the Records table?

Thank you so much for your help.
Tamer

export excel sends no excel file

Publication date: August 14, 2018

Hi Igor

hopefully last question on this project.
The export is not working correctly. I can’t get an excel file back.
see example

import excel files

Publication date: August 14, 2018

Every time I try to import a file from excel I am unable to do so. It deletes the file and will not import. I have well in excess of 800 contacts to import and re-creating from scratch is not a possibility. Am I doing something wrong?

Is it possible to upload an excel file as template for exporting?

Publication date: August 14, 2018

Although I can export the table in plain excel format and then copy all the data to the already formatted excel file and then adjusted to match the destination format, I have to do this every day in order to make it suitable for a report. It would be a great time saver if the exported xls file is already in the desired format. I think this can be done if I upload the prepared formatted excel as a template and set it as the template of each export.

form with a search button

Publication date: August 15, 2018

Does MTH have the capability to create a form with a search button that makes a results page appear when search button is clicked?

In other words, would the example below be possible?

Could I upload an excel file of family names and addresses. Then make a form that has a text field and a button. The text field is for the user to type in a family name. The button is a search button. Once the button is clicked, a results page appears with family name and address (from the excel spreadsheet) that match the users input.

Thank you for any feedback!

export to excel from table widget

Publication date: August 15, 2018

How and where do I define e-mail address to which exports are sent? (per report if possible)

PDF/XLS export not working

Publication date: August 16, 2018

It’s been many weeks since we’ve been able to export any search of filter results as either PDF or XLS. I’ve tried multiple searches as simple as 2 line results and nothing will export. Help?

Import Not Working

Publication date: August 16, 2018

I tried to import an excel file today. On clicking the import link a form opens but fails to load wider than a few millimetres

Excel file doesn't contain relationship columns

Publication date: August 16, 2018

I found that when using the Excel export feature in an embedded iframe coded webpage, the created file does not contain the relationship columns.

If you export the same form by logging into MTH account, it will actually export a proper file with all the columns in place.

If you need extra information let me know and I’ll be glad to provide it.

Thanks in advance!

Showing Import Progress status while importing XLS or CSV database

Publication date: August 16, 2018

It seems to just stall when you try and upload. It just says be patient while we are uploading……

Export as Excel

Publication date: August 20, 2018

I think it would be an excellent addition if we had the option to export to Excel via download rather than email. I just discovered that you have download capability built into the Team member export (so it may not be a complicated addition) — and it would be a most useful addition for my clients.

Thank you,

Russell

Update existing entries via import (match on record ID)

Publication date: August 20, 2018

This is a must-have feature that was incredibly useful in DabbleDB. As a application developer, it is often necessary to have users outside the database update information that is inside the database. In this situation, it is critical to be able to bulk update existing records. There are also cases where it is simply faster to manipulate/update data in bulk in Excel and import it back into the database.

Here’s the link to the DabbleDB description of the feature: http://blog.dabbledb.com/2008/10/plays-well-with.html

Online (but not ecommerce) Order Process

Publication date: August 20, 2018

Hi

what we are looking to provide is a process to make online ordering (but not ecommerce) easier. It also needs to provide the facility to have the data entered during the process exported to a multi line csv or excel file.

The process envisaged will have 3 steps: see attached document http://mytaskhelper.com/images/data/btxTV1vGHiI4Ckm1CRK4B8/dQrgSYd95eW53OJCuP-Fdt/orderprocessspec.pdf for images of required inputs & outputs

Step 1: Enter Client / Order Header info
- a standard form to collect name, email, delivery & invoice addresses etc
- (no problem to achieve with existing functionality)

Step 2: Enter multiline information
- a form to collect the product detail and the personalisation requirements for each product
- needs to be linked to Client Details entered previously (note: I envisage that these 2 collection steps will be 2 discrete forms as in an e-commerce checkout environment – however it doesn’t have to be so!)

Step 3: Output ‘Order Details’
- as now send an email to the form administrator
- provide export capability to allow excel file to be output with the collected information – as per the layout attached


Thanks
John

Import from XLS/CSV File

Publication date: August 20, 2018

Instead of importing from a set of records that have been copied & pasted from a text file, it would much appreciated to be able to just Browse and select a file that’s either an XLS or CSV type of file, with the option of specifying that it has a header row or not.

exporting and importing data from and into excell

Publication date: August 20, 2018

Thanks you for your great work!

Question:

I like the option importing and exporting from excell files into and out of the database system!

I was wondering if it would be possible to export a ’ selection’ of the records into an excell spreadsheet.
For example, after using the search options, you get a useful selection and want to export it to an excell spreadsheet

so far i seems only possible to export the
whole database, rather than the selected record.

thanks,
Christien

Export of Databases data

Publication date: August 20, 2018

We need to be able to export database data to xls, csv.