Read first: Previous version support information

Trying to import a csv data from Safe in Cloud in csv [Solved]

cathber
cathber
Community Member
edited January 2019 in 1Password 7 for Windows

Trying to import a csv data from Safe in Cloud in csv but all password are in user name, the user name are in password!
Should be long before correcting all. Is it a way to switch user name and password in their place?

1Password Version: 7.3.657
Extension Version: Not Provided
OS Version: Win 10 Pro 1809
Sync Type: safe in cloud
Referrer: forum-search:csv import

Comments

  • MrC
    MrC
    Volunteer Moderator
    edited January 2019

    @cathber ,

    Safe in Cloud has several different categories that you won't be able to import directly into 1Password. And you'll need to edit those out of any CSV file.

    Instead, I'd recommend you use the safeincloud converter, which is part of the converter suite. Use version 1.11 in Testing Bits, mentioned in the first post of the thread. The README.pdf will walk you through the process. The converter runs quickly, and can manage all of your stock categories.

    $ perl convert_to_1p4.pl -v safeincloud safeincloud_mac.xml
Imported 15 items
Exported 4 note items
Exported 2 creditcard items
Exported 2 passport items
Exported 5 login items
Exported 2 membership items
Exported 15 total items
You may now import the file /Users/MrC/Desktop/1P_import.1pif into 1Password

    Once you have the .1pif file, you can import into any 1Password desktop app.

    If you don't want to go that route, you'll need to edit your CSV according to How to create a 1Password compatible CSV file. This format can only handle Logins on Windows, or 1Password.com.

  • cathber
    cathber
    Community Member

    Hi thanks for the answer, but that's not working. I've downloaded the converter suite installed it on my computer following the read me file I download and extract the strawberry perl zip file and follow the advices in the readme but nothing work as the %USERPROFILE%\Desktop\convert_to_1p4\install_modules.bat command won't work
    I've try a lot of command but only one work loading the convert_to_1p4\install_modules.bat but I receive the message
    Loading internal logger. Log::Log4perl recommended for better logging
    CPAN: CPAN::SQLite loaded ok (v0.212)
    CPAN: LWP::UserAgent loaded ok (v6.36)
    mkdir C:\myperl\cpan\sources\authors: Permission denied; AccÞs refusÚ at C:\myperl\perl\lib/CPAN/FTP.pm line 540.
    As I'm not a command line frequent user, i'm lost in the dark
    Thanks for help

  • MrC
    MrC
    Volunteer Moderator

    @cathber,

    Let me verify that there are no issues on Windows 10 1809. I assume you are on a 64-bit system?

  • cathber
    cathber
    Community Member

    Yes

  • MrC
    MrC
    Volunteer Moderator
    edited January 2019

    @cathber ,

    OK, I did a full cleanup, and then installed as per the README.pdf on Windows 10 1809 x64. It all worked fine.

    Two questions:

    If you go look inside of C:\myperl, where you placed your Strawberry Perl extraction, do you see the following?

    Are you on a corporate system that might be protecting certain operations?

  • cathber
    cathber
    Community Member

    Ok I've the same view

  • MrC
    MrC
    Volunteer Moderator

    @cathber ,

    Close and command shell windows.

    Double click the "portableshell.bat" file to launch a new command shell window.

    manually type in that command shell window:

    cpan Text::CSV

    and tell me if that works.

  • cathber
    cathber
    Community Member

    I've the same message
    C:\myperl>cpan Text::CSV
    Loading internal logger. Log::Log4perl recommended for better logging
    CPAN: CPAN::SQLite loaded ok (v0.212)
    CPAN: LWP::UserAgent loaded ok (v6.36)
    mkdir C:\myperl\cpan\sources\authors: Permission denied; AccÞs refusÚ at C:\myperl\perl\lib/CPAN/FTP.pm line 540.

  • MrC
    MrC
    Volunteer Moderator

    @cathber,

    The Permission denied indicates that you, as a user, are not being allowed to write to the folder C:\myperl\cpan. Yet, you created this area when you extracted Strawberry Perl there. There are only two things that would prevent this: 1) antivirus software, or 2) your Windows administrator on a corporate environment is preventing users from performing certain activities.

    Do you have some AntiVirus installed (if so, which product), or is this on a corporate network that may be preventing certain activities?

  • cathber
    cathber
    Community Member

    Norton

  • MrC
    MrC
    Volunteer Moderator

    @cathber

    Try Disabling Norton completely. It is overly aggressive. You may need to add the C:\myperl area to its list of exclusions. I have no idea how this is done anymore (I have not used Norton in over 15 years).

    Alternatively, you may be able to delete C:\myperl and re-extract the archive in your home folder. But this will not work if your user profile contains a space in it (such as C:\Users\Cath Ber). This is an limitation when building some of the cpan modules.

    If this is all getting to be too much for you, and you want remote help, I'm happy to assist you. I've done this for hundreds of people, and will guide you ahead of time what to do, so that you do not reveal any confidential information. You'll share your system remotely with me, we'll both see your system's screen, and I'll ask permission via chat before I control anything. You can disconnect / control the session when you wish, and only you can allow me to enter. If you wish to work this way, send me an email - it is at the top of the convert_to_1p4.pl script.

  • cathber
    cathber
    Community Member

    Thanks, I've look at the permissions and found that I can only work on the perl directory as admin, I add permissions for my user id and the cpan text::CSV work now
    C:\myperl>cpan Text::CSV
    Loading internal logger. Log::Log4perl recommended for better logging
    CPAN: CPAN::SQLite loaded ok (v0.212)
    CPAN: LWP::UserAgent loaded ok (v6.36)
    Fetching with LWP:
    http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
    CPAN: YAML::XS loaded ok (v0.75)
    Fetching with LWP:
    http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
    Fetching with LWP:
    http://cpan.strawberryperl.com/modules/03modlist.data.gz
    Creating database file ...
    Done!
    Running install for module 'Text::CSV'
    Fetching with LWP:
    http://cpan.strawberryperl.com/authors/id/I/IS/ISHIGAKI/Text-CSV-1.99.tar.gz
    CPAN: Digest::SHA loaded ok (v6.02)
    Fetching with LWP:
    http://cpan.strawberryperl.com/authors/id/I/IS/ISHIGAKI/CHECKSUMS
    CPAN: Compress::Zlib loaded ok (v2.081)
    Checksum for C:\myperl\cpan\sources\authors\id\I\IS\ISHIGAKI\Text-CSV-1.99.tar.gz ok
    CPAN: Archive::Tar loaded ok (v2.32)
    CPAN: CPAN::Meta::Requirements loaded ok (v2.140)
    CPAN: Parse::CPAN::Meta loaded ok (v2.150010)
    CPAN: CPAN::Meta loaded ok (v2.150010)
    CPAN: Module::CoreList loaded ok (v5.20181130)
    Configuring I/IS/ISHIGAKI/Text-CSV-1.99.tar.gz with Makefile.PL

    Welcome to Text::CSV (v.1.99)

    You have Text::CSV_XS (v.1.37), so Text::CSV can work very fast!!

    Checking if your kit is complete...
    Looks good
    Generating a gmake-style Makefile
    Writing Makefile for Text::CSV
    Writing MYMETA.yml and MYMETA.json
    ISHIGAKI/Text-CSV-1.99.tar.gz
    C:\myperl\perl\bin\perl.exe Makefile.PL -- OK
    Running make for I/IS/ISHIGAKI/Text-CSV-1.99.tar.gz
    cp lib/Text/CSV.pm blib\lib\Text\CSV.pm
    cp lib/Text/CSV_PP.pm blib\lib\Text\CSV_PP.pm
    ISHIGAKI/Text-CSV-1.99.tar.gz
    C:\myperl\c\bin\gmake.exe -- OK
    Running make test
    "C:\myperl\perl\bin\perl.exe" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef Test::Harness::Switches; test_harness(0, 'blib\lib', 'blib\arch')" t/.t
    t/00_pod.t ............... # PERL_TEXT_CSV: undef
    t/00_pod.t ............... ok
    t/01_is_pp.t ............. ok
    t/10_base.t .............. ok
    t/12_acc.t ............... ok
    t/15_flags.t ............. ok
    t/20_file.t .............. ok
    t/21_lexicalio.t ......... ok
    t/22_scalario.t .......... ok
    t/30_types.t ............. ok
    t/40_misc.t .............. ok
    t/41_null.t .............. ok
    t/45_eol.t ............... ok
    t/46_eol_si.t ............ ok
    t/50_utf8.t .............. ok
    t/51_utf8.t .............. ok
    t/55_combi.t ............. ok
    t/60_samples.t ........... ok
    t/65_allow.t ............. ok
    t/66_formula.t ........... ok
    t/70_rt.t ................ ok
    t/71_pp.t ................ ok
    t/75_hashref.t ........... ok
    t/76_magic.t ............. ok
    t/77_getall.t ............ ok
    t/78_fragment.t .......... ok
    t/79_callbacks.t ......... ok
    t/80_diag.t .............. ok
    t/81_subclass.t .......... ok
    t/85_util.t .............. ok
    t/90_csv.t ............... ok
    t/91_csv_cb.t ............ ok
    t/fields_containing_0.t .. ok
    t/rt99774.t .............. ok
    All tests successful.
    Files=33, Tests=52205, 33 wallclock secs ( 3.16 usr + 0.58 sys = 3.73 CPU)
    Result: PASS
    ISHIGAKI/Text-CSV-1.99.tar.gz
    C:\myperl\c\bin\gmake.exe test -- OK
    Running make install
    Installing C:\myperl\perl\site\lib\Text\CSV.pm
    Installing C:\myperl\perl\site\lib\Text\CSV_PP.pm
    Appending installation info to C:\myperl\perl\lib/perllocal.pod
    ISHIGAKI/Text-CSV-1.99.tar.gz
    C:\myperl\c\bin\gmake.exe install UNINST=1 -- OK

    What to do next?

  • MrC
    MrC
    Volunteer Moderator
    edited January 2019

    @cathber

    Fantastic progress. Go ahead now and run the remaining cpan commands:

    cpan   XML::XPath  Date::Calc

    and then continue from step 3d.

  • cathber
    cathber
    Community Member
    edited January 2019

    Running cpan XML::XPath Date::Calc and after a long time I can continue to step 3d but
    Using the command cd %USERPROFILE%\Desktop\convert_to_1p4
    give The specified path was not found

  • MrC
    MrC
    Volunteer Moderator
    edited January 2019

    You would enter that into the command shell window, @cathber , but the exact path you supply to the cd command depends on where you extracted and placed the convert_to_1p4 folder. You should have the converter folder convert_to_1p4 on your Desktop.

    You can do the cd command one directory at a time. For me and my Desktop folder, it would be:

    cd C:\Users
cd MrC
cd Desktop
cd convert_to_1p4

    You would use your own username instead of MrC, of course.

    If any of those fails, then you know which directory doesn't exist. You can type dir after each of those commands to see the contents of the directory (folder).

  • cathber
    cathber
    Community Member

    convert_to_1p4 is on e: not on desktop should I copy and paste the dir to the desktop?

  • MrC
    MrC
    Volunteer Moderator
    edited January 2019

    @cathber

    You don't have to - you can instead do something like the two commands below:

     E:
 cd  E:\path\to\convert_to_1p4

    where you use the appropriate path. The first sets the current drive, the second changes directories.

    This is the reason in the README.pdf file I recommend specific path names for users, so they can avoid these troubles.

  • cathber
    cathber
    Community Member

    Thanks for your help. safein cloud database imported in 1password everything seems ok.

  • MrC
    MrC
    Volunteer Moderator
    edited January 2019

    That's great news @cathber !

    Hope you enjoyed the slopes. Now enjoy 1Password!

    Note: there were two issues here: 1) user did not have admin perms to install necessary modules, and 2) user had unzipped converter folder to a non C: drive and the README does not support this.

  • cathber
    cathber
    Community Member

    I've enjoy skying from 9 am to 2 pm even we're saturday, lot of people on slopes far more than other days of the week. As I live in a sky resort, I've just to take the bus in front of my home to be on slopes 5 minutes later especially when sun shines.....

  • MrC
    MrC
    Volunteer Moderator

    As I live in a sky resort

    Your life sounds very rough.

This discussion has been closed.