Direct CSV import of scanner destinations

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mrwho
    Major Asshole!

    Site Contributor
    2,500+ Posts
    • Apr 2009
    • 4303

    Direct CSV import of scanner destinations

    Good afternoon all.

    Is there any brand/model of MFP that will allow direct import and export of address book data into .csv files without the need of proprietary software?

    Thank you.
    ' "But the salesman said . . ." The salesman's an asshole!'
    Mascan42

    'You will always find some Eskimo ready to instruct the Congolese on how to cope with heat waves.'

    Ibid

    I'm just an ex-tech lurking around and spreading disinformation!
  • wav
    Trusted Tech

    Site Contributor
    250+ Posts
    • Oct 2021
    • 272

    #2
    Re: Direct CSV import of scanner destinations

    hi,
    see this it maybe helpful

    Import/Export (hp.com)

    Importing the Address Book of the Machine | User Guide | IM 350, IM 430 (ricoh.com)

    [SETTING MODE]|System Control|BP-70M65|09-07_021|manual download|MFP / Copier / Printer products|Office solution: Sharp (global.sharp)

    Comment

    • rohit34hj
      Junior Member
      • Jan 2024
      • 2

      #3
      Re: Direct CSV import of scanner destinations

      Since you have multiple rows of items in your file NS doesn't know if you want them all in 1 transaction or separate transactions. Since you are doing ADD here, you need to provide a Document# or ExternalID that is the same on all rows that you want grouped together onto 1 transaction. If you have auto-numbering turned on and you disallow overrides, then the Document# you import here won't actually be saved onto the transaction (because it will get an auto number instead) but the CSV importer will use the Document# to know what rows you want batched together onto the same 1 transaction.

      Comment

      • dalewb74
        Service Manager

        Site Contributor
        1,000+ Posts
        • Feb 2018
        • 1064

        #4
        Re: Direct CSV import of scanner destinations

        many of them will allow export import, but not between different brands. and some won't allow if the age difference is a few years different. i don't know of any that uses actual csv file.

        Comment

        • slimslob
          Retired

          Site Contributor
          25,000+ Posts
          • May 2013
          • 35063

          #5
          Re: Direct CSV import of scanner destinations

          Originally posted by dalewb74
          many of them will allow export import, but not between different brands. and some won't allow if the age difference is a few years different. i don't know of any that uses actual csv file.
          I don't know about other manufactures but Ricoh has a way to convert their WIM export file to a csv file. I had to use it once for a customer who wanted to have the same address book on the their MP C3503s and on their computers that were using LAN Fax.

          Comment

          • rohit34hj
            Junior Member
            • Jan 2024
            • 2

            #6
            Re: Direct CSV import of scanner destinations

            Since you have multiple rows of items in your file NS doesn't know if you want them all in 1 transaction or separate transactions. Since you are doing ADD here, you need to provide a Document# or ExternalID that is the same on all rows that you want grouped together onto 1 transaction. If you have auto-numbering turned on and you disallow overrides, then the Document# you import here won't actually be saved onto the transaction (because it will get an auto number instead) but the CSV importer will use the Document# to know what rows you want batched together onto the same 1 transaction.
            9apps apk

            Comment

            • rrrohan
              Service Manager

              Site Contributor
              1,000+ Posts
              • Sep 2011
              • 1971

              #7
              Re: Direct CSV import of scanner destinations

              if you can print out the address list you can take a photo then use the excel option of import data from image

              it will OCR the text and then you can make your own CSV file

              Comment

              • Hart
                Trusted Tech

                100+ Posts
                • Feb 2024
                • 236

                #8
                Re: Direct CSV import of scanner destinations

                Sharp can do it natively on the newer units (CR4.5 at least).

                Old method with proprietary format
                2024-04-12 09_04_22-Window.jpg

                New method with standard CSV
                2024-04-12 09_04_35-Window.jpg

                Comment

                • Saturn
                  Trusted Tech

                  Site Contributor
                  100+ Posts
                  • Nov 2023
                  • 147

                  #9
                  Originally posted by slimslob
                  Re: Direct CSV import of scanner destinations

                  I don't know about other manufactures but Ricoh has a way to convert their WIM export file to a csv file. I had to use it once for a
                  customer who wanted to have the same address book on the their MP C3503s and on their computers that were using LAN Fax.
                  From the IM series onwards you can download the address book directly as a .csv file. If we need a .csv file from older Ricoh models,
                  we save the address book as a xxxxxxx_addr.udf file, import it onto an IM machine and save it as a .csv file.

                  Safe as CSV.png
                  I don't care about who your father is, as long as I'm fishing here, you won't walk on water.

                  Comment

                  Working...