SeedCode Support Forum

SeedCode Calendar :: RE: Tip: Show Users OR Resources in the Schedule Grid

Author: John Sindelar
Posted: Wed Jul 01, 2009 4:18 pm (GMT -9)
Topic Replies: 2

Absolutely Paul, thanks!
_________________
John Sindelar
SeedCode LLC

SeedCode Calendar :: RE: Tip: Show Users OR Resources in the Schedule Grid

Author: Paul Fenley
Subject: Update Example (maybe)
Posted: Wed Jul 01, 2009 1:50 pm (GMT -9)
Topic Replies: 2

Hi John,

Should there be another paragraph symbol before the "-" at the end?
_________________
--Paul

fmSpark :: RE: "export' to word document after merging

Author: John Sindelar
Posted: Wed Jul 01, 2009 7:48 am (GMT -9)
Topic Replies: 1

Sorry for the late reply; I'm not sure how I missed your post.

So there is nothing built into fmSpark for exporting to Word and that isn't something I have a lot of experience with. You could certainly copy and paste, but you can also make new letter layouts in fmSpark. That might let you create layouts that have the tables, etc you need. (Each template in fmSpark can be tied to a different layout.)

Hope that helps,

John
_________________
John Sindelar
SeedCode LLC

SeedCode Calendar :: RE: Weekly repeat anomaly

Author: John Sindelar
Posted: Wed Jul 01, 2009 5:41 am (GMT -9)
Topic Replies: 1

lol. We had friends that used to keep a "tech sabbath"-- one day a week they wouldn't buy or sell anything. Tougher than you'd think and I always thought that was pretty cool.

But, I haven't built it into our calendar.

Are you sure you're setting the Stop After or Stop On values so that you'd get more than 1 repetition? Because I can't reproduce the problem you're having. Can you let me know what version of the calendar you're using (you'll find this in white text at the bottom of the Admin or Settings tab).

Thanks.
_________________
John Sindelar
SeedCode LLC

SeedCode Calendar :: Weekly repeat anomaly

Author: sburgess
Subject: Weekly repeat anomaly
Posted: Wed Jul 01, 2009 4:50 am (GMT -9)
Topic Replies: 1

I'm trying to schedule a repeating event on Sundays. When I click continue, nothing happens - it shows the first one, does nothing else, and won't let me do anything except delete that first one. If I tell it to repeat on Mondays, it works fine. If I make the initial appointment on Saturday and repeat on Sundays, it also does not work. Daily repeats seem to work starting on any day. It's just the weekly Sunday stuff that doesn't. Is the program just telling me I need to be keeping the Sabbath?

fmSpark :: RE: Auto Sort when opening fmSpark for the first time every day

Author: Regine
Subject: Recent Mailing
Posted: Tue Jun 30, 2009 5:35 am (GMT -9)
Topic Replies: 5

Hi John

Thanks for the information.
I realized after I had posted my message, that I forgot to answer your question.

Yes, we running all files on FileMaker Server and I think it is particular a problem for myself, when I login via VPN over the internet. In the office over the network it does not seem to affect the user as much.
I just delete my 1500 drafts and had 990 completed letters left.
When I logged fresh into the database, it sorted the 990 records. So it is definitely related to this feature.

I will write a script which deletes them every now and then.

Kind regards

Regine

fmSpark :: RE: Auto Sort when opening fmSpark for the first time every day

Author: John Sindelar
Posted: Tue Jun 30, 2009 4:57 am (GMT -9)
Topic Replies: 5

Hi. I think deleting your drafts is important; then you can use the checkbox at the top of the portal (leaving it blank) to remove completed mailings from this list (so it only shows recent drafts) and you'll be set.

There is another sort in fmSpark's relationship graph between _User and _BATCH, but I can't say that removing that sort won't break something. Maybe Ernest can comment on that. I'd focus on deleting the drafts.

And I'd asked if you were opening this from a remote server--I ask because I haven't heard anyone mention this sorting thing before and we have customers with a *lot* of mailings. Can you let me know if that is the case?

Thanks,

John
_________________
John Sindelar
SeedCode LLC

fmSpark :: "export' to word document after merging

Author: verybless
Subject: "export' to word document after merging
Posted: Mon Jun 29, 2009 8:32 pm (GMT -9)
Topic Replies: 1

We are looking at fmSpark. One question

After merging, we need to do more formatting like adding tables and so on. Is it possible to export the merge document into Word format ? Or we have do a copy and paste ?

Thank you

fmSpark :: RE: Auto Sort when opening fmSpark for the first time every day

Author: Regine
Subject: Recent Mailing
Posted: Mon Jun 29, 2009 6:36 pm (GMT -9)
Topic Replies: 5

Hi John and Ernest

I think the recent mailing maybe the problem. We actually do not use this feature.

I just looked into the layout and there are already over 2300 letters just for myself.
Obviously I am doing a lot of testing without actually completing the letter, so around 1500 are drafts.

I guess I need to write a script to get the Drafts removed every now and then, but that would still leave the sorting for the real letters?
I already removed the sort criteria in the _Draft Table, but that did not make a difference.

Any more ideas, how I can stop the sorting?

Thanking you in advance.

Kind regards

Regine

fmSpark :: RE: Auto Sort when opening fmSpark for the first time every day

Author: ernestkoe
Subject: sort
Posted: Sun Jun 28, 2009 1:33 pm (GMT -9)
Topic Replies: 5

take a quick look at your 'recent message/batch' screen. Do you have many hanging out there?
_________________
Ernest Koe
The Proof Group LLC

fmSpark :: RE: Auto Sort when opening fmSpark for the first time every day

Author: John Sindelar
Posted: Sun Jun 28, 2009 1:25 pm (GMT -9)
Topic Replies: 5

Hi Regine,

I'm looking into this, but having added 3000 records to my MergeExpressions table I don't get a sort showing up. (Are you opening fmSpark from a remote server?) Would you be able to post the contents of your "Create letter for CONTACT" script?

Thanks,

John
_________________
John Sindelar
SeedCode LLC

SeedCode Calendar :: RE: Invoices vs Statements

Author: John Sindelar
Posted: Sun Jun 28, 2009 1:13 pm (GMT -9)
Topic Replies: 1

Hi there,

Don't think you're missing anything.

We *really* simplified the invoice section, so there is just a single field for the amount paid on the invoice. If you need to record multiple payments you'll want to create a table for that and then turn our amount paid field into a calc that looks at the sum of the payments applied to the invoice.

Hope that helps,

John
_________________
John Sindelar
SeedCode LLC

SeedCode Calendar :: Invoices vs Statements

Author: csacks
Subject: Invoices vs Statements
Posted: Sun Jun 28, 2009 11:48 am (GMT -9)
Topic Replies: 1

Is there a reason that an invoice doesn't show the payments (deposits or prepayments) posted to that particular invoice? Or is there a way to do this that I am just missing?

fmSpark :: Auto Sort when opening fmSpark for the first time every day

Author: Regine
Subject: Auto Sort when opening fmSpark for the first time every day
Posted: Wed Jun 24, 2009 5:33 pm (GMT -9)
Topic Replies: 5

Hi John

Every day, when I first open fmSpark via the script "Create letter for CONTACT" it performs a Sort before it actually shows the Template window.

It sorts through around 2500 records and it takes quite a while and is very annoying.
Even with Script Debug, I have not been able to find out, where this sort is coming from and what it actually sorts?

We have only around 250 templates, so it can't be that.
I looked through the fmSpark Data file and the only table with around 2500 records is the Merge Expression table.

Please can you tell, how I can turn off the sort if it is not essential? If the sort is only for the Merge Fields, I would rather have it attached to the Merge Field button and sort only when it is necessary.

Thanking you in advance.

Kind regards

Regine

Tips & Tricks :: RE: Tags & Keywords

Author: John Sindelar
Posted: Thu Jun 18, 2009 1:57 pm (GMT -9)
Topic Replies: 1

Thanks for the kind words Joel.

We generally build a new "tags" table and import into that from the found set of contacts, replacing all newly imported records with the current tag. This way you can have any number of tags per contact and multiple users can be tagging records at the same time.
_________________
John Sindelar
SeedCode LLC