English > Support

Importing from Excel

<< < (3/3)

nostra:
PVD accepts length as hh:mm:ss or a number of minutes without text after or before it.

rick.ca:

--- Quote ---PVD accepts length as hh:mm:ss or a number of minutes without text after or before it.
--- End quote ---

Thanks. You saved me from more testing.  :P

...So, the most effective way to deal with this sort of situation is to convert the form of the data using Excel. In this case, =TEXT(LEFT(Length,LEN(Length)-4),"0") would do the trick (replace Length with a reference to the cell with length in the form "123mins").

"hh:mm:ss" is another matter. If the data is already in this form, in text, the plugin will recognize it. If it is not text, but a time-value the cell is formatted to display like this, it will need to be converted to text with =TEXT(Length,"hh:mm:ss").

Once the new column with the formulae is displaying the data in the correct format, use Copy-Paste Special-Values to convert it to text. Now that it no longer relies on the original data, that column may be deleted.

ruffa:
if it accepts 'number of mins' without text after it then i will try the method of using the replace the word mins with nothing, then try to import again i guess.thanks for the suggestions

buah:
Assuming that this is proper topic for my question, that I'm not familiar with databases, and hoping that my question won't arise at 4chan, I'm asking someone to help me:

Which value (formula, expression) I have to enter in a MS Excel, so when it is imported to a referent PVD cell it produces PVD's "Wish" field - checkbox to be checked? Is it possible any way?

buah:
OK, I figured it out. For others who might have dilemma: value in Excel's cell - "1" for PVD's checkbox checked, and "0" for unchecked.

Navigation

[0] Message Index

[*] Previous page