SeedCode Support Forum

I have three calendars that seemed to publish okay
My datafile and zula are hosted at foxtail

I'm getting the following error.
Sat Jan 07 14:54:42 PST 2012: Sync failed: java.lang.NumberFormatException: For input string: " "

Test test configuration give me - For input string: " "

I setup a brand new test setup on a Win 7 desktop. Was able sync sample data and a older copy of our file that is hosted at Foxtail.

What happens if either of both the start and endates are blank. I made sure that they were all populated except for 4 dates in which there is a proposed event but not date set yet.


Thanks
Scott

Hi Scott,

Events with both dates empty are no problem and are just ignored. Events that have an end date with no start date will cause errors for Google and iCal.

java.lang.NumberFormatException: For input string: " "

Pretty sure this has something to do with using quotes in the actual data you're passing to Zulu, and that can cause issues with the queries. I'd look for quotes and see if you can substitute or remove them form the zulu data.

Let me know if that helps.
Jason

I did not find any quotes in the data. Did notice that all of the uuid fields are blank as well as the ical data fields. There is note there that they get popluated by plugin. ( that may be old) Perhaps I erased them when doing a Google Reset instead of deleting zulu_uuid in the zulucalendarlist

Hi Scott,

You are correct, those fields should be left for Zulu to populate. It's some kind of data issue that is throwing off the Java SQL query...hoping it was a quite as that's a common one. Are you able to run the publish script without any errors? That should pick up any data type issues (field vs number) which could also be the cause. Did a field type change between the older and newer copy?

Thanks!

Yes, it does publish okay. I doubt that a field type changed. I would like to test with my "live" file but do not know how to get a copy of it since it is hosted at foxtail.

I'll see if foxtail can send me a copy of the file. I don't see a way that I can make a copy from the FM client.

I had read in the documentation about two fields that limit the number of ical records. I did see those in records. I think I started with Zulu when it brand new

Hi Scott,

Thanks. Foxtail provides a dashboard that allows you to back-up and download your databases, I'd check with Angelo to make sure you have access to that.

hth,
Jason

Jason,
I do have access but did not know how to download the file. I just got the file downloaded and will try syncying it on my test setup. I will let you know how it goes.

Thanks
Scott

I took my cleaned up my test data, only 9 straight forward records. On my test setup, not foxtail, I am getting this message when publishing.

http://64.151.86.220/zulu/publish?_vers ... 151.86.220

The LOCATION in the last line may be suspect, I'm using a location for a filter

Hi Scott,

If there publishing script made it this far, then the field types and mapping should be fine as they've passed the validation part of the script. I'm a bit suspicious of your IP address 64.151.86.220. Typically we would publish from within the network, so the IP would start with a 192. or 10. You may be hitting a firewall going through that public one. We have some steps for testing the server and connectivity here, under "Is It Your Server?"

http://www.seedcode.com/pmwiki/pmwiki.php?n=Zulu.Troubleshooting

Let me know if that helps!
Jason

I had neglected to change the address in the script. My test of 18 records published and synced. The problem must like you said, something in the data. I'll have to figure out away what record(s) are causing the problem.

I'll post again if find anything interesting in the data.

Getting theses are the 1st on is when testing the configuration
Test configuration For input string: " "
When trying to sync
Thu Jan 12 07:36:53 PST 2012: Sync failed: java.lang.NumberFormatException: For input string: " "

The zulusampledata works fine. I took my test file down to 2 records. I'm using the same publish calendar script for both files. I eliminated any filters. I have is down to as basic as a I can

Thanks
Scott

Hi Scott,

What's the file name? Does it have spaces in it?

-J

Peak7

Hmmm...

Can you send me a copy of the file to [email protected]? Please include the [Full Access] log-in info.

Thanks!
-Jason