Text Object Import Worksheet

Administrator
Administrator Member, Moderator, Administrator Posts: 2,506
edited 2010-10-13 in Download section
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.

Comments

  • RadoA
    RadoA Member Posts: 4
    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
    jhoek Member Posts: 216
    Thanks. Could you please send me the file that failed to import?
    Kind regards,

    Jan Hoek
    Product Developer
    Mprise Products B.V.
  • RadoA
    RadoA Member Posts: 4
    It is the TXT file included in instalation ZIP.
  • jhoek
    jhoek Member Posts: 216
    I see what you mean & will look into it ASAP. Thanks for reporting this!
    Kind regards,

    Jan Hoek
    Product Developer
    Mprise Products B.V.
  • jhoek
    jhoek Member Posts: 216
    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!
    Kind regards,

    Jan Hoek
    Product Developer
    Mprise Products B.V.

Categories