Problems with splitting items

[David_F]

hi Kinook,

I have worked out what (for me anyway) causes the error I reported earlier in relation to splitting an item. I can reliably produce it if in a database I try to split an item, and the options I have set under Import do not correspond with what I am doing.

E.g. if I try to split an item but the "Split text on separator" box is unchecked, I get the error message as previously noted: "ItemAttribute table references missing row" etc. Or if the box is checked, but the item does not contain separators corresponding to what is in the separator box in Options, I get the error message. At this point if you Undo enough you come out of the error message; but I suspect if you keep trying to use the Split command when things don't match up as described above, you can end up as I did with other problems: missing template folder etc.

So now I know how to avoid the error happening - but it doesn't seem a very "forgiving" way of doing things...

cheers

David F.

[kinook]

I wasn't able to reproduce that behavior. Can you ZIP and post or send a database that can demonstrate the issue? Thanks.

[David_F]

Will do... but just out of curiosity, on your system, if you try to split an item, and it can't be split (separators aren't present, "split"option isn't checked), what happens? Does it just fail silently?

[cnewtonne]

I'm able to reproduce an error that seems to be related to undoing a split operation if the split parent is first child of a root item.
https://www.kinook.com/Forum/showthr...2345#post22345

[cnewtonne]

I'm able to reproduce the 'error pasting data: foreign key ...'

1. Download the urd file from https://www.dropbox.com/s/bponofyugf...-data.urd?dl=0
2. Verify option / 'split text on separator is checked'
3. Verify options / text separator value is null
4. Go to info item 'Testing split errors' & drag its contents to tree root 'My Data'
5. Should get the error

Thanks

[David_F]

hi cnewtonne,

haven't been able to download the db, but that is the same error message I get. What is meant to happen when you do this? If I drag some text over to my Home icon, whether this text has separator text within it or not, I just get an item created under Home with that text in it.

David

[kinook]

Originally Posted by David_F

Will do... but just out of curiosity, on your system, if you try to split an item, and it can't be split (separators aren't present, "split"option isn't checked), what happens? Does it just fail silently?

The Split text on separator does not apply to the Item | Split command. It applies when importing or pasting text into UR -- the Separator text will be used to create multiple items, splitting the imported text on the separator.

If the separator text is not found when splitting, it creates a single item. Although I did find that if Separator text is empty, UR will hang when splitting an item (or importing text with Split text on separator checked). We'll fix that.

[kinook]

The latest download (6.1.0.2) fixes the following issues:

1) Hang when splitting or importing item and Tools | Options | Import | Separator text is blank

2) Error undoing after splitting or importing item at root of tree

3) Updated the help to document the import options applying to Split and Join commands

4) Dropping text not honoring Split text on separator import option

[David_F]

Sorry Kinook, I don't want to drag this out, and I appreciate the work you've done, but I still have a problem with this new version.

My basic case is an item containing the lines:

item 1
item 2
item 3

I want to use Item > Split to turn this into three items. In Options > Import, in Separator Text I put two carriage returns. I understand now that the "Split Text on Separator" option isn't relevant for this operation so I just leave that unchecked.

When I now do Item > Split, I get the same error message as before. However, if I press ctrl-Z a few times, I get to a point where there are the three items, as originally intended.

So I can get to the objective, but it's an awkward way to do it and it makes me a bit wary of using the feature.

[kinook]

Does that occur in a new database?