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

cathber

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

MrC

@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

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

@cathber,

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

cathber

Yes

MrC

@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

Ok I've the same view

MrC

@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

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

@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

Norton

MrC

@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

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

@cathber

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

cpan   XML::XPath  Date::Calc

and then continue from step 3d.

cathber

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

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

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

MrC

@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

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

MrC

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

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

As I live in a sky resort

Your life sounds very rough.