Are there any docs or examples on now to import from Excel or SQL Server?
What other options are there for importing data?
Thank you
Hi Jay,
I “Really” appreciate the fast responses.
I tried to install FDM by coping the zip to here:
C:\faunadb\fdm-1.14
then I ran this command from Windows Powershell:
./fdm
but I got this error:
Error: A JNI error has occurred, please check your installation and try again
Exception in thread “main” java.lang.UnsupportedClassVersionError: com/fauna/fdm/Main has been compiled by a more recent version of the Java Runtime (class file version 55.0), this version of the Java Runtime only recognizes class file versions up to 52.0
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:468)
at java.net.URLClassLoader.access$100(URLClassLoader.java:74)
at java.net.URLClassLoader$1.run(URLClassLoader.java:369)
at java.net.URLClassLoader$1.run(URLClassLoader.java:363)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:362)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at sun.launcher.Laun
and this is the java version I have: 1.8.0_261
- Workloads:
For a proof of concept i want to import about 1200 companies, 150 categories, and about 4000 many to many relationships between company and category.
but later companies may increase to 30-40k categories to 300 and the M2M relationships… a lot more…
and if all goes well, all of this will increase much more agian.
@georgep couple of things before you start with FDM as it is still in Preview mode plus you seem to have a Windows shop 
- Please refer this limitations section.
While the Fauna Data Manager works on Windows, only limited testing has been done on that platform. You may experience unexpected platform-specific issues. We certainly plan to expand our Windows testing for the Fauna Data Manager for future releases.
- FDM needs Java 11 and above.
One more thing, FDM does not support relationships that you create in GraphQL.
the docs said Java 11 or later, so I installed Java 13 and still get the following error:
Error: A JNI error has occurred, please check your installation and try again
Exception in thread “main” java.lang.UnsupportedClassVersionError: com/fauna/fdm/Main has been compiled by a more recent version of the Java Runtime (class file version 55.0), this version of the Java Runtime only recognizes class file versions up to 52.0
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:468)
at java.net.URLClassLoader.access$100(URLClassLoader.java:74)
at java.net.URLClassLoader$1.run(URLClassLoader.java:369)
at java.net.URLClassLoader$1.run(URLClassLoader.java:363)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:362)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at sun.launcher.LauncherHelper.checkAndLoadMain(LauncherHelper.java:495
May be you have multiple versions of Java and FDM is using the old one ? Did you explicitly setup JAVA_HOME environment variable ?
This is my environment variable:
should I change it from
1.8.0.15
to
1.8.0_261
or
1.8.0.261
or
1.8.0.26
It should be to the path where you have Java 13 installed.
