Text Object Import Worksheet

Administrator

Text Object Import Worksheet
After accidentally overwriting objects (while importing them as text) one too many times, I decided to create an Import Worksheet for text imports. In this initial version, the comparison logic is a bit simpler than C/SIDE's Import Worksheet: if the object already exists, the default action will be set to Skip (as opposed to Replace), leaving it to the user to make a smart and well-informed decision about whether to overwrite (Replace) or not.

In addition, you can export (a selection of) individual objects from the Import Worksheet.

I'm assuming standard "Danish" formats for dates and times in the object properties.

Please be careful when importing objects. I'm afraid I cannot be held responsible if, by your own fault or my tool's, an object gets overwritten unintendedly.

Note: Because of the use of the C/AL statement IMPORTOBJECTS, you need NAV 2009 SP1 to run this object.

http://www.mibuso.com/dlinfo.asp?FileID=1206

Discuss this download here.

RadoA

It's great but it need some corrections. I tried included text object file and it is not working (wrong format of file - empty lines). But files exported directly from NAV are OK.

jhoek

Thanks. Could you please send me the file that failed to import?

RadoA

It is the TXT file included in instalation ZIP.

jhoek

I see what you mean & will look into it ASAP. Thanks for reporting this!

jhoek

Interesting situation, here.

I exported the objects from my development database, and compared them to the objects on mibuso.com. It turns out that the text object file on mibuso.com contains an additional carriage return at the end of each line (so: CRCRLF). I suspect it has something to do with the fact that I e-mailed my objects to Luc, the webmaster here, using a Mac, which uses different codes for line ends.

Let me try and send Luc a new copy, and see if that works.

Sorry for the inconvenience & thank you for your patience!