Changes

Jump to: navigation, search

Template:July2021Upgrade

9 bytes added, 18:01, 24 June 2021
m
Updated Default Autoloader Behavior to Import Pound Signs for CSV Upload
<!--124506 - Home Depot file upload security-->
====Updated Default Autoloader Behavior to Import Pound Signs Symbols for CSV Upload====The default behavior of the autoloader has been updated for CSV and TXT file types to import lines containing pound signs symbol ( # ). Previously, a pound sign symbol 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 symbol 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 symbol 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 symbol 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 therefore all pound symbols will be treated as data.
Smartstaff
2,014
edits

Navigation menu