Changes

Jump to: navigation, search

Template:July2021Upgrade

8 bytes added, 18:00, 24 June 2021
m
Updated Default Autoloader Behavior to Import Pound Signs for CSV Upload
The default behavior of the autoloader has been updated for CSV and TXT file types to import lines containing pound signs ( # ). Previously, a pound sign at the start of a line would have been ignored as a comment line and not imported. Depending on the format of you imported file, multi-line data containing pound signs within values, such as an address field, may have also caused issues and been ignored by the autoloader. To force the autoloader to treat values beginning with pound signs as comments, you will have to turn on a new toggle called '''Ignore comment lines denoted by pound symbol ( # )'''. When this setting is toggled ON, rows ''starting'' with a pound symbol ( # ) will be treated as comments and skipped during processing. You can still process data with pound symbols with this setting ON if you wrap the entry with the pound symbol in quotes (Example: John, Smith,"#123 Peter Street"). If the new setting is OFF, you can now have a pound sign in your data (Example: John, Smith,#123 Peter Street) and it will still be processed as data. To see the new setting, navigate to '''Menu Icon''' > '''Global Settings''' > '''Autoloaders''' > Edit the desired autoloader > '''File Layout''' tab.
<u>'''Note:'''</u> Import wizards do not have this toggle and as such therefore all pound signs are symbols will be treated as data.
<!--125115 - Add option to allow # character if encountered in an imported file-->
Smartstaff
2,014
edits

Navigation menu