Changes

Jump to: navigation, search

Template:July2021Upgrade

507 bytes added, 17:59, 24 June 2021
m
Updated Default Autoloader Behavior to Process Pound Signs for CSV Import
<!--124506 - Home Depot file upload security-->
====Updated Default Autoloader Behavior to Process Import Pound Signs for CSV ImportUpload====A new toggle was added 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 all pound signs are treated as data.
Smartstaff
2,357
edits

Navigation menu