Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 12-23-2007, 12:32 AM
Logik Logik is offline
Registered User
 
Join Date: 02-13-2007
Posts: 4
Question re: Item Title

Hello to all,
I have a question I'm hoping one of the experts can answer. I've been using UR for the last year primarily for GTD, and first now do I see the potential for projects and workflow. Right now I manage many parts of projects in Excel, and it occurred to me that if I created Items and Attributes and imported them in, I could create a "drag-and-drop" type of system for the projects I manage, including importing .csv files from Excel. The problem for me is the Item title after I've brought the data in. For example, let's say I have a list of servers for a particular customer in Excel. I have columns containing information on each server including name, IP address, etc. I create a Template in UR called Servers and create all the Attributes that match my columns and have them on that Template. I step through the import process and match the columns to the Attributes. The Import completes and all my servers are in.... But in the Explorer pane they are labeled "Server", "Server (1)", "Server (2)", etc. This isn't very useful, particularly if I have to click on each server to be able to see the name (which is one of the Attributes) and I may have hundreds of servers for a particular client. Am I doing this incorrectly, or is there any type of workaround? Selecting each item and renaming it afterwords would be way to time consuming and take away any productivity benefits gained from using UR in the first place.

If this isn't an available option and would be time consuming to implement, I would be happy if when importing a .csv there was an option box that read something like "Have Item Title equal value in Attribute <dropdown>, any items with a blank value in this Attribute will not be created".

Thanks in advance for anyone's comments!
Reply With Quote
  #2  
Old 12-23-2007, 01:39 AM
ashwken ashwken is offline
Registered User
 
Join Date: 10-16-2005
Location: Blairsville, GA USA
Posts: 431
Logik,

On the Excel side, create a column (attribute) named Item Title or rename an existing column.

If this column name is present in the CSV it should be picked up automatically by the mapping dialog of the CSV import, or should be available in the drop-down list once a Template is selected as the import mask.

A couple more things to be aware of when importing CSV:

Logical fields need to be in the form of Yes=1 or No=0 to be recognized by the UR Yes/No Attribute Type. These values can be quoted (character) or unquoted (numeric) in the CSV.

A text string of values, separated by the ";", can be imported to User-Defined Keywords.

HTH
Reply With Quote
  #3  
Old 12-23-2007, 01:47 AM
Logik Logik is offline
Registered User
 
Join Date: 02-13-2007
Posts: 4
Thank You, ashwken!

It worked perfectly, just what I needed!
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 12:46 AM.


Copyright © 1999-2023 Kinook Software, Inc.