Fwd: Upload tool for adding large amount of data in Zoho Creator

[Emilio Osorio]

Hola a todos,

Ya nos enviaron el uploader para Zoho. Yo ando atorado ahorita con chamba, pero si alguien quiere probarlo creo que con esto estamos listos por si queremos migrar a TVT o cualquier otra app a zoho.

Saludos,
Emilio

---------- Forwarded message ----------
From: Charles Adaikalam <cha...@adventnet.com >
Date: Nov 6, 2007 3:26 PM
Subject: Upload tool for adding large amount of data in Zoho Creator
To: oem...@gmail.com
Cc: Support < sup...@zohocreator.com>

Hi Emilio,

As discussed through chat yesterday, I have written a small java file which will accept a configuration file.

Usage of this tool:

java ZohoCreatorFormUploader <configuration file path>

The configuration file will be a key-value pair with the following options

         ownerName= <Application Owner's Zoho Id>
         appName= <Application Name> [Refer http://creator.zoho.com/api/reference ]
         formName=<Form Name> [Refer http://creator.zoho.com/api/reference ]
         dataFile= <File path of the csv data file> [This should have the deluge field name as the first row. To get all deluge field names in one place, refer http://creator.zoho.com/api/reference ]
         apiKey= <Zoho API key> [You can get one here ]
         proxy=<true/false>
         proxyHost=<Proxy Host>
         proxyPort=<Proxy Port>
         proxyUser=<Proxy User Name>
         proxyPassword=<Proxy Password>


Proxy details are optional. I have used the CSV APIs of Zoho Creator to bulk add records. Reference : http://writer.zoho.com/public/help/add-record-csv/fullpage

To run, you need to have a JRE installed and this will work for a public form only. Right now I am enhancing it for private forms. Since the timeout for uploading the files in the server is currently 300 seconds(5 minutes), I will have to work on splitting the HttpRequest. I will be splitting it by 1000 rows each (or we can get it as a configuration value). I was able to add about 19000 records using this.

You can use this for initial testing and once I finish with the above 2 pending work items, I will update you. Please let me know if you need any clarifications in this regard.

Thanks,
Charles

-- 
Visit http://www.zohocreator.com to build web applications online at the click of a mouse.

Visit http://blogs.zohocreator.com for latest updates 

--
Emilio Osorio García
Tel: +52 (55) 3233 2476

"There's no way to happiness, Happiness is the way..."
                                                                     -Shakyamuni