You need to sign in to do that
Don't have an account?
Superfell
Data Loader for OSX
I was reminded by the Data Loaders' original author (the infamous Lexi) today that the more recent versions only have minor functionality improvements in them, so rather than waiting for the source of those versions to get released, I went ahead and built a new OSX version of the data loader source that is there. This is v7.0 of the data loader, it includes export, insert, update, and upsert. (but not the FK externalId support). I think makes it about 2 revs out of date, but i think is still useful anyway. You can grab a copy from my blog
All Answers
I am encoutering a couple of quirks when trying to export data using the OSX LexiLoader.
1. I need to have a file already created for it to export to.
2. Query request size seems to be limited to 9999.
Are these user error or enhancement requests?
Thanks,
Karen
2. There's no reason to change the query request size from the default of 500, this has no effect on the total number of rows you can extract.
Do you contract out your services? We are a 3 person crew running mac and would be interested in contracting with you for SF help from time to time?
If so what is your fee? Thanks.
What does affect the number of rows extracted?
I assumed that the reason that my export file had only 500 rows in it was because the default query request size was 500. I just tried again with default query size of 9999 and I get an INVALID_BATCH_SIZE error. At 750 it does the same thing as it does at 500 and it tells me that it has successfully processed 500 of 60000+ records and then it stops the extraction.
Thanks,
Karen
Sorry, I'm not available for contract work. But if you have ideas for what'll make working with Salesforce.com and the Mac easier, feel free to post them here.
I get the message that it has successfully extracted the 500 records and then it just stops and the window closes and I am back to the Welcome to Sforce Data Loader 7.0 - LexiLoader Version and I am being asked to "Please choose an action from the menu." I am not getting the message that I am used to from Windows where I am asked if I wish to view the file.
Thanks,
Karen
2007-07-19 11:09:22,605 INFO [main] controller.LoaderController initConfig (LoaderController.java:291) - The log has been initialized
[LaunchRunner Error] SforceDataLoaderRunner.main(String[]) threw an exception:
org.eclipse.swt.SWTException: Device is disposed
at org.eclipse.swt.SWT.error(SWT.java:3374)
at org.eclipse.swt.SWT.error(SWT.java:3297)
at org.eclipse.swt.SWT.error(SWT.java:3268)
at org.eclipse.swt.widgets.Display.error(Display.java:1105)
at org.eclipse.swt.widgets.Display.checkDevice(Display.java:623)
at org.eclipse.swt.widgets.Display.update(Display.java:3953)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:674)
at org.eclipse.jface.window.Window.open(Window.java:648)
at com.sforce.dataloader.ui.LoaderWindow.run(LoaderWindow.java:107)
at com.sforce.dataloader.controller.LoaderController.createAndShowGUI(LoaderController.java:159)
at SforceDataLoaderRunner.main(SforceDataLoaderRunner.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at apple.launcher.LaunchRunner.run(LaunchRunner.java:88)
at apple.launcher.LaunchRunner.callMain(LaunchRunner.java:50)
at apple.launcher.JavaApplicationLauncher.launch(JavaApplicationLauncher.java:52)
Thanks,
Karen
Thanks for all the work you do with OS X and Salesforce.
I am still on 10.3.9 and am trying to use your Lexiloader 7.0. When I enter my correct username and password and submit it, I get the error "Invalid username or password." Does Lexiloader v 7.0 work on 10.3? Is there something I should do, besides upgrade my operating system? I work for a small nonprofit and we don't have the money to do much in the way of paid software.
Thanks
Rachel
see http://trust.salesforce.com/trust/security/identity_feature.html
Rachel
I have been desparately looking for a database tool and I think this is what I've been needing to mass create activity records and opportunities based on SF ID?
Being a newbie to SQL, I don't recognize the "upsert" function. Is documentation on the Data Loader available?
Thank you so much.
Your search - http://na1.salesforce.com/help/doc/en/data_loader.htm - did not match any documents.
Lynn
Lynn
Thanks for your assistance.
Lynn
I am trying to use the Data loader for OSX. No records will import and I get the following error against each record.
Record Type: id value of incorrect type: Business
I have made sure the UTF-8 setting is correct (reading and writing) and checked the id value and record type exist.
Any ideas why this import is failing?
Many thanks Simon. I managed to load some data.
Would help if there were some guidance notes on using id's. Do you know if there is a guide somewhere?