• Not Answered

bulkedit fails to import special characters

I'm trying to use bulkedit to mass create new modules. It regularly fails whenever it hits a "°F" even though it is in my engineering units file, and looks correct in the text file. Its such a common character, I'm hoping someone has a workaround for this? I already tried making the default units in the module subtype template "°F"

Updating Type: MODULE: Name: TI_8133ZSB
1: WARNING: The parameter 'AI1/IO_IN' is not found on the function block definition 'TI_8133ZSB'. It is ignored in the context of this usage ''
2: WARNING: Importing ATTRIBUTE_INSTANCE
1: WARNING: The name '░F' was not found in this context
2: WARNING: Unable to set engineering units for scaling parameter value
3: WARNING: IMPORT ERROR: IMPORT of MODULE with key TI_8133ZSB FAILED at line:2723 column:51. This could cause other serious import errors for related items in this file. Import is now resuming at the next item in the file.

I'm working on V15 today, but I've run into this on several versions of deltav.

3 Replies

  • I ran into a similar issue in the past. I don't recall the exact solution but I would try the following couple of things.

    1. Make sure you are using the excel bulk edit add-in save button, not the Excel application save button.
    2. Export a module that has been configured with the °F unit. Copy and paste from the export into the bulk edit sheet you are building for import, rather than type in the engineering units manually.
  • In reply to Jesse Delanoy:

    I had a similar problem with °C which was due to the text file I was importing from being in ASCII format. To be successful the text file must be in UNICODE format. Using the Excel Bulk Edit add-in save button ensures that the text file is saved as UNICODE.
  • In reply to Cedric Dawnhawk:

    Ok! I've got it sorted out now. I was using the excel bulk edit add in, but it was an old version. I grabbed the new one from the v15 bulk edit folder (D:\DeltaV\DVData\BulkEdit\BulkEdit_Support.xla) and that solved the problem.