After importing data from SplashID, i cannot change credit card type on file

willym

I've imported my old data from SplashID 8 on my mac. all went well, but under the credit card info, i'm missing the option to select the credit card type (MS,Amex, etc). on new credit cards entered, i do have the field to choose the type.
Couldn't find anywhere how to add that field to existing cards info.
Thanks.

MrC

Hi @willym,

How did you do the conversion? With 1Password's internal converter, or the external utility convert_to_1p4?

willym

Internal import option on 1p5

MrC

When you Edit the credit card item, the type field should appear. Does it not appear for you?

SplashID does not export the credit card type, so there's nothing to convert and import (the best it does is export an icon index number).

willym

Exactly. It does not show, and I want to add it, as I have it for new records I've added.
On I ported records the type is just not there, nor any option to add one. I have date, text, name, and many others, but no type field.

Thanks for answering, hope for a solution soon :)
Willy.

MrC

Hmmm, I'm not sure how to test this, as I can't get the internal converter for 1Password 5.3.BETA-19 (530019) to work with a SplashID 8/Mac export. 1Password 5 just beeps and no import occurs. It may be that my data is more complex than the internal converter can handle, and SplashID 8/Mac won't export a single record (it is an awful, bug-ridden program).

You might want to try the converter I mention above.

willym

well, at the beginning it didn't work for me, so i exported to a csv file (and not encrypted, as the encrypted/password didn't work as well). only then it took the 250 records i had...
But still, fields missing i cannot add to the records (e.g. type of credit card)

MrC

I've been able to reproduce this. The internal converter is eliminating the fields with empty values, and you have no way to re-add the necessary key fields such as the CC Type.

I had to convert the SplashID/Mac v8 VID export to UTF-8 for 1Password to import it. The clue was in the log:

3/16/15 10:03:18.257 AM 1Password 5[11562]: 530019 [IMPORT:0x600000877500:] E importFileAtURL:ofType:subtype: | Failed to read import data: Error Domain=NSCocoaErrorDomain Code=261 "The file “sp8_exp.vid” couldn’t be opened using text encoding Unicode (UTF-8)." ...

willym

Well, now i know it is not only me.... now the question how this can be fixed. sounds strange that you cannot add fields you want in any case :)

MrC

I've mentioned it to the AgileBits folks - I'm sure they'll follow-up shortly.

You can add custom fields, however, fields in form fill categories need to be named, typed, and internally named specifically, since the 1Password code treats these specially (that's what allows the form filling). And that you cannot do as a user from the UI. Its just a bug - let's see how AgileBits responds...

willym

Thanks !

littlebobbytables

Hi @willym,

My role here in AgileBits is that of support, so when it comes to this sort of topic MrC is actually far more knowledgable than I. He's put a lot of time and effort into making his importers for various formats.

While obviously we need to get this resolved in terms of the greater picture my initial goal is just to get things resolved for you. My initial query then is how many items are we referring to? If it's one or two then probably the quickest resolution is a manual method of creating new Credit Card items and copying the relevant data over.

If we're talking about a couple more than that we'd want to find a cunning way to correct the existing ones. I exported all of the dummy Credit Card items in the demo vault and they all have the following

{"k":"cctype","v":"visa","n":"type","a":{"guarded":"yes"},"t":"type"}

where the data for the v field is the card type. Now I'm wondering what that looks like on the broken ones or if it isn't there at all. If it isn't there it might be we can add where necessary so as to at least (hopefully) allow editing in 1Password.

Let us know what you think.

MrC

FYI: The exported 1PIF (or copied JSON) is missing the entire cctype section. Adding that section back will create the type field, but it will be empty (but can be edited). To get the "visa" value to appear, you also have to add the "type":"visa" key/value pair to the top level of secureContents.

willym

Hello and thank you for the follow up. I have around 15 records like this one.
If you can tell me what file I should edit, I can try it out. I will need to know where the file actually is sitting, and how I will be able to edit it if it is encrypted :)

Thanks
Willy

MrC

You would:

1. select the records
2. export the selected records as 1PIF
3. edit the 1PIF and add the sequence of characters mentioned by @littlebobbytables above to each record (you must add the sequence at the correct location and with the correct syntax)
4. save the 1PIF
5. import the IPIF into 1Password

Note, this will only add back the field placeholder (with no value), which you can then Edit and set. You would need to add the other item correctly that I mentioned above in post #13 too, for the value to just appear after the import. The name you must use for the type is not so obvious in some cases.

Example:

littlebobbytables

Hi @willym,

As you can see the steps are a bit more technical and manual than I'm sure both us and yourself would like but it should mean it fixes the issue for you now which is the important part. Let us know how you get along.

willym

Would the export/import duplicate the records ? should i erase the current one i have ? or it will be smart enough to change only the relevant records on the DB ?

Thanks.

MrC

Nope, no dups. The export will contain a unique UUID per record, and these are matched against existing records.

willym

Well, i would expect to have the option of adding any field (or any relevant field) i want through the UI , especially those that are missing in any way from the default template... no ?
Is this a feature to be enabled in the near future ? doesn't sound like a biggy .....:O)

littlebobbytables

Hi @willym,

If I had to guess I'd say the best way forward is that we don't make any assumptions regarding the .1pif files and instead work in the basis that they may not have been created using a 1Password vault as the source. It's certainly something where we could use improvement.

willym

@littlebobbytables , i totally agree with you !, and have the option to edit the file, no matter what :lol:
Thanks !

Drew_AG

On behalf of @littlebobbytables and @MrC, you're very welcome! Just let us know if you have more questions about that or need anything else - we're here for you. :)

AlvinG

Like many on this site, I have been unable to import my SplashID data. I have tried the software itself and the converter but all I get are error messages or corrupted data. If this can't be resolved I will demand a refund because this is quite useless!. I registered for this forum but I had to save the Username and Password in SplashID!!! Please help.

MrC

@AlvinG,

Sorry for your troubles.

This is the only post I see of yours, and the first I've heard of your issues regarding conversion. Can you post a follow-up message here. Indicate what the problem was (exact error messages are best), your SplashID version, and the platforms + versions used for both. I'll help you get your data converted and imported.

AlvinG

SplashID Safe Ver 8.0.2.842 (I tried the data import from both apple and Windows)
I am on a new Mac with OS X Yosemite
1Password Version 5.3 (530029) Mac App Store
When importing directly, nothing happened when I hit the “Import button”. When I hit “return”, the import screen closed and nothing was imported. Initially, all 187 records were imported but everything was corrupted.
Error message when using the convert application is as below:

Alvins-MacBook-Pro:convert_to_1p4 AlvinAlleyne$ perl5.16 convert_to_1p4.pl splashid -v ../pm_export.txt
Use of uninitialized value $_ in pattern match (m//) at Converters/Splashid.pm
line 187 (#1)
(W uninitialized) An undefined value was used as if it were already
defined. It was interpreted as a "" or a 0, but maybe it was a mistake.
To suppress this warning assign a defined value to your variables.

To help you figure out what was undefined, perl will try to tell you
the name of the variable (if any) that was undefined. In some cases
it cannot do this, so it also tells you what operation you used the
undefined value in. Note, however, that perl optimizes your program
anid the operation displayed in the warning may not necessarily appear
literally in your program. For example, "that $foo" is usually
optimized into "that " . $foo, and the warning will refer to the
concatenation (.) operator, even though there is no . in
your program.

File is not a version 3.0 or 4.0 VID file: ../pm_export.txt

Error message edited for readability - @brenty

MrC

Hi @AlvinG,

I'd like to suggest we keep separate the conversations about the 1Password native importer and my converter, since they are two different things. At least one data item format in the 8.0 version of SplashID changed, and that may be what is causing your issues with the 1Password native importer. So let's ignore that route...

As for my converter, you need to run the converter on the same platform that you exported the data, using that instructions for that platform. In other words, you can't export SplashID on Windows and move the exported file to OS X and run the converter there. Export and Convert on the same platform.

The line being reported in the error message is suggesting that your export file was created on one platform, and the conversion run on another.

AGAlumB

@AlvinG: Just to build on what MrC suggested, we offer a trial version of 1Password for both Mac and Windows, so you can use whichever platform you need to be able to test the import. I hope this helps! :)

AlvinG

Thanks for the comments and suggestions guys. unfortunately, I will be traveling over the next week and I will not be able to deal with this now. Rest assured however, that I will keep trying when I return home. Thanks again.

LauraR

@AlvinG - please try this at your convenience and let us know. Safe travels!

AlvinG

I finally got the trial version of 1Password for windows (thanks Brenty) and after editing the exported SplashID csv file with a text editor, the Windows version of 1Password was able to import the name, username and password for each record. No other information or note was imported. I successfully imported the database into the mac version but I have had to go through my entire database (187 records) and manually copy and paste the data that I needed. Not really what I would call satisfactory.

AGAlumB

@AlvinG: While we do our best to offer some import options, neither Splash ID nor 1Password were developed with the other in mind, I'm afraid.

Hopefully we can improve this in the future, but we understand that it isn't really in our competitors' best interest to improve interoperability. And we will continue to prioritize the actual use of 1Password over fighting with 3rd party data so that the experience of using the app day to day is as good as it can be. :)