csv import / applicant review / automated form fill
automate pdf fill

Import CSV data, review packet fields, assign photos, and generate immigration forms through one flat operator workflow.
Templates
Applicants
Photos
live
Source / templates / review / generate / prompt
1. Load the source CSV
No CSV loaded yet
2. Choose the PDF forms
3. Review and edit applicants
Select an applicant and correct any value before generating the PDFs.
Upload a CSV to start reviewing applicants.
4. Generate the PDFs
7 PDFs for 0 applicants
5. Generate the CSV with an AI tool
Paste the prompt below into your LLM together with the applicant facts. The LLM must respond with only the CSV.
This prompt is intentionally strict. The model must generate only the CSV and nothing else.
You are preparing a production CSV for Fiji immigration PDF autofill.
Your only allowed output is the CSV itself.
Do not output markdown.
Do not output code fences.
Do not output explanations.
Do not output notes.
Do not output labels.
Do not output anything before the CSV.
Do not output anything after the CSV.
Generate the CSV only.

Primary objective:
- Convert human-provided applicant facts into one CSV row per applicant.
- Keep rows consistent, legally plausible, and medically coherent.
- Never invent sensitive facts (criminal history, medical findings, immigration history). If unknown, leave blank.

How each PDF uses the CSV:
1) Certificate of Photograph
- Uses: applicant_full_name, applicant_passport_number, applicant_date_of_birth_*, applicant photo upload in the app, certificate_of_photograph_date, certificate_of_photograph_notary_name, certificate_of_photograph_notary_license_number.
- Keep notary and certificate details complete whenever this PDF is needed.

2) Employee Consent Form
- Uses: applicant_full_name, employer_name, consent_applicant_date, consent_witness_full_name, consent_witness_address_line_1, consent_witness_address_line_2, consent_witness_date.
- Ensure witness and date details are complete if consent is provided.

3) Medical Report
- Identity: applicant_surname, applicant_given_names, applicant_permanent_residential_address, applicant_gender, applicant_date_of_birth_*, applicant_nationality, applicant_passport_number.
- Section A yes/no fields: medical_ever_hospitalised_or_surgery, medical_refused_employment_or_entry_on_medical_grounds, medical_dependency_on_drugs_alcohol_or_substances, medical_mental_disorder_fits_epilepsy, medical_hiv_aids_or_std.
- Section A details: medical_history_details, medical_reason_for_medical_examination.
- Section B findings: medical_heart, medical_lungs, medical_kidney, medical_liver, medical_hiv_and_std_tests, medical_xray, medical_other_observations.
- Section C outcomes: medical_applicant_date, medical_examiner_witness_date, medical_medically_fit, medical_medical_examiner_date.

4) Statutory Declaration
- Uses applicant_full_name, applicant_passport_number, applicant_present_address or applicant_permanent_residential_address, employer_position_of_employee, employer_name, statutory_declaration_declared_place, statutory_declaration_declared_country.
- The bottom declaration date is generated automatically from the current date when the PDF is created.

5) Training Agreement
- Trainer identity comes from applicant_full_name, applicant_nationality, applicant_passport_number, employer_position_of_employee, employer_name.
- Trainee fields come from: training_agreement_trainee_name, training_agreement_trainee_fnpf, training_agreement_trainee_position, training_agreement_trainer_date, training_agreement_trainee_date, training_agreement_employer_authorized_signatory, training_agreement_employer_date.
- The agreement made-on date is generated automatically from the current date when the PDF is created.
- The training commencement date is generated automatically as current date + 2 calendar months when the PDF is created.
- employer_duties_of_position is reused as the scope of training in the training agreement.
- employer_duties_of_position should contain at least 6 bullet points and at most 8 bullet points, with each bullet on a new line starting with '- '.

6) Terms and Conditions
- Employer side: employer_name, terms_employer_date, terms_employer_witness_full_name, terms_employer_witness_designation, terms_employer_witness_date.
- Employee side: applicant_full_name, terms_employee_date, terms_employee_witness_full_name, terms_employee_witness_designation, terms_employee_witness_date.

7) Work Permit Application (pages 1-9)
- Core identity: applicant_full_name, applicant_preferred_title, applicant_gender, applicant_date_of_birth_*, applicant_nationality, applicant_passport_number, applicant_passport_issue_details, applicant_place_of_birth, applicant_occupation, applicant_marital_status.
- Addresses: applicant_permanent_residential_address, applicant_postal_address, applicant_present_address, applicant_intended_residential_address_1..3, applicant_intended_postal_address_1..3.
- Stay history: applicant_current_fiji_stay_*, applicant_previous_fiji_stay_has_stayed, previous_permit_1..8_*. 
- Family and police sections: family_member_1..6_*, police_address_history_1..8_*, applicant_criminal_history_has_conviction, criminal_history_1..3_*, police_report_date.
- Employer section: employer_name, employer_address_line_1, employer_address_line_2, employer_nature_of_business, employer_position_of_employee, employer_duties_of_position, employer_is_new_position, employer_incumbent_details, employer_required_qualifications, employer_applicant_qualifications, employer_reasons_cannot_fill_locally, employer_reasons_local_applicants_unsuitable, employer_training_plan, employer_declaration_date, employer_declaration_full_name, employer_declaration_position, employer_witness_full_name, employer_witness_address_line_1, employer_witness_address_line_2, employer_witness_date.
- Table blocks: local_employee_1..5_*, expatriate_employee_1..5_*, advertisement_1..3_*, training_person_1..4_*.
- Investor section: investor_business_name, shareholder_1..4_*, investor_fic_granted_date, investor_commencement_date.
- Checklist page: supporting_* fields (all should be yes/no).

Quality rules:
- Use yes/no only for binary and checklist columns.
- Keep person identity fields consistent across all sections in the same row.
- Keep employer and witness names consistent where repeated.
- employer_duties_of_position must have 6 to 8 newline-separated bullet points that are concrete and role-specific because it is reused as the training scope.
- If medically_fit is yes, findings should not contradict it unless explicitly stated by input facts.
- For repeated blocks (family_member_*, previous_permit_*, criminal_history_*, advertisement_*, training_person_*, shareholder_*, police_address_history_*): if data exists for a row, fill all relevant columns for that row; otherwise leave that row empty.
- Do not put placeholder words like N/A, unknown, nil, -; leave blank instead.

CSV mechanics:
- Keep the header row exactly as provided, in the same order.
- Do not add, remove, rename, or reorder any column.
- Quote any value containing commas, line breaks, or double quotes.
- Escape double quotes inside values using standard CSV escaping.
- Every data row must have the exact same number of columns as the header.
- The response must be only the raw CSV content.

Header row (must match exactly):
applicant_full_name,applicant_surname,applicant_given_names,applicant_preferred_title,applicant_gender,applicant_date_of_birth_day,applicant_date_of_birth_month,applicant_date_of_birth_year,applicant_nationality,applicant_passport_number,applicant_passport_issue_details,applicant_place_of_birth,applicant_occupation,applicant_marital_status,applicant_permanent_residential_address,applicant_postal_address,applicant_present_address,applicant_intended_residential_address_1,applicant_intended_residential_address_2,applicant_intended_residential_address_3,applicant_intended_postal_address_1,applicant_intended_postal_address_2,applicant_intended_postal_address_3,applicant_current_fiji_stay_date_of_entry,applicant_current_fiji_stay_port_of_entry,applicant_current_fiji_stay_permit_type,applicant_current_fiji_stay_permit_expiry_date,applicant_previous_fiji_stay_has_stayed,applicant_ten_year_address_history_1_dates,applicant_ten_year_address_history_1_address,applicant_ten_year_address_history_2_dates,applicant_ten_year_address_history_2_address,applicant_ten_year_address_history_3_dates,applicant_ten_year_address_history_3_address,spouse_ten_year_address_history_1_dates,spouse_ten_year_address_history_1_address,spouse_ten_year_address_history_2_dates,spouse_ten_year_address_history_2_address,spouse_ten_year_address_history_3_dates,spouse_ten_year_address_history_3_address,applicant_criminal_history_has_conviction,police_report_date,certificate_of_photograph_date,certificate_of_photograph_notary_name,certificate_of_photograph_notary_license_number,statutory_declaration_declared_place,statutory_declaration_declared_country,employer_name,employer_address_line_1,employer_address_line_2,employer_nature_of_business,employer_position_of_employee,employer_duties_of_position,employer_is_new_position,employer_incumbent_details,employer_required_qualifications,employer_applicant_qualifications,employer_reasons_cannot_fill_locally,employer_reasons_local_applicants_unsuitable,employer_training_plan,employer_declaration_date,employer_declaration_full_name,employer_declaration_position,employer_witness_full_name,employer_witness_address_line_1,employer_witness_address_line_2,employer_witness_date,consent_applicant_date,consent_witness_full_name,consent_witness_address_line_1,consent_witness_address_line_2,consent_witness_date,terms_employer_date,terms_employer_witness_full_name,terms_employer_witness_designation,terms_employer_witness_date,terms_employee_date,terms_employee_witness_full_name,terms_employee_witness_designation,terms_employee_witness_date,medical_reason_for_medical_examination,medical_ever_hospitalised_or_surgery,medical_refused_employment_or_entry_on_medical_grounds,medical_dependency_on_drugs_alcohol_or_substances,medical_mental_disorder_fits_epilepsy,medical_hiv_aids_or_std,medical_history_details,medical_heart,medical_lungs,medical_kidney,medical_liver,medical_hiv_and_std_tests,medical_xray,medical_other_observations,medical_applicant_date,medical_examiner_witness_date,medical_medically_fit,medical_medical_examiner_date,training_agreement_trainee_name,training_agreement_trainee_fnpf,training_agreement_trainee_position,training_agreement_trainer_date,training_agreement_trainee_date,training_agreement_employer_authorized_signatory,training_agreement_employer_date,investor_business_name,investor_fic_granted_date,investor_commencement_date,family_member_1_full_name,family_member_1_date_of_birth,family_member_1_country_of_birth,family_member_1_sex,family_member_1_relationship,family_member_2_full_name,family_member_2_date_of_birth,family_member_2_country_of_birth,family_member_2_sex,family_member_2_relationship,family_member_3_full_name,family_member_3_date_of_birth,family_member_3_country_of_birth,family_member_3_sex,family_member_3_relationship,family_member_4_full_name,family_member_4_date_of_birth,family_member_4_country_of_birth,family_member_4_sex,family_member_4_relationship,family_member_5_full_name,family_member_5_date_of_birth,family_member_5_country_of_birth,family_member_5_sex,family_member_5_relationship,family_member_6_full_name,family_member_6_date_of_birth,family_member_6_country_of_birth,family_member_6_sex,family_member_6_relationship,previous_permit_1_from,previous_permit_1_to,previous_permit_1_permit_type,previous_permit_2_from,previous_permit_2_to,previous_permit_2_permit_type,previous_permit_3_from,previous_permit_3_to,previous_permit_3_permit_type,previous_permit_4_from,previous_permit_4_to,previous_permit_4_permit_type,previous_permit_5_from,previous_permit_5_to,previous_permit_5_permit_type,previous_permit_6_from,previous_permit_6_to,previous_permit_6_permit_type,previous_permit_7_from,previous_permit_7_to,previous_permit_7_permit_type,previous_permit_8_from,previous_permit_8_to,previous_permit_8_permit_type,criminal_history_1_date,criminal_history_1_offence,criminal_history_1_sentence,criminal_history_2_date,criminal_history_2_offence,criminal_history_2_sentence,criminal_history_3_date,criminal_history_3_offence,criminal_history_3_sentence,local_employee_1_count,local_employee_1_position,local_employee_2_count,local_employee_2_position,local_employee_3_count,local_employee_3_position,local_employee_4_count,local_employee_4_position,local_employee_5_count,local_employee_5_position,expatriate_employee_1_count,expatriate_employee_1_position,expatriate_employee_2_count,expatriate_employee_2_position,expatriate_employee_3_count,expatriate_employee_3_position,expatriate_employee_4_count,expatriate_employee_4_position,expatriate_employee_5_count,expatriate_employee_5_position,advertisement_1_newspaper,advertisement_1_issue_date,advertisement_1_applicant_count,advertisement_1_result,advertisement_2_newspaper,advertisement_2_issue_date,advertisement_2_applicant_count,advertisement_2_result,advertisement_3_newspaper,advertisement_3_issue_date,advertisement_3_applicant_count,advertisement_3_result,training_person_1_name,training_person_1_position,training_person_2_name,training_person_2_position,training_person_3_name,training_person_3_position,training_person_4_name,training_person_4_position,shareholder_1_name,shareholder_1_shareholding_percent,shareholder_1_monetary_value,shareholder_2_name,shareholder_2_shareholding_percent,shareholder_2_monetary_value,shareholder_3_name,shareholder_3_shareholding_percent,shareholder_3_monetary_value,shareholder_4_name,shareholder_4_shareholding_percent,shareholder_4_monetary_value,police_address_history_1_address,police_address_history_1_from,police_address_history_1_to,police_address_history_2_address,police_address_history_2_from,police_address_history_2_to,police_address_history_3_address,police_address_history_3_from,police_address_history_3_to,police_address_history_4_address,police_address_history_4_from,police_address_history_4_to,police_address_history_5_address,police_address_history_5_from,police_address_history_5_to,police_address_history_6_address,police_address_history_6_from,police_address_history_6_to,police_address_history_7_address,police_address_history_7_from,police_address_history_7_to,police_address_history_8_address,police_address_history_8_from,police_address_history_8_to,supporting_completed_and_signed_application_form,supporting_application_fee,supporting_police_report_principal_applicant,supporting_police_report_spouse,supporting_police_report_children,supporting_medical_report_principal_applicant,supporting_medical_report_spouse,supporting_medical_report_children,supporting_english_knowledge_evidence,supporting_advertisement,supporting_local_understudy_names,supporting_training_plan_programme,supporting_contract_of_employment,supporting_analysis_of_applications,supporting_ftib_approval_and_fic

Final output rule: generate the CSV only.
Generate only the raw CSV, with the exact header row and one row per applicant.
mohammed efaz / automate pdf fill